General

Re: Generate auto unique ID in InfoPath Form

Evanz — Mon, 30 Nov 2020 20:46:44 GMT

Hi Hilary, sounds so simple but I couldn't think of it. Thanks for your quick turnaround. Much appreciated. :)

Re: Generate auto unique ID in InfoPath Form

Hilary Stoupa — Mon, 30 Nov 2020 15:43:02 GMT

concat("T", substring-before(substring-after(now(), ":"), ":"), substring-after(substring-after(now(), ":"), ":"), substring-after(substring-after(today(), "-"), "-"))

Generate auto unique ID in InfoPath Form

Evanz — Wed, 25 Nov 2020 00:40:25 GMT

Hi,

I found the code for creating an unique ID in InfoPath form with 6 digits number as below. But I wonder is it possible if I want to add an additional letter (T or C) before the number like T122030? If yes, what should the new "concat" code be?

(concat(substring-before(substring-after(now(), ":"), ":"), substring-after(substring-after(now(), ":"), ":"), substring-after(substring-after(today(), "-"), "-")))

will return something like 122030 which equates to mmssyy minute, second and current date.

Thanks so much for your help as always!