Apr 01, 2022 10:28 AM
Hi, I am new to airtable, I’m creating a zapier automation from airtable to google sheets transferring data from a view (which is locked so no changes can be unwittingly made), when I test within Zapier the record fills into google sheets correctly but when its running later by itself it only transfers over 3 or 4 out of the 8 fields to be mapped, so in principle it works but there is some issue on collecting the data. The fields missing are dates, text and currency fields that i formatted in. google sheets, which is what I am wondering is causing the problem. Can anyone direct me as to what things to check? Thanks!
Apr 01, 2022 12:10 PM
Are there any error messages in Zapier?
Apr 01, 2022 12:12 PM
No, reading up on it something that might be happening is that its passing the data over before I’m finished filling it in in the original location.
Apr 01, 2022 01:00 PM
Scrap that, did a test and it didn’t update until it was finished, I think its because I have formatted the google sheet columns and then its not able to map them! But without the end format they don’t work for me.