January 21, 2019

Searching Picklist, Multi-Picklist, and Date Values from Global Search and List View Search in Salesforce

Problem Description :  Salesforce has limited support for “Search” functionality. Users can only search values stored in the text fields/controls. Salesforce users cannot search values in Multi-Select objects as it is not supported. Multi-Select values are stored as text strings separated by semicolons in the database. The majority of business savvy customers want to search on all/any field on the screen.
January 21, 2019

How To Identify a Date Which is “X” Business Days From a Particular Date in Salesforce?

Problem Description: Salesforce customers/users find it hard to count business days between today and a particular date as there is no function/method which lets you know the number of business days between two dates. So, if a user wants to get notified when there are exactly 'x' business days left before a particular date, there is no straightforward way of achieving it. Challenges to User/Developer: A Suggested workaround is to create a formula field that holds a date which is exactly 'x' business days away from a particular date.