← Forum Post Reply →

• ← Group Forum | Forum Topic Directory

  Autonumbering Issue – InfoPath Form (2 posts)

• Dawn Weatherman said 1 year, 8 months ago:

  We are using an InfoPath form in which we are setting a transaction number as a concatenation of field and the formula max(@ID)+1 where the ID comes from the form library the InfoPath forms are being submitted to. The connection to the receive the ID is set up so it does not grab the ID when the form is opened. That is done as part of the submisison rules. This is set up correctly and seems to work fine. HOWEVER, occassionally several forms receive the same number. These forms are not being submitted at the same time. It is like the list gets stuck for several forms and then breaks loose and starts numbering correctly again. Has anyone ever run into anything like this and if so do you have any recommendations on what I can do to fix it.

• Kevin Pine said 1 year, 8 months ago:

  You could use a workflow to write the Form ID to a field in the form upon submitting the form. When the form is subsequently opened the control will be populated.

  You could also use conditional formatting to hide the Form ID control until it is populated.