AnsweredAssumed Answered

Want to update the displayed record based on the date

Question asked by karenarvin on Apr 1, 2015
Latest reply on Apr 1, 2015 by philmodjunk

Title

Want to update the displayed record based on the date

Post

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!

Outcomes