Hi,
I tried to create a field called “ver”, whose data type is Whole Number. It is a required field.
My idea is to create Flow via Automate to add 1 to this field every time a record is updated.
However, as this field itself is cumulative is also a type of update, it will also trigger this flow and the value of this field will keep getting bigger.
At the moment I can only do this by adding a field update condition to the flow's trigger, e.g. the flow is only triggered when the fullname is updated.
Then add 1 to the ver field for each update.
This can be cumbersome for entities with a large number of fields, requiring a list of all the fields to be statistically updated.
However, since the Version Number that comes with the system cannot be added directly in the Form, nor can it participate in Calculate or Process assignment, this is the best solution that I can think of at the moment.
If this helped you, I'd appreciate it if you'd mark this as a Verified Answer, which may in turn help others as well.
Best Regards,
Nya
