ANS-0782 · CUSTOM FIELDS, RECORDS & FORMS
How to Set a Blank Value in a NetSuite Dropdown List Using a Workflow
NetSuite administrators can configure workflows to clear values from dropdown or list/record fields, ensuring data consistency and automation.
Short answer
To clear a dropdown list value in NetSuite using a workflow, create a workflow with a 'Set field value' action. Configure the action to target the desired dropdown field, select 'Formula' as the value type, and enter NULL as the formula. This action effectively removes the selected value, setting the field to blank.
Scenario
NetSuite users often need to automate the clearing of values from dropdown or list/record fields based on specific conditions. This requirement typically arises when certain field selections become irrelevant or need to be reset as part of a business process, ensuring data accuracy and streamlined operations.
Solution
To set a blank value in a dropdown list using a NetSuite workflow, follow these steps:
Create the workflow.
Configure the workflow to trigger 'On Create or Update'.
Add the action "Set field value".
Enter a condition (optional) to define when the field should be cleared.
Select the specific dropdown or list/record field that needs to be set to a blank value.
For the 'Value' type, select 'Formula'.
Enter the following formula to clear the field:
NULLExpert NetSuite Support
Need help with this NetSuite issue?
Custom Fields, Records & Forms consulting and configuration support