InfoPath Dev

 Thank you Hillary for taking time to look into this.  bundledproj is a Boolean field with 0 and 1 value. projid is a field name for a Bundled Project ID Number. I used your approach and let the filed picker picked the suggested fields.  My formula now looks like this. concat(number(substring(appdate, 1, 4)), (substring(apptype, 1, ...

I have an Application Form going to a SharePoint 2010 Form Library. The Final ApplicationID is populated when User clicks "Yes" radio button stating that he/she is ready to submit. The Textbox control for the ApplicationID should look like this: 2015C-02-025b1. Here are the rules: 2015 = current year C or L = Application ...