About Zapier Community
New to our Community? Get to know more about our space and how to make the most of your time here.

Code of Conduct Community FAQ's Zapier Common Questions What to Expect

Get Started With Zapier
New to Zapier? We have got you covered with our Zapier 101 Resources.

Zapier Essentials

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

Zapier Reading
All of our best learning resources can be found here.

Featured Articles Show & Tell AI Hub Zapier Tools Hub

Learning Groups
Excited to meet other builders? Check out our interest areas full of doers, dreamers, and in-betweeners.

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.

Best answer

Find a Bubble thing by searching listed items

  • 23 February 2023
  • 5 replies
  • 279 views
DaveMo

Hello,

 

I have a Bubble.io data type “orders” that contain a list of “order items”s unique ids. I am trying to compile these individually listed “order items” so they can be used in an invoice line items using the QB online integration. 

 

However, when I use the workflow “Find a Bubble Thing in Bubble” to search for unique IDs of order items from the listed order items unique IDs, nothing is found. I’ve tried variations “in list” “contains list” etc but nothing is working. I’ve tried formatter by Zapier as well to split text.

 

Any and all help is greatly appreciated, this is the one thing holding up my MVP. 

https://zapier.com/editor/183850535/draft/183850536/setup

 

UPDATE: I’ve used Utilities in Formatter by Zapier to convert line items to text. I can use this to Find a Bubble Thing in Bubble but it only works if I use the first item, I can’t select multiple or it isn’t found. I’m still stuck trying to turn this list into individual line items for an invoice...

icon

Best answer by DaveMo 25 February 2023, 02:16

View original

5 replies

Troy Tessalone
Userlevel 7
Badge +14

Hi @DaveMo 

Good question.

For us to have enough context, please provide detailed screenshot with how your Zap steps are configured along with specific examples from Bubble, thanks.

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
DaveMo

 

 

Above is the first step where I’m formatting a list of order items to individually order items.

 

Below I’m trying to find those individual items in Bubble. As you can see the output from step two seems to work.

 

However, when I test this action the keyword is a list again. It will work if I just use output item 1, then I suppose I can do the same Find a Bubble Thing in Bubble for Output Item 2, Item 3 etc etc. Technically that would work however, I wouldn’t know how to add those results as line items for Quickbooks online...

 

Below is the Quickbooks Online Create an Invoice.

 

christina.d
Userlevel 7
Badge +9

Heya @DaveMo! 

Full transparency, your question had me stumped! But I wanted to share a similar question here that may help us both get unstuck?

There’s also this handy guide my teammate Nick wrote on Formatter and line items specifically:

Also I may be way off base here but in your first screenshot for the search term field - does does adding a comma after every Output Item (ex: Output Item 1: xxx, Output Item 2: xxx, Output Item: 3: xxx, etc) change the format at all?

Keep us posted, we’d love to get to the bottom of this with ya!

DaveMo

Thank you @christina.d!

 

I was recently able to hack together a solution. I first had to create a zap to invoice. Then I created another Zap to update the invoice.

 

The problem was that I was able to find the order items for an order. However, I was not able to find specific fields for those order items. So what I did instead was create and save the fields (as lists ie price, quantity, description, price x quantity) I needed for the invoice and save those on the order level. Once I had that information I was able to update the invoice line items with the field lists that were created on the order level. 

 

They really did not make it easy but doing it this way I didn’t even need to use the zapier formatter. There were dozens of ways this could’ve worked where I got one step from the finish line.

 

On bubble side I also had to create a 15 second delay when triggering the zap to update the invoice in order for it to compile.

christina.d
Userlevel 7
Badge +9

Ayy, @DaveMo! Stoked to hear you were able to sort this out. 🤗

Thanks for keeping us in the loop and sharing what ended up working for ya! 

 

Reply


Terms & Conditions