Calculate total number from various number entries in configurable list widget

  • Profile Image
    BeTheChange_Conviventia
    Asked on June 27, 2020 at 10:08 PM

    Dear team, 


    I have a configurable list which contains different rows. In each row the user is asked to enter a number (number of hours). I need to calculate the total number (of hours) that each user entered in the configurable list. If it is not possible to do it on the form itself, can you help me alternatively do it in the spreadsheet? the spreadsheet shows all data from the configurable table mixed in the same cell for each user. so maybe if you just help me pull the data from the "Cuántas Horas de Servicio acumuló en esta fecha" number container into a separate column in the spreadsheet it would suffice so i can simply SUM all the numbers from all rows at the bottom of spreadsheet. PLEASE DO YOUR MAGIC! 

    https://www.jotform.com/build/201756867803060


    PS: So far your help has been amazing!

    Blessings 

  • Profile Image
    Amin_N
    Answered on June 28, 2020 at 01:09 AM

    I'm afraid it's not possible to calculate fields of the Configurable List Widget.

    However, you may easily calculate the "Cuántas Horas de Servicio acumuló en esta fecha" field values after received on your end.

    For example, you may easily do that by downloading submissions as Excel, then use a calculation function to get the total value of sheet cells.

    Related guide: How-to-Export-Form-Data-to-Excel

    I hope I have been of any help.

  • Profile Image
    BeTheChange_Conviventia
    Answered on June 30, 2020 at 06:28 PM
    Good afternoon, The problem is that all the data from the config list
    appears in only one column per user. All I need is to calculate the
    "Number" value of my config list to appear in a separate cell? Please help
    :)
    Thank you
    Jeisson Delgado
    *Coordinación de Voluntariado *
    Bogotá - Colombia
    *Conviventia*
    p: m: 305 7069775
    a: Carrera 9 # 1c-30
    w: www.conviventia.org



    El dom., 28 de jun. de 2020 a la(s) 00:09, Jotform (noreply@jotform.com)
    escribió:
    ...
  • Profile Image
    Amin_N
    Answered on June 30, 2020 at 07:52 PM

    I'm afraid that this is not possible either. We do not support calculations for Configurable List widget fields because all fields are considered only one widget.

    You can try using an Input Table instead to do calculation.

    Related guide:

    Calculate-Values-in-the-Input-Table-Through-Condition.