How to allow multiple product selections with individual quantities in a form?

1

Hello everyone,

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:

  1. Select more than one product
  2. 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?

Thanks in advance for your suggestions!

2

Is it meant for users with access to the doc?

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.

Do you follow me?

Let me know if this helps!

Pablo

1 Like
3

what you mean pseudo-forms with modals?

4

I just edited my previous post to add an example