How can I use one field to filter the drop-down options in another field?

When a user selects a value in Field 1(Region), I only want the corresponding data for that region be available for selection in Field 2 (Chapters). Any ideas on how to do this?

1 Like

Good question. So you mean if someone selects Florida from a “state” drop down, automatically the second drop down will only have a list of cities in Florida or something like that?

That is correct.

There is an example here: https://www.wix.com/code/home/example/Cascading-Form

Thank you @shantanukumar847 This certainly got me a lot further than when I started. In the example provided, they are performing a search. I need to SAVE the selected data to the database collection because my fields are on a registration form. I needed to narrow the choices when someone is registering so that when they submit it saves to the database collection for future reference. Any suggestions?

@lwoodward72 You can use wixData.insert to insert the data normally into a database. Just code the correct field keys to input elements on the page.