I’m working on an “ordering system” that tracks and calculates orders within a stock for an event.
The stock has drink products (coca cola, coke zero, …) and can deliver to certain locations (bars).
I’d love to give a form view to a bar manager and ask them to order for their own bar each night of the event.
The issue on hand is I can’t seem to enable a bar manager to “add” a product within the form, without creating a column for each product.
Ideally, I would have a sheet containing all products and all product info (content, packaging, …), one containing all info about a certain bar and one containing all info regarding the orders that have been put.
I’ve managed to figure out most of this, except for the “selecting a product and the amount” in a form.
I am looking forward to your insights!