1 Reply Latest reply on Sep 23, 2014 7:13 AM by philmodjunk

    Dates Automation



      Dates Automation



      Hi! I'm very new to FM and I would like know if it is possible to automate certain dates and days of the week?

      Here's the scenario:

      Client enrolled on package lessons. Let's say he is scheduled on each Monday of the month with certain timings but started on the second week. The output would be like this if possible:

      08 Sept 2014    3:00 PM
      15 Sept 2014    3:00 PM
      22 Sept 2014    3:00 PM
      29 Sept 2014    3:00 PM

      Thanks guys! I would really appreciate your help on this matter.





        • 1. Re: Dates Automation

          Each entry shown should be a record in a related table, one for each pairing of date and time--which can be a single value in a timestamp field or a pair of fields, one for the date and one for the time.

          You can set up a global field or pair of fields specifying the day of the week and the time plus possibly a field specifying the number of such entries to create and then a script can generate this set of entries in a related table linked to your client table. (Use a portal to list the date/time entries for a given client.)