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

    The data from Jotform that is sent to my own spreadsheet is changing my formulas

    Asked by molishows on June 22, 2015 at 02:27 AM

    i am useing google sheets for my data from jot form and have my own spread sheets that i need to transfer the data to in the same doc as the doc set up when i linked it. in my sheets i have made there is some formulas that take the data from the submission page. each time the data comes in from jot form it is changing my formulas that the line of data is linked to and moving the formulas down a line. how do you stop this?! i useing your form as it links to google sheets well and i have my spread sheets in google sheets and it can input the data for me!

    formulas same doc
  • Profile Image
    JotForm Support

    Answered by Welvin on June 22, 2015 at 06:01 AM

    Are you using the IMPORTRANGE function in Google Spreadsheet to pass the data from the form's spreadsheet to your own sheet? I don't have the idea yet on how to stop the problem from happening, but if you can share us the spreadsheets, we would be happy to check it further for you.

    But maybe, you should check the formula and see if there is something that overrides the functions making it move down a line.

    Thanks