Skip to main content

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

I’m trying to create a zap for a connection between Airtable and Quickbooks Online.

 

I need to search Customer in Quickbooks from the Airtable record. In Airtable, the company field is a lookup field from another table. When searching Quickbooks by this field in Zapier, it’s recognizing customer as a number and not successfully finding a match

Note: I confirmed the customer is formatted and spelt exactly the same in Quickbooks Online so the only thing I can think of is the lookup field is not formatted in the method that the search field needs?

Hi @ccamm086 

Good question.

The Search Value is the record ID from Airtable.

You would need to map a variable that has a value of the company name.

You may need to add a Lookup Field to the Zap table to bring over the Company Name from a different table.

 

Hi… the current setup is mapped to the company (previous screenshot) is a lookup field..

@ccamm086

Can you show screenshots of the matching QBO Display Name that has a value of “recMsbs14XHWCvsAE”?

 

That’s the issue I was trying to explain (Airtable is showing the company as numbers when using the lookup field and not the actual data)

Attaching screenshot from Airtable and QB

@ccamm086 

In Airtable, the Company is a LINK field type.

 

 VS (as an example) the Billing Contact field is a LOOKUP field type, which looks up fields from a linked record.

 

In Zaps, linked record fields show the internal Record ID from Airtable.

In Airtable, you would need to add a Lookup Field to pull over Company Name.

Then you can search by the Company Name value in the QBO step.


 

Yes, that worked. Didn’t realize it was a linked record and not lookup field. I feel dumb🤣

Terms & Conditions