Thursday, June 27, 2019

Create a Customer Saved Search Report With the Column Showing the Customer ID Together With the Customer Name

 

Solution:

-       Edit Customer Saved Search Report

-       Navigate to Results tab > Columns subtab

-       Add the field = Formula (Text)

-       In the Formula column, copy and paste this formula CONCAT({entityid},CONCAT(' ', {altname}))

-       Hit Done

-       Preview the result

No comments:

Post a Comment