I am creating an events site. I want to filter events by location, type and date (month, year)
I have followed an online tutorial linked below and have dropdown working with location and type but want to add date options.
While I know I can create two new fields in the database called "Year" "Month" I would prefer not to and have the dropdown linked to the datefield in the dtatabase.
Is this possible. Basically a user selects Month and Year from two different dropdowns and then the scripts checks that against the datefield in the database.
If not can I just add a date picker to the dropdown
Sample code I use is
functionsearch(){wixData.query("Properties").contains("status",String($w('#dropdown1').value)).and(wixData.query("Properties").contains("propertieType",String($w('#dropdown2').value))).and(wixData.query("Properties").contains("title",$w('#input1').value).or(wixData.query("Properties").contains("agentName",$w('#input1').value))).find().then(results=>{$w('#propertiesRepeater').data=results.items;});
Here is a link to the tutorial any help welcomed
Thanks
Really 480 people have read this but no one knows how to do it
Can it be done