AnsweredAssumed Answered

How do I create a field with a condition?

Question asked by taskaras on Jun 8, 2017
Latest reply on Jun 9, 2017 by fitch

I have an author field which may contain up to 10 names.  I'd like to create a new field based on the author field which will output like this:

 

If the author field contains more than 6 names, then output as first author., et al.

 

Example:

Grothe, B., et al.

 

If the author field contains 6 authors or less, then keep as is:

 

Grothe, B., Jacobs, G., Padgett, K., Aaronson, N. K., & Jacobs, G.

 

 

 

Outcomes