Is there a way to autogenerate a number?
I’m building an intake request form, but want each project request to come in with an autogenerated number.
One way would be to reference a number in a table, but that seems like a waste of a table.
Is there a way to have a number function lookup a number, then +1 to that number to generate the next number, but then update the previous number so that it is forever increasing?
Previous Project Code is 1000
New project code looks up 1000 then add 1, but then updates the 1000 to now be 1001.
Project Code 1001
Maybe build a child flo that only adds one to the previous number? Your thoughts?