Add More than 1 product in cashier app

AppSheet AppSheet Q&A
, , , ,
1

I am building a cashier software to log transaction. But the problem is I am still unable to find solution where I can record more than 1 product (with their details like price, expiry_date, barcodes). Just like normal cashier transaction is that you will have 1 receipt number, but it contains alot of items. and it could only hold 1 item per 1 receipt number. Anyone could help?

I already asked ChatGPT, and their solution kinda work. But it leaves a warning sign on my transaction log.

1 Like
2

These template could help out.

https://www.appsheet.com/templates/A-sample-app-for-adding-product-to-a-cart-and-purchase?appGuidString=35ca2abe-74a6-4cad-afa4-75bab46635ea

https://www.appsheet.com/template/appdef?appName=OrderCaptureHow-to-71626&appId=OrderCaptureHow-to-71626#Data.Columns.Products

1 Like
3

This is a really basic “parent & child” or “one to many” relationship. You can find tons of info by doing a general search on either of those terms. This is done by having 2 tables, one of which has a Ref type column that points to the other table.

4

I decided to recreate the cashier app and idk why now it works. Before, the id on cashier_details always give me error warning sign. But thank you for the answer