Basically when i test run a response from jotform, sent through zapier then to xero, the description, quantity and unit price is not seperated, but grouped together? ill show ya the screenshot of xero and my zapier lineup as the reference, any help is appreciated and also please explain thoroughly (?) since ive just gotten into this yesterday, thanks again!!
Hi
For us to have more info, post screenshots showing these:
The screenshot only shows how Zap step 6 is configured.
What about the other Zap steps?
Looks like you are passing an invalid number for the Quantity variable.
Value: 2 1
Notice the space between the numbers.
Also, it may be that the Unit Price variable value needs to be divided by 100.
e.g. 10200 / 100 = 102.00
You’ve posted screenshots showing the TEST tab, but that we need to see how your Zap steps are configured in the CONFIGURE tab while in EDIT mode.
Looks like you are passing an invalid number for the Quantity variable.
Value: 2 1
Notice the space between the numbers.
re: yes, i spaced it out since there are 2 different items
ive attached the others here
ive also used the help of chatgpt but seems only i could get this far
Zap action: Looping - Create Loop from Line Items
That Zap action expects the input values for the line items to be structured as an array.
The way you have the variables mapped for the 3 inputs it merely creating a concatenated text string.
If there will only ever be 2 line items to handle (as shown in your examples), then try using this Zap action: Looping - Create Loop from Text
If you will be using this approach, then you won’t need the Formatter steps.
However, if there can be 1+ loop iterations (e.g. could be 1 or 2 or 3 or 4 or etc.), then we will need to see how your Zap is structured in the DATA OUT from Zap step 1.
Info about handling line items in Zaps:
If you are looking to hire help, there is a directory of Zapier Partners: https://zapier.com/partnerdirectory
If there will only ever be 2 line items to handle (as shown in your examples), then try using this Zap action: Looping - Create Loop from Text
re: the examples were just hypothetical. and there will be more, maybe 5+ or 9+ items in a purchase order made from entering/ordering on jotform.
However, if there can be 1+ loop iterations (e.g. could be 1 or 2 or 3 or 4 or etc.), then we will need to see how your Zap is structured in the DATA OUT from Zap step 1.
re: the data out from zap step 1 is my jotform submission? if so here are the screenshots, and if not please specify which data out? thank you. I’ll also attach my whole string for reference.
the last couple of screenshots are empty since there is only 2 items ordered from jotform
Have you tried using a configurable list widget on the Jotform to collect 1+ items?
https://www.jotform.com/help/282-how-to-set-up-the-configurable-list-widget/
It’s likely that will output the data as an array of items that you can then use in this Zap action: Looping - Create Loop From Line Items
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.