- BabysoftCCAsked on March 25, 2017 at 10:05 PM
I am trying to use Zapier to create a new invoice in Zoho Books via a JotForm. The issue is how to create the proper Line Items. Does JotForm support or have any way to create the appropriate Line Item array required by these invoice programs (like Zoho Books)?
As you can see in my form I have four (4) Sets of Line Items (Item Name, Quantity,Rate, Details).
I appreciate your help.
- JotForm SupportNik_CAnswered on March 26, 2017 at 06:35 AM
I assume you're referring to these fields:
Unfortunately, I'm not sure that this can be modified since it is a Zoho integration. But as a workaround, you could create those fields as regular text fields. Since Configurable list widget is passing to every integration as one field.
Then all values will pass to Integration as an individual field.
Could that work for you?
Please let us know.
- BabysoftCCAnswered on March 26, 2017 at 10:34 AM
No, I'm not looking at the configurable list widget. I am looking at the individual Item Name, Quantity, Rate, Details fields (of which there are four sets). Is there any way these can be configured into an array to be entered as line items into an invoice program (like Zoho Books). I'm sure there must be some people that use JotForm as an order form and would need to export that data into their invoice software (i.e. Quickbooks, Xero, Zoho Books, Etc Etc).
- JotForm SupportNik_CAnswered on March 26, 2017 at 11:56 AM
Oh, I'm sorry I misunderstood the problem.
Since I can not test that with my Zoho integration. Could you please check how the data is transferring from the Configurable list widget? What I mean is that you could use those fields from a Configurable list widget because, as I said in my previous reply, all values should come in array when they are submitted through Configurable list. So that might work for you.
Bottom line, you can check how the data appears from these fields:
And if it is ok then you can switch the below fields to configurable list widget:
Again, all values from Configurable list widget are going as an array to our integrations.
Please check and let us know how it worked for you.
- BabysoftCCAnswered on March 26, 2017 at 12:19 PM
Here is an image of what the Zapier Integration between JotForm And Zoho Books looks like (I have focused just on the area of the Line Items in the Zoho Books Invoice):
I have some test information in the merge boxes (like "test",and "1" in the above image), normally the field names from JotForm would go in there.
As you can see, each individual box in a single line item requires it's own individual field. Is there a way to specify exactly which boxes from within JotForm's Configurable List will be exported? It looks to me like there is just one field name for the whole widget and no way to parse out specific fields from within the configurable list.
Thanks again for your help.
- JotForm SupportNik_CAnswered on March 26, 2017 at 01:01 PM
Thank you for additional information provided.
Unfortunately no, I don't think that there is a way to specify which field from Configurable list widget will go to which field in Integration.
Could you please share how the Configurable list widget is showing on Zoho's side if it is showing as one field then it could work. If the order of those fields is not important of course.
Because this is how the data from a Configurable list is showing in Spreadsheet for example:
So I'm just thinking in that direction if it will show in the same way in Zoho integration.
We'll wait for your response.
- BabysoftCCAnswered on March 26, 2017 at 01:39 PM
When I put the Configurable List Widget Field ID into the Description Field for Zoho Books, this is what is imported into the Description Field on the invoice:
Doesn't look like Configurable List widget will work unless I can
parse out each individual box from the line item and import it into
the specific line item boxes in Zoho Book's Invoice.
If I use basic text and number boxes, I can fill one line item,
but then there is nothing that can trigger the next line item so new
invoice items can be entered. I'm assuming this is something that Zoho has
to figure out with the Zapier integration.
- JotForm SupportMikeAnswered on March 26, 2017 at 03:01 PM
- BabysoftCCAnswered on March 26, 2017 at 03:57 PM