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.


  • Profile Image

    Creating multiple rows/entries in Google Spreadsheet per specific field in Jotforms

    Asked by PJ_ on February 07, 2014 at 11:09 PM

    Hi!

    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. 

    Thanks. :)

     

    rows new form name horizontal integrate
  • Profile Image
    JotForm Support

    Answered by liyam on February 08, 2014 at 06:39 AM

    Hello PJ,

    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.

    Thanks.

  • Profile Image

    Answered by PJ_ 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. :)

  • Profile Image

    Answered by Brian  on September 03, 2015 at 04:57 PM

    I have the same problem.  Do you know of a workaround, perhaps using Google Forms?  What I'm trying to do is make a sign-up form for a scouting group and want to allow parents to sign up multiple kids (each getting their own row in the spreadsheet) from a single form submission.
  • Profile Image
    JotForm Support

    Answered by jonathan on September 03, 2015 at 10:37 PM

    @Brian,

    I have move your question separately here http://www.jotform.com/answers/654813

    We will attend to it shortly