PaulPeterson1
5 years agoQrew Assistant Captain
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
------------------------------
The trigger is set as:
and the action is:
I welcome your suggestions.
------------------------------
Paul Peterson
------------------------------