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.