# Setting up multiple options for each product in a form - how? **URL:** \ **Category:** Ask for Help\ **Created:** [April 9, 2020, 3:45pm UTC](https://community.glideapps.com/t/setting-up-multiple-options-for-each-product-in-a-form-how/6681 "2020-04-09T15:45:22Z")\ **Posts on this page:** 5\ **Page:** 1
**Author:** ![Rasha](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rasha/32/4585_2.png) [@Rasha](https://community.glideapps.com/u/Rasha)\ **Post date:** [April 9, 2020, 3:45pm UTC](https://community.glideapps.com/t/setting-up-multiple-options-for-each-product-in-a-form-how/6681/1 "2020-04-09T15:45:22Z")
I’m setting up a sample order form for products with three variables, each is a mandatory selection for customers: 1. Product: (select product) 2. Box size: (select box size) 1 fillet ($25) 5 lbs fillets ($100) 10 lbs fillets ($200) 1. Quantity (select quantity) 1 2 3 Creating all possible combinations of each product doesn’t seem practical. I’ve tried using relations but it doesn’t appear to be the way. There’s also a finite amount for each product - another challenge. In the original version of the form, the product choice was limited, so having two choice components in the form was sufficient (see below). The first component pulled from a (product name - price) column on a “Products” sheet, the second from a (Quantity) column on an “Options” sheet. ![snip](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/1/1207b2393027a7df83e4ff30fc1524b86b7059d0.png) Am I going about this wrong? ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [April 11, 2020, 5:14pm UTC](https://community.glideapps.com/t/setting-up-multiple-options-for-each-product-in-a-form-how/6681/2 "2020-04-11T17:14:50Z")
I’m guessing you’ve gotten more answers from this thread? > [@Dynamic Dependent Choices](https://community.glideapps.com/t/dynamic-dependent-choices/6234/4): > > Hello Jaime, could you please explain this a little more?, I need to so something like this. I need a choice component to show countries and then a choice component to show cities of the country selected in the previous choice component. I don’t understand how to set the visibility conditions, also could you please share your sheet? Thank you ---
**Author:** ![Rasha](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rasha/32/4585_2.png) [@Rasha](https://community.glideapps.com/u/Rasha)\ **Post date:** [April 12, 2020, 9:37am UTC](https://community.glideapps.com/t/setting-up-multiple-options-for-each-product-in-a-form-how/6681/3 "2020-04-12T09:37:56Z")
Hey there. I’ve checked out the various options on that thread including th Dynamic List Filter in your Concepts app. There are many permutations of the above scenario and the app is used by independent parties (via copy this app) so relying on visibility in component features is not an option especially for larger and more complex product lists. I actually wanted to delete this post but have no permission. ---
**Author:** ![AlfredoZGC](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/alfredozgc/32/4958_2.png) [@AlfredoZGC](https://community.glideapps.com/u/AlfredoZGC)\ **Post date:** [April 12, 2020, 3:41pm UTC](https://community.glideapps.com/t/setting-up-multiple-options-for-each-product-in-a-form-how/6681/4 "2020-04-12T15:41:26Z")
@Jeff_Hager I’ve got some answers but I haven’t found the solution yet. I need my choices to be dinamic depending of the previous choice ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [April 15, 2020, 2:10am UTC](https://community.glideapps.com/t/setting-up-multiple-options-for-each-product-in-a-form-how/6681/5 "2020-04-15T02:10:30Z")
> [@Filter based on customer profile inputs](https://community.glideapps.com/t/filter-based-on-customer-profile-inputs/6654/8): > > @AlfredoZGC For the future, this is a separate topic, so start a new one next time. You will need a sheet that lists all of the Countries. You will need another sheet that lists all of the Cities and the associated Country. You will need a sheet that lists all of the Districts and the associated City and the associated Country. Create a template column that joins the the Country and City into one column. First create a choice component that points to the sheet that contains your Co…