---
title: View Available Personnel in a Geographical Area | Lookup Helper Use Case Library
description: With Lookup Helper, create information relationships in Salesforce to quickly find available resources within the geographical location of the customer.
image: https://www.passagetechnology.com/hubfs/Imported_Blog_Media/img-32.png
---

[GET DEMO](https://www.passagetechnology.com/any-product-one-on-one) **+1 (224) 655-6779

[![Trusted Salesforce service partner Passage Technology](https://www.passagetechnology.com/hubfs/2021/Nav-header-logo_PT.png) ](https://www.passagetechnology.com)

- Solutions 
    - By User Type 
          - [Admins](https://www.passagetechnology.com/en/solutions/salesforce-admin) 
                  - [Getting Around Rollup Limitations](https://www.passagetechnology.com/en/solutions/salesforce-admin#rollup-limitations)
                  - [Reports & Data Aggregation](https://www.passagetechnology.com/en/solutions/salesforce-admin#Reports)
                  - [GDPR Compliance](https://www.passagetechnology.com/en/solutions/salesforce-admin#GDPR)
                  - [Data Cleanup](https://www.passagetechnology.com/en/solutions/salesforce-admin#cleanup)
          - [Project Managers](https://www.passagetechnology.com/en/solutions/salesforce-project-managers) 
                  - [Managing Internal Projects](https://www.passagetechnology.com/en/solutions/salesforce-project-managers#internal-projects)
                  - [Collaborate on External Projects & Client Status Reporting](https://www.passagetechnology.com/en/solutions/salesforce-project-managers#External)
                  - [Project Analytics](https://www.passagetechnology.com/en/solutions/salesforce-project-managers#Analytics)
                  - [Salesforce Training for Project Management Success](https://www.passagetechnology.com/en/solutions/salesforce-project-managers#SF-training)
          - [C-Suite](https://www.passagetechnology.com/en/solutions/c-suite) 
                  - [Business Insights](https://www.passagetechnology.com/en/solutions/c-suite#business-insights)
                  - [Decision Making & Prioritizing Initiatives](https://www.passagetechnology.com/en/solutions/c-suite#decision-making)
                  - [Project Planning & Managing Execution](https://www.passagetechnology.com/en/solutions/c-suite#managing-execution)
                  - [Custom Solutions & Integrations](https://www.passagetechnology.com/en/solutions/c-suite#custom-solutions)
          - [IT Managers](https://www.passagetechnology.com/en/solutions/it-managers-using-salesforce) 
                  - [Security & Compliance](https://www.passagetechnology.com/en/solutions/it-managers-using-salesforce#security)
                  - [Enabling Salesforce Users](https://www.passagetechnology.com/en/solutions/it-managers-using-salesforce#enabling-team-members)
                  - [Managing IT Projects](https://www.passagetechnology.com/en/solutions/it-managers-using-salesforce#projects)
                  - [Avoiding Technical Debt](https://www.passagetechnology.com/en/solutions/it-managers-using-salesforce#avoid-technical-debt)
          - [Salesforce Analysts](https://www.passagetechnology.com/en/solutions/salesforce-analysts) 
                  - [Reports & Data Aggregation](https://www.passagetechnology.com/en/solutions/salesforce-analysts#reports)
                  - [Project Management](https://www.passagetechnology.com/en/solutions/salesforce-analysts#project-management)
                  - [Custom Solutions & Integrations](https://www.passagetechnology.com/en/solutions/salesforce-analysts#custom-solutions)
    - By Industry or Cloud 
          - [Software](https://www.passagetechnology.com/en/solutions/computer-software-industry) 
                  - [Reports & Data Aggregation](https://www.passagetechnology.com/en/solutions/computer-software-industry#reports)
                  - [Decision Making & Prioritizing Initiatives](https://www.passagetechnology.com/en/solutions/computer-software-industry#decision-making)
                  - [Project Management](https://www.passagetechnology.com/en/solutions/computer-software-industry#project-management)
                  - [Security & Compliance](https://www.passagetechnology.com/en/solutions/computer-software-industry#security)
          - [Healthcare & Life Sciences](https://www.passagetechnology.com/en/solutions/healthcare-life-sciences-industry-cloud) 
                  - [Project Management](https://www.passagetechnology.com/en/solutions/healthcare-life-sciences-industry-cloud#project-management)
                  - [HIPAA Compliance](https://www.passagetechnology.com/en/solutions/healthcare-life-sciences-industry-cloud#hipaa)
                  - [Reports & Data Aggregation](https://www.passagetechnology.com/en/solutions/healthcare-life-sciences-industry-cloud#reports)
                  - [Custom Solutions & Integrations](https://www.passagetechnology.com/en/solutions/healthcare-life-sciences-industry-cloud#custom-solutions)
          - [Financial Services](https://www.passagetechnology.com/en/solutions/financial-services-industry-cloud) 
                  - [Relating Custom Objects](https://www.passagetechnology.com/en/solutions/financial-services-industry-cloud#custom-objects)
                  - [Reports & Data Aggregation](https://www.passagetechnology.com/en/solutions/financial-services-industry-cloud#Reports)
                  - [Improving Data Quality](https://www.passagetechnology.com/en/solutions/financial-services-industry-cloud#data-quality)
                  - [Compliance](https://www.passagetechnology.com/en/solutions/financial-services-industry-cloud#Compliance)
          - [Nonprofit](https://www.passagetechnology.com/en/solutions/nonprofit-industry-cloud) 
                  - [Reports & Data Aggregation](https://www.passagetechnology.com/en/solutions/nonprofit-industry-cloud#reports)
                  - [Improving Data Quality](https://www.passagetechnology.com/en/solutions/nonprofit-industry-cloud#data-quality)
                  - [Project Management](https://www.passagetechnology.com/en/solutions/nonprofit-industry-cloud#project-management)
- Products 
    - [Rollup Helper](https://www.passagetechnology.com/rollup-helper-overview)
    - [Milestones PM+](https://www.passagetechnology.com/milestones-pm-plus-overview)
    - [Lookup Helper](https://www.passagetechnology.com/lookup-helper-overview)
    - [Prioritization Helper](https://www.passagetechnology.com/prioritization-helper-overview)
    - [Data Quality Helper](https://www.passagetechnology.com/data-quality-helper-overview)
    - [Work Trail](https://www.passagetechnology.com/work-trail-overview)
- [Support](https://www.passagetechnology.com/support) 
    - [Rollup Helper](https://www.passagetechnology.com/rollup-helper-training)
    - [Milestones PM+](https://www.passagetechnology.com/milestones-pm-plus-training)
    - [Lookup Helper](https://www.passagetechnology.com/lookup-helper-training)
    - [Prioritization Helper](https://www.passagetechnology.com/prioritization-helper-training)
    - [Data Quality Helper](https://www.passagetechnology.com/data-quality-helper-training)
    - [Work Trail](https://www.passagetechnology.com/work-trail-training)
    - [Services](https://www.passagetechnology.com/developmentservices)
    - [Knowledge Articles](https://passagetech.my.site.com/KnowledgeBase/s/)
    - [Log a Support Case](https://www.passagetechnology.com/contact-us)
- [Resources](https://www.passagetechnology.com/resources) 
    - [Blog](https://www.passagetechnology.com/passage-technology-blog)
    - [Customer Success Stories](https://www.passagetechnology.com/customer-success)
    - [Essential Guides for Business Transformation with Salesforce](https://www.passagetechnology.com/en/essential-guides-for-business-transformation-with-salesforce)
    - [Use Case Libraries](https://www.passagetechnology.com/use-case-libraries)
    - [Knowledge Articles](https://passagetech.my.site.com/KnowledgeBase/s/)
    - [Release Notes](https://www.passagetechnology.com/release-notes)
- [Company](https://www.passagetechnology.com/about) 
    - [About Us](https://www.passagetechnology.com/about)
    - [Press & Testimonials](https://www.passagetechnology.com/press-testimonials)
    - [Contact Us](https://www.passagetechnology.com/contact-us)
    - [Partners](https://www.passagetechnology.com/partners)
    - [Careers](https://www.passagetechnology.com/working-at-passage)
- [Search](https://www.passagetechnology.com/search)

# View Available Personnel in a Geographical Area

[![Free Salesforce business guides to help admins/developers, project managers, sales managers, and decision makers. Download the free PDF series now: Reinventing Your Business, Reimagining Your Salesforce®.](https://www.passagetechnology.com/hubfs/2021/Essential-Salesforce-Guide_Helper-Suite.png) ](https://www.passagetechnology.com/en/essential-guide-for-salesforce-admins-developers)

## Problem: As an inbound call center rep, I need to quickly and easily find available resources within the geographical location of the customer.

## Solution: Use Lookup Helper to relate your custom geographical record to your custom personnel object, then use Rollup Helper to display the first available representative.  

This use case is highly adaptable, but for documentation Zip Code and Field Rep are the Custom Objects being used.

Note: This use case assumes that there is a checkbox on the Field Rep record for “Available” and a text field on the Field Rep object for the Zip Code “Assigned To.

![Zip code Object](https://www.passagetechnology.com/hubfs/Imported_Blog_Media/img-32.png)

![Related Field Reps to Zip Code](https://www.passagetechnology.com/hubfs/Imported_Blog_Media/img-37.png)

 

First, create a custom lookup field on Field Rep that looks up to Zip Code, then create a Lookup Helper Setting to populate Zip Code:

1. Select Child Object:  Field Rep
2. Select / Create Lookup Field to be Used
   
     1. Maintain Existing Lookup Relationship
     2. Zip Code
3. Select Lookup Helper Setting Type
   
     1. Lookup Helper Setting Type: Field matches ID
     2. Select field on Field Rep to match the ID: Assigned To
4. Save and Run the Lookup Helper setting and enable real time on Field Rep.

Next, create a text field on Zip Code: Available Rep

Create a rollup with Rollup Helper displaying the name of the first available rep:

1. Select Destination Object: Zip Code
2. Select Target Field: Available Rep
3. Select Source Field
   
     1. Which object would you like to use as the source:      
        
            1. Child Object: Field Rep
            2. Select Relationship: Zip Code - Field_Rep__c.Zip_Code__c
     2. Which field on Field Rep should we use as a source:
        
            1. Field Rep Name
            2. Select Type: Text

Create a new filter: First Available

1. Enter Filter Name:  
   
     1. First Available
     2. Limit to 1 record
2. Specify Sort Order (You can use whatever field makes the most sense for your process.)
   
     1. Record ID
     2. Ascending
3. Specify Filter Criteria
   
     1. Deleted = False (Default)
     2. Available = True

Save and Run the rollup.

![Available personnel image](https://lh6.googleusercontent.com/Nt80W1uaVLNuTez0jPYysjsgKnpFi8Hj3hRUl9ISu_LnK0cG3nqElMiDPwHN0diUbJcOzt_xN4EMgZpoSJ5QtsLWm0HIReFDFZvA9nI-uOzQkzJbiyqp-zrjJUnF3ObsaYY7VFUgYWggBV-4x3hl6Tc)

This use case can be extended by rolling up the results from Zip Code to Account. For further assistance with this use case, schedule a [one-on-one demo](https://www.passagetechnology.com/any-product-one-on-one).

How are you identifying specific people in a geographic region at your company? Please share in the comment section below.

 

**Have questions? **  
[![Schedule Demo](https://no-cache.hubspot.com/cta/default/4130736/7f11138e-273e-446e-9889-6e6fb453e4c5.png)](https://cta-redirect.hubspot.com/cta/redirect/4130736/7f11138e-273e-446e-9889-6e6fb453e4c5)

 

Tags: [Custom Object](https://www.passagetechnology.com/lookup-helper-use-cases/topic/custom-object), [Admin Apps](https://www.passagetechnology.com/lookup-helper-use-cases/topic/admin-apps), [Rollup Helper](https://www.passagetechnology.com/lookup-helper-use-cases/topic/rollup-helper), [Field Rep](https://www.passagetechnology.com/lookup-helper-use-cases/topic/field-rep), [Zip Code](https://www.passagetechnology.com/lookup-helper-use-cases/topic/zip-code)

| [** Automatically Assign Leads to Accounts ](https://www.passagetechnology.com/lookup-helper-use-cases/assign-lead-to-account-based-on-domain) | [Lookup Helper Use Case Library](https://www.passagetechnology.com/lookup-helper-use-cases) | [ Optimize Sales Rep Reporting and Leaderboards in Salesforce ** ](https://www.passagetechnology.com/lookup-helper-use-cases/sales-rep-reporting) |
| --- | --- | --- |

[ Tracking Open Cases on Contacts in Salesforce ](https://www.passagetechnology.com/lookup-helper-use-cases/track-open-cases-on-contacts-in-salesforce)

[ Tracking Open Cases on Accounts in Salesforce ](https://www.passagetechnology.com/lookup-helper-use-cases/track-open-cases-on-accounts-in-salesforce)

[ Relate Contacts to their Assistants in Salesforce ](https://www.passagetechnology.com/lookup-helper-use-cases/relate-contacts-to-their-assistants-in-salesforce)

[ Automatically Link Contacts to Individuals in Salesforce ](https://www.passagetechnology.com/lookup-helper-use-cases/automatically-link-contacts-to-individuals-in-salesforce)

[ Automatically Link Contacts to Account Owners in Salesforce ](https://www.passagetechnology.com/lookup-helper-use-cases/automatically-link-contacts-to-account-owners-in-salesforce)

[ Link Child Accounts to Ultimate Parent Account in Salesforce ](https://www.passagetechnology.com/lookup-helper-use-cases/ultimate-parent-account)

[ Set Queue Custom Object on Any Standard Object ](https://www.passagetechnology.com/lookup-helper-use-cases/top-use-case-set-queue-custom-object-on-any-standard-object)

[ Display Related List of Grandchild Records on the Parent Record ](https://www.passagetechnology.com/lookup-helper-use-cases/top-use-case-link-cases-and-opportunities-to-parent-accounts)

[ Relating Cases to Accounts in Salesforce ](https://www.passagetechnology.com/lookup-helper-use-cases/relating-cases-to-accounts-in-salesforce)

[ Assign Lead to Account Owner and Send New Lead Notification ](https://www.passagetechnology.com/lookup-helper-use-cases/assign-lead-to-account-owner-and-send-new-lead-notification)

![Salesforce certified services by trusted Passage Technology](https://www.passagetechnology.com/hubfs/Salesforce/SF%20Partner%20Badges%202026%20(for%20footer).png)

Explore

- [Rollup Helper](https://www.passagetechnology.com/rollup-helper-overview)
- [Milestones PM+](https://www.passagetechnology.com/milestones-pm-plus-overview)
- [Lookup Helper](https://www.passagetechnology.com/lookup-helper-overview)
- [Prioritization Helper](https://www.passagetechnology.com/prioritization-helper-overview)
- [Data Quality Helper](https://www.passagetechnology.com/data-quality-helper-overview)
- [Work Trail](https://www.passagetechnology.com/work-trail-overview)

Services

- [Custom Development Services](https://www.passagetechnology.com/developmentservices)
- [Milestones PM+ Starter Packs](https://www.passagetechnology.com/milestones-pmplus-starter-packs)

Learn

- [Support Portal](https://www.passagetechnology.com/support)
- [Resources Portal](https://www.passagetechnology.com/resources)

Company

- [About](https://www.passagetechnology.com/about)
- [Careers](https://www.passagetechnology.com/working-at-passage)
- [Press & Testimonials](https://www.passagetechnology.com/press-testimonials)
- [Partners](https://www.passagetechnology.com/partners)

Questions?

- [Contact Us](https://www.passagetechnology.com/contact-us)
- +1 (224) 655-6779

[GET DEMO](https://www.passagetechnology.com/any-product-one-on-one)

© 2026 Passage Technology LLC All Rights Reserved. [Privacy Policy](https://www.passagetechnology.com/privacy-policy) | [Purchasing & Legal](https://www.passagetechnology.com/purchasing-and-legal) | [Terms of Service](https://www.passagetechnology.com/terms-of-service) | [App Security](https://passagetech.my.site.com/KnowledgeBase/s/article/Security-and-Privacy-Policy-1578080055496)

- [** ](https://www.facebook.com/passagetech)
- <https://x.com/passagetech>
- [** ](https://www.linkedin.com/company/passage-technology)
- [** ](https://www.youtube.com/channel/UCK2tzaCWVC7PmFCXrLirnZw)

```json
{
  "@context" : "https://schema.org",
  "@type" : "BlogPosting",
  "author" : {
    "@type" : "Person",
    "name" : "Susan Harris",
    "url" : "https://www.passagetechnology.com/lookup-helper-use-cases/author/susan-harris"
  },
  "dateModified" : "2026-07-30T18:10:03.798Z",
  "datePublished" : "2016-11-17T17:19:13.000Z",
  "headline" : "View Available Personnel in a Geographical Area",
  "image" : [ "https://www.passagetechnology.com/hubfs/Imported_Blog_Media/img-32.png" ],
  "mainEntityOfPage" : {
    "@id" : "https://www.passagetechnology.com/lookup-helper-use-cases/view-available-personnel-in-a-geographical-area",
    "@type" : "WebPage"
  },
  "publisher" : {
    "@type" : "Organization",
    "logo" : {
      "@type" : "ImageObject",
      "url" : "https://www.passagetechnology.com/hubfs/Logo%20PT_colors_wide_on-white.png"
    },
    "name" : "Passage Technology LLC"
  }
}
```