Small context : my trigger is when a subscription is cancelled in stripe, in this case I want to send the data of this cancellation in airtable, I can get the creation date but not the cancellation date, any idea how to find it ?
All I can find is the “Ended at” which is not a real date…
Thanks for your answers !!
Best answer by ken.a
Hey there @Impala,
No worries at all!
Thanks for giving that a try. One possible reason here is that the “Date churn” field on your Airtable only accepts a certain format of date. Could you please try changing the “To Format” field in the Formatter step, and match the format to the “Date creation” field.
I looked at the screenshot, and it seems like the “canceled date” is being returned as a Unix timestamp. I suggest adding a formatter step after the trigger to convert Unix to a readable date.
The formatting works well thanks, the output corresponds to the real date but when testing the action to enter the data in airtable, the date of churn is not taken into account and does not appear. Do you have any idea what this could be? Thank you for your answer
Thanks for giving that a try, and I’m glad it works well!
Before we dig deeper into this, to ensure that we have sufficient context, kindly share detailed screenshots of the Zap History data IN/OUT of the Airtable step. Please don’t/blur out include any personal information in the screenshot.
I appreciate the screenshot, but it’s not quite the screenshot that I was looking for. I apologize for the confusion. The Data IN/OUT of the Zap should be located in your Zap History: https://zapier.com/app/history
Please include the whole sectionof the latest Zap Run in the screenshot as well. Here’s an example:
Based on my observation, it is possible that you are using an older version of Airtable. If you are seeing a version number alongside the app name, it may indicate that you are running an outdated version of the application.
Could you please try changing the Airtable app to the latest version? Here’s how:
Turn off the Zap.
Click on the “App & event” section of the action step.
Click on “Change”.
Search for Airtable.
Select Airtable tagged as “Latest”.
Publish the Zap, and trigger it.
Please give that a try, and let us know how it goes!
Thanks for giving that a try. One possible reason here is that the “Date churn” field on your Airtable only accepts a certain format of date. Could you please try changing the “To Format” field in the Formatter step, and match the format to the “Date creation” field.