In one of work assignments, where We had implemented Info Path Forms to Collect User Data. There is a new Requirement to automatically converts first letter of each Field to Upper Case.
For example, If use Enters the Name for City Field as chennai, the output should be Chennai.
In this blog, I will provide you the steps followed to achieve this Upper Case Conversation in InfoPath Form SharePoint 2013.
Steps
- Create a field named as City.
- Create a new action rule and configure it as follows:
Set a field’s value: ‘City’
Value: Click on FX and use the below formula.
concat(translate(substring(City, 1, 1), "abcdefghijklmnopqrstuvwxyz", "ABCDEFGHIJKLMNOPQRSTUVWXYZ"),substring(City,2,string-length(City-1)))
Happy SharePointing :-)