The Assignment Exclusion Field setting allows you to control exactly which records should be included in the RH Matrix, RH Manage Assignments, or RH Time Tracking Lightning components.
For example, the following time tracking matrix shows all assignments for a resource named Olivia White.
Since assignments might be against Opportunities, Projects, or other non-billable records, this list could get quite long. Using the Assignment Exclusion Field functionality, we could separate this single time tracking matrix into three distinct matrices, one for Opportunities, one for Projects, and one for other non-billable assignments.
This keeps each matrix at a manageable height and makes it easy to find the assignment you need quickly.
In addition to the RH Matrix, the same logic can be applied to other components like RH Manage Assignments and RH Time Tracking.
How to set it up
Each interface allows you to specify an Assignment Exclusion Field which can be either a checkbox field or a checkbox-based formula field.
If no field is specified, all assignments for a record will be displayed. If a field is specified, only assignments where the field value is TRUE will be displayed and assignments where the field value is FALSE will not be displayed.
RH Matrix
When adding the RH Matrix to a Lightning page, use the Assignment Exclusion Field dropdown to select a checkbox or checkbox formula field from the Resource Assignment object.
For more information, view the The Matrix Lightning Web Component support page.
RH Time Tracking
When adding the RH Time Tracking component to a Lightning page, use the Assignment Exclusion Field dropdown to select a checkbox or checkbox formula field from the Resource Assignment object.
For more information, view the Enhanced Time Tracking Component support page.
RH Manage Assignments
Similar logic can be applied to the RH Manage Assignments component as well. For example, Projects within XYZ Company have project teams of 25 – 35 resources.
Instead of managing all of their resources within a single assignments screen, they would prefer to segment the assignments within three main groups, the account team, the development team, and the testing team, which are determined by the Role field of the assignment. They could accomplish this by creating three checkbox formulas on the Resource Assignment object.
The “Is Account Team” formula:
ISPICKVAL(ResourceHeroApp__Role__c, "Account Manager") || ISPICKVAL(ResourceHeroApp__Role__c, "Project Manager")
The “Is Dev Team” formula:
ISPICKVAL(ResourceHeroApp__Role__c, "System Architect") || ISPICKVAL(ResourceHeroApp__Role__c, "Developer")and the “Is Test Team” formula:
ISPICKVAL(ResourceHeroApp__Role__c, "QA Tester")We can then use these fields for each of the RH Manage Assignments components that we add to the page.
The result is that we have three separate RH Manage Assignments components, with each displaying assignments for a specific team.
Legacy Matrix
To create the matrix in the Opportunities tab above, we first created a checkbox formula field on the Resource Assignment object called “Is Opportunity”:
NOT(ISBLANK( ResourceHeroApp__Opportunity__c ))Next, we create a Visualforce page which will use the new “Is Opportunity” field in the Assignment Exclusion Field setting:
Only those Resource Assignments where the “Is Opportunity” field is TRUE will be included.
Example – Show Projects and only high-probability Opportunities
The following time tracking matrix shows all assignments for a resource named Olivia White.
But let’s say that you wanted to limit the assignments shown on a Resource time tracking matrix to only those that are related to a project OR to opportunities with a probability greater than 75%. You could create a formula field on the Resource Assignment object called “Projects and High Prob Opps Only” with the following formula:
NOT(ISBLANK(Project__c) || (NOT(ISBLANK(ResourceHeroApp__Opportunity__c)) && ResourceHeroApp__Opportunity__r.Probability > 75))We can then use this field as the Assignment Exclusion Field for our time tracking matrix:
You can now see that the matrix only shows the assignments for projects and for high probability opportunities.
