Sunday, November 4, 2018

Add Prefixes to Saved Search Results

SCENARIO

  • User is working on a saved search that displays the Start Date and End Date of former employees
  • Instead of just seeing plain dates on the results, the user would like to see the prefixes SD and ED before the dates in each row of results.

1. Navigate to Lists > Search > Saved Searches > New.

2. Select Employee.

3. Provide a search title.

4. Set the criteria as needed.

5. Under Results tab, add:

  • Formula (Text) : Formula = 'SD:' || {birthdate} : Label = Start Date
  • Formula (Text) : Formula = 'ED:' || {birthdate} : Label = End Date

6. Add other result fields as needed such as Name and Email.

7. Click Save & Run.

No comments:

Post a Comment