How to use apsheet to add more than 1 item in form

This is the first time I need to do something like this to work in app sheet

On my one screen, I have The following data to input so it saves to Google sheet. this is my form Im using

_rowNumber= no input
Nom=auto input (key and label)
Datum= todaysdate
Kaart=type(price)
Kontant=type(price)
Prys=type(price)
Ontvang=type(price)
Kleingeld=type(price)
Francois=type(price)
Kotie=type(price)
Item=Text

Is it posible to do the following in apsheet, if so how do I do it

It must ask how many items there is, so if there is 3, it must then let me add a price for each one and the item for each one, then it must add the price together so when using received and back it must use the total of all prices.

https://www.appsheet.com/Template/AppDef?appName=Winkel-4890189&utm_source=share_app_link

https://docs.google.com/spreadsheets/d/1N3Opo0H1oBP4pLV9LIOyJnE3zwHfWGCyMyJIcht3YSA/edit?usp=sharing

0 2 145
2 REPLIES 2

It sounds you are looking for a kind of a "parent" & "child" relationship but though you can do it in the same table. First it asks how many items you need to add, and after the save, you would need to add equal amount of rows tied to that "parent". The "parent" row could have a virtual column that calculates the total.

Though you can use two tables with the same way but then you would have a Ref column in your child table.

Thank you, I not that good at doing this, not sure how to use a "parent" & "child" relationship from same table.  Each item will use a new row

Top Labels in this Space