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!
Workflow Criteria Custom Formula - SuiteAnswers?
I know that the Functions available in a normal formula field are referred to as 'SQL Expressions' (even though NetSuite runs on Oracle!) and there is a very good article in SuiteAnswers explaining all of these.
When you try to create a custom formula for a Workflow Criteria, the list of Functions is completely different.
What 'type' are these, and is there a similar SuiteAnswers page that documents them?
What I am trying to do is check if the first two digits of a telephone number field are 07 and then trigger a workflow action. In SQL expressions I would probably use something like TO_CHAR and then SUBSTR to extract the first two characters for comparison. How can I do this in Workflow Criteria?