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

    What if I have several forms, but I want them ALL to funnel into the same Google Spreadsheet? How do I do that?

    Asked by luxuryhomemagazinedc on April 09, 2014 at 05:48 PM
    same all
  • Profile Image
    JotForm Support

    Answered by EltonCris on April 09, 2014 at 06:32 PM

    Hi,

    That's not possible with the integration as of the moment.

    The workaround is to import submissions from different google spreadsheets into a single spreadsheet using importRange function.

    Here's how:

    https://support.google.com/drive/answer/3093340?hl=en

    Example:

    Formula

    IMPORTRANGE("0AgxqsUM6gnFjdDQ2OGV2U0ZUbTI3S3FfUEdfVWpnaFE", "Submissions!A1:C10")

    0AgxqsUM6gnFjdDQ2OGV2U0ZUbTI3S3FfUEdfVWpnaFE - is the spreadsheet key taken from the source spreadsheet URL after key=, example:

    https://docs.google.com/spreadsheet/ccc?key=0AgxqsUM6gnFjdDQ2OGV2U0ZUbTI3S3FfUEdfVWpnaFE&usp=drive_web

    Video:

    Hope this helps!