Hello,
I have 3 dropdown lists connected to a collection, each one to a column, the second one is enabled and filtered when we make the first choice, and the third enabled and filtered when we make the third choice. however, when I preview the project, the first dropdown list does not show the items in it at all
here is the code that I used. If anyone can help I would be very grateful.
$w . onReady ( function () {
uniqueDropDown1 ();
});
function uniqueDropDown1 (){
wixData . query ( “BEIRUT_ZONES_BUILDINGS” )
. limit ( 20 )
. find ()
. then ( results => {
const uniqueTitles = getUniqueTitles ( results.items );
$w ( “#cadasterCitizen” ). options = buildOptions ( uniqueTitles );
});
function getUniqueTitles ( items ) {
const titlesOnly = items . map ( item => item.fieldkey );
return [… new Set ( titlesOnly )];
}
function buildOptions ( uniqueList ) {
return uniqueList . map ( curr => {
return { label:curr , value:curr };
});
}
}
export function cadaster_change ( event , $w ) {
uniqueDropDown2 ();
$w ( “#parcelIdCitizen” ). enable ();
}
function uniqueDropDown2 (){
wixData . query ( “BEIRUT_ZONES_BUILDINGS” )
. contains ( “cadaster” , $w ( “#cadasterCitizen” ). value )
. limit ( 20 )
. find ()
. then ( results => {
const uniqueTitles = getUniqueTitles ( results.items );
$w ( “#parcelIdCitizen” ). options = buildOptions ( uniqueTitles );
});
function getUniqueTitles ( items ) {
const titlesOnly = items . map ( item => item.fieldkey );
return [… new Set ( titlesOnly )];
}
function buildOptions ( uniqueList ) {
return uniqueList . map ( curr => {
return { label:curr , value:curr };
});
}
}
export function parcel_change ( event , $w ) {
uniqueDropDown3 ();
$w ( “#buildingCitizen” ). enable ();
}
function uniqueDropDown3 (){
wixData . query ( “BEIRUT_ZONES_BUILDINGS” )
. contains ( “parcel_id_” , $w ( “#parcelIdCitizen” ). value )
. limit ( 20 )
. find ()
. then ( results => {
const uniqueTitles = getUniqueTitles ( results.items );
$w ( “#buildingCitizen” ). options = buildOptions ( uniqueTitles );
});
function getUniqueTitles ( items ) {
const titlesOnly = items . map ( item => item.fieldkey );
return [… new Set ( titlesOnly )];
}
function buildOptions ( uniqueList ) {
return uniqueList . map ( curr => {
return { label:curr , value:curr };
});
}
}