Form Calculation: Widget is not retaining calculated field.

  • OfferSharing
    Asked on August 15, 2019 at 9:49 PM

    Hi Guys,

    3 of the fields at the bottom are not showing the result when submitted.

    Please help, thank you!

    Roger


    Jotform Thread 1928871 Screenshot
  • Kevin Support Team Lead
    Replied on August 15, 2019 at 11:15 PM

    I can see you are using the Form Calculation widget, but it seems there is a mix of numeric and text fields: 

    15659252332019 08 15 21h08 41 Screenshot 10

    Note that it's not possible to have such mix of elements, this would cause conflicts as the calculations are not compatible with text. 

    Kindly remove this from the widgets and see how it goes. 

  • OfferSharing
    Replied on August 16, 2019 at 12:35 AM

    Is it possible to have it show as a % another way?

  • OfferSharing
    Replied on August 16, 2019 at 1:13 AM

    I removed this from the widget, and the result still did not show, please let me know.

    Thank you!

  • BJoanna
    Replied on August 16, 2019 at 2:59 AM

    The calculation in your form is cleared when the next button is clicked. This is happening because you are performing a calculation for the "Total Guaranteed Leads" with conditional logic and you also have the round () function without any field in the Form Calculation widget for the same field. 

    1565938447round Screenshot 10

    When the Next button is clicked the calculation set inside of the Form Calculation widget is overruling the calculation that is performed with conditions. To resolve the issue remove the round () from the mentioned widget. 

    You can also add back the % sign to your other widgets. 

  • OfferSharing
    Replied on August 16, 2019 at 4:25 PM

    Hello!  I removed the Round () feature, but the calculations still didn't come through.

  • Kevin Support Team Lead
    Replied on August 16, 2019 at 5:03 PM

    Removing the round() function works, what happens is that the widget does not calculate properly when you have a calculation in the widget itself and conditionally inserting a value, so it's only recommended to do only one option. 

    I have also checked your form and the function is still there: 

    15659893542019 08 16 14h50 45 Screenshot 10

    I cloned your form on my end and removed the function, it works as expected, please make sure you're removing the option from your widget too, make sure you're clicking the save button on the widget after removing it, otherwise changes will not be saved. 


  • OfferSharing
    Replied on August 17, 2019 at 3:11 PM

    I've confirmed its updated, but still not saving to the PDF / email 

  • Mike_G JotForm Support
    Replied on August 17, 2019 at 3:52 PM

    I have checked the "Total Guaranteed Leads" Form Calculation widget in your form and it still has the round() function.

    1566071017zt15 40 35 Screenshot 10

    As for the fields not showing in the email notification, I would suggest that you double-check if the {uniqueName} or field name of each field in the email matches what it is in its properties. How-to-Find-Field-IDs-and-Names

    1566071226zt15 44 54 Screenshot 21

    To easily correct it if it doesn't match, please refer to the screenshot below.

    1566071495zt15 49 Screenshot 32

    Please make sure to save the changes after applying them.

    If you have other questions or concerns, please do not hesitate to let us know.