24.07.2022
15:32
Hello,
I have a form that has a 5 steps. On each step I have a form field that has 4 options('statuses') : open,closed, opened-again, in-progess. I want to have the value open in first 3 steps, than on step 4 i want to have a status 'closed'. How do I make the step depend on the field?
24.07.2022
16:47
Hi,
if I understand it correctly the field should spend on the step the workflow moved to.
I would accomplish this by using the OnEntry trigger of the step to change the filed value.
This would be achieved by setting up the choce field to use an sql statement for providing the values using constants as ids. This way you can use the same constant to set the status. Using the OnEntry will set the status to the correct value from wherever the workflow moved to this step.
Here's a little example using constants in a choice field, also is a bit off topic:
https://daniels-notes.de/posts/2021/little-excel-helpers#sql-command-for-fixed-values-used-in-a-picker-field
Best regards,
Daniel
