Running totals from spinners

  • Profile Image
    lhogan
    Asked 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
    Saccarab
    Answered 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