Assigned Calculation Values in the Input Table not showing in the Form Calculation widget

I am configuring JotForm for registration for an event. I am using the input table widget to capture the names of the attendees. Within the input table, I would do a single count against the "School Level Option" for every time it is filled as I want every row to have a single count. I am using the Form Calculation field to add up the number of attendees but the field only shows 0 - what am I doing wrong?

Hi Letitia,

Thanks for reaching out to Jotform Support. Let me help you with that:

When using the Input Table widget to capture attendee names and trying to count the number of filled rows based on the "School Level Option," the Form Calculation widget showing 0 usually means the calculation is not properly set to count the filled rows.

Here’s how to ensure the count works correctly:

1. Check the Input Table widget settings: Make sure the widget is configured to allow counting or that each row's value can be referenced in calculations.
2. Use the correct calculation formula: The Form Calculation widget needs to be set up to count the number of non-empty rows or specific selections. You might need to use conditions or formulas that check if each row is filled and then sum those counts.
3. Verify field references: Ensure the Form Calculation widget is referencing the Input Table widget correctly. Sometimes, the widget’s value might need to be parsed or converted for the calculation to work.

If you want a precise step-by-step guide on setting up the calculation formula for counting rows in the Input Table widget, please let me know.

Give it a try and let us know how it goes.

The "School Level" option has a value of 1 listed for each option so it's counted. The form calculation is using the "COUNT" function for the "Input Table" and pointing to the School Level column in the widget. What else am I missing?

Hi Letitia,

Thanks for the additional details. Since you are using the COUNT function in the Form Calculation widget pointing to the "School Level" column in the Input Table and it still shows 0, the issue might be that the COUNT function does not directly work with Input Table widget columns in that way.

The Input Table widget values are not always directly accessible for calculations like COUNT in the Form Calculation widget. Instead, you may need to use conditions or separate form fields to track each row's selection and then sum those values.

Alternatively, you can consider using multiple single choice or dropdown fields for each attendee's "School Level" and then use the Form Calculation widget to sum those fields, as this setup works better with the COUNT function.

If you want, I can guide you on how to set this up or suggest other ways to count attendees based on your form structure.

I need a solution that is easy for the parents to enter their children's names in a form. The Input Table has a "add" button that makes it easy. Please provide other seamless options for this.

Hi Letitia,

For an easy and seamless way for parents to enter their children's names while still being able to count attendees, the Input Table widget with the "Add" button is indeed very user-friendly. However, since the Form Calculation widget cannot directly count rows in the Input Table, here are some alternative approaches you can consider:

1. Use a separate hidden number field: Add a hidden number field that users do not interact with. Then, use conditional logic or calculation to update this field based on the number of rows filled in the Input Table. This way, you can sum or count the entries indirectly.
2. Custom JavaScript (if embedding the form): If you embed your form on a website, you can use custom JavaScript to count the rows dynamically and update a calculation field. This requires some coding but keeps the Input Table interface intact.
3. Use multiple Input Table widgets: Split the form into sections with smaller Input Tables and use calculations on each, then sum the results. This can sometimes help with counting limitations.
4. Request feedback on form design: If you want, I can help you design a form that balances ease of use with accurate attendee counting, using widgets and conditions effectively.

These options aim to keep the Input Table's ease of use while enabling accurate counting. If you'd like, I can help you implement any of these solutions or suggest a tailored approach based on your form.

Please review the form using the provided URL to offer recommendations.

Hi Letitia,

To review your form and provide specific recommendations, could you please share the URL or the form ID of the form you want me to check? This will help me look into the form setup and suggest the best options for counting attendees while keeping the Input Table widget easy for parents to use.

Form ID 252703672025149

Hi Letitia,

Thank you for providing the form ID. I will review your form with ID 252703672025149 to offer specific recommendations on how to best count attendees while maintaining the ease of use of the Input Table widget for parents.

I will get back to you with tailored suggestions shortly.

Hi Letitia,

The Calculation Values in the Input Table element won't work using the Dropdown Input Type. This will only work on Single Choice and Checkbox. Let's walk through this together using a cloned form:

1. In Form Builder, click on the gear icon on the right side of the Input Table element.
2. Under the Fields tab, go to the Column Types section.
3. Change the School Level to either Single Choice or Checkbox. Then test the form element and you'll see the assigned value will show on the Form Calculation widget.

If your main requirement is to collect details of the youth who'll attend and allow users to add rows, you can check out the Configurable List widget. A helpful guide about this widget is on this link. I've created a demo below that you can check out:

1. In Form Builder, click on Add Element on the left side.
2. Under the Form Elements, go to the Widgets tab and look for the Configurable List widget. Then drag and drop it into the form's page.
3. Next, in the Widget Settings on the right side, you can configure which subfields you're going to use. You'll need to set them in the Field configuration section. More details about laying out the widget are on this link.
   

Here's a screencast of how this works:

But getting the total using the Form Calculation widget won't work. As the subfields of the Configurable List widget can't be selected in the Add Fields on the Form Calculation widget.

Let us know if you have any other questions.