Calculation

  • Profile Image
    jrhines
    Asked on April 02, 2019 at 05: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,

  • Profile Image
    denis_calin
    Answered on April 02, 2019 at 08: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.00

     

    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!