Saturday, December 29, 2018

Formula to Use to Get the Child Name or Any Value After the Colon Mark

Create a saved search that will extract the child name on a parent child field:

1.    Lists > Search > Saved Searches > New.

2.    Click any Search Type (i.e. Transaction).

3.    Click Results tab > Add Formula (Text) field and add the formula below:


Note: Change {name} with the correct fieldID where the Parent : Child Name exists.

No comments:

Post a Comment