-
orsosbudmahakamAsked on September 19, 2023 at 2:11 AM
Dear team,
How can I download the submitted ID in my form without being transformed into scientific format in excel when it's downloaded?
I need the numer ID to be fully displayed as is, and not being like E+15 or something.
I saw a discussion somewhere for the same problem, but I don't think it was solved.
Please kindly help.
Thank you
Best Regards
Tommy
-
Silvano JotForm SupportReplied on September 19, 2023 at 7:21 AM
Hi Orsosbud,
Thank you for contacting Jotform Support. I’m sorry you're having issues with your form submissions ID. Let me look into it and get back to you with a solution.
-
Silvano JotForm SupportReplied on September 19, 2023 at 8:00 AM
Hi Orsosbud,
We really appreciate your patience and understanding while we handle your request. When I tested your concern, the same thing happened, so I created a ticket about it and escalated this to our Developers. Our Developers are working on the issue as fast as they can. As soon as we have an update, we’ll let you know. Thanks for your patience.
-
Olivia Product Triage SpecialistReplied on September 20, 2023 at 4:21 AM
Hi Tommy,
I'm writing related to the issue about data format. The number field's data format is automatically changed because of the way of how Excel reacts when a long number is received. So, it's an expected behavior to change the data format to scientific in the Excel's side. We recommend you to collect that data using a Short Text field, instead of the Number field. This will solve the data format issue in the Excel file.
You can also make the necessary arrangements under the Options tab, in the element's Settings.
Give it a try and let us know how it goes.
-
orsosbudmahakamReplied on September 20, 2023 at 8:10 PM
Hi Olivia,
Thank you for your prompt answer. But since the data is now collected and there's no way that I can ask my client to re-submit their data, don't you think there's another workaround to solve this problem?
Kindly need your help.
Thanks
Tommy on behalf of Orsosbud
-
KrisLei Jotform SupportReplied on September 21, 2023 at 5:09 AM
Hello Tommy,
Thank you for getting back to us. As a workaround for the existing submissions, you can add an apostrophe (') at the beginning of the numbers in the downloaded Excel report, as shown in the screenshot below:
This will reformat the numbers without the scientific notation. Give it a try, and reach out again if you have any other questions.