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

    Form deletes excel formula

    Asked by Tackettpro on November 17, 2015 at 06:53 PM

    When the form sends the data to my google sheets it deletes the cell formula. So we have to go in and manually input the data. Major pain.

    Note the last entry. It should read 20 in the last column but Jot form deletes the formula.

    This also happens with Google Form when we send data to a  Google Sheets form with cells containing formulas.

     

    Any solutions? 

    excel formulas send data spreadsheet reset spreadsheet
  • Profile Image
    JotForm Support

    Answered by jonathan on November 17, 2015 at 11:24 PM

    When the form sends the data to my google sheets it deletes the cell formula. So we have to go in and manually input the data

    Unfortunately this is how the Google Spreadsheet integration works. 

    If you redo the integration process, it will reset the Submissions and will recreate the Submission sheet again, then populate it with submission data from the form.

    Try not to remove the integration if necessary so that you will not have to do the integration process.

    Hope this help. Let us know if issue remains.

    Thanks.

  • Profile Image

    Answered by Tackettpro on November 19, 2015 at 01:22 AM

    I am wanting Google Sheets to auto calculate the totals of my order. I input the formula into Sheets and it works when I manually type in the info. However, when Jot form sends the info to Sheets it erases the formula on those columns. So I have to go back in and manually past the formula into each entry. 

  • Profile Image
    JotForm Support

    Answered by Chriistian on November 19, 2015 at 03:23 AM

    Hi,

     

    As my colleague mentioned, this is how the Google Spreadsheet integration works. If you try to edit the spreadsheet integrated to Jotform, it might break the integration. You can try to add your calculation to a different/separate sheet and just link it to the spreadsheet integrated to JotForm.

     

    Regards.