[SalesForce] Custom settings in one of the triggers

Currently we have a trigger on Account object which updates one field based on certain conditions and if that field value matches with another object where all the values are mentioned. One of the conditions we are also checking on running user's country field like this

if (usrcountry == 'Australia' || usrcountry == 'New Zealand'  || usrcountry == 'Austria' || usrcountry == 'Belgium' )

{
Logic
}

As there are more no. of countries coming to use this part, I need to create a custom settings instead of hard coding country value always in this condition.

I have created a hierarchical custom settings let's say test and filled country values like this Australia, New Zealand, Germany by holding them in a custom field under custom settings which are comma separated. However, I am unsure how to use this in if condition of the trigger which I mentioned here – if (usrcountry == 'Australia' || usrcountry == 'New Zealand' || usrcountry == 'Austria' || usrcountry == 'Belgium' )

Best Answer

See the code sample below for how to use a comma separated list that is stored in a custom setting.

// Get value from the custom setting
MyCustomSetting__c cs = MyCustomSetting__c.getInstance();
String countryList = cs.CountryList__c;

// Split to a List then convert to a Set.
List<String> listOfCountries = countryList.split(',');
Set<String> countries new Set<listOfCountries>;

// Using the Set
if (countries.contains(usrcountry)) {
    // logic
}

Null checks are excluded from this sample. You would need to add them where needed.

Related Solutions

[SalesForce] Combine Custom settings with Custom Labels

Sdry, I have wanted to do exactly this ever since Custom Settings came out. The problem, though, is that there is no Apex API for Custom Labels (click the link to vote for the idea for it!), so Custom Labels cannot be dynamically retrieved or requested within Apex. However, it CAN, as of Spring 12, be done in Visualforce, using Dynamic Components.

Here, I think is what you are looking for in Apex (that cannot yet be done):

Custom Settings + Custom Labels IN APEX (**not yet possible**)

// Get the stored Custom Setting record for User Preferences
User_Prefs__c p = User_Prefs__c.getInstance(UserInfo.getUserId());

// Get the stored ISO Code
String isoCode = p.ISO_Code__c;

// Get the running user's language
String languageKey = [
    select LanguageLocaleKey from User 
     where Id = :UserInfo.getUserId() 
     limit 1
].LanguageLocaleKey;

// Get the translation of the ISO Code corresponding to this user's language
// **THIS IS NOT POSSIBLE YET IN APEX**
String translatedCode = System.Label.getLabel('ISOCode_'+isoCode).getTranslation(languageKey);

And here would be an equivalent if you are using Visualforce:

Custom Settings + Custom Labels IN VISUALFORCE (possible right now)

/* APEX CONTROLLER */
public class Controller {

    public String getStoredISOCode() {
        // Get the stored Custom Setting record for User Preferences,
        // and return the ISO code
        return User_Prefs__c.getInstance(UserInfo.getUserId()).ISO_Code__c;
    }

}

/* VF PAGE */
<apex:page controller="MyController">

    <b>ISO Code</b>{!storedISOCode}
    <b>Translated</b>{!$Label['ISOCode_' & storedISOCode]}

</apex:page>

[SalesForce] Fetching Record Type Name / Id values from Custom Settings – best practise

A problem with switching to the name is that in triggers only the immediate fields of objects are available. So RecordTypeId is available but the related field that has the record type name RecordType.Name is not without performing an extra query.

ID values in sandboxes are the same as in production because a sandbox is a clone of production.

So I suggest that you do not make this change.

Best Answer

Related Solutions

[SalesForce] Combine Custom settings with Custom Labels

[SalesForce] Fetching Record Type Name / Id values from Custom Settings – best practise

Related Topic