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

    Google Drive sheet integration sometimes adds "-" after the submission ID

    Asked by nePrecisionWelding on December 11, 2014 at 06:52 PM

    Hi,

    I keep noticing that my Google Drive sheet integration for my "NPW Projects" form adds "-" after the submission ID, but not all the time...

    Cheers,

     

    Stephen

    submission id sheet all
  • Profile Image
    JotForm Support

    Answered by Charlie on December 11, 2014 at 08:54 PM

    Hi,

    Upon checking our end, I was able to replicate the problem. When the form is integrated in the Google Spreadsheet, and a submission has been done, the Submission ID column adds ID with a "-" at the end. I've created a report and escalated it to our developers and the back end team so that they can take a closer look. We'll receive a notification from them when an update has been made.

    Thank you for understanding.

  • Profile Image
    JotForm Support

    Answered by steve on December 12, 2014 at 05:00 AM

    I believe this occurs when the submission ID starts with a zero. By adding a dash google spreadsheet interprets it as a word, not a number. Thus you can still tell what the submission ID is. Otherwise it will cut off the leading zeros.

    Let us know if you have further questions.

  • Profile Image

    Answered by nePrecisionWelding on December 12, 2014 at 08:01 AM

    Hi,

    I don't think that's the case. None of my submission ID's start with a zero.

    S

  • Profile Image
    JotForm Support

    Answered by Charlie on December 12, 2014 at 10:33 AM

    Hi,

    For the meantime, may I suggest a possible workaround for this? We can have a separate column where when a submission has been done, the ID will be automatically be edited (removes the hypen and paste it on another column).

    1. In your Google Spreadsheet, create another column, just beside the Submission ID

    My Submission ID column is in column "L", and the column where I want to paste the edited ID will be in column "M" which I named "Edited ID".

     

    Add this formula once in the row 2 of column "M"/"Edited ID". The name and column letter will depend where yours is.

    Add this formula:

    =ARRAYFORMULA(IF(L2:L = "", "", LEFT(L2:L,LEN(L2:L)-1)))

     

    The formula basically tells you that IF all the values in "Submission ID" is blank do nothing, otherwise if it has a value, GET that ID and remove the hypen and paste it on column "M".

    Whenever a new submission is receive, it should automatically edit the ID.

    I hope this helps. Let us know if you need more assistance on this.

    Thank you.

  • Profile Image
    JotForm Support

    Answered by steve on December 12, 2014 at 04:31 PM

    I'll have development confirm, but I'm pretty sure it has to do with ensuring the submission ID is processed as a word and not a number. This ticket will be updated when we have a response.

    Thanks.

  • Profile Image
    JotForm Support

    Answered by alp_deniz on January 08, 2015 at 01:07 PM

    Hello,

    This issue is finally fixed. Thank you very much for bearing with us.

    Kind regards