Generate auto unique ID in InfoPath Form - InfoPath Dev
in

InfoPath Dev

Use our Google Custom Search for best site search results.

Generate auto unique ID in InfoPath Form

Last post 11-30-2020 12:46 PM by Evanz. 2 replies.
Page 1 of 1 (3 items)
Sort Posts: Previous Next
  • 11-24-2020 04:40 PM

    • Evanz
    • Top 200 Contributor
    • Joined on 04-16-2020
    • Posts 56

    Generate auto unique ID in InfoPath Form

     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!

  • 11-30-2020 07:43 AM In reply to

    Re: Generate auto unique ID in InfoPath Form

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

  • 11-30-2020 12:46 PM In reply to

    • Evanz
    • Top 200 Contributor
    • Joined on 04-16-2020
    • Posts 56

    Re: Generate auto unique ID in InfoPath Form

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

Page 1 of 1 (3 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.