-
BeTheChange_ConviventiaAsked 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
-
Amin JotForm SupportReplied on June 28, 2020 at 1: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.
-
BeTheChange_ConviventiaReplied on June 30, 2020 at 6:28 PMGood 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ó:
... -
Amin JotForm SupportReplied on June 30, 2020 at 7: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: