RE: How To ADD any name in Author Field by Formula Harkpabst Meliantrop 7.Aug.18 03:23 PM a Web browser Notes Client 7.0.3Windows Vista
First, your Authors field must be set to "allow multiple values" for this to work properly.
The formula is simple enough. In Formula language everything is a list (containing one or more elements). All you have to do is to add one list element to the list that is already in the field. It is always a good idea to use @Trim to remove empty values and @Unique to remove duplicate values.
How you do this depends on how you enter the new value. If this is a Notes client application and there is a button to populate the Authors field, you would write something like this:
FIELD Authors := @Unique(@Trim(Authors : "The New Name"))
If the The New Name was in an names field called "NewAuthor", this would translate to:
FIELD Authors := @Unique(@Trim(Authors : NewAuthor))
If the Authors field is a computed field, that should get the new value when saving the document, your Value formula would simply be:
@Unique(@Trim(Authors : NewAuthor))
or
@Unique(@Trim(@ThisValue : NewAuthor))
Return to top
. . RE: How To ADD any name in Author F... (Harkpabst Melia... 7.Aug.18) 
Print this page
