Copy jotform submissions sheet into another sheet

  • Profile Image
    lamccray
    Asked 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..

  • Profile Image
    Carina
    Answered 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
    lamccray
    Answered 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
    BryanPaulo
    Answered 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.