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

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

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.

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.

Hi,

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

S

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.

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.

Hello,

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

Kind regards