r/Airtable

HALP?! Record Linking is CONFUSING me!! Started a new job in a b2b account manager role with ~150 accounts that will RARELY change. I'm trying to link contacts to accounts but the lookup fields and functions/rules are KILLING ME! PlzHalp.

I need 3 main sections to this AirTable: Accounts, Notes/to-do, Vendor (PDF library).

I want to have my accounts listed in alphabetical order with account names only (I'm driving a lot and need a simple view).

Accounts:

  • Account Names ONLY plainly listed in Alphabetical order as my 'homepage'
  • Tap/select an account name to open a detailed account view
  • Display all account contacts clearly within the account
    • Contact names
    • Phone numbers
    • Email addresses
  • Include an easily accessible notes section within each account
  • Allow notes to be updated and sync'd into a separate “Notes / To-Do” table automatically, while still keeping a history within the account details
  • Use the Notes / To-Do table for follow-ups, reminders, and tracking activity

Notes/Daily To-do:

  • Ability to mark notes/tasks as “Done” or “Cleared”
  • List notes organized by associated account name
  • Display either:
    • The full note directly in the table
    • OR a link to the full note when additional detail is needed
  • Use notes for:
    • Follow-ups
    • Reminders
    • To-do tracking
    • Account activity history

Vendors:

  • List vendor names ONLY in alphabetical order
  • Tap/select a vendor name to open a detailed vendor view
  • Display vendor contact information clearly within the vendor account
    • Contact names
    • Phone numbers
    • Email addresses
  • Include either:
    • PDFs directly attached to the vendor
    • OR links to a centralized PDF library
  • Use vendor records for quick access to supplier information and documents

I posted in another thread and instead of suggestions, I had people messaging me requesting $300-$600 for a "full crm setup" . Just want to be clear, this is only bridging the gap while I'm in the field. The company uses SUPER out of date systems that aren't very realistic to use while in the field.

I wanted to give a full overview so there was no confusion and context was clear!

Any help, guidance or suggestions would be VERY much appreciated!

reddit.com
u/MycologistColonist — 8 hours ago

Prevent Linked Record creation when values not found?

I have a Projects table that links to another Risks table to associate risks to existing projects. The issue is, people can fill out the risk table and enter the Project Linked Record and If it doesn’t exist (or they just hit enter) it forces a new Project record to be created. I do not want this. Projects shouldn’t be created here. Only referenced to be included.

Google says if the Projects table uses a formula as primary field and not text then it won’t allow a new creation but that’s a lie (tested it) and it still allows it. Google also said to use a View for the linked record which also doesn’t work. Sure it reduces the visible records but people can still create projects here.

The only think I can think of is using a text field instead and an automation that checks against existing project names and if so, adds the appropriate linked record and if not throws a status flag but that’s ridiculously overkill.

Why is this not a simple toggle switch in linked records in 2026?! Just disable NEW record created if toggled.

reddit.com
u/BlazedAndConfused — 1 day ago

been using Airtable for stuff like lightweight CRM, project tracking, internal workflows, and client management. overall I like the flexibility but once you start scaling it a bit the pricing and setup can get harder to justify.

before we commit deeper into it, I wanted to see what other tools people have switched to that still give a similar feel without becoming overly complicated or expensive.

mostly curious what alternatives people here actually ended up happy with long term and what made you move away from Airtable in the first place.

reddit.com
u/Fantastic-Video9087 — 6 days ago

Testing airtable for small business, running to a few issues

I'm testing the waters with airtable to track both inventory/materials, orders, & customers for the small business I work at. It's a laser business and we make a lot of different products, ranging from pre-made, pre-made with customization, and fully custom orders. I'm running into a few problems so far.

  1. A lot of our products have variations to choose from. Ex: a 20oz tumbler can come in red/blue yellow, but a 40oz tumbler can come in red/green/white. This is hard to set up in the data tables and I'm not sure how to handle it.

  2. Setting up an order form. I've tried both airtable's forms as well as jotform. Airtable forms are limited it looks like, maybe I'm just doing it wrong, but I can't get them to handle input like "20oz tumbler, red, premade" vs "20oz tumbler, green, customized".

The issue I was having with Jotform was that when I linked it to my test airtable's Order table, it refused to acknowledge the Customer field even existed on the airtable side (along with a couple other fields).

I'm 100% open to using other forms/apps for taking orders, but it needs to a)have a free tier, as I'm just testing this for my boss atm, b) have a mobile app that lets you fill out the form and submit it, because my bosses often take orders while on vacation/etc and they're glued to their phones, and c) have airtable integration, or the form integrates to another good database app to keep track of orders.

reddit.com
u/Street-Painter3410 — 4 days ago

