ajayz

Formula - Proper (self)

Discussion created by ajayz on Mar 24, 2015
Latest reply on Mar 25, 2015 by ajayz

I seem to be having an issue with using the "Proper" formula.

 

I have a field called "Prepared_by" which allows the user to enter their name.  I want to stop formatting issues of all cases or all lower cases etc.

I've set up a calculated value on the Auto-Enter Tab with the following formula:

 

Proper(TextFormatRemove ( Self ))

 

I've removed the check box - Do not replace existing value of the field if (any)

 

From what I understand - when the user enters their name the format will be correct to "Tony Smith" in stead of TONY SMITH

 

However, when I test the field its not doing anything.?

 

What have I missed?

 

Formula.jpg

Outcomes