Hi team,
I am looking for a solution to create the time slots from the existing date & time field. One of our clients wants a solution to this. They have created the appointments in the Google calendar which is synced with the Airtable. Here the synced record has only a single date and time and they want us to book 3 appointments in this slot by automating the bookings with 30 min intervals of actual time. For example, if an appointment is set for May 22, 2023 2 PM then the 3 bookings will be booked like May 22, 2023 2 PM, May 22, 2023 2:30 PM May 22, 2023 3 PM. Does someone have any idea how should we create a formula to create this kind of slot in the Airtable field?
