Auto numbering Field - InfoPath Dev

InfoPath Dev

Use our Google Custom Search for best site search results.

Auto numbering Field

Last post 07-07-2020 09:15 AM by Hilary Stoupa. 1 replies.
Page 1 of 1 (2 items)
Sort Posts: Previous Next
  • 07-03-2020 09:10 AM

    Auto numbering Field

    Dear Support, I would like to create a field to show number ( Ex: 0001, 0002,....) when user open new form. Could you please help me to do this. Attached file is sample.
  • 07-07-2020 09:15 AM In reply to

    You'll have to add a data connection to the library the form submits to. You can then, in rules, as part of the submit rules, query the library to get a count of items. Then you can use a concat formula to prepend leading zeros to the count - sample formula can be found in this thread: Keep in mind that this is not 100% guaranteed to get you unique numbers - it might be possible for two users to be submitting at the same time, and for the count to be the same.
    Hilary Stoupa

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