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

    Google spreadsheet in JotForm using ImportRange function

    Asked by Cameron on February 19, 2014 at 02:56 AM

    I have a few questions. I currently use the Google drive feature to capture info imputed from my jotform. In the spreadsheet made from jotform , I rearrange the columns around will the info still go in the right field.

     

    Basically what I need is to get the info from my spreadsheet that is generated from jotform on the spreadsheet on to another sheet which our warehouse fulfills our orders. I have made it where the info gets transferred right now using =importrange feature when they edit it, it messes the whole sheet. up.

     

     

    What I'm asking is if you have any suggestions on how I get the info from the Google Drive Spreadsheet that jotform has made on to another sheet automatically and where I can have that sheet edited without effecting the spreadsheet since its an importedrange.

     

    Thank you for your time and thoughts,  any suggestions will be very helpful.

    Page URL:
    www.pinnpt.com/request_samples

    JotForm rearrange and
  • Profile Image
    JotForm Support

    Answered by jonathan on February 19, 2014 at 04:10 AM

    Hi,

    What you can probably do before you do the importRange process is to have another copy of the JotForm spreadsheet and execute the importRange function using the copy only. This way the original data source (Jotform spreadsheet) will always be safe and never modified.

    Another method you can try is using import range Key (documentation). I think this method will not touch the internal content of the spreadsheet when it does the import process. So it should not mess up the JotForm spreadsheet.

    Hope this help. Inform us if you need further assistance.

    Thanks!