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!
Increment Numeric Field using Workflow
I need a workflow to increment the value of a numeric field by 1 when the workflow is triggered.
The field is integer number:
And the workflow formula is:
Which is based on SuiteAnswers Answer Id: 30843
When the field is empty, triggering the workflow sets it to 1 (correctly)
When the field is set to 1, triggering the workflow sets it to 11
I thought this was behaving like a string field, but I wasn't able to get the 'TO_NUMBER' function to work with the workflow.
Strangely, after 4 triggers the field shows 1,111 so this is clearly a numeric field, but the + function in the formula appears to be concatenating it in a string format rather than addition.
0