My worksheet has following two tables
Table 1 : Category
-
category_id
-
main_category
-
sub_category
Table 2 : Vendors
-
vendor_id
-
sub_category
-
venodor_name
Table 1 : Category Sample data as follows
-
1,ENTERTAINMENT,OTT
-
2,SHOPPING,SHOPPING_APPS
Table 2 : Vendor List sample data as follows
- 1,OTT,Netflix
- 2,OTT,Hotstar
- 3,OTT,Sony Live
- 4,OTT,SHOPPING_APPS, Amazon
- 5,OTT,SHOPPING_APPS, Walmart
How to make a depended dropdown using two sheets / two tables in a single view.
ie when user select category dropdown, it shows dependent sub category when user select a sub category it further shows vendor dependent dropdown.
LinkedIn
Twitter
