Issues with the calculation.

  • Treins
    Asked on January 21, 2022 at 9:11 AM

    Hello there,
    I am having an issue when calculating values within the form.

    I am transfering a calculation from excel to jotform, but the calculated values in jotform differ a little from the ones in excel. See attached a screenshot: left side jotform, right side excel values.
    Do you know how that happens?

    Is it possible to import excel calculation sheet into jotform form fields?


    Thank you!


    1642772200 61eab6e85ab9a calc screenshot Screenshot 10

  • Basil JotForm Support
    Replied on January 21, 2022 at 9:19 AM

    Hi,

    Unfortunately, importing calculations from excel is not possible.

    Which fields are 1.32, 1.33, and 1.34 connected to as I do not see these numbers in the form?

    Could you share the equations so maybe we can try assisting with them?

    Looking forward to your reply.

  • Treins
    Replied on January 23, 2022 at 3:04 PM

    Hello,
    I found the solution for the different numbers by myself - but is it possible to show very small numbers in jotform in a scientific way like in excel: for example in the screenshot A1.8: 2.43823E-07 instead of 0.000000243823?
    Thank you!

  • Nina_J
    Replied on January 23, 2022 at 4:53 PM

    Hi there,

    I will check and confirm for you. I will update you once I have the information.

    Thank you!

  • Nina_J
    Replied on January 24, 2022 at 6:19 AM

    Thank you for waiting.

    I have confirmed that we don't have a tool or widget to convert numbers to scientific format.

    Let us know if you have further questions.

    Best,