Search dataset through month and year

Ask the community
,
1

I would like to get the result of my delivery report through month and year of delivery.

I have a dropdown for month and input year and once search button was clicked it should display the deliveries of the searched month and year on table i prepared.

981×281 11.3 KB

On the dataset the delivery date is only one field.

I don’t know how to filter the dataset through delivery date field using only month and year and display on table only its 5 fields ( 5 columns on table) instead of all the fields in dataset. And on the 6th column I would like get the percentage of the sold goods.

I hope someone can help me, I’m new.

2

Filtering is a very popular issue and there is no one right way to write your code to filter your dataset.
Check the links on filtering by dropdowns:

  1. https://www.wix.com/corvid/forum/community-discussion/help-with-multiple-dropdown-s-to-filter-a-dataset-and-populate-a-repeater-with-results-using-wix-cod e

  2. https://www.wix.com/corvid/forum/corvid-tips-and-updates/example-search-a-database

  3. https://www.wix.com/corvid/example/cascading-form

  4. https://www.youtube.com/watch?v=EhXed0u6wh0

  5. https://www.youtube.com/watch?v=r0DLqkRDJ34

  6. https://www.vorbly.com/Vorbly-Code/WIX-REPEATER-WITH-MULTIPLE-FILTERS

  7. https://www.vorbly.com/Vorbly-Code/WIX-REPEATER-MULTIPLE-FILTERS-WITH-RESET

  8. https://www.wix.com/corvid/forum/community-discussion/filter-one-dropdown-by-another

  9. Corvid: About Creating Searches and Filters of Displayed Data

  10. Filtering Database Content Displayed on Your Page

  11. About Filtering and Sorting Database Content Displayed in Page Elements

And of course many forum posts on filtering by date:

https://www.wix.com/corvid/forum/search/filter-by-date
https://www.wix.com/corvid/forum/search/filter-by-month

3

thanks