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].*')
j
jen
05/22/2025, 6:52 PM
if you want it to remain clickable, use the column type Formula (HTML) and format it as a hyperlink e.g. something like