Build an Airtable Sales Rep Portal

The Problem: Reps Cannot See Their Own Patch

You run your sales operation on Airtable. Accounts, the pipeline, scheduled jobs, the product catalogue, and the paperwork all live in one base. But your field reps have no clean way to see their own patch:

• Add them as Airtable collaborators, and every rep sees every other rep's accounts, your full pipeline, and your cost and margin fields. Each seat also costs $20/month on Team plans.
• Send a weekly export, and it is stale the moment you send it. Reps work off yesterday's numbers and call you to check what changed.
• Build a custom rep app, and that is weeks of development for a basic view of data you already hold, plus ongoing maintenance.
• Use a full CRM (Salesforce, HubSpot), and you are migrating off a system that already works, paying per seat, and retraining the team.

What you need is a way for each rep to log in and see only their own accounts, their own jobs, their own pipeline, and the shared product catalogue, without seeing other reps' territories or your internal numbers.

How CollabPortals Works for Sales Rep Portals

CollabPortals connects to your Airtable base and creates a branded portal each rep accesses with a shared link. They log in with their email, are matched to their own rep record, and see only the records assigned to them. Your operations team carries on working in Airtable.

The key idea is ownership. Each table links back to a Reps table, and the portal scopes every table to the logged-in rep automatically. A shared table like the product catalogue is made visible to everyone, so the whole team works from the same list.

Example: Medical Device Field Sales

A medical device company gives each field rep a portal onto the accounts and surgical cases they support.

Table	Rep Access	Purpose
Accounts	View, edit	Hospitals and clinics in the rep's territory
Case Bookings	View, create, edit	Scheduled cases the rep is supporting, on a calendar
Opportunities	View, edit	The rep's pipeline, on a board by stage
Products	View only	The shared implant and device catalogue
Documents	Full access	Order forms, brochures, and signed usage sheets
Rep assignment	Hidden	The link field that scopes each record to its owner
Cost / margin	Hidden	Internal pricing the field team should not see

Each rep sees their own accounts, their own cases, their own pipeline, and the shared catalogue. Your team sees everything, with the cost and margin fields the reps never get.

Build a Sales Rep Portal Step by Step

Here is how the live demo above is put together. It takes about an hour the first time, with no code involved.

1. 1

   Set up your Airtable base

   Start with the base you already run: Accounts, Case Bookings (or jobs, visits, installs, whatever your reps schedule), Opportunities, a Products catalogue, Documents, and a Reps table for the people who log in. Reps is the hub. It holds each rep's email, and every other table links back to it, so each rep only ever sees their own records.

2. 2

   Connect the base and pick the user table

   Point CollabPortals at that base, then choose Reps as your user table and Email as the login field. Each rep signs in with their email and is matched to their own record, then sees only the rows that link to them.

3. 3

   Show the shared catalogue to everyone

   The product catalogue is the one table every rep should see in full. Add a link field from Products to the Reps table, link each product to your reps, and set the table to show all records. Now the whole team works from the same list while accounts and pipeline stay scoped per rep.

4. 4

   Hide your cost and margin fields

   Decide field by field what reps see. Show the list price, hide the cost and margin. Hide the rep-assignment link field that does the scoping, so the view stays clean. Reps get what they need to sell without seeing how the numbers are built.

5. 5

   Give each table the view that fits

   Pick how each table appears. Case Bookings on a calendar so a rep sees the month ahead, Opportunities as a board so a deal moves from Lead to Qualified to Won, Products as a gallery with photos, Accounts and Documents as tables. Same data, laid out for the field.

6. 6

   Let reps filter and drill in

   Turn on filter, search and sort controls so a rep can filter accounts by status or products by category. Use related tabs so opening an account shows its cases, pipeline, and documents in one place.

Use Cases for Sales Rep Portals

Medical Device and Pharma Reps

Reps coordinate surgical cases and consignment stock across the hospitals in their territory.

• Accounts (view, edit), hospitals and clinics, with notes the rep keeps current
• Case Bookings (view, create, edit), scheduled cases with date, procedure, and products needed
• Products (read-only), the shared implant and device catalogue
• Documents (full access), order forms and signed usage sheets
• Hidden: cost, margin, other reps' territories

