Make meetings marked "Every Day" show on selection of any single day in search

[BethShaffer]

We have a database of meetings where each meeting selects the days of the week they meet via a multiselect dropdown.  The choices are:

Every Day
Sunday
Monday
Tuesday
Wednesday
Thursday
Friday
Saturday
Contact for Day

The problem is that when a visitor searches meetings, if they select Monday for instance, only meetings that contain Monday appear.  Those marked Every Day should also appear in the search results, but because of the static nature of these dropdowns, it doesn't work that way.  

I need some kind of script that tells Caspio to include results for Every day on a search for any day of the week.

I tried adding all the days, comma separated, to the Value field in my Days table, but that gets me nowhere.  If I try to include the Value field in the search, it breaks the whole page and no results appear at all.

Is this even possible or is it yet another limitation of Caspio?

[telly]

Hi @BethShaffer,

I suggest add another criteria for that field and set it to display only and then on the advance tab enable onload to Everyday. Basically the logic will be like Field is equal to value OR every day. 


Here is the expected result: 


 

[telly]

Hi @BethShaffer,

Here is another example, it shows on how to set it up:https://howto.caspio.com/faq/reports-datapages/how-to-add-today-to-after-now-or-next-x-days-criteria/