Re: Keep a fields value

jaxkookie — Tue, 24 Jan 2012 22:56:26 GMT

This will not be an easy task unless you create a seconday table that stores and provides your numbering. The ID is perfect for this use, but this is unavailable until form is submitted. Now some will argue that you can create a data connection connection to the library and return the ID. this would allow you to do "max(@ID) +1. the only drawback from this method is 2 users could open a form at the same time having the same ID.

If the form does not need to be named in sequential order and get away with another naming convention, you can promote a field that can solve for your issue. This will allow you to retrieve the item ID from SP and concat its value to the promoted field.

Keep a fields value

Jay@Work — Tue, 24 Jan 2012 19:47:44 GMT

I'm trying to find a way to use a sequential numbering system to name forms that are submitted to a forms library in SP 2010 (also Infopath 2010)

The form naming convention will be OPxx where xx is a sequential number. 1 number higher than the previously submitted form.
I created a field LastUsedNumber and when the form loads there are 2 rules
LastUsedNumber = LastUsedNumber + 1
FormNumber = concat("OP",LastUsedNumber)

But of course each time the form loads LastUsedNumber is blank so FormNumber will always be OP1

How can I persist this value somehow in this browser enabled form or do I need to look at storing it elsewhere?

General

Re: Keep a fields value

Keep a fields value