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

    Does edited cell values in google spreadsheet remain unchanged when new submissions are received?

    Asked by Mlkr on October 09, 2014 at 06:24 PM

    Hi,

    Found this link while searching the forums.
    http://www.jotform.com/help/228-How-to-Integrate-Form-with-Google-Spreadsheet

    Also found a lot of forumusers discussing the problems with the spreadsheets not updating if they are manually changed. Is this problem fixed?

    What I would like to be able to do:
    - Open spreadsheet and change a single value imported from the form.
    - Have this changed value remain changed after next integration from the form into the spreadsheet.

    Or will this still break the spreadsheet integration?


    Thank you for your response!
    /Marcus M

    JotForm problem next not updating
  • Profile Image
    JotForm Support

    Answered by ashwin_d on October 10, 2014 at 12:17 AM

    Hello Marcus,

    Also found a lot of forumusers discussing the problems with the spreadsheets not updating if they are manually changed. Is this problem fixed?

    You should not edit the headers of the integrated google spreadsheet. Editing the first row text will cause the integration to break.

    Open spreadsheet and change a single value imported from the form.

    Yes you can edit any cell value of your integrated google spreadsheet except the first row displaying the column header.

    Have this changed value remain changed after next integration from the form into the spreadsheet.

    When you edit a cell value, it will be saved permanently. When new submission records are copied to the integrated google spreadsheet, the changed cell value will remain intact. If you remove the google spreadsheet integration form your form and integrate again, it will create a new google spreadsheet and it will copy the submission data you have in your form which will obviously not have the edited cell value.

    Hope this answers your query.

    Do get back to us if you have any questions.

    Thank you!

  • Profile Image

    Answered by Mlkr on October 10, 2014 at 05:23 AM

    Thank you for quick answer!

    Yes this answers all my questions and it looks like I will be able to build the function I am after with this :)

    I'll probably be back in the future with more questions ;)

  • Profile Image
    JotForm Support

    Answered by ashwin_d on October 10, 2014 at 07:24 AM

    Hello Mlkr,

    You are welcome.

    Do get back to us if you have any questions.

    Thank you!