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.

Question

Multiple records in Airtable to convert to line items in Quickbooks online.

  • December 29, 2025
  • 3 replies
  • 12 views
dalenster

Hello,

I’m attempting to take multiple records in Airtable (Print Orders) and convert each record as separate line items in Quickbooks Online as an invoice.  I got everything in order and ran a test and it appears it’s only appending one of the two Print Orders in the invoice.

I have the Find Record as such: https://www.awesomescreenshot.com/image/58091162?key=1bcc1abcc2db2cfdfe025f5d83fc2c29

THen I created the line items correctly, I think: https://www.awesomescreenshot.com/image/58091223?key=8df6e4ebcdb233e0d4164a28d7df9592

 

Create invoice in Quickbooks: https://www.awesomescreenshot.com/image/58091292?key=b65dce793991f409133e7cff733e61cd

I’m not sure what I’m missing. Any help would be appreciated.

3 replies

Sebastian M
Forum|alt.badge.img+2
  • Sebastian MZapier Staff
  • Zapier Staff
  • December 31, 2025

Hi ​@dalenster, thanks for reaching out 👋

 

I believe the Formatter by Zapier step should not be necessary.

 

Your Find Record in Airtable step should already be outputting the results as line-item arrays, as per this setting:

 

a5e012c476b4dc2114f7786db698a40c.png
(view image larger)

 

I’d suggest mapping the relevant fields directly from the output of your Airtable step into your QuickBooks Online step.

 

Hope this helps 😄

Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Troy TessaloneZapier Orchestrator & Solution Partner
  • Zapier Orchestrator & Solution Partner
  • December 31, 2025

Hi ​@dalenster 

Help links about using line items in Zaps: https://help.zapier.com/hc/en-us/articles/8496277737997-Use-line-items-in-Zaps

 

Formatter step is not needed.

 

Help link about expected values for dropdown lists: https://help.zapier.com/hc/en-us/articles/8496241696141-Add-custom-values-to-dropdown-menu-fields-in-Zaps

 

You probably need to add this Zap step: QBO - Find Products

 

Zap action: QBO - Create Invoice

This supports line items.

 

⚡ Troy Tessalone - AutomationAce.com | Platinum Zapier Solution Partner | #1 Zapier Community Contributor
Sparsh from Automation Jinn
Forum|alt.badge.img+6

Hey ​@dalenster,

The fields you are providing in the actions are empty as you can tell by their yellow colour. Your third action of Find Record is probably giving empty fields as the output.

You may want to fix that and see if it fixes your issue. Hope it helps!

https://zapier.com/partnerdirectory/automation-jinn | Zapier Silver Solution Partner| Automationjinn.com
Terms & ConditionsAccessibility statement