Dropdown Menu and Subs Best Options

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:

Choice 2

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.

1 Like

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.

1 Like

Alright. Let me try it out and get back to you. “Cracks fingers”

1 Like

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

Arts & Collectibles

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

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

Okay it worked!

Here is a photo!

It’s going to be hell to reorganized tho.

1 Like

This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.