InfoPath Dev

Jimmy, I have a retrieval data connection for each forms library in SharePoint.  The secondary data source has a repeating group with just the ID field.  So everytime I submit a form to this library a new ID in a new row is created???  If that is the case, then I guess it would be retrieving multiple rows.  I thought ...

Thanks for the reply Hilary!  When you are using these functions specifically with the ID field for auto-numbering the forms, shouldn't the result using NZ or MAX be the same?  When I setup my data connections for my form libraries and I select ID from the SharePoint list, I'm thinking it is just one field, so NZ ...

What exactly is the difference in what is returned?  I set up a field that displayed both.  After initially getting zero for NZ when the folder was emply, I didn't see a difference for a while.  Then, after saving a form and opening it up and submitting it, there was a difference.  After that the nz result didn't ...

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

Yep!  The reason for the dashes is that this field is concat'd with additional fields to form an ID, which needs to always be a certain length.

I got it!  I am just going to concat a string of dashes onto the field value and take a substring of that.

I have a requirement to have a six digit field's unused available spaces filled with dashes. example1:  wheel- examle 2:  car--- If six characters are entered, then nothing needs to be done.  I was trying to figure a way to do this by using string-length, then set the fields value by concatinating dashes onto the field's ...