Discussions
Read on for the latest updates including:
• Agenda Builder launch
• SuiteWorld On Air registration
• New NetSuite Prompt Studio Contest
• And more!
Check out this thread to learn more!
Using CASE FORMULA in custom field
Hi Experts,
I am new to NetSuite trying to write a formula. My requirement is like this:
I have a 2 fields of type checkboxes and more field of type free form text. I have placed all the three values on sales order. My requirement is " If checkbox 1 is selected then Free form text field should get the value of subsidiary and if checkbox 2 is selected the location value needs to get in freeform text field. "
CASE WHEN {custbody193}='T' THEN {custbody192}= {tranid} ELSE 0 END
I was using above formula but getting an error. If in place of {custbody192} = 'T' if i place 1 then it is saying 1 if 193 is selected but i am not able to get the value of subsidiary in to this. Please guide me.