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

    Running totals from spinners

    Asked by lhogan on June 14, 2017 at 01:34 AM

    Hi everyone, I have a spinner that users can select a number in from 1 to 15. This works fine, but I would like to add all responses to this together and put a result on a virtual report. Is there any way to do this sort of calculation within visual reports? I can get the result pretty quickly from downloading the excel export and summing the column, but I'd like something that live updates if possible.

  • Profile Image

    Answered by Saccarab on June 14, 2017 at 03:49 AM

    You could use Google Spreadsheet integration instead of excel.

    That would probably solve your issue but you might possibly need to add a formula to do the summing operation on the column you mentioned.

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