Dec 30, 2024 07:44 AM
Hello,
I have an issue with ISO8691 date format between Calendly and Airtable using Make.com
My workflow is Calendly (Watch Events) > Airtable (Create a Record)
Calendly sends an object with a date field :
Airtable configured this way in Make :
And the field in the record is configured this way :
Gets as input :
But creates a record with :
What can i do ? Seems that something is wrong but can't figure out where.
Solved! Go to Solution.
Dec 30, 2024 09:05 AM - edited Dec 30, 2024 09:06 AM
When you're using Make's Calendly modules to send dates & times to Airtable using Make's Airtable modules, you will need to format those dates & times in Make in a special way.
Please see the screenshot below to see how you will need to use Make's formatDate() function to send these times to Airtable.
In my screenshot below, I've got it set to MM/DD/YYYY h:mm A, but if you're in Europe, you might need to change it to DD/MM/YYYY h:mm A.
Hope this helps! If you’d like to hire an expert Airtable consultant to help you with anything Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld
Dec 30, 2024 09:05 AM - edited Dec 30, 2024 09:06 AM
When you're using Make's Calendly modules to send dates & times to Airtable using Make's Airtable modules, you will need to format those dates & times in Make in a special way.
Please see the screenshot below to see how you will need to use Make's formatDate() function to send these times to Airtable.
In my screenshot below, I've got it set to MM/DD/YYYY h:mm A, but if you're in Europe, you might need to change it to DD/MM/YYYY h:mm A.
Hope this helps! If you’d like to hire an expert Airtable consultant to help you with anything Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld
Dec 30, 2024 01:48 PM
Works after changing Date settings