4 Replies Latest reply on Jun 19, 2019 10:51 PM by Norbert Maijoor

    Linking a "Day" based Roster into a Calendar

    Kyle Treasure

      Hi everyone,

       

      I'm a little stumped with this one but I'm sure someone will have the easy answer!!

       

      I have a set of Roster data which runs in a two week cycle, based off a 'link number'.

       

      Thus, each employee will have the following table assigned to them (2 week in place of the one below)

       

       

      Link NumberMON_JOB_1TUE_JOB_1 WED_JOB_1 THU_JOB_1FRI_JOB_1 SAT_JOB_1 SUN_JOB_1
      1TRAINING TRAINING TRAINING TRAINING TRAINING OFFOFF
      2OFFOFFOFFWORKWORKWORKWORK

       

      Keep in mind here that the 'MON_JOB_1' is the column header.

       

      I need to turn this into a full calendar, whereby I link a table similar to the one as follows, to the corresponding values in the table above.

       

       

      01/02/201902/02/201903/02/2019
      MON_JOB_1TUE_JOB_1WED_JOB_1

       

       

      I just need to figure out how to link the value from the first table (eg 'TRAINING') to a date.

       

       

      Happy to provide more detail as required.


      Thank you so much in advance to anyone who can help.

       

      KB