3 Replies Latest reply on Aug 7, 2017 3:32 PM by mikeo'neil

    Please Help!  Need Script to Increase Time Fields by 30 Minutes

    bendavis1957

      I thought that this would be really easy but I've been beating my head against the wall for two days now.  I'm a novice and I've spent big $$ with a developer and was left high and dry at the end of the day on Friday.

       

      Basically, I have a database containing info on about 50 students.  Each student must be scheduled for one 30 minute lesson, one day each week.  So I have a time field for every student and each student has been assigned to a particular day.

       

      So, I did a simple sort on the day, or I could do it by name/alpha, but the idea is to determine the best day for each student.

       

      Then, I thought it would be simple to start out with a "Show Custom Dialogue Box, using a global field called "Starting_Time" to use for the first time slot for each day of the week.  Then, just take the first time (8:00 AM) and loop through the records adding 30 minutes to each students time field.  It would look something like:

       

      Bob     8:00 AM

      Bill       8:30 AM

      Amy     9:00 AM

      Ben      9:30 AM

       

      and just continue to the end of each day and repreating the process for the next day with 8:00 am as the start time.   Then, minor time changes could be made manually as needed.   Does anyone have a script that will work--hopefully that I can understand?