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

    Copy jotform submissions sheet into another sheet

    Asked by lamccray on June 02, 2014 at 02:36 PM

    I would like to copy the sumbissions from a jotform generated google sheet but I am experiencing issues. I want to use the copy of the sheet to manage and assign the requests. The copied sheet does not auto copy the new submissions using the importrange function. To get it to update I have to manaually edit the function. Just to make sure this was an isolated issue I checked to see if importrange worked using two other spreadsheets and it worked fine. Does jotform prevent the copying of jotform generated sheets? Is there a work around to this issue?

     

    Thanks..

    JotForm checked google spreadsheet importrange
  • Profile Image

    Answered by Carina on June 02, 2014 at 04:48 PM

    I also could not import the Excel submission list into a Google Spreadsheet.

    I believe the best way is to create a Google Spreadsheet Integration in your form and then merging both spreadsheets. 

    Let us know if the problem persists.

  • Profile Image

    Answered by lamccray on June 03, 2014 at 08:01 AM
    I have the jotform data going to a google sheet. I have copied that sheet
    into another google sheet and I am having issues with the new sheet not
    updating automatically when new form entries are received.
    *Torri McCray*
    Business Systems Analyst | Information Technology
    University of Michigan Athletic Department | Stephen M. Ross Athletic Campus
    1000 South State Street | Ann Arbor, MI 48109-2201
    MGoBlue.com | Phone: (734) 936-0963 | Fax: (734)
    647-1188
    ...
  • Profile Image

    Answered by BryanPaulo on June 03, 2014 at 10:21 AM

    Have you used the IMPORTRANGE function? To fetch the data from the JotForm spreadsheet to the second sheet, kindly use the following syntax:

    IMPORTRANGE(spreadsheet_key, range_string)

    example:

    IMPORTRANGE("abcd123abcd123", "sheet1!A1:C10")

    spreadsheet_key - The long sequence of characters in the "key=" attribute of the URL. In the new Google Sheets, use the entire URL.

    You can read more about importrange function HERE.

    Let us know if you need further help.