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) ?
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.
Yes, that is exactly what am looking to. I need an incremental field that looks like the standard one.
