Has anyone tried out the new google calendar automation?
I have two tables: timeslots and reservations. For the start and end date of the calendar invite, I use the lookup to get the times from the timeslots table. Unfortunately the automation doesn’t support lookup fields yet so I made a formula instead (it’s just the field name of the lookup).
When I test the automation, it fails! It cannot parse the start and end time. Any workarounds to this?