Requirement

You want to set the first letter in a field to uppercase, this is usually the case for fields that contain a persons name, etc.

Solution

  1. Create a field called ‘Name’.
  2. Create a new action rule for the field and set it up as follows:
Condition: None
Rule Type: Action
Run these actions:
Set a field’s value: ‘Name’
Value: Click on FX and use the following formula.

concat(translate(substring(Name, 1, 1), "abcdefghijklmnopqrstuvwxyz", "ABCDEFGHIJKLMNOPQRSTUVWXYZ"),substring(Name,2,string-length(Name-1)))

Now, when a person enters ‘mary’ as a name, the form will automatically update to ‘Mary’ when they proceed to the next field.