Field Sales and Outside Sales Teams

Account executives manage a patch of accounts and a personal pipeline.

• Accounts (view, edit), the rep's named accounts and contacts
• Opportunities (view, edit), the rep's pipeline on a board by stage
• Activity / Visits (view, create), calls and meetings logged from the field
• Hidden: company-wide pipeline, internal targets, commission tables

Distributors and Manufacturer Reps

Independent reps or distributors see only the accounts and orders tied to them.

• Accounts (read-only), the accounts assigned to the rep
• Orders (view, create), orders the rep places for their accounts
• Products / Inventory (read-only), the shared catalogue and stock
• Hidden: dealer cost, other reps' orders, sourcing data

What Makes This Better Than Airtable Interfaces

Capability	CollabPortals	Airtable Interfaces	Custom Portal
External rep access	Yes, email verification, no Airtable account	No, requires Airtable seat ($20/month)	Yes (custom dev)
Per-user cost	None, unlimited users for $10/month	$20/month per rep on Team plan	Varies
Per-rep data isolation	Automatic (email-based matching)	Manual (complex filter setup)	Custom logic
Field-level permissions	Per-portal granular control	Tied to Airtable's permission system	Custom logic
Setup time	Minutes	Minutes (but internal only)	Weeks to months
Maintenance	None, changes in Airtable reflected instantly	Minimal	Ongoing
Custom branding	Logo, theme colours, favicon, portal name, and your own custom domain	Limited to Airtable UI	Full control

The key difference: Airtable Interfaces is for your internal team. CollabPortals is for the reps in the field. For a deeper look, see our full comparisons of CollabPortals vs Airtable Interfaces and CollabPortals vs Airtable Portals.

Field-Level Permissions for Sales Data

A sales base holds fields reps should never see:

• Show to reps: Account name and address, contact details, deal stage and value, case dates and procedures, list price, document attachments
• Hide from reps: Cost, margin, commission rates, internal targets, other reps' accounts and pipeline
• Editable by reps: Account notes, booking notes, opportunity stage, uploaded documents
• Read-only for reps: List price, the product catalogue, anything owned by the operations team

This lets reps keep their own accounts and notes current while your team retains control over commercial data.

Take It Further

The walkthrough above is the whole build. A few options are worth knowing once you are up and running:

• Scope by ownership automatically. Each rep sees only the accounts, cases, and deals linked to them, matched by the email they log in with. New reps just get a row in the Reps table.
• Share one catalogue, scope everything else. The product list shows to the whole team while accounts and pipeline stay private per rep.
• Let reps work from their phones. The portal is responsive, so a rep can check the day's cases or update a booking note from the car.
• Use roles for managers. Give a regional manager a role that sees every rep's accounts while reps see only their own, all from the same base.

After set-up, every change you make in Airtable shows up in the rep's portal instantly, with nothing to sync.

For the generic version that applies to any base, see the setup guide.

Frequently Asked Questions

Can each rep see only their own accounts and deals?

Yes. Each rep is matched to their record in your Airtable Reps table via email. They see only the accounts, cases, and opportunities linked to them. One rep cannot see another rep's territory.

How do reps see the shared product catalogue?

Add a link field from the Products table to the Reps table and link each product to your reps, then set the table to show all records. Accounts and pipeline stay scoped per rep, while the catalogue is shared with the whole team.

Will reps see our cost or margin?

No. You choose exactly which fields are visible at the portal level. Show the list price and hide cost, margin, and commission, even though they sit on the same table in Airtable.

Can reps update their accounts and log activity from the field?

Yes. Enable edit on the fields you want reps to change, such as account notes, booking notes, or deal stage, and turn on create where reps should add records like visits or orders. Changes appear in your Airtable base immediately.

How much does this cost compared to adding Airtable seats?

CollabPortals costs $10/month for unlimited users and portals. Adding reps as Airtable collaborators costs $20/month per user on Team plans. For 20 reps, that is $10/month vs $400/month.

Does the data stay in Airtable?

Yes. CollabPortals reads and writes directly to your Airtable base using the Airtable API. Your data stays in Airtable, CollabPortals is just a controlled window into it.