I have a zap that sends form dates (e.g., 22/01/2024) to Airtable, but the date field remains empty. Adjusting date formats did not resolve the issue.
I experienced similar issues when trying to integrate form dates into Airtable using Zapier. In my case, I discovered that even though the dates looked correct, Airtable was expecting a precise format. I resolved it by utilizing Zapier’s built-in formatter tool to convert the date string into a format Airtable recognizes. In addition, I verified that both the form and Airtable were aligned in terms of timezone settings and field configurations. It turned out that even minor discrepancies between the formats could cause the field to remain empty.
Encountering issues with form dates integration in Zapier to Airtable is common. I resolved a similar issue by considering that the data might be correctly formatted but not parsed as dates in Airtable. I found that adding an intermediary step to handle the format conversion using a code or custom formatter step in Zapier ensured the dates were recognized. Additionally, verifying that the field types in Airtable are configured as date fields prevented any misinterpretation. Checking each mapping meticulously and validating through logs helped uncover subtle misconfigurations that caused the device to ignore the data upon reception.
hey, try adding a custom code step to force the date into iso format before sending. i had similar probs and reformatting within zap fixed it. also check if airtable really supports that date type. good luck!