Help! I need to pull data from another row, not an option in Airtable.

I’ve been building a cash flow forecast base for my small business and I’ve gotten stuck with not being able to pull data from another record into my formula. Unfortunately this isn’t a feature airtable offers, does anyone know if a similar tool does?

Basically each day of the year is a record. I have two tables for incomes and expenses that roll up to the main daily bank total table. In that table I have my daily starting balance, my net gain/loss (rollups), and the ending total. I want future dates to keep updating the starting balance from the previous days ending balance. In theory I could do this with automations, but I have so many transactions that it would take up too many runs.

Thoughts?

reddit.com
u/Mtchick84 — 2 days ago

​Hi everyone,

​I’ve been reflecting on my workflow lately and wanted to take the pulse of the community. With Claude becoming so capable (Artifacts, MCP, etc.), I’m curious about how you’re managing your data and projects:

​The Migration: Have any of you completely migrated away from Airtable to a simpler "Claude + Google Sheets" setup? (Using Claude as the relational 'logic' and Sheets as just the raw storage).

​The Integration: Or are you leaning harder into Airtable by using the new Claude/Airtable integrations (MCP/Field Agents) to keep everything structured?

​I used to rely on Airtable for everything, but sometimes I feel like Claude + a simple spreadsheet is "lighter." However, I miss the relational power of Airtable when things get complex.

​What does your current stack look like? Are you ditching the database for the LLM, or merging them?

reddit.com
u/SnooPies9796 — 8 days ago

Title: Does Enterprise Plan help fix lag?

Hey everyone,

Our team is currently hitting a massive wall with Airtable performance and I’m trying to figure out if this is a pay to play problem or an architectural problem.

We’re on a Business plan. We have about 15 people using the base, currently sharing 4 seats (I know, I know) and the base has become almost unusable during peak hours.

So here are the symptoms:

* Automation Queue: During peak times, automations that should be instant are sitting in a "processing" line for up to an hour.

* Script Timeouts: Scripts that usually take 2-5 seconds are randomly hitting the 180s limit and failing during high-traffic windows.

* UI Lag: General "heaviness" when entering data or switching views.

Airtable pushes their "Enterprise Scale" and HyperDB as the solution for this, but is the "dedicated infrastructure" actually faster? Or are we just going to pay 5x the price to have the same scripts timeout on a slightly prettier dashboard?

For those who have been here:

  1. Did moving to Enterprise/HyperDB actually solve your automation execution speeds and script timeouts?

  2. Or did you find more success by offloading (e.g., moving scripts to Google Cloud Functions/Pipedream and using Airtable only as a UI)?

  3. How much did "modularizing" your base (Hub and Spoke model) actually help with the peak-time congestion?

We love the flexibility, but we’re reaching the point where the no-Code dream is starting to feel like a performance nightmare. Would love to hear some war stories before we sign a massive contract or start a 6-month migration to a SQL backend.

Thanks!

reddit.com
u/Agitated_Mud8409 — 7 days ago

Is there a shortkey for horizontal scrolling? The scrollbar is too narrow to grab n drag properly

I tried left/right arrows and the mouse scroll wheel, but they both don't work. Are there any other shortkeys aside of arrows to scroll horizontally if one has many field columns?

reddit.com
u/Cantuccini — 5 days ago

So, I came into this community to get some perspective on how realistic a no code approach would be and I am reading tons of terms I am not familiar with. Should I continue? My goal is to not be reliant on my current vendor and also get access to the participant data to enrich the athlete experience at my competition events. I do 2 events each year which attract 1000 athletes each.

reddit.com
u/YakTime8950 — 10 days ago

Got tired of paying $20 - 45/seat for collaborators who only update one status field a month. So I built RowRouter as the cheapest possible way to do it.

You paste a Personal Access Token (or OAuth), pick a base / table / fields, generate a per-row magic link, send it. The recipient gets a clean mobile form prefilled with the current values, edits, submits - change writes back to Airtable. They never create an account, they never see the rest of your base.

Single-use tokens by default. Field-level access controls (only what you allow is visible). Full audit log of every open and submit. Optional review-before-publish queue. AES-256-GCM at rest, hashed link tokens. Works for vendors, freelancers, customers, anyone external you don't want to pay a full Airtable seat for.

Free during the founding beta - 500 links/month while I figure out pricing. Founding users lock a discount off the launch price for two years.

Curious whether this maps to anyone else's pain or whether I just hated my own bill.

Not affiliated with Airtable. Built by one person, happy to take feedback.

rowrouter.com
u/igorvladyka — 6 days ago

Asking the community: which icon style best fits Airtable formulas / automations / scripts?

so basically i am upgrading that community project and adding support for writing Airtable Scripts and Automation Scripts straight from the IDE editor + AI client.

