I am trying to append my airtable records to a google sheet at regular intervals, including my last modified column. How can I get it to append the actual value, and not just the character length of the value. I’m getting results like 29, 30, 29, 29… for my rows instead of 8/18/2021 10:27:31 or whatever
Hi @Mark_Hostetler - I don’t think this is going to work. I’m guessing your automation is something like:
At a scheduled time → Find Records → Append Row to Google Sheets
The problem is that Find records returns a list or an array of records and you need a way to iterate through these to append them as individual rows on the Sheet. However, Airtable Automations don’t offer an iterate component directly.
One way around this would be to run a script in the automation as the 3rd part, but this is going to need a lot more coding (the script would be able to iterate through the list of records returned and post them to the Sheet).
Another way would be to change the automation to work off a view - e.g. when a record enters a view. Here your view might be when the created at time is more than 10 minutes ago. In this scenario, you’re dealing with each record individually, so you can append to the Sheet easily. The downside of this method is that every record triggers the automation, so you burn through a lot more of your automation allowance.
That would explain my other issues as well! Thank you for clarifying this!
This topic was solved and automatically closed 3 days after the last reply. New replies are no longer allowed.