How can I perform a calculation inside a Configurable List widget?

  • Profile Image
    Asked on January 31, 2015 at 09:45 AM

    I am working with the configurable list to create a cost calculator. The participants enter the staff they have working on a particular project. So the fields are "Employee Name", "Hourly Rate" and "Number of hours".

    I don't want to set the number of rows because they will have a variable number of employees working on a particular project. I want them to add a row to add a new employee.

    What I need is the individual "Employee Cost" as the 4th column, and the total cost increment with each row added.

    Can you please advise if there is a way I can achieve this?

    Since Employee costs are one element of the cost, I need to pick up the total cost and add it to other costs which are calculated in different fields, such as legal costs, etc.

    Thanks heaps!

  • Profile Image
    Answered on January 31, 2015 at 05:18 PM

    Unfortunately that would not be possible to do in configurable list at this time. I would suggest creating the required fields (using multiple tools, such as Text box and similar) up in advanced so that you can cover as much as it could be required and use conditions to hide/show them as needed.

    This will also allow you to set other conditions on your jotform depending on their values as well as calculating different values on it.