Nov 18, 2018 06:03 AM
Hi
I’ve created an integration from Zapier to AirTable.
My blue sky scenario would be, that when ever I populate a AirTable base with a new record, this record will include a unique email address for each row.
I want Zapier to detect each new record and send and email to the email value I put in the AirTable row. However, from my AirTable rows I frequently use “Link to another record” to other tables, and this is where I pull the email value from.
Zapier cannot read values in AirTables where the value is based upon values from “Link to another record”, is this just me?
Please see my screenshot.
Any help is welcome - I don’t know if this is a Zapier problem or an AirTable problem.
Nov 18, 2018 07:33 AM
i think i’ve run into the same issue you’re describing here.
what worked for me was adding additional columns that mirrored the linked columns to the table, so for your example, i would add another column “Begivenhed as text”, make it a formula where it just equals {Begivenhed}.
Zapier should recognize this new “as text” column with the correct contents. hope this helps.
Nov 18, 2018 09:02 AM
Thanks Mini_Ro I thought of doing exactly the same :slightly_smiling_face:
However I’d wish that was possible, instead of the case where Zapier simply cannot see the field.
Nov 19, 2018 02:44 AM
Hi
There are two ways you could deal with this requirement:
Create lookup fields within the table you are triggering the Zap from which bring the data from the linked record into the triggering record, or
Use a Find step in Zapier to lookup the records in your linked tables (using the record IDs held in the link fields in the triggering table).
Hope this helps…
Jan 09, 2020 08:57 AM
hi all
I’m struggling to get any of the workarounds to work for me - this is for an Airtable/Zapier/ActiveCampaign integration.
I am wanting a trigger where:
a) new record appears in a view
b) a contact with an email address contained in that same view is emailed
The challenge is that the email address of the column is being “lookuped” from another table, and ActiveCampaign isn’t therefore reading the email address for me to complete the search and identification of the contact.
ActiveCampaign is coming back as registering “no data” in the field at all, which is obviously a problem.
Keen if anyone has any suggestions for a workaround here - I’ve tried the approach of creating another column and putting that as equal to the lookup column…but this data is still not being registered by ActiveCampaign, which continues to think that the field is empty.
Many thanks in advance!