Help

Annoying lookup issue

Topic Labels: Formulas
1206 7
cancel
Showing results for 
Search instead for 
Did you mean: 
Dom_Moir
5 - Automation Enthusiast
5 - Automation Enthusiast

Hi all,

• I’m asking Harvest to populate a field in table jobs called {client id by Harvest} via Zapier - this is working fine
• I then want AT to lookup the corresponding client {Name} in my client table that relates to the client ID {client ID - manual} in the calient table and populate the field {client name - lookup} in the table jobs

i cant make it happen for some reason… quite frustrating.

any thoughts?

7 Replies 7

What are you doing to try to create the link?

Are you trying to get Zapier to create the link, or are you trying to get Airtable to create the link? Is there a reason why you aren’t adding steps to your Zap to find the client and link it?

Dom_Moir
5 - Automation Enthusiast
5 - Automation Enthusiast

the zap successfully creates record in the Job table - the zap only offers the client id which is a numeric code.

after that, everything should be done via AT…

I also have the client id code in a field, in the client table next to the client name (the primary field)

i want to be able to pull the client name by looking up the corresponding numeric code in that table

Dom_Moir
5 - Automation Enthusiast
5 - Automation Enthusiast

and thanks for responding :slightly_smiling_face:

If you want Airtable to populate the linked record field based on the client ID code, you will need an automation in Airtable to find the proper record and link it. You would need a “Find records” action followed by an “Update record” action.

You could also have Zapier find the record in the other table and create the link. It would take the same basic steps–finding the record to link, and then updating the record.

Dom_Moir
5 - Automation Enthusiast
5 - Automation Enthusiast

Hi Kuovonne - again - thanks or your assistance.

here’s a quick grab - it might make more sense with this…

this is where i’m going wrong :confused:

Airtable

Thanks for the screen capture. When you open the linked record in the {Calculation 2} field, what do you see in the {Name} field? Are you sure that the {Name - Calculation …} field is based on the {Calculation 2} linked record field, and not a different linked record field?

Dom_Moir
5 - Automation Enthusiast
5 - Automation Enthusiast

Calc 2 click thru:

SAINT___Jobs__-_Airtable