Adding filters from database

Ask the community
,
1

i am trying to add filters from an excel database that i uploaded to my data manager. i would like to add numerous filters so that people can narrow down there search. i am going to be selling tires and wheels and various other products so the excel data i have is large and it would be nice if people can filter what they are looking for.
similar to these sites https://www.1010tires.com/Wheels/AR+ATX or https://kxwheels.com/kx/tire/tiresize_search/
i want a checkbox style filter like the ones attached.
i have tried searching for this and dont really understand some of the generic examples.
thank you.

349×707 22.1 KB

2

On your search page, you can easily have a repeater on that page which shows all your tyres and wheels or just a set number of items in a repeater.

Then you can have a checkbox list like you have got on the left, which will either filter your list after the user has chosen all their checkbox options and clicks on a apply filter button. Or you can have the checkboxes filter the repeater after each checkbox is ticked.

Or you can filter your repeater with a dropdown choice like on the right, where each dropdown filters the repeater as they go down in the choices.

There are a lot of different options for you to do, however all of them will require a chunk of code to be written for it.

Have a read of this section first.
https://support.wix.com/en/corvid-by-wix/basics

Repeater:
https://support.wix.com/en/article/about-repeaters
https://support.wix.com/en/article/about-displaying-database-content-in-a-repeater
https://www.youtube.com/watch?v=uiftGNZsLXA
https://www.vorbly.com/Vorbly-Code/WIX-SUBMIT-FORM-AND-UPDATE-REPEATER
https://www.vorbly.com/Vorbly-Code/WIX-REPEATER-WITH-MULTIPLE-FILTERS
https://www.vorbly.com/Vorbly-Code/WIX-REPEATER-WITH-FILTER-BUTTONS
https://www.vorbly.com/Vorbly-Code/WIX-CODE-REPEATER-SORTING-BUTTON
https://www.wix.com/corvid/reference/$w.Repeater.html

Checkbox:
https://support.wix.com/en/article/working-with-the-connect-checkbox-panel
https://www.wix.com/corvid/example/checkbox-dropdown
https://www.vorbly.com/Vorbly-Code/WIX-REPEATER-MULTIPLE-CHECKBOX-FILTERS
https://www.wix.com/corvid/reference/$w.Checkbox.html
https://www.wix.com/corvid/reference/$w.CheckboxGroup.html

Dropdowns:
https://support.wix.com/en/article/dropdown-settings
https://support.wix.com/en/article/working-with-the-connect-dropdown-panel
https://www.wix.com/corvid/reference/$w.Dropdown.html
https://support.wix.com/en/article/corvid-tutorial-adding-collection-data-search-functionality
https://www.wix.com/corvid/example/search
https://codequeen.wixsite.com/dropdown
https://www.youtube.com/watch?v=EhXed0u6wh0
https://www.youtube.com/watch?v=r0DLqkRDJ34
https://www.vorbly.com/Vorbly-Code/WIX-REPEATER-MULTIPLE-FILTERS-WITH-RESET
https://www.vorbly.com/Vorbly-Code/WIX-CODE-DROPDOWN-OPTIONS-FROM-DATABASE
https://www.wix.com/corvid/forum/wix-tips-and-updates/example-no-database-duplicates
https://www.wix.com/corvid/forum/wix-tips-and-updates/example-remove-duplicates-from-connected-dropdown-options

Results Table Button Filtering
https://www.wix.com/corvid/forum/community-discussion/search-a-database
https://www.youtube.com/watch?v=-nMeGbXAdrc

Querying Your Data
https://support.wix.com/en/article/corvid-working-with-the-data-api
https://www.wix.com/corvid/reference/wix-data.WixDataQuery.html

Set Filter on Dataset (so in theory you could have one repeater on a page which just shows tyres and another repeater on another page which just shows the wheels, however both would be using the same dataset for it’s info)
https://www.wix.com/corvid/reference/wix-dataset.Dataset.html#setFilter

Enjoy having a code read and starting to get your head all around it.

3

Hi, I have tried using some of these examples and i cant seem to figure this out. im not sure what i am doing wrong.
I enabled Corvid, created a new page called “Wheels”. i imported my data, added a repeater from the “lists and grid” templates. i connected all the data from my database. Everything shows when i preview my page.
However, when i add a multi section checkbox from the “Add Page”, i can not get it connected to my fields from my database.
I would like to add checkboxes so that customers can narrow their search.
i am trying to add the following boxes: Brand, Style, Diameter, Width, Offset, Finish, ect.

PLEASE HELP !!!

thank you,

865×527 8.92 KB

349×707 22.1 KB