The Form calculation field could not multiply the fields

  • Profile Image
    kurtemail
    Asked on February 11, 2020 at 05:10 AM

    I am putting in a very simple formula, the Number of Guests X 300,000 into the Deposit field but it keeps showing as blank. 

    It is urgent and driving me crazy. Any assistance would be greatly appreciated.

  • Profile Image
    kurtemail
    Answered on February 11, 2020 at 05:27 AM

    I found that typing in 300000 instead of using the keyboard on the Build screen it is no longer blank but refuses to multiply by the number of guests. It worked perfectly for weeks. It must be a glitch in the program.
    Please help !!!

  • Profile Image
    roneet
    Answered on February 11, 2020 at 07:42 AM

    Let me test it and get back to you in some time.

    Thanks.

  • Profile Image
    roneet
    Answered on February 11, 2020 at 07:52 AM

    Have you fixed the issue? I am unable to replicate any issue with your form on testing it:

    1581425513888888888.gif

    Let us know if you have further questions.

    Thanks.

  • Profile Image
    kurtemail
    Answered on February 12, 2020 at 01:33 AM

    Thanks for your reply.

    After trying more than 10 times, it seems to have randomly fixed itself without me doing anything different. 
    I have had many instances where I have changed a formula in a calculation widget and saved and published it, but when I check it again it has not saved the changes.
    Do you know why these things are happening? Is there a lag after saving and publishing or something like that? 

    Regards,

    Kurt.

  • Profile Image
    roneet
    Answered on February 12, 2020 at 02:40 AM

    Did you save the widget after making a change to the syntax?

    1581493081888888888.gif

    In case if your change does not reflect you can delete the widget and add it once more.

    You can also clear your account's cache:

    https://www.jotform.com/help/229-How-to-Clear-Your-Form-Cache

    Thanks.