Tuesday, October 16, 2018

Merge Values of Multiple Fields and Display in a Custom Field

User wants to combine the values of multiple fields into one field only. This is regardless of the entity field type.

1. Navigate to Customization > Lists, Records, & FieldsEntity Fields > New.
2. Enter any Label.
3. Select Free Form text in the Type field
4. Unmark the Store Value field
5. In the Validation & Defaulting tab > set the Default Value as {custentity1}||' '||{custentity2}||' '||{custentity3}
Note: custentity1, 2 and 3 are sample internal IDs of the custom field
6. Mark the Formula field.
7. Click Save.



No comments:

Post a Comment