IdeaExchange · Idea Details

This idea has been delivered and can no longer be voted or commented on. If you’d like to add to this conversation, please post a new idea.
Vote 320  points

Jorge Linale

Upper case function for formula fields

Salesforce Platform, Customization, Delivered Ideas, Large Enterprise Ideas, Large Enterprise

Delivered (Archive)

When creating formula fields in custom objects, in the advanced formula tab would be useful to have a formula to convert text to upper case, similar to the UCase() function of Basic, the string.toUpperCase() of Java, or the string.ToUpper() of C#.
With this function the following formula could be avoided:

IF( OR({!Unit_of_Measure__c}="SQM",{!Unit_of_Measure__c}="Sqm",{!Unit_of_Measure__c}="sqm") , value_if_true, value_if_false)

and i.e. could be replaced with some more efficient code like:

IF( UCase({!Unit_of_Measure__c})="SQM", value_if_true, value_if_false)

A lower case version of the function would also be nice.

7 years ago · 7 Comments · Report Abuse

Latest Comment from Product Management

Mary Scotton

Two new formula functions are coming in Winter '08: UPPER() Converts all letters in the specified string to uppercase. If there are characters in the string that are not letters, they are unaffected by this function. For example, UPPER('salesforce.com') returns 'SALESFORCE.COM' LOWER() Converts all letters in the specified string to lowercase. If there are characters in the string that are not letters, they are unaffected by this function. For example, LOWER(' SALESFORCE.COM') returns ' salesforce.com'

6 years ago · Report Abuse

1 to 7 of 7

Ideas

Apps

Questions

Help us to keep IdeaExchange clean by pointing out overlapping ideas. We'll investigate your suggestion and merge the ideas if it makes sense.



 

 

Thanks for your merge suggestion. We will review it shortly and merge the ideas if applicable.

Salesforce.com takes abuse situations very seriously. Examples of abuse include but are not limited to posting of offensive language or fraudulent statements. To help us process your request as quickly as possible, please fill out the form below describing the situation. For privacy and security reasons, the final outcome of an abuse case may not be revealed to the person who reported it.


 

Thank you for your feedback. We take abuse seriously and will investigate this issue and take appropriate action.