Auto generate a OrderID

[Jeff_Hager]

Here is info on how to use the Unique ID special value.

Glide Docs

Glide Docs

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.

How to create an app for taking Sales Orders

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…