The forum where ops managers, freelance consultants, and nonprofit directors come to unstick themselves — mid-build, tab-switching, hunting for the one thread that maps their exact tunnel.
The silent failure usually means your payload exceeds the 100KB limit. Check your record count — if you're passing full linked records instead of just IDs, you'll hit this wall fast. Add a 'Limit record fields' step before the webhook action and test with a single record first.
Stakes escalate from formula fixes to multi-table architecture. Someone here has mapped every tunnel.
You've checked the field type. You've refreshed the page. You've rebuilt the rollup from scratch. Still zero. The linked records are there — you can see them — but the count refuses to acknowledge them.
ROLLUP returns 0 on linked records that clearly have values — junction table issue?
41 replies
yuki_airtable
Formula Expert · 2,100+ answers
Classic junction table trap. Your ROLLUP is pointing at the junction table, not the final destination table. You need a second linked field from junction → destination, then ROLLUP from there. Draw it out: Table A → Junction → Table B. The rollup lives on Table A, traverses Junction, counts Table B.
Junction Table Architecture Template
3,840 builders using this template
Webhook automation triggers once then silently stops — no error in run history
23 replies
tomasz_w
Airtable Consultant · 1,200+ answers
The silent failure usually means your payload exceeds the 100KB limit. Check your record count — if you're passing full linked records instead of just IDs, you'll hit this wall fast. Add a Limit record fields step before the webhook action and test with a single record first.
Webhook Debugger Checklist Base
1,620 builders using this template
You built the automation. You tested it. It worked perfectly. You deployed it. Now it's Wednesday midnight, the trigger should have fired six times, and your Slack is silent. No error. No log. Nothing.
Three client types. Two interface views. One base. You need Client A to see only their records, Client B to see aggregates, and your team to see everything — without duplicating the base or creating a maintenance nightmare that collapses in six months.
Multi-tenant client portal in Airtable — interface permissions without base duplication
67 replies
priya_builds
Base Architect · 980+ answers
The cleanest solution I've seen at scale: one base, one Clients table with a Type field, filtered interface pages per type using the record link as the permission gate. Each client sees a page filtered to their own record ID. No duplication. The key insight is using the interface's "Start from a record" feature as your access control layer.
Multi-Tenant Client Portal Starter
5,210 builders using this template
47,200
Questions answered
94%
Marked as solved
8,300
Active builders
2.4hrs
Median answer time
Yuki Tanaka
@yuki_airtableFormula Architecture
Tomasz Wiśniewski
@tomasz_wAutomations & APIs
Priya Nair
@priya_buildsBase Architecture
Rafael Cortez
@rafael_cxInterface Designer
@dana_nonprofit answered "Syncing form submissions to multiple tables without duplicates"
4m ago
@ops_overnight marked solved "ROLLUP returns 0 on linked records"
12m ago
@lee_consultant posted "Best practice for client-facing interface with field permissions?"
18m ago
@yuki_airtable answered "IF statement inside SWITCH — precedence confusion"
31m ago
47,200 answered questions. 94% solved rate. The thread you need — the one with the junction table answer, the rollup fix, the interface binding workaround — exists. Search it first.
ROLLUP returns 0 on linked records that clearly have values
✓ solvedRollup count not updating after linked record deleted
✓ solvedSUM rollup showing blank instead of 0 on empty linked table
✓ solved