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.

Tks in advance!!