since these are local files, they need their own syntax, highlights, rules, and all that stuff. right now i'm stuck on the file formats and icons part.

this is what im thinking so far:

file type extension what it’s for
Airtable Script </> .s.at normal Airtable scripts
Airtable Automation Script⚡️ .as.at automation scripts
Airtable Formula (Fx) .f.at or .formula formulas

icons-wise, since there's no official icons or logos for these projects from airtable i've got a few styles mocked up (see screenshots). i'm kinda torn between (D) and (E) while (B) is good too, but ngl i don’t really trust my visual taste lol.

curious what you guys think fits better, or if there’s a totally different approach that makes more sense. just my 2 cents, feedback welcome until next release.

u/Aggravating_Bad4639 — 5 days ago

Hey All,

Just a general question. My job is weird, started out welding some frames for a friend, now I'm involved in Project Management and Business Development (something I have previous experience of but have been on the tools for 15 years). I find myself building a CRM/Project management database using Airtable.

This thing is looking pretty swish and testing has gone well so far, I'm probably 90% of the way there.

Got me wondering what it was cost out in the world for a tool of this type if my pal had to contract in the job?

I'm not fishing for a pay rise or new career! I've really enjoyed the change of scene and reduction in minor metal related injuries in my new temporary role.

Based in the UK but interested wherever you are from.

reddit.com
u/johnnynovo2118 — 7 days ago

How do you handle the “what changed this week” part?

I track everything in Airtable, tasks, deliverables, hours, but turning it into a client-facing weekly recap is still manual copy/paste into a doc. Curious if anyone’s automated the diff between this week and last week or if you all just write it from memory.

reddit.com
u/Broad-Draw109 — 12 days ago

I'm just working with chatgpt this morning and I see that the application is no longer available in the chatgpt interface. Is it only for me?

reddit.com
u/ppbarzin — 8 days ago

I'm using Airtable as an operations management system for a catering business. When a delivery is confirmed, it automatically sends a confirmation email to the client from our Google Workspace email address.

I've gone through a few iterations trying to get this working properly and keep hitting walls:

