- nePrecisionWeldingAsked on December 11, 2014 at 06:52 PM
I keep noticing that my Google Drive sheet integration for my "NPW Projects" form adds "-" after the submission ID, but not all the time...
- CharlieAnswered on December 11, 2014 at 08:54 PM
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.
- JotForm SupportsteveAnswered 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.
- nePrecisionWeldingAnswered on December 12, 2014 at 08:01 AM
I don't think that's the case. None of my submission ID's start with a zero.
- CharlieAnswered on December 12, 2014 at 10:33 AM
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.
- JotForm SupportsteveAnswered 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.
- alp_denizAnswered on January 08, 2015 at 01:07 PM
This issue is finally fixed. Thank you very much for bearing with us.