I am currently using an app formula UNIQUEID to create an ID for each new row added. There are instances where a user may go back and edit a column (or multiple) and I would like the UNIQUEID to be unchanged but each edit is regenerating the UNIQUEID. As it is an app formula, the methods I have tried are not working.
Is there a resolution for this?
Ideally I would like a sequential number CC0001, CC0002, CC0003 etc but as we have many users, I do not want to risk duplicate IDโs.
Thank you.
LinkedIn
Twitter
