Help

Issue ISO8601 date format from Calendly through Make

Solved
Jump to Solution
234 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Jokoast
4 - Data Explorer
4 - Data Explorer

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 :

Jokoast_0-1735573263295.png
And the field in the record is configured this way :

Jokoast_3-1735573384338.png

Gets as input :

Jokoast_1-1735573290582.png
But creates a record with :

Jokoast_2-1735573320143.png

What can i do ? Seems that something is wrong but can't figure out where.

 

1 Solution

Accepted Solutions
ScottWorld
18 - Pluto
18 - Pluto

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

Screenshot 2024-12-30 at 12.02.16 PM.png

See Solution in Thread

2 Replies 2
ScottWorld
18 - Pluto
18 - Pluto

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

Screenshot 2024-12-30 at 12.02.16 PM.png

Works after changing Date settings

Jokoast_0-1735595279227.png