Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
How Do I Enforce Entry of Only One of four fields using Workflow?
I have four fields on a form. The User MUST enter data into ONLY one of these 4 fields, but they MUST enter at least one field.
I have tried many different formulas on the Action Condition, but I cannot make it work.
Here's an example using just 2 of the fields:
((nlapiGetFieldValue('custrecord_rb_all_items') == "F")?0:1 + (nlapiGetFieldValue('custrecord_rb_manuf_division').toString().length == 0)?0:1) != 1 The first field is a Checkbox (T/F), and the 2nd is a List/Record type.I'm not sure how to test for the field being empty (null).
The approach I was trying to use is to test each field, and if something has been entered, set the result to 1, and then sum all of these expressions.
0