<div>
You need to use the &quot;Max&quot; function to get the current maximum ID and add 1 &nbsp;within InfoPath. For this you can create the SharePoint hosted WCF service, create new data source within InfoPath pointing at this service and add calculated field to the InfoPath form (select new data source)
</div>


You need to use the "Max" function to get the current maximum ID and add 1  within InfoPath. For this you can create the SharePoint hosted WCF service, create new data source within InfoPath pointing at this service and add calculated field to the InfoPath form (select new data source)

<div>
I'll give that a try. &nbsp;Thanks for the feedback.
</div>


I'll give that a try.  Thanks for the feedback.

<div>
<div class="content wysiwyg-content">
When using MS InfoPath 2010 to enter data into a SharePoint database, I want to be able to display in the InfoPath form in a field called SBSR#, the text &quot;SBSR&quot; plus the next available ID number from the SharePoint database ID field. &nbsp;How can I make that happen? &nbsp;What formula will make that happen in the InfoPath Text Box Properties dialog box? &nbsp;Everything I've tried so far produces NaN because the item hasn't been written to the SharePoint database yet.<br />
<br />
I appreciate any ideas.<br />
<br />
Bill
</div>
</div>


When using MS InfoPath 2010 to enter data into a SharePoint database, I want to be able to display in the InfoPath form in a field called SBSR#, the text "SBSR" plus the next available ID number from the SharePoint database ID field.  How can I make that happen?  What formula will make that happen in the InfoPath Text Box Properties dialog box?  Everything I've tried so far produces NaN because the item hasn't been written to the SharePoint database yet.

I appreciate any ideas.

Bill

Generate an ID Number

Microsoft InfoPath is a software application for designing, distributing, filling and submitting electronic forms containing structured data. The product features a WYSIWYG form designer in which the various controls (e.g. textbox, radio button, checkbox) are bound to data, represented separately as a hierarchical tree view of folders and data fields. All the data stored in InfoPath forms are stored in an XML format. Secondary data sources can be built into the form or they can be accessed through an external data connection to SharePoint or a Web service.

InfoPath

Microsoft Sharepoint is a software platform and family of software products used for collaboration and web publishing combined. These capabilities include developing web sites, portals, intranets, content management systems, search engines, wikis, blogs, and other tools for business intelligence and collaboration. SharePoint has a Microsoft Office-like interface, and it is closely integrated with the Office suite.