What are the Salesforce IP Addresses & Domains to whitelist?

178 Comments / Salesforce, Uncategorized

Required Domains If your company has policies to whitelist only Salesforce domains, please include to the following domains to ensure you receive all content from Salesforce:*.force.com*.salesforce.com*.salesforceliveagent.com (Necessary if you are using Live Agent, Omni or SOS)*.visualforce.com*.documentforce.com*.lightning.com*.salesforce-communities.com (Necessary if you are using Communities or Site.com)*.forceusercontent.com*.forcesslreports.com *.salesforce-hub.com (Necessary for Customer 360)*.trailblazer.me

How to find inline links/images in Salesforce knowledge using apex

Article, Data Migration, Knowledge, Salesforce, Uncategorized

We often get requirement to move articles/Knowledge from any platform to Salesforce but somehow we miss inline links to update. This script is just a quick way to find such affected articles: String artIds = ”;for(Knowledge__kav k : [SELECT ArticleBody__c FROM Knowledge__kav WHERE Language=’en_US’ AND PublishStatus=’Draft’]){    if(k.Answer__c!= null && k.ArticleBody__c.containsIgnoreCase(‘help.company.com’)){        //system.debug(k.Id);  …

How to find inline links/images in Salesforce knowledge using apex Read More »

Push notification in Lightning Service Console

1 Comment / Salesforce, Uncategorized

There is a very powerful feature in classic console that whenever any changes happens at any record by other users, you can know it in list view and case detail page as well: https://trailhead.salesforce.com/en/content/learn/modules/service_console_customize/service_console_customize_push But unfortunately, Salesforce does not provide this feature in lightning service console yet — a real pain for support agent. Here is an idea …

Push notification in Lightning Service Console Read More »

Custom Fiscal Week (Monday to Sunday) in Wave Analytics (Salesforce Einstein Analytics)

Salesforce, Uncategorized

https://success.salesforce.com/ideaView?id=0873A000000E4d2QAC   q = load “GR_Opportunities”; q = foreach q generate ‘CloseDate_day_epoch’ as ‘CloseDate_day_epoch’, ‘CloseDate_sec_epoch’ as ‘CloseDate_sec_epoch’, ‘Id’ as ‘Id’, ‘StageName’ as ‘StageName’,  daysBetween(toDate(“24-06-1985”, “dd-MM-yyyy”), toDate(CloseDate_sec_epoch)) % 7 as ‘datediff’; q= foreach q generate (case when datediff == 6 then (case when daysBetween(now(), toDate(CloseDate_sec_epoch))>=-6 and daysBetween(now(), toDate(CloseDate_sec_epoch))<=0 then “CurrentWeek” else “OtherWeek” end) when datediff == …

Custom Fiscal Week (Monday to Sunday) in Wave Analytics (Salesforce Einstein Analytics) Read More »

Filter Reports via URL Parameters in Lightning Experience

9 Comments / Salesforce, Uncategorized

No need to futz with filters! Pass URL parameters to set filter values in Lightning Experience reports. When linking to reports or when bookmarking a report, add filter value parameters to the URL to customize how the report filters when opened. For example, bookmark your opportunities report and add a filter value parameter to specify …

Filter Reports via URL Parameters in Lightning Experience Read More »

Calculate Week Days between two Dates in Wave Einstein analytics (SAQL)

Salesforce, Uncategorized

Requirement: a SAQL query to find the number of WEEKDAYS between two dates. Specifically, can use this SAQL query in a Compute Expression SAQL Expression: Here dataset name is “cases”. Start date is Created Date of a Case record and End Date is ClosedDate of Case. Algorithm is copied from here: https://help.salesforce.com/articleView?id=000004526&type=1. q = load “cases”; q = …

Calculate Week Days between two Dates in Wave Einstein analytics (SAQL) Read More »

Why Email publisher action is not visible on Case though it is added to the page layout?

8 Comments / Salesforce, Uncategorized

1. Ensure “Enable Case Feed Actions and Feed Items” is enabled under support settings. To modify Support settings : Go | Setup | Customize | Cases | Support Settings.   2. If you do not find the setting “Enable Case Feed Actions and Feed Items” under support settings, make sure “Feed Tracking” is enabled for case object. To …

Why Email publisher action is not visible on Case though it is added to the page layout? Read More »