How can I make a single submission result in multiple rows being added to a Google Sheet?

  • Profile Image
    Asked on July 11, 2017 at 01:29 PM

    I'm new to JotForms, but I think it's the solution I've been looking for.  I'm trying to make an order form for my clients that allows them to order multiple items.  The problem I'm running into is that I need each item to have multiple fields (Book Number, Page Number, Document Type, etc.) and have each item ordered end up on its own line on a Google Sheet, with all the fields having their own columns so that each order can go into a fully sort-able table.  The Configurable List option works really well for inputting the information, but all the data of a Configurable List ends up as a bunch of JSON pairs in a single cell of the Google Sheet.

  • Profile Image
    Answered on July 11, 2017 at 02:49 PM

    There's a workaround to achieve that but it would require a bit of work.

    That's to use regular fields on each of them, then align the fields side by side by shrinking them. (Right click the field > Shrink)

    To make them repetitive, simply duplicate the fields e.g. 4 times and use show/hide condition to reveal them depending on the number of orders selected.


    Feel free to clone this form so you can see how it was setup.

    If you need further assistance, let us know here.

  • Profile Image
    Answered on July 11, 2017 at 02:57 PM

    Thank you for the really quick response!

    I thought about doing what you suggested, and it would sort of work, but that would result in multiple fields that need to be the same field in order to use them in a database.  You'd end up with fields "Book Number1", "Book Number2", etc, but there just needs to be multiple entries into the "Book Number" field.  Also, I will always have an unknown number of entries with each submission.

    Is it possible to perform a sub-entry?  For example, if a person was filling out the form, they'd put in their name, email, etc., then fill out the fields defining their order, click an entry submit button to enter the details for that part of the order, but the name and email fields would remain populated and on screen until the click a final submit button.

  • Profile Image
    Answered on July 11, 2017 at 04:40 PM

    The fields in the form can be displayed separately by using form collapse field or a page break to create multi-page forms. However, the fields still exist in the same form and when the submission is received they will be displayed as you receive a single page form submission. Unforutnately, it is not possible to have multiple submit buttons on the form. 

    The only workaround at this moment to have the submission data in the separate columns is to have separate fields on the form. 

    Hope this information helps!