Hello all! I have a mentor/ mentee booking system I’ve set up through Airtable. However Mentors are looking to set-up standing availability. To do this I’ve added a Weekly or Monthly to the form.
I’m trying to use automation to trigger when they are selected and create new records (DATEADD 7 days ,etc), which simply need their email and the new times (a Week out, for 12 weeks, or a month out for the same). However I can’t get the automation to accept a formula (whether directly in the automation, or pulling from a new column) for the Date and Time field. It either says cannot convert the string to time, or when I have it correctly in date time then it tests successfully but leaves the date and time field blank in the new record.
Any ideas on workarounds? I was thinking maybe Zapier, but it would be very clunky and many steps. Not sure if there is a way to use a scripting block here.