Tuesday, October 2, 2018

Display Only the Child Item's Name on Item Searches (excluding the parent item's name)

It is possible to show the customer "Child" name only on a Transaction Saved Search iinstead of displaying it as "Parent:Child" through a formula.

To do this:

1. Edit/Create a Saved Transaction Search.
2. Go to Results tab, then go to Columns sub tab.
3. Select Formula(Text) from the Field dropdown list.
4. Set the following formula:

REGEXP_REPLACE(REGEXP_SUBSTR({name},': [^:]+*$'),': ','')
 
5. Click Add.
6. Click Save & Run.

 

No comments:

Post a Comment