-
TreinsAsked 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!
-
Basil JotForm SupportReplied 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.
-
TreinsReplied 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_JReplied 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_JReplied 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,