I am trying to update a Google sheet when I add or update a record in AirTable; however when I go through the mapping process when setting up the action, some of my fields (two URL fields and 1 date field) do not show up as options to map. These cells have contents in AirTable. I have also tried to update the zap, refresh the fields, completely recreate the zap, and attempt both with empty AT cells and filled AT cells. Nothing is working. Any advice?
+14
Hi
Good question.
Airtable only returns fields with values.
Make sure to test with a record that has the desired fields populated.
Are the fields all the same type? (If yes, then what field type?)
How to change trigger test data: https://help.zapier.com/hc/en-us/articles/8496310366093
Hi
Yes, the fields are populated and it is two URL fields and one date field.
+14
Did you try changing/refreshing the trigger test data?
How to change trigger test data: https://help.zapier.com/hc/en-us/articles/8496310366093
We’d need more proof in the form of screenshots showing the record ID and fields in Airtable as well as the same one in the Zap trigger examples.
Here are the fields in all places
Airtable:
Sheets:
Zapier:
+14
We’d need more proof in the form of screenshots showing the record ID and fields in Airtable as well as the same one in the Zap trigger examples.
+14
The provided screenshots don’t show an Airtable Record (preferably with the Record ID) that has the fields populated, along with the corresponding record pull in to the Zap trigger as an example.
+14
Airtable Record IDs.
Formula field:
RECORD_ID()https://support.airtable.com/docs/finding-airtable-record-ids
The record ID is in both Sheets and AirTable, and can be seen in both screenshots
+14
You have not provided a screenshot of the record data populated in Airtable that matches to this record ID.
Here it is in both AT and Sheets.
+14
Are you able to provide screenshots with the other fields populated for that record in Airtable for the data points that aren’t available in the Zap trigger?
Yes, see below:
+14
Were you able to pull thru an updated version of the Airtable Record in the Zap trigger: https://help.zapier.com/hc/en-us/articles/8496310366093
Hi
Good question.
Airtable only returns fields with values.
Make sure to test with a record that has the desired fields populated.
Are the fields all the same type? (If yes, then what field type?)
How to change trigger test data: https://help.zapier.com/hc/en-us/articles/8496310366093
I need a way to recognize that an Airtable field is empty, which is different from the field not existing at all. Hope this makes sense.
+14
Might be best to post your own topic so it gets proper attention.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
