This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

using the html formula on a saved search, how do I format a link that is dynamic depending on a field?

&gt;*AI generated answer (using internal Slack threads):*
To format a dynamic link in a saved search using the HTML formula, you can use the following formula:

```'&lt;a href=\"<https://test-production.myshopify.com/admin/orders/>' || {custbody_lb_shopify_trx_id} || '\"&gt;' || {custbody_shopify_order_number} || '&lt;/a&gt;'```

In this formula, `{custbody_lb_shopify_trx_id}` and `{custbody_shopify_order_number}` are the dynamic fields that you want to include in your link. Replace these with the actual fields you want to use.

Please note that the link will be clickable only if the 'Disable HTML in Search Formula' preference is not enabled in your account settings.

******
Disclaimer:

This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes.
******

&gt;*Slack thread 1:* <https://netsuiteprofessionals.slack.com/archives/C298P0BCK/p1697776850590159|here> (available only if the original thread was posted in the last 90 days)
&gt;*Similarity score:* 0.864286959

&gt;*Slack thread 2:* <https://netsuiteprofessionals.slack.com/archives/C298P0BCK/p1636561452053000|here> (available only if the original thread was posted in the last 90 days)
&gt;*Similarity score:* 0.859819353

&gt;*Slack thread 3:* <https://netsuiteprofessionals.slack.com/archives/C298P0BCK/p1651684059844849|here> (available only if the original thread was posted in the last 90 days)
&gt;*Similarity score:* 0.848409832



Please provide your feedback on this answer.