Some Very useful Salesforce Links

http://sfdchack.blogspot.in/

http://blog.jeffdouglas.com/

Comments

Post a Comment

Popular Post

Show Custom And Standard Object

Image
ShowCustomAndStandardObject Requirement:   Create two custom pick list field . first picklist contains the the three values" All, Custom, Standard" when user select "All" then in the second picklist show all custom and standard object, and when user select "custom" the custom object filter and same for  "standard". And After that click on "show filed" button  then all field of selected object appear in table. and User can select the fields and click on "query button" the generate query in string form. <!--ShowCustomAndStandardObject--> Create Visualforce page <apex:page controller="clsCustStandObj"> <meta name="google-translate-customization" content="afb3859aeab26f11-8390680e6d2f19bf-g71f10bf08db6379c-15"></meta> <div id="google_translate_element"></div><script type="text/javascript"> function googleTranslateElementInit() ...
Read more

Rollup value from Child object To Parent Object Using Aggregate Result Query

Requirement: Update Total Age on Account from contact. Write a trigger on Contact, When Contact record will insert with age value update the total age on Account of child contacts, Create Age number field on Contact object Create Total Age number field on Account Object trigger updateTotalAgeonAccount on Contact (after insert,after delete ,after update) { set<Id> accountIds = new set<Id>(); list<account> updateAccounts = new list<account>(); if(Trigger.isUpdate ||Trigger.isInsert) { for(contact c : trigger.new) { accountIds.add(c.accountid); } } if(Trigger.isDelete) { for(contact c : trigger.old) { accountIds.add(c.accountid); } } //run the query to sum the data AggregateResult[] totalAges= [select  SUM(age__c)totalAge,accountId  From Contact where accountId IN:accountIds group by accountId]; System.debug('totalAges@@@'+totalAges); for(AggregateResult ar: totalAges) { Id thisAccountId...
Read more

Check Duplicate EmailId when user Insert the Contact

Check Duplicate EmailId when user Insert the Contact trigger OnContactChekDuplicateEmail on Contact (before insert) { Set<String> emails = new Set<String>(); List<Contact>lstCon = new List<Contact>(); set<String> setEmail = new set<String>(); for(Contact Con:trigger.new){ emails.add(con.Email); } lstCon=[Select name,id, email from Contact where Email in:emails]; for(Contact con :lstCon){  setEmail.add(con.email); } for(Contact c :trigger.new){  if(setEmail.contains(c.email)){   c.adderror('Email duplicate'); }    } }
Read more