Assignment Exclusion Field

Overview

The Assignment Exclusion Field setting allows you to control exactly which records should be included in the Matrix, Manage Assignments, or Time Tracking lightning component interfaces.

For example, the following time tracking matrix shows all assignments for a resource named Olivia White.

All assignments together

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 district matrices, one for Opportunities, one for Projects, and one for other non-billable assignments.

Exclusion Field Separate Tabs

This keeps each matrix at a manageable height and makes it easy to find the assignment you need quickly.

In addition to the Matrix, the same logic can be applied to other interfaces like Manage Assignments and Time Tracking Lightning Component.

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.

To create the Matrix in the Opportunities tab above, we first created the formula on the Resource Assignment object called Is Opportunity:

NOT(ISBLANK( ResourceHeroApp__Opportunity__c ))
Copy to Clipboard

Next, we create a visualforce page which will use the new Is Opportunity field in the Assignment Exclusion Field setting:

Opportunity Exclusion Visualforce Page

Only those Resource Assignments where the Is Opportunity field is TRUE will be included.

Opportunity Assignments Only

Example – Manage Assignments Component

Similar logic can be applied to the Manage Assignments component as well.  For example, Projects within XYZ Company have project teams of 25 – 35 resources.

Exclude Example 2 - Large number of assignments A

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 of the assignment.  They could accomplish this by creating three checkbox formulas on the Resource Assignments object.

The Is Account Team formula:

ISPICKVAL(ResourceHeroApp__Role__c, "Account Manager") || ISPICKVAL(ResourceHeroApp__Role__c, "Project Manager")
Copy to Clipboard

The Is Dev Team formula:

ISPICKVAL(ResourceHeroApp__Role__c, "System Architect") || ISPICKVAL(ResourceHeroApp__Role__c, "Developer")
Copy to Clipboard

and the Is Test Team formula:

ISPICKVAL(ResourceHeroApp__Role__c, "QA Tester")
Copy to Clipboard

We can then use these fields for each of our Manage Assignment components that we add to the page.

Exclude Example 2 - Exclude field on component for test team

The result is that we have three separate Manage Assignment components, with each displaying assignments for a specific team.

Exclude Example 2 - Assignments grouped by Team

Example – Show Projects and only high-probability Opportunities

The following time tracking matrix shows all assignments for a resource named Olivia White.

Olivia Time Tracking Matrix - without exclude

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))
Copy to Clipboard

We can then use this field as the Assignment Exclusion Field for our time tracking matrix:

Exclude field on the time tracking matrix

You can now see that the matrix only shows the assignments for projects and for high probability opportunities.

Olivia Time Tracking Matrix - with exclude

Have more questions?

Contact Us