- JotForm SupportEltonCrisAnswered on October 08, 2014 at 04:22 AM
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.
- UoNSUAnswered on October 27, 2014 at 09:02 AM
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?
- CharlieAnswered on October 27, 2014 at 10:11 AM
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.
- alp_denizAnswered on January 08, 2015 at 01:03 PM
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