Hi. I am new to AppSheet (and do not have a programming background).
I am creating an app to scan the bar codes on products that were used in a procedure and have them be added to an invoice so that they can be re-ordered.
The number of products used in a procedure is not fixed.
How do you recommend I set up this data table and AppSheet form?
Thanking you in advance
If you have more than just one product to read and the amount can be what ever, I would propose to use Related table structure where the invoice is a parent record and scanned products are child records. Then you can have as many products as you need. Please check this article:
User | Count |
---|---|
41 | |
36 | |
30 | |
23 | |
16 |