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