Create a code for each confirmed order

[Jeff_Hager]

This may be a method they used.

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…