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.
Configurable List Widget and adding a single column - or workaround.Asked by sweepcleaning on September 23, 2016 at 12:57 AM
I really wish you would create a way for the form calculation to add up just a single column from inside the configurable list widget. this would be extremely helpful. I see that many others have asked as well. In my case we are creating a form for employees to submit their hours. We need three columns: 1) the date, 2) the location worked, and 3) the hours. they add another row and set the next date, the next location for that date, and then the hours for that day. The dates worked vary from employee to employee, so I like the configurable list option because they can add as many rows as they need. some employees only need a few rows, and some need more I would really like to be able to have the final submission calculate the total hours (i.e. add up only the third column amounts into a final amount). This would save the huge step of our payroll having to add up two weeks of hours for every employee every time. any chance there is a workaround even? thanks.
Thank you for your feedback. Unfortunately it is not possible to calculate the columns or rows in the Configurable List Widget. This widget is only designed for collecting data from users, not perform calculations.
A possible workaround I can suggest would be to use the Spreadsheet Widget instead. This widget allows you to use calculation functions on its cells. However, this widget is not a dynamically expanding widget like the configurable list.
Please let us know if you need further assistance.