I am having a lot of difficulties creating unique, sequential numbers (for orders in my database) reliably in workflows. It’s in the format PP-100001 (100000+X where X is a simple sequential number stored in each row of the database).
I have created workflows that do a search for the highest sequential number using :max and then adding one but it is unreliable, seems like the workflow sometimes skips, doesn’t fire or does the same twice. I simply cannot afford for this to occur.
Is there a reliable way to have each row of data in a thing have a unique sequential number? What is the best practice as it is essential that the number is both unique and sequential as it is sent to a payment platform that requires this?