i have saved search on sales order and in that i removed the number from customer name using formula can we add customer link in that formula to open customer record formula text is below REGEXP_SUBSTR({entity}, '[A-Za-z].*')

AI generated answer (using internal Slack threads):

Based on the conversations, it seems that you are trying to add a hyperlink to the customer record in your saved search results. Unfortunately, you cannot directly add a hyperlink in a formula field in a saved search. However, there is a workaround. You can create a Formula (Text) field in your saved search and use the following formula:

HYPERLINK('https://<ACCOUNT_ID>.<http://app.netsuite.com/app/common/entity/custjob.nl?id=|app.netsuite.com/app/common/entity/custjob.nl?id=>' || {entity.id}, {entity})

Replace

<ACCOUNT_ID>

with your actual account ID. This formula will create a hyperlink to the customer record using the customer's internal ID (

{entity.id}

) and display the customer's name (

{entity}

) as the link text. Please note that this formula will only work if the entity is a customer. If the entity could be a different record type (e.g., a vendor or partner), you would need to adjust the URL in the formula accordingly. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******