Calculation

  • jrhines
    Asked on April 2, 2019 at 5:22 PM

    I have to many people making error with there count when submitting registration forms. Is there any way I can calculate the number of people attending based on the number of rows with information filled in?


    Thank you,

  • denis_calin Jotform Support
    Replied on April 2, 2019 at 8:27 PM

    Hi @jrhines!

    I have cloned your form and was looking at different options available. The Form Calculation Widget is only limited to adding values from different rows and columns, not checking whether a row has been filled. Here is a screenshot of a possible solution to your question:

    1554250303Screen Shot 2019 04 02 at 5 Screenshot 10

     

    You can add an extra column in each of the three Input Tables and ask to enter a value of 1 per each attendee. I have added an additional Form Calculation Widget called Calculate to add all of the values from the last column. The screenshot shows only the last table being filled for testing purposes. 

     Here is a guide that addresses this in more detail: https://www.jotform.com/help/343-How-to-Perform-Form-Calculation-in-the-Matrix-Field

     

    Please let me know if you would like any further help.

    Thank you and have a wonderful day!