Use Case

How a visual collaboration software company runs its customer reference database in Airtable

A visual collaboration software company built a shared Airtable base to store customer stories and reference accounts for its sales and marketing teams. With 35 editors and hundreds of viewers, the team eliminated scattered files and gave the full sales organization instant access to the references it needs to close deals.

The problem

Sales and marketing teams at a visual collaboration software company relied on a mix of shared documents, email threads, and informal Slack channels to track customer stories and reference accounts. When a sales rep needed a relevant case study for a prospect, finding the right reference meant digging through multiple tools with no guarantee the information was current.

Access was inconsistent: some team members had too much, others too little. Governing who could edit versus who could simply look up a reference required manual workarounds under a legacy permission model that did not cleanly separate contributors from read-only viewers, making license management cumbersome as the sales organization grew.

What they built

The team deployed a single Airtable base that serves as the company's internal customer reference database. Sales and marketing contributors can add and update customer stories, tag them by industry, use case, and stage, and attach supporting materials, while the rest of the sales organization accesses the base as free viewers with no license overhead.

Okta SSO provides authentication and is being configured for SCIM group provisioning so that new hires are automatically placed in the correct permission group without any manual IT intervention. The Editors and Viewers license model made it practical to extend read access to hundreds of colleagues at a cost structure that fits the team's budget.

The outcome

Sales reps can now search and filter the reference database directly in Airtable to surface the most relevant customer stories for any prospect conversation, without waiting for a colleague to find and forward a document. The shared base also reduced the number of ad-hoc requests to the marketing team because reps can self-serve most lookups.

The IT team gained a cleaner access model tied to SSO, reducing the overhead of managing individual logins and permission changes. As the team rolls out SCIM group provisioning through Okta, onboarding new sales team members into the correct access tier will become fully automated.

Inside the solution

Customer story repository and reference management

Sales & CRM

Sales & Business Development

  • Customer story repository with structured tagging by industry, use case, and deal stage.
  • Internal lookup tool for sales reps to self-serve relevant reference accounts.
  • Viewer-heavy access model that extends read access to hundreds of colleagues at no license cost.
  • Customer reference information was scattered across documents, email, and Slack with no single source of truth.
  • Manual license management under a legacy permission model that did not separate contributors from read-only viewers.
  • No SSO or automated provisioning, requiring IT to manage individual logins and permission changes by hand.
  • Consolidated customer story access for the full sales organization in one searchable base.
  • Unlimited free viewers enabling broad visibility without additional license spend.
  • Simplified licensing using the Editors and Viewers model, with Okta SSO governance in place.
  • Sales
  • Marketing
  • IT
  • Okta SSO
  • SCIM group provisioning
Build out this use case

Sales Reference & Customer Database

Give your whole sales organization one searchable home for customer stories and reference accounts, tagged by industry, use case, and deal stage so reps find the right proof point without emailing marketing. Automations open review tasks for new stories, flag any story a declined request exposed as stale, and send a weekly refresh digest, while Airtable AI writes a rep-ready brief and triage note for every record.

Sales Reference & Customer Database - Overview dashboard
How it works

How the reference database workflow runs end to end

Capture customer stories

Marketing contributors add new customer stories to the Airtable base, tagging each record by industry, use case type, and deal stage to make filtering quick for any sales rep.

Govern access with Okta SSO

All team members authenticate through Okta. Editors get contributor access to create and update records. The broader sales organization joins as free viewers, keeping license costs contained.

Self-serve lookups by sales reps

Sales reps open the base and filter by the tags most relevant to their open opportunity, pulling up verified customer stories without emailing marketing or searching through documents.

Automate provisioning with SCIM

As SCIM group provisioning goes live through Okta, new hires are automatically assigned to the correct permission group on their first day, eliminating manual IT setup for every new team member.

FAQ

Frequently asked questions

Airtable's Editors and Viewers license model lets the company give hundreds of sales team members read-only access to the reference database at no additional license cost. Only the roughly 35 active contributors hold editor seats, keeping costs proportional to who actually manages records.

Okta SSO is live and governs authentication for all users. SCIM group provisioning is currently being configured so that Okta will automatically assign new employees to the correct Airtable permission group, removing the need for manual IT intervention on every hire.

Yes. Each customer story record is tagged with structured fields including industry, use case type, and deal stage. Sales reps can apply filters or use views pre-built by the marketing team to surface the references most relevant to a specific prospect conversation.

Previously, reference information lived across shared documents, email threads, and Slack messages with no consistent format. The Airtable base gives every team member one searchable location with up-to-date records maintained by a defined group of editors, reducing both the time to find a reference and the risk of sharing stale information.

The reference database base can be linked to a sales pipeline base so reps can attach relevant customer stories directly to open opportunities. It can also feed marketing reporting on which references are most frequently used, helping the team prioritize which customer stories to refresh or expand.