Skip to main content
Question

Automation Not working as expected

  • Mar 19, 2021 8:51 PM UTC
  • 0 replies
  • 53 views

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
------------------------------
This topic has been closed for replies.

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
------------------------------