ANS-0157 · SAVED SEARCHES & FORMULAS
How to Display Custom Form Information in NetSuite Saved Searches?
Learn how to expose custom form details in NetSuite saved searches using a custom field and workflow.
Short answer
Directly referencing the {customform} field in NetSuite saved search formulas is not supported. To display custom form information, create a custom field, populate it via a workflow, and then reference this custom field in your saved search.
Scenario
Users often need to include details about the custom form used for a record within NetSuite saved searches. Attempts to directly reference the {customform} field in a saved search formula typically result in an 'invalid field' error, preventing the desired data from being displayed.
Solution
To display custom form information in a NetSuite saved search, directly referencing the {customform} field within a formula text is not natively supported and will typically result in an 'invalid field' error. Instead, a workaround involving a custom field and workflow is required.
Create a Custom Field: Create a custom field (e.g., a Free-Form Text field) on the relevant record type (e.g., Customer, Transaction Body Field for transactions) to store the custom form's name.
Implement a Workflow: Create a workflow that triggers on the record type. Add a 'Set Field Value' action within the workflow to populate your custom field (from step 1) with the value of the {customform} field. This ensures the custom field captures the form used.
Reference in Saved Search: Once the custom field is populated by the workflow, it can be directly referenced in your saved search results or criteria to display the custom form information.
Expert NetSuite Support
Need help with this NetSuite issue?
Saved Searches & Formulas consulting and configuration support
