Salesforce (3)

Allow Multiple Email Addresses in a Lightning Input Component

The lightning input component has built in support for emails which works great when you need to accept an email address as input. <lightning:input aura:id=”emailForm” label=”To: ” type=”email” name=”toEmail” value=”{!v.toEmail}” required=”true”/> This auto validates the input to ensure its in the correct format. The moment you add a semi-colon to add multiple emails, the validation […]

Salesforce Formula For Calculating Case Age In Hours Excluding Weekends

This is a modification of the Salesforce formula for finding the number of business hours between two dates. Here is the Salesforce formula: ROUND( 8 * ( ( 5 * FLOOR( ( DATEVALUE( date/time_1 ) – DATE( 1900, 1, 8) ) / 7) + MIN(5, MOD( DATEVALUE( date/time_1 ) – DATE( 1900, 1, 8), 7) […]

Adding Custom Color Flag Fields in Salesforce

Salesforce no longer allows you to create custom fields with custom background colors. However, you can add images to custom fields. Let’s say you wanted to create a custom field to identify case age in business hours. For this example, we’ll identify a case opened within 24 hours with a green flag, a case opened […]