For Instance today day is Monday. so you only want to show those restaurants who have happy hours on Monday and hide those who do not have ?
Am I right?
If this is what you want I think instead of making a “Do a search for:Restraunt”
Make - “Do a search for :happy hours”
condition- “Days of the week contains current day”
Adn you have already linked the happy hour to a restraunt so in the repeating group to populate the name of the restaurant you can use “current cell’s happy hours restrunts name”
now in every 24 hours you can update the current day option set to make this entire process dynamic
Hope this helps
If any point of my solution is wrong feel free to reply this helps me grow
This seems like a very complicated way to store happy hours. Why not just a openingTime (number 1-24) and a closingTime (same)? It would also allow you to find records already in progress or upcoming etc…
Thank you to everyone who chimed in with some helpful recommendations. I realized I was using “Do a search” for the Restaurant data type and when I switched it to the Happy Hour data type I was able to get everything to display and hide how I would like it.
@nocodenikhil I ended up using conditional statements to show the happy hours according to the day selected in the drop-down. Here’s what that looks like:
@code-escapee One reason is because a restaurant’s happy hour offering on Monday is different than the offering on Tuesday. A second is because I liked the formatting more this way and it is more clear for the restaurant when setting up their happy hour times in their dashboard.