In addition of that, I guess what you need exactly is to know how to create an Order ID. Because once I order something, my order ID must be different in a second time or for another user.
Here’s what I used and help me a lot a while ago with Buffalo Burger and Forker (multi-delivery app), thank to @Jeff_Hager !
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…
5 Likes