Creating a search form with multiple (optional) fields

Is it possible to create a form to search a mysql db where there are multiple search fields on the form but the user can choose any of them as criteria. Not sure how to handle the empty fields in wappler ui?

ex form has 3 fields: date name location

query possible: date between first and second date and location = california (the name field is left blank on the form)

Thanks,
Rick

Community Page
Last updated: