App SALE, Form multiple

Hello, I hope you can help me with the following:
I have form where I have to fill with sales data (customer, date,products, product quantity) the problem is that sometimes I have several products for a single customer, and I want to be able to load all these products at once with their quantity, in the same form, then when I give to SAVE it is saved in Excel ROW by ROW by product.

0 1 81
1 REPLY 1

So what I'd do is have the form just record the information for one product.  Then have the form reopen on save, saving one click.  To save further time maybe set Intial Values for [Date]=Today() and [Customer] to be whatever the last row added was.

But dont create a single record where you list 5-10 items in one record.  That WILL cause you issues later and doesn't play to Appsheets strengths.

Top Labels in this Space