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

  • Profile Image
    PJ_
    Asked 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. :)

     

  • Profile Image
    liyam
    Answered 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
    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. :)

  • Profile Image
    Brian 
    Answered 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
    jonathan
    Answered 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