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

    I need to see generate sums from my submissions

    Asked by narrowbridgecandles on August 18, 2016 at 10:42 PM

    I am creating forms that gather orders over a period of time. I sell 6 different products. I am producing candles in relationship to where the numbers are with the orders.

    I know I can export the form submissions into an excel file where I can then generate a sum of all the orders for each kind of candle.

    Is there any other ap or widget that can add up field from many form submissions that I can view as they come in? 

    As it stands I will need to export the submissions everyday for months and manually add up the fields which is a huge waste of time for me.

    I was also looking at the Google Spreadsheet Integration Ap which might solve this problem ( if the form submissions update automatically, and I have a sum calculation entered into google forms, than I can just view this form daily with live data, without having to export over and over and do the calculations over and over).

    Do the Google Spreadsheet Integration Ap automatically update as new form submissions come in? Has this been working smoothly?

    This has been quite a puzzle to figure out, any help you can offer here would be greatly appreciated.

    Thanks so much,

    Jonah

    Submissions generate my submissions creating forms new form problem excel
  • Profile Image
    JotForm Support

    Answered by Rose on August 19, 2016 at 03:36 AM

    Google spreadsheet integration is of course possible in JotForm. And it works fine for your situation.  As long as you receive submission, those should be pushed there automatically. 

    I think following guidance can answer most of your question about it.

    https://www.jotform.com/help/228-How-to-Integrate-Form-with-Google-Spreadsheet

    If you have more questions, please do not hesitate to contact us.