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

    Integration with google sheets is not working

    Asked by sebasromo on June 28, 2016 at 05:51 PM

    Hi! I found an answer to my question but the image is not displayed https://www.jotform.com/answers/430834-Google-Spreadsheet-submissions-can-I-add-columns-and-rows


    The same thing is happpening. Every time a new line is added to the submissions sheet, in the processing sheet, where I have all my formulas, it jumps from =sheet1B4 to =sheet1B7 (if 7 lines where added due to the submission. 

    Do you have any clues on how to solve this?

    I need to copy and paste the formulas every time I want to update my results :(

    Thanks for the help.

  • Profile Image
    JotForm Support

    Answered by BDAVID on June 28, 2016 at 06:12 PM

    The screenshot is showing now. So, please take a look a the thread again: https://www.jotform.com/answers/430834, and let us know if that helps.

    Another way to do this, would be by pulling data from the integrated spreadsheet to a new spreadsheet by using IMPORTRANGE, and then customize the new one as you want to.

    Let us know if you need more help, we will be glad to assist you.