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!
How do resolve Error: Invalid Expression in a workflow formula
Hello - I am using the below formula in a workflow Set field Value action to join the value of a custom field with the letter 'C' if a check box field is checked.
Example:
custevent1 = Odessa
custevent_la_comptruck = checked
The result should be 'Odessa C'. Instead, the result is: ERROR: Invalid Expression
{custevent1} || CASE WHEN {custevent_la_comptruck} = 'T' THEN ' (C)' ELSE '' END
I've tried several different versions of the formula, using IF instead of Case When. Any suggestions? Thanks!