- PJ_Asked on February 07, 2014 at 11:09 PM
We're planning to integrate Jotforms in our order processing, using Google Docs (Spreadsheet) to gather the data in a tabular manner. I can see that G-Spreadsheet is able to lay-out all data in a horizontal manner (fields are placed as headers, adding up a new row per submission). My question, however, is that would it be possible for Jotforms to give G-Spreadsheet the data in the following structure:
Submission 1 Name A Item1 Qty
Submission 1 Name A Item 2 Qty
Submission 1 Name A Item 3 Qty
As you can see, these entries came from a sing;e submissions, varying only on the 'Item' field. For example, a user will list down all of his/her orders in Jotforms with each order given its own field (item). Once submitted, each order (item) will have its own line entry in Google Spreadsheet, with Submission and Name being constant.
We would like to have the forms done like this to make the process much simpler. We wouldn't want our users to submit a new form each time they would add a new item.
- JotForm SupportliyamAnswered on February 08, 2014 at 06:39 AM
Unfortunately, what you're looking for is not possible, each row in the spreadsheet is only equivalent to a single submission. So for the ordered items, it will only fit inside a single row.
Please do let us know if you have further questions.
- PJ_Answered on February 09, 2014 at 08:52 PM
Hey there liyam, thanks for clarifying on this. We'll make do with the data we can get from Jotforms/G-docs the since Jotforms looks promising and very inuititive. Thanks again. :)
- BrianAnswered on September 03, 2015 at 04:57 PM
- JotForm SupportjonathanAnswered on September 03, 2015 at 10:37 PM
I have move your question separately here http://www.jotform.com/answers/654813
We will attend to it shortly