I have finally figured out how to search database using multiple checkbox filters.
But when I go to page or refresh my page there is information in my table without any filters being applied.
This is happening before there are any checkboxes selected(filtered).
How can I have the table start empty when the page loads as well as when none of my checkboxes are selected?
Why not just have the table hidden on load and only show when there are results to show in it?
Or use dataset set filter.
https://www.wix.com/corvid/reference/wix-dataset.Dataset.html#setFilter
I did try having the table hidden on load but once it has been filtered the table is still there with some content even though none of my checkbox filters are checked.
Would a screen shot and posting my code help?
I have figured a way to have the table to be empty on load.
Can someone help me on when non of the filters are selected that the table pulls no information?
Have a look at this page as it shows how to only have the table load if their are results to show.
https://support.wix.com/en/article/corvid-tutorial-capturing-and-displaying-ratings
Wix already do a checkbox dropdown tutorial too.
https://www.wix.com/corvid/example/checkbox-dropdown
Plus, check other previous forum posts too.
https://www.wix.com/corvid/forum/community-discussion/how-to-add-a-multi-checkbox-search-data-filter
https://www.wix.com/corvid/forum/community-discussion/filtering-using-multiple-checkboxes
I have figured it out thanks. But there seems to be some issue or bug.
If I put information directly in database my page works properly it can be filtered and when no checkboxes are selected nothing is populated in the table.
But if I create a page and put the user inputs for the fields and link them to the database when the information goes into the database it doesn’t get filtered and always shows up on the page.
Does this mean that there is something wrong when the information is being entered in my user form? What could be the issue?
Looks to be if I have more than 3 checkboxes on my input page then the issue happens. (Data get populated into database and matches input page form) But will always show on my table and not get filtered.
But if I have 3 or less checkboxes on my input page then everything works correctly. (Data goes in database and then can be filtered and displayed correctly on table).
Can someone help me out with this?