Create Cascading Form to search State > City

Ask the community
,
2

Your wished functionality is doable by CODE.

There are several ways of how to solve it.

  1. DATASET-WAY
  2. WIX-DATA-WAY
  3. MIXED-WAY

What would be your steps?

  1. Choose item from FIRST-DROPDOWN → GETTING RESULTS !!!
  2. RESULTS adding to SECOND-DROPDOWN
  3. Choosing item from SECOND-DROPDOWN → GETTING AGAIN SOME RESULTS
  4. Adding the SECODN-RESULTS whereever you want.

https://www.wix.com/velo/reference/wix-data/query

$w.onReady(()=>{
	$w('#myDropdown1_IDhere').onChange(()=>{
		console.log("starting first filtering-process here");
		start_Filter1();
	});
});

function start_Filter1() {
	// use for example Wix-Data-Api here to get the filtered results.
	// or do it by the usage of a connected dataset to your database.
	//either write the results immediately to the dropdown_1 or return themback to the main-function and add them to the second dropdown.
	
}

Repeat these actions for DROPDOWN-2.

Maybe, after reading this post here, you will get some more ideas, who knows…