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
------------------------------
Sign up
Already have an account? Login
Login to the community
Login with Quickbase US – quickbase.com Login with Quickbase EU – quickbase.eu
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.