Newbie Questions

Re: Autopopulate a field with incremental ID # and set # of digits.

Hilary Stoupa — Fri, 30 Jul 2010 15:31:40 GMT

One issue with generating an ID when the form opens -- most methods suggest getting the max ID currently in use and incrementing... but what happens if I open a form, and the ID I get is 2, and you open a form before I submit mine? You also get an ID of 2. You really need to consider using a SQL table where you can "reserve" an ID for your form -- the general idea is outlined here.

Re: Autopopulate a field with incremental ID # and set # of digits.

mpeters — Fri, 30 Jul 2010 13:13:08 GMT

To get it zero filled, concat a field with four zeroes onto the front of the ID number field, then use the 'substring' function to grab the four right-most digits. Concatted field: 00002, after substring: 0002

So, if you have a larger number it would look like this: 0000102, and the substring would look like this: 0102

Re: Autopopulate a field with incremental ID # and set # of digits.

mgarant — Fri, 30 Jul 2010 12:51:33 GMT

To have the increment ID, create a Data connection to your sharepoint library, with only the column ID taken from it. Then, set the default value of your field to Max([ID from the data connection])+1. For the "0001" thing, i do not know how to do this. Maybe someone else could help?

Autopopulate a field with incremental ID # and set # of digits.

AlexG — Thu, 29 Jul 2010 17:58:34 GMT

Hello, I'm somewhat new to Infopath and this is my first time to the forums.

I'm trying to get a textbox to autopopulate an ID number that will increment based on the number of forms submitted to a sharepoint library. Also, I need it to be a set number of digits, so that it will be 0001, 0002, and so on, instead of "1", "2".

1. is it possible to set a text box to look like "0001" "0002" instead of simplifying to "1" or "2"

2. I want this text box to autopopulate upon form creation/the form being opened, not based on a button as with this example.

Any suggestions?