Set field field maximum value plus 1

I need a workflow that triggers on create and retrieve a custom field maximum value and add 1 to it. I created a workflow and added a new action with a formula Max({custentity_az_empalternativeid})+1 but it doesn’t work. is there anything wrong with this formula.

Rookie Asked on April 12, 2020 in SuiteFlow.
Add Comment
2 Answer(s)

What is the type of the  entity custom field ?

Which trigger do you use at your Set Field Value action?

Do you enable the workflow logs?

Beginner Answered on April 12, 2020.

it is a free text field and the trigger is on entry. also, I tried it as an integer number but the same. doesn’t work

on April 12, 2020.

It must be a numeric field.  In this case,  the MAX formula is not necessary. All you should do is {customfield}+1

What is the event that trigger the Workflow (ALL, Before Record Load, Before Record Submit , ARS) ?

on April 12, 2020.
Add Comment

What you are looking to do can’t be done with workflow. You will need to script this. Or create an auto numbering process involving creating custom records. There’s a suite answers article on how to do this, but I’m having trouble finding it.

Advanced Answered on April 13, 2020.

Yes, that is exactly what am looking to. I need an incremental field that looks like the standard one.

on April 13, 2020.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.
  • This site made possible by our sponsors: Tipalti