I have a form for a Contacts table that collects specific data. I have another table for Leads that I need to pull this data into. I already have it linked and that works fine. The problem lies when the form is submitted. I would like a way to auto-match this data. For example, the Contacts Table contains an “email address” field. The Leads table is set up to pull the Contact info from the new record into different sort options. As it stands right now, I have to go in and manually link the contact info. I thought that by adding an email address field into the Leads table I could somehow auto-match it. Any ideas? Thank you.
Page 1 / 1
Airtable doesn’t do any sort of auto-matching between tables, even when there’s a field linking the two together. You could probably pull it off with either Zapier or Integromat, though. You would set your zap/scenario to trigger when a new record is created by your form, then use what’s in that record to create the link you need to the
Airtable doesn’t do any sort of auto-matching between tables, even when there’s a field linking the two together. You could probably pull it off with either Zapier or Integromat, though. You would set your zap/scenario to trigger when a new record is created by your form, then use what’s in that record to create the link you need to the
Thanks Justin.
Yeah I figured as much. I do have Zapier and have used it somewhat to do some basic automated stuff. I tried making this work but couldn’t get the right trigger combo to get it to work. I would appreciate some step by step help! Thanks,
Ramsey
Thanks Justin.
Yeah I figured as much. I do have Zapier and have used it somewhat to do some basic automated stuff. I tried making this work but couldn’t get the right trigger combo to get it to work. I would appreciate some step by step help! Thanks,
Ramsey
Sorry for the delayed reply. Things are quite busy on this end, and I won’t be able to get to this for a while. If someone else can jump in and assist, that would be much appreciated.
Bumping this because now that Airtable has built-in automation, I am wondering if I can accomplish this without the need of an outside app. I just about have it figured out, except I am stuck on the action step - it’s triggered when my “contact info” field is empty (because the form submission doesn’t have that), but does include the email address. I want to search the Contacts Table for a matching email address, and then update the Leads table with the link to the field. Any ideas?
Bumping this because now that Airtable has built-in automation, I am wondering if I can accomplish this without the need of an outside app. I just about have it figured out, except I am stuck on the action step - it’s triggered when my “contact info” field is empty (because the form submission doesn’t have that), but does include the email address. I want to search the Contacts Table for a matching email address, and then update the Leads table with the link to the field. Any ideas?
@Ramsey_Stoneburner This is definitely doable. In fact, I tested it the other day while writing another response:
@Ramsey_Stoneburner This is definitely doable. In fact, I tested it the other day while writing another response:
I think this is the step I am stuck at. I have the first step, find record, and the conditional logic to pull the matching record. But then updating the original record keeps throwing errors as I’m not sure which field to use.
Example, I don’t know if I should link using List or Grid and really what options to select here.
I think this is the step I am stuck at. I have the first step, find record, and the conditional logic to pull the matching record. But then updating the original record keeps throwing errors as I’m not sure which field to use.
Example, I don’t know if I should link using List or Grid and really what options to select here.
When looking at the list of options from the “Find records” action, scroll past List and Grid. Under “Make a new list of” you’ll see “Airtable record ID.” Insert that into the linked record field and it will link to the found record(s).
When looking at the list of options from the “Find records” action, scroll past List and Grid. Under “Make a new list of” you’ll see “Airtable record ID.” Insert that into the linked record field and it will link to the found record(s).
That did it! Took a minute, I had to set “Record ID” to the “Airtable record ID” first, but then followed your instructions for the linking process. Thank you so much this is pretty amazing!!
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.