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.
Now is the time to ask your NetSuite-savvy friends and colleagues to join the NetSuite Support Community! Refer now! Click here to watch and 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?
Tagged:
0