-
jrhinesAsked 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,
Page URL: https://form.jotform.com/90086577058163 -
denis_calin Jotform SupportReplied 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:
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!