What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.
At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.
We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.
Sorry for this inconvenience.
We are aware of the issue as seen on the image below. That was a hack in order to update submission IDs on the spreadsheet correctly. Otherwise, updating submissions would end up with exponential numbers like 2.688 E+8. So it is necessary until our developers can restrict submission IDs to string type only.
Google spreadsheets were working normally without a hyphen before they switched to Spreadsheets v2. However, don't get me wrong as I have this submitted to our developers for further investigation and so you will get updates once this is resolved.
any update on when this will fixed as it is important to how we use google spreadsheets
or is there a formula where we can keep the numbers only?
Unfortunately we still don't have an update regarding this issue. But rest assure that the dev/technical team has been informed regarding this.
For a temporary workaround, if you are looking for a formula to be used in the Google Spreadsheet just to remove the hypen, you can use this formula to a new column (ex. column "I"):
=LEFT($H2, LEN($H2) -1)
Assume that the column for Submission ID is in "H" and starts with row "2". Then the output will reflect on column "I", just drag the current cell with formula all the way to the rows below, so that the changes can be applied to existing values in the rows in column "H".
Let us know if this helps. Regarding the issue, we will notify you when our developers have resolved this.
We have finally fixed the issue regarding dashes behind submission ids. Please accept my apologies for the delay.
Thank you very much for letting us know