Adding conditional logic to the instructions and adding a formula block to the macro are solutions that a consultant can suggest to meet the agent's requirements of sending email to customers prior to violating an SLA based on three different SLA levels using macros. These solutions can help create macros that perform different actions based on different criteria, such as the SLA level of the case. For example:
* Adding conditional logic to the instructions is a solution that involves using IF and ELSE statements to control when to execute certain actions in a macro. Conditional logic can be used to create a macro that checks the SLA level of the case and sends an appropriate email template based on the SLA level. For example, if the SLA level is Gold, send an email template with a high priority message; else if the SLA level is Silver, send an email template with a medium priority message; else, send an email template with a low priority message.
* Adding a formula block to the macro is a solution that involves using formulas to calculate values or perform logic in a macro. Formula blocks can be used to create a macro that calculates the time remaining before the SLA violation and inserts it into the email body using quick text. For example, use a formula block to subtract the current date and time from the SLA violation date and time, and format the result as hours and minutes. Then use quick text to insert the result into the email body.
Verified References: [Service Cloud Consultant Certification Guide & Tips], Add Logic to Macros, Use Formulas in Macros