How To ADD any name in Author Field by Formula

HCL Domino Domino Forum
1

Dear All,

Let me know i have Author field i want to add one name in author field but old name not removed only append new name but i want to add by this Lotus Formula how i do this ?

2

Subject: How To ADD any name in Author Field by Formula

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))

3

Subject: RE: How To ADD any name in Author Field by Formula

Hi

If Author field have already value and as per formula i will apply then may be this old value Replace to new value , so i want keep Old value and add new value so what is the formula for this?

4

Subject: The answer is in the previous answer

@Unique(@Trim(Authors : “The New Name”))

You may want to really read up on formulas if you’ve been hired to do this work, as with your current knowledge, you could do more damage than good.

5

Subject: RE: The answer is in the previous answer

Ok thanks for your sugesstion

6

Subject: RE: The answer is in the previous answer

Note that if this is done from an agent instead of from a field formula or an action within the context of the document, it may change the field type from authors to an ordinary text field. One would need to refresh all fields in order to fix that.