redirect user to page based on a response in the dropdown

Ask the community
,
4

Hi,
You can query the database, check if the user selected the relevant city / state and redirect to the page.
Here’s a code snippet:

import wixData from 'wix-data'; 
import wixLocation from 'wix-location'; 

$w.onReady(function () {
	$w('#searchBtnId').onClick(()=>{
		//collection name
		wixData.query("vendedores")
		//first dropdown value
		.eq("state", $w('#stateDropdownID').value) 
		//second dropdown value
		.eq("cidades",$w('#stateDropdownID').value )
		.find() 
		.then( (results) => { 
			let firstItem = results.items[0];
			//redirect to the link 
			wixLocation.to(firstItem.link);
		}) 
		.catch( (err) => { 
			let errorMsg = err; 
		} );
	});
});

Click here to learn more about the to function of Wix Location API.
Click here to learn more about the query function of Wix Data API.

Should the issue persists, please send us the site URL and the page name (the name, not the page URL…) so that we can have a look.

Good luck,
Ta.