Form Calculation fields are not calculating

  • Gaines_Kimberly
    Asked on October 1, 2022 at 2:30 AM

    Also, the associate points fields won't calculate

  • Rhina JotForm Support
    Replied on October 1, 2022 at 2:45 AM

    Hi Kimberly,

    Thanks for reaching out to Jotform Support. To clarify, are you referring to the Statement of Purpose Scores? If so, my colleague responded on this thread related to the inquiry. If you're referring to a different scoring, can you please clarify the specific name of the field that wont calculate and what is the calculation requirement so we can further check?

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


  • Gaines_Kimberly
    Replied on October 1, 2022 at 10:49 AM

    On the PFS Evaluation form, I am trying to prefill from the PFS Training Provider form. The fields that I am having trouble prefilling are on the PFS Evaluation Form.


    Underneath the heading Training Provider Eligibility:

    1. Is the program Pell Grant eligible?
    2. This needs to prefill from the PFS Training Provider Form field of the same name.
    3. If that field fills with yes, then the field called Pell Grant - Points Awarded should fill with zero points. IF that prefills with no, then the field called Pell Grant - Points Awarded should fill with 10 points.
    4. Is the program WIOA/Title I eligible?
    5. This needs to prefill from the PFS Training Provider Form field of the same name.
    6. If that field fills with yes, then the field called WIOA/Title I Points Awarded should fill with zero points. IF that prefills with no, then the field called WIOA/Title I Points Awarded should fill with 10 points.

    Underneath the heading Applicant Data:

    1. The participant is currently enrolled in an adult education program.
    2. This needs to prefill from the PFS Training Provider form field of the same name.
  • Manilene JotForm Support
    Replied on October 1, 2022 at 11:54 AM

    Hi Kimberly,

    Thanks for getting back to us with additional information. Please allow me a bit of time to conduct some testing on your form. I'll get back to you as soon as I have an update.

    I appreciate your patience on this.

  • Manilene JotForm Support
    Replied on October 1, 2022 at 1:38 PM

    Hello Kimberly,

    Thanks for your patience while we looked into this. I have test-cloned your form and was able to set the conditions for each field based on the workflow you provided. I matched line 35's (Is the participant question) field value with line 46 (The participant is enrolled..) to make the condition work. Please see the screenshots below for your reference.

    1664645664 63387a20eb20d  Screenshot 10

    Result:

    1664645436 6338793c5a500  Screenshot 21

    Here's the demo form you can clone and test.

    Please give it a try and let us know if you have any further questions.

  • Gaines_Kimberly
    Replied on October 1, 2022 at 4:35 PM
    Beautiful! Thank you!
    ...
  • Gaines_Kimberly
    Replied on October 1, 2022 at 5:40 PM
    This condition is not working. Can’t figure out why. This is from the same form referenced in this thread.
    [cid:image001.png@01D8D5B3.CCDBD190]
    ...
  • Rhina JotForm Support
    Replied on October 1, 2022 at 7:06 PM

    Hi Kimberly,

    Upon checking, there is no assigned values for the fields. To assign a value follow the steps below:

    Click on the gear icon or Properties

    Click on Options and turn on Use Calculation Values

    Assign 10 points for No

    See result below:

    1664665868 6338c90c41872 Screen%20Shot%2 Screenshot 10

    1664665868 6338c90c1148e Screen%20Shot%2 Screenshot 21

    1664665867 6338c90bd6072 Screen Shot 202 Screenshot 32

    See updated cloned form below:

    https://form.jotform.com/222737038127960

    You can clone this form and edit to your preference.

    If you need further assistance, please let us know.