how to create an Activity Saved Search wherein the filter is based on an Employee field. Currently, no Employee fields are available on the Activity Saved Search filter fields drop-down.
Solution
- Create a Custom Entity Field for Employee Records
- Navigate to Customization > Lists, Records & Fields > Entity Fields > New
- Label: Enter label
Example: New Region - Type: Select Free-Form Text
- Store Value: Enter Checkmark
- Click Applies To
- Employee: Enter Checkmark
- Click Display
- Subtab: Select Main
- Display Type: Select Normal
- Click Save
- Create a Custom CRM Field
- Navigate to Customization > Lists, Records, & Fields > CRM Fields > New
- Label: Enter Label
Example: Assigned To Region - Type: Select Free-Form Text
- Store Value: Remove Checkmark
- Click Applies To
- Tasks: Enter Checkmark
- Click Display
- Subtab: Select Main
- Display Type: Select Hidden
- Click Sourcing and Filtering
- Source List: Select Assigned
- Source From: Select Region New
- Click Save
- Create an Activity Saved Search
- Navigate to Lists > Search > Saved Searches > New
- Click Activity
- Search Title: Enter the title
Example: Activity Saved Search - Click Criteria
- Click Standard
- Field:
- Select Assigned To Region (Custom)
- Assigned To Region: Enter the name of the region
- Select Type
- Type: Select Activity
- Select Assigned To Region (Custom)
- Click Save & Run
Note: The user cannot use the Sales Rep fields because the values are based on the Customer Record’s Sales Rep field. The value of the field can only be sourced by creating a new CRM field based on the Custom Employee field.