Airtable native Gmail integration - Works but strips HTML formatting, so emails arrive as plain text (or at least I couldn't get HTML rendering reliably).

Make.com with Gmail module - This worked well for most clients, but some Outlook users with stricter security settings were receiving the raw HTML code as plain text rather than a rendered email. My understanding is it was a MIME formatting issue where Outlook wasn't recognising the content type correctly and just dumping the HTML source.

Things I've explored since:

  • Twilio (our account is deactivated, don't want to create a new one)
  • Brevo (ran into IP/deliverability issues on the free plan)
  • Google Apps Script web app (seems like it could work but feels like a lot of overhead for what should be a simple send)

Has anyone solved this cleanly? Ideally I want something that:

  • Sends from our actual Google Workspace email
  • Supports proper HTML (we're using MJML-compiled templates)
  • Handles Outlook correctly with proper multipart MIME
  • Is either free or very low cost
  • Can be triggered via webhook or Airtable script automation

Open to suggestions, including whether Google Apps Script is actually simpler than I'm making it out to be.

reddit.com
u/hamz2361 — 11 days ago

Perhaps an unusual use case here!

I've been using Airtable for nearly a decade now, but for ONLY ONE, fairly straightforward purpose. I haven't needed to use any of the more advanced and interesting features before now.

I noticed a sample Table called "Novel Planning Template" and it REALLY got me thinking as I'm in the planning stages for a serious novel attempt!

I've been setting up a bunch of tables and so on, and even considering doing a large amount of the actual drafting inside Airtable.

What I was wondering is:

Is it possible to set up some kind of automation to pick up on things like character names (and nicknames) as I write scenes, and automatically link the "scene" record to those character records?

The character records would already exist, and I expect that I'd need to have a field somewhere for alternative versions (keywords) of the character's name(s).

Scenes would be their own records, with a long rich-text field, and a variety of linked record fields like characters, locations, important objects, and so on.

Some of those fields will always need to be manually linked - for instance when an important object is present but not mentioned in the scene text.

But it would be wonderful to take SOME of that manual work done for me!

[Free user]

[Website & app]

[not a fan of AI, but for something as small and "mechanical" as this, I'm willing to give it a chance]

reddit.com
u/Puzzleheaded-Phase70 — 7 days ago

I am using Deep Match (GPT-4.1 model) to auto-link records by reading the title of the current record. But it is taking forever. Is anyone else experiencing this?

reddit.com
u/ivan-ds — 14 days ago

If you use AI assistants with Airtable, the official MCP server only covers the public REST API - which doesn't expose a lot of the things you actually want automated (no view creation, no rollup/lookup/formula fields, no view config, etc.). airtable-user-mcp is a community add-on designed to run alongside the official one, it uses Airtable's internal API to fill the gaps. Your MCP client sees the union of both tool sets. here's the latest update changelog:

v2.4.1 — 16 new tools (52 total)

Sidebar sections (the thing that's been bugging everyone)

  • Create / rename / move / delete sections
  • One move_view_to_section tool covers four user actions: move-into-section, move-out-to-ungrouped, reorder-section, reorder-within-section
  • Destroying a non-empty section auto-promotes its views — no manual evacuation needed

One-shot view setupset_view_columns(viewId, visibleColumnIds, frozenColumnCount?)
Turns a brand-new view from "all 168 fields visible" to "just these 10 in this order" in a single call. Used to be 158 separate show/hide calls.

Non-grid view metadata

  • Kanban / Gallery: cover image field, fit vs crop, color rules
  • Calendar: date column ranges (single date or range, multiple overlays at once)
  • Cell wrap toggle, frozen-column divider position

Form metadata (legacy form views)
Description, redirect URL, "send me a copy" toggle, response attribution, branding removal, per-user email-on-submit notifications. Bundled into one set_form_metadata call.

Bug fixes (came from a real user report — agent hit walls building 13 views end-to-end)

  • isEmpty / isNotEmpty on text/formula/lookup/rollup fields no longer return cryptic 422s. Auto-rewritten to = / != "" client-side using the cached schema.
  • 3-level nested filter errors now explain the depth limit and recommend the flatten workaround
  • reorder_view_fields accepts partial maps (move one column without sending all 168)
  • manage_tools now tells the LLM exactly what's hidden by the active profile so destructive tools aren't invisible-by-omission

Repo: https://github.com/Automations-Project/VSCode-Airtable-Formula
npm: https://www.npmjs.com/package/airtable-user-mcp
VS Code extension: Nskha.airtable-formula (bundles the MCP + a dashboard)

Free, Local, MIT, not affiliated with Airtable.

>-------
>!Side note: I already did one for r/perplexity_ai you can also use it to do "research & Computer Agentic" to get content with A.I and fresh scrapped data to fill the airtable with 😉 Both MCPs built to unlock what their APIs can't do.!<

>>!check release note for perp: [Free/Open‑Source] Perplexity User MCP & VSCode Extension - boost coding with agentic search + agent‑to‑agent chat : r/perplexity_ai!<

>!and video showcase: [Video] Perplexity User - VS Code Extension with MCP Server (no API key required - use your personal account either it's Free/Pro/Max) : r/mcp!<

u/Aggravating_Bad4639 — 13 days ago

Come da titolo.

Ho costruito insieme al mio assistente virtuale 😅, un base per tenere traccia delle mie sigarette elettroniche , liquidi e resistenze in uso. Ho creato il tutto con circa 8 sigarette 8 magazxini resistenze e magazxino liquidi. Per far sì che tutto funzioni automaticamente Ho bisogno di campi rollup, lookup, link to e formula, da collegare tra i vari magazxini, sigarette. Con le automazioni ottengo:

Cambiocresistenza, resistenza in uso, data del cambio, stato della resistenza, scalo del magazzino, liquido in uso ben visibile.

Ora ogni volta che aggiungo una sigaretta, se ha resistenze diverse, devo creare tutti i campi e magazzino dedicati. Volevo usare le chiamate API e far creare tutto all AI. Non capisco però se non gli ho dato impasto le istruzioni giuste per usare e creare questi campi o è proprio un limite di Airtable.

Mi dite per favore se con lApi si possono creare campi:

Lookup

Rollup

Formula.

??

Vi mostro il mio lavoro.. non ridete ho conosciuto airtable un mese fa e sono una superprincipiante!

Grazie a chi vorrà darmi una mano a capire come fare.

u/Cautious_Potato_551 — 11 days ago

I got tired of manually updating Airtable, and I was building a custom tool that lets me send updates in normal English-speak to a bot via emails or text messages.

(It makes sure no data is overwritten or duplicated by doing fuzzy matching, checking for multiple matches, and then waiting for manual approval. It also links related records.)

Before sinking more time into this, I want to see if there's an easier way or if something already exists.

I have some people who want me to build a version for their Airtable and each one would need a custom setup since their Airtables are all set up differently. So maybe there's some more flexible thing out there.

I assume one can stitch this together with Zapier or n8n, but that also looks pretty hard. Has anyone seen tools that nail this, especially for texting / ccing & ensuring manual approval?

https://reddit.com/link/1t11g0g/video/drhyaeefdkyg1/player

reddit.com
u/Successful_Budget148 — 12 days ago