Is it possible to automatically switch views based on the time of day?
For example, I have a Dashboard view made up of several ‘Ref’ views. One of the ‘Ref’ views is for the current days’ orders, labeled “Today’s Orders”. This view basically becomes obsolete after lunch, as we switch gears to a view called “Tomorrow’s Orders”.
Is there anyway to apply some sort of Show_If formula, or maybe another method so that “Tomorrow’s Orders” shows up between noon to midnight, and “Today’s Orders” show up between midnight to noon?