Help on connecting repeater to a filtered dropdown via dataset

Ask the community
,
12

Thank you, slowly starting to make sense. I keep looking at the link you’ve shared and have found the screenshots you show, but it isn’t helping me to understand the code.

So on the user interface, my dropdown labels are sitedropdown, locationdropdown, advisordropdown, so is my DDprefix “dropdown” as you posted below?

var DATABASE = "Dupree_stuff"
var REPEATER = "#repeater2"
var DDprefix = "dropdown" //rename related dropdowns, like shown DDprefix -> dropdown)

I am still stuck on the below and what ids/fields should go in in place of the purple text:

for (var b = 0; b <items.length; b++) {
                    Options.push([])    
                    Options[a].push({"label": items[b], "value": items[b]})
                }
                $w('#'+DDprefix+(a+1)).options = Options[a]
                $w('#'+DDprefix+(a+1)).placeholder = DropDowns[a]    
            })
        }       
    }   
}
 
 function FILTER_ENGINE(){
 let query = wixData.query(DATABASE).limit(1000)
 
 //Filter-DropDowns-------------------------------------------
 for (let i=0; i < DropDowns.length; i++) {
 
 if (MEMdropdowns[i]!==undefined && MEMdropdowns[i]!=="undefined"){
            $w('#dropdown'+DDprefix+(i+1)).value = MEMdropdowns[i]
            query =  query.eq(DropDowns[i], MEMdropdowns[i])
        }
    }
    query.find()
    .then(async res => {
 let itemData = await res.items          
        console.log(itemData)
        $w('#'+REPEATER).data = itemData
    })
}