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?
You can post now and register later.
If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.
Question
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?
Link to comment
Share on other sites
2 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.