ANS-0852 · CUSTOM FIELDS, RECORDS & FORMS
How to Clear a Picklist Field Value Using a NetSuite Workflow
Learn the correct method for setting a picklist (select) field to null or blank within a NetSuite workflow, avoiding common pitfalls.
Short answer
To clear a picklist field value in a NetSuite workflow, do not use the "Static Value" option with a blank selection. Instead, configure the "Set Field Value" action to use a "Formula" and input an empty string (``) as the formula. This ensures the field is correctly set to null, effectively clearing its current selection.
Scenario
Users attempting to clear a picklist (select) field value within a NetSuite workflow may encounter issues when using the "Set Field Value" action. A common approach of selecting "Static Value" and then choosing a blank option from the dropdown does not successfully clear the field. This results in the field retaining its previous value rather than becoming null.
Solution
To successfully set a picklist field value to null or blank using a NetSuite workflow, follow these steps:
Navigate to the workflow definition and select the desired "Set Field Value" action.
For the field you wish to clear, configure the "Value" setting.
Instead of choosing "Static Value" and attempting to select a blank option, set the "Type" to "Formula".
In the "Formula" field, enter an empty string:
''This formula explicitly instructs the workflow to set the picklist field to a null value, effectively clearing any existing selection.
Expert NetSuite Support
Need help with this NetSuite issue?
Custom Fields, Records & Forms consulting and configuration support