Forum Discussion

PaulPeterson1's avatar
PaulPeterson1
Qrew Assistant Captain
5 years ago

Automation Not working as expected

I have a table that is feeding a calendar report.  Most events are system generated, but some are manually created to block out time on the calendar.  One of the things I want to be able to do is create a range of events based on the start date and end date.  This is frustrating at the moment because I did have it working, made a change and don't recall how I had the automation set before.  The idea is to have a start and end date.  The user will create the first event and an automation will create the remaining events.  As an example, suppose I want to create a vacation week.  The user would create the first record is created using the start date of 3/22 and an end date of 3/26.  The automation would create the remaining events for 3/23, 3/24, 3/25 and 3/26.

The trigger is set as:
and the action is:

I welcome your suggestions.

------------------------------
Paul Peterson
------------------------------
  • Hi Paul,
    Calendar reports are able to display a start and end date. So, why do you need to create additional Schedules? 
    If you do need/want additional Schedules then please explain the unexpected results that you're currently receiving.

    ------------------------------
    John Crosland
    Software Developer
    Inglett & Stubbs
    Mableton GA
    ------------------------------
    • PaulPeterson1's avatar
      PaulPeterson1
      Qrew Assistant Captain
      I need the event(s) for tracking purposes.

      As stated, the user is creating the initial event, the automation is currently creating the second and third event in the example above, but not the fourth and fifth.

      ------------------------------
      Paul Peterson
      ------------------------------
      • PaulPeterson1's avatar
        PaulPeterson1
        Qrew Assistant Captain
        I found the issue, the ticket number (key field) is based on milliseconds and the automation firing more than once in the same millisecond.  I adjusted the ticket number formula and now it is working as needed.

        ------------------------------
        Paul Peterson
        ------------------------------