Want to update the displayed record based on the date
I have a table with schedule information for several different groups; who's on call each shift/day each week. I enter the on-call schedules into the table several weeks in advance. I need to make only the relevant record, i.e. the one for this particular group for the current week, visible on the display layout. I know I could run a script to archive the old schedules and display the new ones all at once, say at 7:00 on Monday Morning, but the problem is the different offices change on-call schedules at different times. Some change at 7:00, some at 8:00, some at 8:30... Is there a way to change the displayed record/schedule for each group at the correct time? I'm running Filemaker Pro Advance 13 (Not Server) Thanks!
It's hard to give a detailed answer from such limited information, but you can probably set up something that updates at specified times of day by using the Install OnTimer Script where you calculated the interval from the current time.