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

    Embedded formula on google spreadsheet

    Asked by jotformhalalcateringsg on July 31, 2012 at 01:32 AM


    My order form is intergated with google spreadsheet. I like this solution so much that I added coloumns to track the status of every incoming order. Everything works fine.

    So, I embeded formula and drop down list to the status columns to make it perfect. However, new record will not be insert into these rows with embedded formula. It will skipped them and insert the new record into a 'clean row'.

    Is there anyway to get around with this ?


  • Profile Image
    JotForm Support

    Answered by jonathan on July 31, 2012 at 02:36 AM

    Hi Wendy

    I had observed this also on the form integration to google spreadsheet. For now, this is how the integration behaves. It seems you can only do your formulation and calculations at the 'end'.

    Meaning, you can modify the sheets for computation purposes only after it is decided that the submission report data is final or completed.

    However, I also discovered that you can do a 'real-time' up-to-date computation and formulation without affecting the submission sheet.

    This is by doing all the computation/formulation on another sheet on the spreadsheet.

    Please check this form spreadsheet. There is another Sheet2(at bottom) where I created formula/computation to compute some data from the original submissions sheet.

    This the the form I used. You can test it and checked again the spreadsheet. See if the formula on Sheet 2 is updating.


    Please inform us if you have further inquiry.