Hi Team
Could you kindly assist how can I auto-generate an Order ID per user to avoid users having the same Order ID
In a form, you can use the special value “unique ID” to do this.
I know I may sound stupid but could you please show how I can do it, please
Here is info on how to use the Unique ID special value.
These are also some thoughts I had a while back to create order ID’s. I don’t have an example, but I think a few people have used a version of the idea.
Here’s a bit of a wild idea.
Create a column in your confirmed orders sheet that will contain only email and business. This can be 2 separate column joined with a template, or you can write it to the sheet later already joined from the form button. Doesn’t matter. We just need email and buiness only.
Next on your products, sheet follow the instructions here to get a lookup column of the user’s signed in email into the products sheet. List Relation "Data"
Next in the products sheet, create…
