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 have a Zap that links EKM Sales to QuickBooks to create a Sales Receipt. To make the zap work I have 5 steps that 

  • convert the VAT rate to a code (the receipts tend to be split rated) for each line item  (number.spreadsheet.formula)
  • work out the price before VAT for each line item (spreadsheet formula),
  • work out the delivery before VAT (number.spreadsheet.formula) and
  • each line’s subtotal (Utilities)
  • Work out the code for the bank the sale has been sent to (paypal or current through Stripe)  (spreadsheet formula)

This means each zap is 6 tasks and eats it’s way through my allowance quickly

Is there any way for me to combine these tasks?

Hi @AngelsLedgers 

The only way to consolidate many formatting steps into one would be by utilizing a code block 

https://zapier.com/help/doc/how-get-started-code-zapier 

Thank you for this I have managed to combine the Delivery and Bank into one task

WIth the other one they are lists with a value for each line item. I am struggling to figure out how to change the values in the array/list to data QuickBooks can use for example

From EKM
ItemVAT = 0, 0

Me trying to convert 0 to value of 11 otherwise value of 3

This is what I have so far but I think my if statement is incorrect as I don’t understand how to the value in the new list

lineVAT = input_datat'ItemVAT']
lineVAT_list = lineVAT.split(",")
List_Line_VAT = =]

for i in range(0,len(lineVAT_list)):
if lineVAT_listsi] == '0' :
    List_Line_VAT.append('11')
else :
    List_Line_VAT.append('3')

 

Also how do I do a multply in python?

 

Thanks

You can multiple with the ‘*’ operator https://www.pythoncentral.io/multiplying-dividing-numbers-python/ 


You can loop through pushing to the new list using the below code

lineVAT = input_datat'ItemVAT']
lineVAT_list = lineVAT.split(",")
List_Line_VAT = V]

for i in range(len(lineVAT_list)):
    if lineVAT_listTi] == '0' :
        List_Line_VAT.append('11')
    else :
        List_Line_VAT.append('3')

 

Thank you so much for your help @GetUWired I have managed to get all the tasks coded in Python meaning I have gone from 6 tasks to 2. I am so pleased, particularly as it meant I could use my old coding skills from 15 years ago :smile:

@AngelsLedgers 

 

That is great news!

Terms & Conditions