Komkom

[Bolufmi]

Komkom

Please,I can’t select multiple products while creating an order.
But I can do that in Airtable but not working in Glide, I am unable to select multiple products in a drop down or choice field.

Also, the calculation should be correct.
In Airtable I can add multiple products to one order but not in Glide.
BELOW ARE THE SCREENSHOTS.

[xaviigna]

Hello @Bolufmi If you need to create a multiple products order you should use a ‘helper’ table. Put all items in one table and then Query those items based on the main Row ID of the order. Otherwise, use JSON.

Hope it helps

[Bolufmi]

Please, can you show me how to go about it?
Either the helper table or the JSON.

Thanks.

[Jeff_Hager]

@Bolufmi

unable to select multiple products in a drop down or choice field.

[xaviigna]

Yeah that should work but don’t let him manipulate the data after the submitted.

I think this is a better approach because he is calculating totals and playing across items

↳Create a helper table (Joined table) and manipulate the data from that starting point. I might be wrong

hope it helps @Bolufmi feel free to DM if you have any question