Some Useful Formula Fields

1) Get Week Day

 CASE( 
MOD( DATEVALUE( CreatedDate ) - DATE( 1990, 1, 7 ), 7 ), 
0, "Sunday", 
1, "Monday", 
2, "Tuesday", 
3, "Wednesday", 
4, "Thursday", 
5, "Friday", 
"Saturday" 
)
2) Get Month Year Based on PickList Values
if( 
ispickval(Status__c,'THIS_MONTH'), 
(case(Month(Date__c), 
1,"JAN", 
2,"FEB", 
3,"MARCH", 
4,"APRIL", 
5,"MAY", 
6,"JUNE", 
7,"JULY", 
8,"AUG", 
9,"SEP", 
10,"OCT", 
11,"NOV", 
12,"DEC", " " 
) +'-'+ TEXT(year(Date__c))) , 
if(ispickval(Status__c,'NEXT_MONTH'), 
(case(Month(Date__c) + 1 , 
1,"JAN", 
2,"FEB", 
3,"MARCH", 
4,"APRIL", 
5,"MAY", 
6,"JUNE", 
7,"JULY", 
8,"AUG", 
9,"SEP", 
10,"OCT", 
11,"NOV", 
12,"DEC", 
13, "JAN", " " 
) +'-'+ if((Month(Date__c) + 1)>12, TEXT(year(Date__c) + 1), TEXT(year(Date__c)))), 
if(ispickval(Status__c,'NEXT_TO_NEXT_MONTH'), 
(case(Month(Date__c) + 2 , 
1,"JAN", 
2,"FEB", 
3,"MARCH", 
4,"APRIL", 
5,"MAY", 
6,"JUNE", 
7,"JULY", 
8,"AUG", 
9,"SEP", 
10,"OCT", 
11,"NOV", 
12,"DEC", 
13,"JAN", 
14, "FEB", " " 
) +'-'+ if((Month(Date__c) + 2)>12, TEXT(year(Date__c) + 1), TEXT(year(Date__c)))), 

if(ispickval(Status__c,'LAST_MONTH'), 
(case(Month(Date__c)-1 , 
1,"JAN", 
2,"FEB", 
3,"MARCH", 
4,"APRIL", 
5,"MAY", 
6,"JUNE", 
7,"JULY", 
8,"AUG", 
9,"SEP", 
10,"OCT", 
11,"NOV", 
12,"DEC", 
0, "DEC", " " 
)+'-'+ if((Month(Date__c) - 1) = 0, TEXT(year(Date__c)-1), TEXT(year(Date__c)))), 

"") 

 )))

OutPut : If Date__c : 16/04/2016 And Status__c Value is "This Month">>> Then O/P is April 2106

 3) Get Tick and Cross Image Using farmula fields
Step First: Upload tick and cross image in document and clik on image copy the image url address

 and Now create the farmula field

 IF(TEXT(Type__c) == "A",IMAGE("https://c.ap1.content.force.com/servlet/servlet.ImageServer?id=0159000000CBMdY&oid=00D90000000K90z&lastMod=1451724592000","Active"), IMAGE("https://c.ap1.content.force.com/servlet/servlet.ImageServer?id=0159000000CBMdT&oid=00D90000000K90z&lastMod=1451724558000","Expired") )
4) Create Formula field for Multi select Pick list values

 SUBSTITUTE( 
IF(INCLUDES(TestMulti__c, "A"), "A;", NULL) + 
IF(INCLUDES(TestMulti__c, "B"), "B;", NULL) + 
IF(INCLUDES(TestMulti__c, "C"), "C;", NULL) + 

 IF(INCLUDES(TestMulti__c, "D"), "D;", NULL) + ".", ";.", NULL)
5) Get Month Name from Date value
CASE(MONTH( DATEVALUE( CreatedDate )), 
1, "January", 
2, "February", 
3, "March", 
4, "April", 
5, "May", 
6, "June", 
7, "July", 
8, "August", 
9, "September", 
10, "October", 
11, "November", 
12, "December", 
"None")

 6) Time stamp Formula for Calculate 5 min

 CreateDate-0.038

Comments

Post a Comment

Popular Post

How to Add Custom Error Message on Catch

Code: try {           // Code Logic } catch(Exception e){ if(e.getMessage().contains('FIELD_CUSTOM_VALIDATION_EXCEPTION, Enter valid Date')) { Apexpages.addMessage(new ApexPages.Message (ApexPages.Severity.ERROR, 'Please Enter valid Date')); return Null;  }  else if(e.getMessage().contains('FIELD_CUSTOM_VALIDATION_EXCEPTION,  Too Large Data')) { Apexpages.addMessage(new ApexPages.Message (ApexPages.Severity.ERROR, 'Please fill 20 character data in field'));  } else {       ApexPages.addmessage(new ApexPages.message(ApexPages.severity.ERROR,e.getmessage()));         return Null; }  } 
Read more

Get All Sub-ordinate User in Role Hierarchy

Que: To Get all Sub-ordinate users in role hierarchy . Solution :  Create a Util Class: public with sharing class RoleUtils {   public static Set<ID> getRoleSubordinateUsers(Id userId) {     // get requested user's role     Id roleId = [select UserRoleId from User where Id = :userId].UserRoleId;     // get all of the roles underneath the user     Set<Id> allSubRoleIds = getAllSubRoleIds(new Set<ID>{roleId});     // get all of the ids for the users in those roles     Map<Id,User> users = new Map<Id, User>([Select Id, Name From User where        UserRoleId IN :allSubRoleIds]);     // return the ids as a set so you can do what you want with them     return users.keySet();   }   private static Set<ID> getAllSubRoleIds(Set<ID> roleIds) {     Set<ID> currentRoleIds = new Set<ID>(); ...
Read more

Show Hyper Link On Add Error in Salesforce Trigger

Requirement: Check Duplicate record in system and show the add error in form of hyperlink corresponding duplicate record ID Solution : Write a trigger and show add error objExistingRecord >>> OldRecord Id objNewRecord >> New Record  objNewRecord.addError('Same Combination of Record already Inserted in System: <a href=\'/'+ objExistingRecord.id +'\'>'+objExistingRecord.Name+'</a>', false);                                                                           Thanks                                                Sumit Shukla
Read more