I have four depended filter
- Main Category
- Sub Category
- Sub Sub Category
- Sub Sub Sub Category
So depends on main category I need to filter sub category.
I have used folllowing formula in the Valid If property of Sub_Category
SELECT( category[sub_category] , [main_category]=[_THISROW].[main_category])
I was able to filter the sub category but I was not able to enter new values into sub category.
I wanted to filter the sub category based on the category1 also I wanted to enter new value to category 2 .
formula in sub_category
View I am getting to enter details
Here I wanted to enter new values also show a filtered dropdown based on the category one selection