Form Calculation widget shows 0 result when form is tested using AI-generated data

Hi there,

I am having trouble with getting form calculations to work properly for my form. Dysart Special Education is making a grant and I need the form to be able to score some of the questions kind of like a quiz. We want to get initial point totals to see who scored the most points and can be awarded the grant. I have hidden point totals for the wieghted questions. However I cannot get the form to score correctly. Can someone help me with this? I might be able to zoom tomorrow or we can set up a time?

Thank you!

Rachel Hebert

Hi President,

Thanks for reaching out to Jotform Support. I'm an AI assistant here to assist you.

Let me help you with that: to make your grant form score like a quiz, you will first need to assign numeric values to your answer choices, and then use a calculation field to total those values. If some of your questions use Single Choice fields, you can assign a point value to each option like this:

It’s easy to assign calculation values to the Single Choice Field element. Let me show you how: 

1. In Form Builder, click on the Single Choice field.
2. Next, click on the Gear icon on the right side of the field.
3. Under the Options tab, toggle on Calculation Values.
4. Enter the calculation values as you want. That's it. You're done. 

After assigning values to all your scored questions, you will need a Form Calculation widget that adds those fields together to get the total score. Since each form is set up a bit differently, it would help if you could share either the form URL or a screenshot of your calculation widget setup (showing its formula), so we can pinpoint why the total is not coming out correctly and guide you step by step.

Once we hear back from you, we'll be able to move forward with a solution.

Reach out again if you need any other help.

https://form.jotform.com/261544993499072

Hi President,

Let me help you with that:

To score your grant form like a quiz with weighted, hidden points, you’ll want to use the Form Calculation widget together with calculation values on your fields.

Here’s the general setup you should follow:

1. Assign calculation values to each scored question (Single Choice, Multiple Choice, Dropdown, or Input Table) so that each answer option has the correct point value.
2. Add a Form Calculation widget to your form and set it to sum all of those point fields into one total score field (you can keep this total hidden if you like).
3. In the Form Calculation widget’s options, make sure it is treating your point fields as numbers (not text) and that Ignore Hidden Fields is turned off if your point fields are hidden but still need to be counted.

The Form Calculation widget has several options that affect how your score is computed and displayed. For example, you can control whether hidden fields are included, how many decimal places are shown, and whether the result is read-only:

Once you configure the options you need, click on Save to apply the changes:

To help pinpoint why your specific form is not scoring correctly, please do the following and share back what you see:

1. Open your Form Calculation widget and take a screenshot of the full formula (showing all fields being added or multiplied).
2. Confirm which questions are supposed to be weighted and how many points each answer should give.
3. Let us know if any of the point fields are hidden and whether they are Single Choice, Multiple Choice, Dropdown, or Input Table fields.

After we hear back from you with that information (or screenshots of your calculation setup), we’ll have a better idea of what’s going on and how to help fix the scoring on this specific grant form.

Reach out again if you need any other help.

There are the screen shots. Each of these questions should be able to be answered by the applicant with one answer. The different point value totals should be able to be totaled. The number should be no more that 45 and a minimum of 11.

Your Role

Special Education Teacher Point value 5

Resource Teacher Point Value 4

Paraprofessional Point Value 4

Behavior Coach Point Value 3

Speech Therapist Point Value 3

Occupational Therapist Point Value 3

Other Point Value 2

Classroom Description part 1

STC 1 Point Value 5

Stc 2 Point Value 5

Resource room Point Value 3

General Education Point Value 2

Other Point Value 2

Classroom description part 2

K-2 Point Value 0

3-5 Point Value 0

5-8 Point Value 0

Middle Point Value 0

High School Point Value 0

Have you received this grant before? 

Yes Point Value 0

No Point Value 5

Approximately how many students will benefit from this request?

All students within the Classroom Point Value 5

A few Select Students Point Value 3

One Student Point Value 2

What need does this request address in your classroom or program?

A. Increasing student access to hands-on learning materials, classroom tools, or instructional resources. Point Value 3

B. Supporting student sensory, social-emotional, behavioral, or regulation needs. Point Value 4

C. Improving inclusion, accessibility, or participation for students with disabilities. Point Value 5

D. Enhancing classroom engagement, motivation, communication, or skill development. Point Value 2

E. Supporting staff with materials, resources, or tools needed to better serve students. Point Value 1

What challenges are you currently experiencing that this grant would help solve?

A. Students need hands-on activities or learning tools to practice important skills. Point Value 2

B. Students need adaptive or accessible materials so they can participate more independently. Point Value 5

C. Students need materials or tools that we do not currently have. Point Value 1

D. Students need communication, social, or life-skills supports that are not currently available. Point Value 3

E. Students need sensory or calming supports to help them stay regulated and ready to learn. Point Value 4

If awarded, how will you measure success or impact?

(Examples: student progress, engagement, participation, reduced behaviors, etc.)  

A. Student progress toward IEP or classroom goals. Point Value 2

