Sales AppSheet

[AdrianoPva2022]

How do I add items with their quantities, in the same sale... Ex: Customer buys 2 shoes and blouse on the same order)

[RezaRaoofi]

You would need 2 tables; one for Orders, and one for Order Details to keep each ordered item in a separate row, then the two tables would be related to each other using a Ref column in Order Details table.

I recommend reading at least step 1 of this articles below:

https://intercom.help/appsheet/en/articles/1100263-app-design-101

and these two articles on relationship between entities:

https://help.appsheet.com/en/articles/895267-data-the-essentials

https://help.appsheet.com/en/articles/961426-references-between-tables