What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.
At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.
We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.
Creating multiple rows/entries in Google Spreadsheet per specific field in JotformsAsked by PJ_ 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.
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.
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. :)
I have move your question separately here http://www.jotform.com/answers/654813
We will attend to it shortly