Build an Airtable Inventory Management Portal

The Problem: Letting People Touch Stock Data Without Letting Them Touch Everything

You track inventory in Airtable. Products, stock levels, vendor pricing, reorder points, count history. The schema works for you, but the people who need to read or update it (warehouse staff, store managers, field technicians, external 3PLs, suppliers) cannot get into Airtable safely.

• Add them as Airtable collaborators and they see every base, every cost, every margin. At $20/user/month on the Team plan, ten warehouse staff costs $2,400 a year before you have shared anything.
• Export to a spreadsheet and the count is wrong before they open it. People update the spreadsheet instead of the source, and reconciliation becomes its own job.
• Build a custom inventory app and now you maintain a second system that has to stay in sync with Airtable forever.
• Use Airtable Interfaces and you still cannot scope rows by who is logged in. Every interface viewer sees every product and every cost.

What you need is a portal where each person sees the inventory rows that belong to them, can run counts and submit reorders, and never sees vendor margins or other locations. Your buying team and ops team keep working in Airtable as before.

How CollabPortals Works for Inventory

CollabPortals connects to your Airtable base and creates a branded portal for the people who interact with stock data. Each user logs in with their email, sees only the records linked to them, and edits the fields you allow. The base does not move, your formulas do not break, your buying team does not change tools.

Example: Multi-Location Stock Portal

A retailer runs five locations and tracks one product catalog with per-location stock levels. Store managers update counts and submit reorder requests. Head office handles purchasing.

Table	Store Manager Access	Purpose
Products	View only	Read-only catalog with description, pack size, retail price
Stock Counts	View, create, edit	Managers run counts at their location and submit them
Reorder Requests	View, create, edit	Managers flag items that need reordering, with reason
Locations	View only	Manager sees their own location record, hidden from others
Users	View, edit	Managers manage their own profile
Vendors	Hidden	Buying contacts and account numbers are head-office only
Vendor Pricing	Hidden	Cost prices, margin, discount tiers stay internal
Purchase Orders	Hidden	Internal buying workflow

Store managers see a clean app: their location, their products, their counts, and a way to flag stockouts. Head office sees the full picture in Airtable.

Use Cases for Inventory Management Portals

Multi-Location Retail and Hospitality

Each store, café, or venue counts and reorders against a shared catalog. The catalog stays consistent, but each location only sees its own counts and only its own staff.

• Stock Counts (create, edit), date, counted-by, location, quantity on hand
• Reorder Requests (create, edit), product, quantity needed, urgency, reason
• Products (view only), description, pack size, supplier (hidden), cost (hidden)
• Hidden: cost prices, gross margin, supplier terms, other locations' counts

Warehouse and 3PL Operations

Warehouse staff or third-party logistics partners count and pick stock for clients. Each client sees their own inventory, your team sees everyone's.

• Inventory by Client (view, edit), SKU, on-hand, reserved, available
• Receipts (create), incoming shipments, dates, condition
• Pick Lists (view), assigned picks for the day
• Hidden: storage fees, client billing rates, internal cost allocation

Equipment and Asset Tracking

Field engineers, depot managers, or rental customers track which units are where, when they were last serviced, and what condition they are in.

• Assets (view, edit), serial number, current location, status, last service date
• Movements (create), date, from, to, transferred-by
• Service Log (view, create), inspections, fixes, parts used
• Hidden: purchase price, depreciation schedule, internal asset value

Manufacturer Raw Materials and BOM

Production staff record material draws against a bill of materials. The portal handles consumption, the office handles purchasing.

• Materials (view), part number, on-hand, reorder point
• Material Draws (create, edit), production run, material, quantity used
• Reorder Triggers (view), items currently below reorder point
• Hidden: vendor cost, lead time agreements, contract pricing

Supplier and Vendor Self-Service

Give suppliers a portal to confirm orders, post shipping updates, or upload pricing changes against their own records, without seeing what other suppliers charge you.

• Their Orders (view, edit), open POs, delivery dates, status
• Their Catalog (view, edit), price list lines for their items
• Hidden: other suppliers, your sell prices, your margins

What Makes This Better Than Spreadsheets or a New App

Capability	Shared spreadsheet	Airtable seats for everyone	Custom inventory app	CollabPortals
Counts feed straight into your live data	No	Yes	Maybe	Yes
Each user only sees their location or client	Manual filtering	No, all-or-nothing	Yes	Yes
Cost prices and margins stay hidden	No	No	Yes	Yes
Counts, reorders, and movements are structured	No	Yes	Yes	Yes
Per-user cost	Free + chaos	$20/seat/month	Build cost + dev	$10/month flat
Your buying team works in Airtable	Partly	Yes	No	Yes

For a closer look at how CollabPortals compares to other portal builders, see CollabPortals vs Miniextensions and CollabPortals vs Softr, or the roundup of the best Airtable portal builders.

Field-Level Permissions for Inventory

Inventory tables almost always mix data that staff need with data they should never see. CollabPortals lets you split that down to the field:

• Show to staff: product description, pack size, on-hand quantity, reorder point, last counted date, location
• Hide from staff: cost price, margin, supplier name, supplier terms, internal notes
• Editable by staff: count quantity, count date, reorder request, condition note, photo
• Read-only for staff: product description, vendor item code, sell price, status flags

The same Airtable table feeds both audiences. There is no second copy of the data, no manual sync, and no chance of staff seeing the cost field by accident.

Getting Started

Setting up an inventory portal usually takes under an hour:

1. Connect your Airtable account. OAuth, your tokens stay yours.
2. Choose your inventory base and pick the table that holds your users. This is usually a Staff, Employees, or Locations table with an email field.
3. Set table and field permissions per role. Decide who can view, who can create, who can edit, and which fields are hidden.
4. Set a record filter so each user only sees their rows. For example, only show Stock Counts where Location is the user's own location.
5. Share the portal link. Staff sign in with their email, verify a code, and start running counts.

No code, no second database, no sync job. Stock data lives where it already lives.

Want the step-by-step version? See the setup guide.

Frequently Asked Questions

Can each location only see its own stock counts?

Yes. CollabPortals matches each user to a record in your Airtable users table. You set a record filter so a user only sees rows linked to their location, their client, or themselves. One store manager cannot see another store's counts.

Can staff submit photos with a count or reorder request?

Yes, if your Airtable table has an attachment field and you make it visible and editable in the portal. Useful for damaged stock, dump lists, or proof-of-receipt on incoming deliveries.

Can I hide cost prices, margins, and vendor names?

Yes. Field-level permissions let you keep cost, margin, and supplier columns hidden while showing on-hand, sell price, and description. The base does not change, only the portal view does.

Does updating a count in the portal update Airtable in real time?

Yes. Edits made in the portal write directly to the underlying Airtable record. There is no separate database. Your buying team sees the new count the next time they refresh Airtable.

Can I integrate with barcode scanners or POS data?

CollabPortals reads and writes Airtable. Anything that already feeds Airtable (POS exports, barcode apps, receiving sheets) shows up in the portal automatically. Outbound integrations work the same way through Airtable automations or scripts.

How is this different from a dedicated inventory or WMS app?

Dedicated inventory and WMS tools (Cin7, Fishbowl, NetSuite Inventory) start around $40 to $200+ per user per month and assume your data lives in their system. If you already track inventory in Airtable, CollabPortals adds the user-facing layer without forcing you to migrate.