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

    Is it possible to assign cells in the spreadsheet widget to columns in a Google Sheet through the GS integration?

    Asked by KCROSBY on April 01, 2017 at 11:56 PM

    I have a fairly complex table created using the spreadsheet widget and would like to be able to send data in some of the cells to row data in a Google Sheet. Currently, each submission of my form results in all of the data from the spreadsheet widget populating a single cell on the Google Sheet.

    Page URL:
    https://form.jotform.us/70895838035164

  • Profile Image

    Answered by Sven on April 02, 2017 at 08:58 AM

    Unfortunately, it's not possible to break the submission data in the google spreadsheet. Altering the data will break the integration and create a new spreadsheet. However, a workaround can be arranged to add some functions, to eventually copy and split the data into a separate sheet. 

    Please refer to this thread that might be of help for you:

    https://www.jotform.com/answers/290516-

     

    Thank you.