Hi Everyone, I have a saved search on Sales Order ...
# general
v
Hi Everyone, I have a saved search on Sales Order transactions. In this search, I have a customer name like "123Test", but I want to remove the numeric part ("123") and display only "Test". Additionally, I want the name to remain clickable and link to the customer record. I am currently using the following formula: REGEXP_SUBSTR({entity}, '[A-Za-z].*')
a
@Vishal Chaudhari just use the CompanyName field
v
may be it is 'entityid' not 'entity'