form where multiple products and quantities

AppSheet AppSheet Q&A
1

Hi everyone, I’m trying to build an application where I charge sales. Sales carry various products and associated quantities.

Does anyone know a way to make a form where multiple products and quantities can be uploaded?

For example:
Bread x 10U
Cakes x 5U
Donuts x 15U

That is, a drop-down list that is generated after another, with an associated quantity. I appreciate your answers.

2

Isn’t this a typical use case of “Is APartOf” referential architecture?

3 Likes
3

You don’t. You add another child table.

3 Likes
4

I did it like this, a child table and I made the parent record part of this table. I had no choice, but it is comfortable anyway.

Thank you for your answers.

1 Like