First, just to touch on usages of barcodes. There is no magic. Your products/services will need to have barcodes created for them - if there isn't any already for them. There are several free services that can help.
Next, you will need to setup the barcode in your datasource- basically simply attach the barcode result to the product row. This is easiest done by adding a barcode column to your Products table, making it Scannable. Then when you enter or edit the Product, scan the barcode and save it. Once you have all the barcodes associated, the Products are ready to be used.
On the Orders side, there will ALSO need to be a Barcode field. This is scanned and used as a lookup to find the proper Product/Service.
When it comes to building an Orders app or feature, the approach that fits best in AppSheet is to use a Parent/Child relationship. You read more about here, References between tables
The idea is you have an Order table as a parent that tracks all of the main information for the Order - Order Date, Customer, Delivery Address, Order Total, etc. Then there is OrderDetails as a child table. This table tracks each Product/Service that belongs to the Order in its own row. This table is where you will scan the barcode to choose the order item, then add any other pertinent details, Size, Color, Quantity, Price, Total, etc.
When the relationship between the two tables is setup correctly, AppSheet automatically creates the proper input Forms which you can modify to your needs. But the main portion is that the Order row will have an OrderDetails table added where there is an Add button. Tapping Add takes you to the OrderDetail input Form to scan and then enter the other details.
That is the basic concept for this type of app. Please let us know if you have questions or had other ideas you wanted to explore.
I hope this helps!
LinkedIn
Twitter
