Simple SOQL to fetch records based on today’s day and month in Salesforce
Sample Code: Date tody = system.today(); String SOQL = 'SELECT Id, Name, Email__c FROM Employee__c WHERE DAY_IN_MONTH(Date_of_Birth__c) = ' + ....
Year: 2015
Simple Batch class for Birthday Notification
Sample Batch class: global class BirthdayNotificationBatch Implements Database.Batchable <sObject> { global Database.queryLocator start(Database.BatchableContext bc) { Date tody = system.today(); String ....
How to send an email to people other than users using Workflow in Salesforce?
to send an email to people other than users using Workflow in Salesforce, add the email addresses in "Additional Emails" section. Note: You can enter up to five (5) email ....
Replace function in String using Apex in Salesforce
Simple Replace Code: String str = 'RAM'; System.debug( 'Replace value is ' + str.replace( 'A', 'O' ) ); Output: Sample Multi-Level or multiple characters replace Code: String str = 'test'; ....
How to change the colors in the Dashboard in Salesforce?
As of now we can change the colors in the Dashboard in Salesforce only if the dashboards are displaying results based on the picklist field. Sample Picklist field: City Sample Dashboard: ....
How to restrict users to update closed Opportunity?
Sample Trigger: trigger OpportunityTrigger on Opportunity (before update) { for(Opportunity oppty : trigger.new) { if(trigger.oldMap.get(oppty.Id).StageName == 'Closed Won') { ....
Chatter Groups
Chatter Groups: Create public, private, and unlisted Chatter groups to collaborate with your teams and work together on projects. Cheers!!!
How to remove time from date Salesforce?
format() will remove the time stamp from Date. Sample Code: Date dat = System.Today(); System.debug(dat.format()); format() is used to get Date from Datetime using Salesforce Apex.
How to add Opportunity Team Member related list in Salesforce?
1. Go to Setup --> Build --> Customize --> Opportunities --> Page Layouts. 2. Edit the page layout. 3. Select Related List. 4. Drag and Drop the "Opportunity Team" related ....
Where Quote pdfs are stored in Salesforce?
Quote pdfs are stored QuoteDocument sObject in Salesforce. Document attribute is used to store the binary data of the document stored in the QuoteDocument object. SOQL:SELECT Id, Name FROM QuoteDocument