I’m trying to have my secondary dropdown options only show specific choices based off the primary dropdown option.
I tried doing this via the Else-If-Then column but it just limited my selection no matter what choice I clicked.
Here is an example:
I herd that the array option is the best way to do it but does that mean I have to change these columns into arrays?
Here is what I’m trying to do:
This is for Pages
You can set a filter on your secondary choice component based on the ‘Screen Value’ of the first selected choice.
Do you mean “Filter Data?” If so, all that does it make my dropdown disappear.
It shouldn’t unless you are adding a visibility condition instead of a filter condition. Can you share a screenshot of how you filter is configured for your choice component?
Couple of things:
It doesn’t look like you are setting the filter correctly. It looks like you specifying a specific category and subcategory by typing them into the filter manually instead of using ‘Screen Values’.
The choice component may not be showing because you have filtered out all possibilities and it’s empty. From what I can see, there is no row in your table that contains both an ‘Automotive’ category, as well as a ‘Cars and Truck Parts’ Subcategory. There is however a row that contain ‘Automotive’ and ‘Bathroom Accessories’…as well as a row that contains ‘Computers Tablets’ and ‘Cars and Truck Parts’.
Based on how your data is structured, I’m not sure how you are trying to establish which subcategories belong to which category. I don’t see anything in your data to establish that connection.
What I think you need is a column to list all categories, and then two columns for the subcategory. One for the subcategory name and one for the category that it belongs to. (something like ‘SubcategoryName’ and ‘SubcategoryCategory’). Then it should be easy to create a filter on the subcategory choice component where the SubcategoryCategory is Screen → Category.
I’m not following in your third example as I don’t get what you mean by SubcatgoryName and SubcategoryCategory. Is that the same? I’m trying to recreate what I had posted in my Bubble example so I don’t have to list all the categories in a single row as I want to keep it organized.
Let’s start by answering this question. By simply looking at your table data, how do you know that the subcategory ‘Cars and Truck Parts’ belongs to the category ‘Automotive’? You should be able to know simply by looking at your data. I personally don’t see anything in your data that represents which category a subcategory belongs to.
Okay. So what I’m trying to do is eliminate the majority of subcategory options based on the primary category. While the data on the sheet doesn’t connect to each other, I was trying to find a way to filter it out. I was also hoping to do so with the Else-If row but it is limited.
Well, it will be really easy to create that filter if you add an extra column next to the subcategory and fill it with the category name that’s associated with that subcategory. I think you are overcomplicating it.
Honestly, instead of adding another column, I would probably just fill the subcategory column with the subcategory that is associated with the 3rd category, and likewise fill the category column with the category that’s associated with the subcategory. So in the end, the category column and subcategory column will have duplicates, and each column will populate the same number of rows.
You have to set up your data so things can connect together. I have no idea how you are attempting to do it with an IF column, but that shouldn’t be necessary. Think of the 3rd category as the primary column, then fill subcategory and category with the appropriate value that relates to each 3rd category.
Alright. Let me try it out and get back to you. “Cracks fingers”
Just as I thought I understand, I’m still confused.
How would I go about adding the columns? I think I get it but then it just gets confusing.
Are you going to add columns like I mentioned in my first suggestion, or are you just going to use your existing columns like I mentioned in my second suggestion?
If you are adding columns, then you can click on the the Plus button at the top right of the data editor.
I think I might have not explained my confusion better but I think I can now.
Using your first example, would it go like this
Category
Arts & Collectibles
Automotive
Baby
Books
AutomotvieCategory
Car & Truck Parts
Motorcycle Parts
Wheels & Tires
Is this what you are trying to say?
No, based on my first suggestion where you add additional columns, it would be something like this.
| Category | SubCategory-Category | SubCategory | ThirdCategory-SubCategory | ThirdCategory |
|---|---|---|---|---|
| Arts & Collectibles | Arts & Collectibles | … | … | … |
| Automotive | Automotive | Car & Truck Parts | … | … |
| Baby | Automotive | Motorcycle Parts | … | … |
| Books | Automotive | Wheels & Tires | … | … |
| … | Baby | … | … | … |
| … | Baby | … | … | … |
| … | Baby | … | … | … |
| … | Books | … | … | … |
| … | Books | … | … | … |
| … | Books | … | … | … |
But in honestly, based on my second suggestion, I think this would be better since you wouldn’t have to add extra columns and you can use the ones you already have.
| Category | SubCategory | ThirdCategory |
|---|---|---|
| Arts & Collectibles | … | … |
| Arts & Collectibles | … | … |
| Arts & Collectibles | … | … |
| … | … | … |
| Automotive | Car & Truck Parts | Carburator |
| Automotive | Car & Truck Parts | Engine |
| Automotive | Car & Truck Parts | Steering Wheel |
| Automotive | Motorcycle Parts | Clutch |
| Automotive | Motorcycle Parts | Forks |
| Automotive | Motorcycle Parts | Brakes |
| Automotive | Wheels & Tires | All-Season |
| Automotive | Wheels & Tires | Off-Road |
| Automotive | Wheels & Tires | Touring |
| … | … | … |
| Baby | … | … |
| Baby | … | … |
| Baby | … | … |
| … | … | … |
| Books | … | … |
| Books | … | … |
| Books | … | … |
| … | … | … |
This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.
