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.

  • Profile Image

    Hypen appears after the Submissions ID on Google Spreadsheet

    Asked by jameshogan on October 08, 2014 at 04:12 AM
    Also, I'm getting an hyphen with the submission ID on Google Spreadsheets.... It seems that it just started to happen for no reason...
  • Profile Image
    JotForm Support

    Answered by EltonCris 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.

    Thank you!

  • Profile Image

    Answered by UoNSU 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?


  • Profile Image
    JotForm Support

    Answered by Charlie 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.


  • Profile Image

    Answered by alp_deniz 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

    Kind regards