Unique ID Widget: Apply changes on the number padding to all existing submissions.

Hi,

On my form 52745887899988 I am using unique ID. Today I added padding. 

After checking current submissions I do not see the padding added. Will this only add it to new submissions and is not retroactive?

I really need it to be added to all submissions, old and new for sorting on a G-Sheet.

Thank you, Robert 

Unfortunately, the change will only take effect to new submissions.

If you like, I can offer you a workaround to be able to get the number padding for your old submissions in Google Sheets.

Since modifying the integrated Google Sheets might cause the integration to break, we will use IMPORTRANGE function on another Google Sheet.

1. Create a new Google Sheets

2. Use IMPORTRANGE to import the values from the first column up until the Unique ID column (column C)

3. On the column after the Unique ID values, please use this function

=0&C2

Where C is the column for the Unique ID.

4. Copy the function to the entire D cell

5. Use another IMPORTRANGE to import the values from the original Google Sheets' column D to end

Hope this helps.

Hi,

Thanks very much for trying this. Unfortunately because I am using IMPORTRANGE already and then customizing the Unique ID to include the form ID for a unique edit link that looks like this; Edit-567 .

=ArrayFormula(HYPERLINK("https://www.jotform.com/edit/"&S2:S, "Edit-"&C2:C))

 I did modify the formula to add padding; "Edit-"&text(C2:C,"0000")) but that created another problem. Back about a month ago JF had a glitch that reset all Unique ID numbers back to 0.  I had to change 4 numbers by adding a decimal place. So this fix above hide the decimal number. I changed it to "Edit-"&text(C2:C,"0000.0")) and that did the trick except all my Unique ID numbers looked like this; Edit-00567.0  or  Edit-00787.1 .... Edit-00787.4   Although this works I don't like the format.

I'm a bit to fussy perhaps. In any case I ramble on... 

If you can think of an alternate method I would appreciate that. 

Many thanks, Robert

Hello Robert,

Unfortunately, it is only possible to adjust already submitted unique ids by editing submissions. The changes should also appear on the spreadsheet. Would it be possible for you to update the IDs from 787.1 to 782 etc and all next submission to the last received? 

You could update the widget with the last ID used to receive further submissions ordered as well. 

Apologies on the inconvenience caused with the widget issue. 

Hello Victoria,

That would send out the notifier and the autoresponder for each creating confusion. If I was going to change it I would start with all submissions for 2018. But again it would not sort correctly using that column if they were not all done. Right now I am using the submission date and that works fine, so perhaps I should leave well enough alone

If I were to change them I will add the padding at the sheet instead, much simpler and less confusion for my users.

Perhaps a widget change request is in order... ?

Many thanks, Robert

I will escalate this as feature request to our second level, although we cannot provide an ETA or ensure this will be implemented, we will keep you updated via this thread. 

Thanks.