+2Hello,
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.
Best answer by ScottWorld
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
+35When 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
+2When 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
Works after changing Date settings
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.