InfoPath Dev

Here's an update that allows zero padding in the last 4 chars of the serial number

In a list form, you'd have to have a column for these helper fields - you could just not display it on the list views, I suppose. It is just that with repeating data, we need a field inside the repeating group to act on each item in the group. Make sense?

 so I figured out the optional attribute field (field attribute) deal. I can add that when creating a blank from or form library form but I don't see how to achieve that in a SharePoint list form. can this be done in a list form?

Wait - this is a SharePoint List form? Or a regular InfoPath form?

 Ok thanks, I will take a look at that. I look forward to the solution. So what I am asking is you mention that there were some helper fields in the form, and when I look in the list of fields in advanced view I see that they are gray in color rather than white like the normal fields. how to you add these helper/supporting fields? these ...

[quote user="JenniferLindsay"]Then you just need to have a query on form load that searches the list for the appropriate rows and pulls only those rows into the form.[/quote] Hello Jennifer, can you explain this point in more detail please? I think this might be a solution for my request here: ...

I only added 20 rows to the default - Under the Data tab in the ribbon, look for the Default button and you can add more. Oh, zero padding is fun, I'll update the sample later today with that. I don't understand your last question - can you clarify?

Good idea, thanks! 

 thanks for getting back with me on that. that looks like it should work for me, the only thing thought is that I need to be able to do more than 20. is that just the way you set the form up and something that can be changed or is that internal to the software. also I need the serial number to be in the format of for instance 16-0010. when ...

Makes sense - I'd just suggest if you need all the columns in the future, you can add fewer of them onto the form, or maybe use a repeating section (I know, all that scrolling!) instead to work around the limit. Thanks for posting on this - I'd had no idea. :)