I’m building a setup in Coda and need help with a form workflow.
I have two tables:
Products – a list of all the items we sell.
Orders – where we log each customer order, with the following columns:
Pick-up Date, Customer Name, a relation to the Products table, and Quantity (of the selected product).
I’d like to create a form view that allows the user to:
Select more than one product
Specify a different quantity for each selected item
Right now, using a multi-select relation doesn’t let me attach separate quantities to each product.
What would be the best way to achieve this in Coda?
If yes, you can create pseudo-forms with modals. Much more flexible than normal forms, but more cumbersome to set up.
If not, as far as I know your only option is to create a helper table as the basis for the form, where you ‘hard-code’ several instances of ‘Product’ and ‘Quantity’ (Product 1, Quantity 1, Product 2, Quantity 2, etc.). Then create an automation that whenever a form is submitted it creates multiple rows in your actual table.