Help with JS Function

Ask the community
,
1

We have created a DB with, amongst others, tables containing Country and Region data…
We have created the following function to filter the region Dataset based upon the CountryName selected from the Country DropDown…

This does not seem to work at all… any help would be appreciated

Thanks…

export function CountryDd_change(event, $w) { 
 //Add your code for this event here:  
 let myCountry = $w("#CountryDd").value; 
 console.log(myCountry); 
 $w("#RegionsDataset").setFilter(wixData.filter().contains("CountryName", myCountry));
2

Hi Clive,

Collection fields usually start with a lowercase letter. Try changing ‘CountryName’ to ‘countryName’:

 $w("#RegionsDataset").setFilter(wixData.filter().contains("countryName", myCountry));
3

We changed the field names to ensure they started with a lowercase, and changed code to reflect this, still does not work

4

Laurence and I are working together BTW

5

Hi,
Is it possible that the name of the dataset element is dataset1 (default name) ?
If it still doesn’t work please share a link to your site and specify the name of the relevant page.
Roi

6

Make sure that you are using the Field Key ( not the Field Name). The Field Name is for human consumption only, the Field Key is used by Wix Code in queries.

472×910 24.8 KB

As Roi pointed out, make sure that you are using the correct Dataset name.

Also, is the dataset connected to the collection?

7

Hi,

Thank you so much, it was the name of the field, talk about a schoolboy error:)