RE: 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.
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?
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
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) ?