B. Increased student engagement or participation. Point Value 4

C. Increased student independence. Point Value 5

D. Reduced behaviors or improved regulation. Point Value 3

E. Staff observations, photos, or work samples. Point Value 1

How does your request align with PTSA initiatives or district goals?

A. Supports inclusion for students with disabilities. Point value 5

B. Improves student access and participation. Point value 3

C. Supports student sensory, social-emotional, or behavioral needs. Point Value 2

D. Builds student independence, communication, or life skills. Point Value 4

E. Provides classroom tools that support student learning. Point Value 1

How often will these materials be used?

Daily Point Value 5

Multiple times per week Point Value 3

Weekly Point Value 2

As Needed Point Value 1

Hi President,

Let me help you with that:

Based on the point values you listed, your setup is perfect for using calculation values on each Single Choice question and then totaling them with a Form Calculation widget so the final score stays between 11 and 45.

Here’s how to make sure each question contributes correctly to the total:

1. Assign the point values to each option

1. Select each Dropdown, Single Choice, or Multiple Choice field (for example, “Your Role”, “Classroom Description part 1”, etc.).
2. Open its Properties and go to the Options section.
3. Turn on Calculation Values.
4. Enter the exact point values you listed (5, 4, 3, 2, etc.) so each answer has the correct numeric value.

Here is how assigning calculation values looks:

2. Add a Form Calculation widget to total all points

1. Add a Form Calculation widget to your form (you can keep it hidden if you only need the score internally).
2. Edit the widget and, in the formula area, insert each scored field and add them together, for example:
   {Your Role} + {Classroom Description part 1} + {Classroom Description part 2} + {Have you received this grant before?} + …
3. Open the widget’s options and make sure the fields are treated as numbers, not text.

3. Check the widget options so hidden scores are counted

1. Open the Form Calculation widget’s options.
2. Review the settings and make sure they match how you want the score to behave (for example, whether to ignore hidden fields or not).
3. Save the widget after adjusting options.

If the total is still not coming out correctly after this, the most common causes are:

• One or more fields missing from the calculation formula.
• One field still using text instead of its calculation value (calculation values not enabled or misaligned with options).
• Widget set to ignore hidden fields while your point fields are hidden.

If you can share exactly which field or question is not being counted correctly (for example, “What need does this request address…” not affecting the total), we can walk through that specific field’s setup step by step.

Reach out again if you need any other help.

Ok so I checked all the fields that you said. I made sure each piece is set correctly but it still is not giving a total. I am probably gonna need a person to check this out. Can I get a zoom meeting?

Hi President,

One of our Support Team members will take it from here to follow up shortly.

Reach out again if you need any other help.

Hi Rachel,

We reviewed your form setup and tested the calculation behavior. It looks like the issue may have been related to the calculation formula at the time. In the screenshot you shared, there appears to be an extra + at the end of the calculation expression which can break or interfere with the score calculation.

Additionally, if any questions have calculation enabled but their option values are left empty or set to 0, those questions won't contribute to the total score which can also lead to unexpected results in the final calculation.

If you still notice any unexpected behavior, feel free to share the latest version or a screenshot of the current calculation setup.

Hi there,

I took away the extra plus in the calculation. This produced a test with a score of zero. I then made sure that all the questions had a hidden base value of at least 1. This next test still produced a calculation total of zero.

Let me know what else I can try. We can set up a zoom if needed as well.

Thanks,

Rachel

here are some screen shots:

Hi Rachel,

I've tested your form and can see that it generates a total. Checkout my screenshot below to see my result:

Are you referring to your submission data that don't show the correct total? Let me take a look at this for you. To do that, we’ll need your permission to access your account. Don’t worry, you can turn it off again once we’re done. Let me show you how to do it:

1. In the top-right corner of your Workspace page, click on your Avatar/Profile Image icon.

2. Then, in the Dropdown menu that opens, click on Settings.

3. Next, in the panel on the left, click on the Security tab.

4. If you haven’t opened your Security page in a while, it’ll ask you to verify. To do that, click on Send Verification Code.

5. Then, enter the Verification Code you receive in your email.

6. Finally, at the bottom of the page, toggle on Jotform Support Access.

After we hear back from you, we’ll have a better idea of what’s going on and how to help.

Hi there. Yes the submission email from the tests have a score of 0. In the corresponding excel sheet i have set up it also does not have a score shown. I have toggled on the JotForm support access. Thank you for your help.

Hi Rachel,

I checked your test submissions and can see that the form was tested using AI-generated data. I was able to replicate the issue when I did the same on a cloned version of the form, but I was not able to replicate it when I filled out the form manually. Take a look at the screenshot below to see my result:

I created a ticket and escalated this to our Developers. We’ll follow up as soon as we have any news. In the meantime, I suggest testing your form by filling it out manually. This will allow you to confirm that the Form Calculation widget works as expected.

Thanks for your patience. We appreciate it.