I’m trying to use Google Calendar automation to create a sequence of 1 hour appointments in my calendar.
I don’t have and don’t intend to create a field in my table that has the start and end time of each appointment entered manually.
I was trying to develop a system at which the automation would count the number of appointments that day and automatically place the next one the hour after.
Any ideias on how to create a field in the table that counts the number of appointments that same day?
With that I could use DATEADD() to increase the starting time of the appointment by 07:00am + number of appointments of that day.