Evaluating Code in Saved Searches Using Formula (HTML) Fields
As of the 2023.2 release, Formula (Text) fields that contain HTML code will only display results as plain text to improve the security of saved searches. You will receive a notification about this change before it takes effect in your account. After 2023.2, you need to use a Formula (HTML) field to evaluate HTML code within a saved search. To view a list of saved searches in your account that currently contain code in Formula(Text) fields, go to Lists > Search > Saved Searches with HTML in Formula (Text).
If you have customized your NetSuite center to remove or rename the Lists tab from the navigation menu, you may not see the Saved Searches with HTML in Formula (Text) list.
To access the list in your account:
-
-
Go to Customization > Center and Tabs > Center Categories.
-
Edit the Search and Center Tab Lists category.
-
In the Link section, select Saved Searches with HTML in Formula from the list and click Add.
-
Click Save.
-
The Create HTML Formulas in Search permission enables you to use Formula (HTML) fields as results fields in searches. You also need this permission to see the correct values in searches when HTML is used for Text Custom fields. To do so, the formula containing HTML must be used within a Formula (HTML) field.
The Create HTML Formulas in Search permission was initially assigned to all roles with Create level access for the SuiteScript permission and Full level access for the Perform Search permission. You can manually enable it for other users on the Role page in the Setup subtab of the Permissions tab.
If a user without the Create HTML Formulas in Search permission tries to edit a saved search that uses a Formula (HTML) field, all Formula (HTML) columns are removed. Additionally, the user will only be able to save a copy of the search using the Save As function.