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

    Question on Google Spreadsheet Integration

    Asked by chudson374 on March 02, 2016 at 10:16 AM

    I would like to create some formulas in the Google Spreadsheet. It seems that if I create them, and then a new submission is made, that it overwrites any changes I've made to spreadsheet.

     

    I'd like to hide some columns (like the IP address), resize some others, and do some formulas. Is there a way to do this without your spreadsheet over-riding my customizations every time the form is filled out?

    create new submission formulas then
  • Profile Image
    JotForm Support

    Answered by BJoanna on March 02, 2016 at 12:35 PM

    I have integrated on of my forms with Google Spreadsheet and I was not able to replicate mentioned issue. Changes that I made on spreadsheet, like hide/delete column, were not overridden when new submission came through.

     

    Can you please try to re-integrate Google Spreadsheet, to see if that will resolve your issue.

    1. Removed the integration in your form.

    2. Clear the Form cache.

    3. Log out from JotForm.

    4. Log in to JotForm.

    5. Reintegrate the Google Spreadsheet.

    Hope this will help. Let us know if you need further assistance.