I have completed the code to have the dropdown to filter out via profession and State but I don’t want it all the items in the data base to be visible when first viewed. I have seen the collapse on load but unsure of where it should be entered. Can anyone shed some light on it.
import wixData from ‘wix-data’;
$w.onReady(function () {
//TODO: write your page related code here…
});
export function dropdown1_change(event) {
let searchBusinessProfessional = $w(“#dropdown1”).value;
$w(“#dataset1”).setFilter(wixData.filter().contains(“businessProfessional”, searchBusinessProfessional));
}
export function dropdown2_change(event) {
let filterStore = $w(“#dropdown2”).value;
$w(“#dataset1”).onReady( () => {
if (filterStore === "Georgia") {
$w("#dataset1").setFilter(wixData.filter().eq("georgia", true));
}
if (filterStore === "New York") {
$w("#dataset1").setFilter(wixData.filter().eq("newYork", true));
}
if (filterStore === "Florida") {
$w("#dataset1").setFilter(wixData.filter().eq("florida", true));
}
if (filterStore === "South Carolina") {
$w("#dataset1").setFilter(wixData.filter().eq("southCarolina", true));
$w("#repeater1").expand();
}
}
)}