1 Reply Latest reply on Apr 1, 2015 4:41 PM by philmodjunk

    Want to update the displayed record based on the date

    karenarvin

      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!