Ask the Community

I'm using Airtable's MCP server to let an AI agent (Claude Code) build and manage a base on my behalf — creating tables, fields, records, linked relationships, the works. The API is excellent for all of this. But I've hit what feels like a showstopper: there is no way to programmatically configure view sorting, filtering, grouping, field visibility, or field order.The result is that my AI agent creates a beautifully structured base with sequenced milestones, prioritised tasks, linked goals — and when I open Airtable, I see records in an arbitrary internal order that bears no relation to creation sequence or any other logic. Every view needs manual sort/filter configuration before the data is usable.I tried the obvious workaround of deleting and recreating records in the desired order. Doesn't work — the UI still displays them in an opaque internal order. I've added Sequence fields to every table so the correct order is encoded in the data, but there's no wa

I’m building up a base for my team. We have many workflows/processes that occur throughout the year and I want to track them, so our team stays on track and have ownership. I’m starting with one workflow but I’m running into an issue where my workflow tasks aren’t getting automated correctly when it runs for the month. My base is currently set up with People, Tasks, Projects, Process Templates (Where our workflows are held), Task Templates (where I would like the tasks that are associated with the processes held), Runs (when this workflow occurs), and then Workflow Tasks (where the team would edit and keep track of their tasks associated with this workflow).Two Things:1. When my automation runs, its supposed to populate all 7 tasks into the Workflow Tasks so that the team can start tracking them. However its only pulling up 1 out of the 7 tasks even though my Find Record is showing all 7 Tasks. I have it repeated and for it to create a r

Given the advent of tools like Claude Code / Codex are there any plans to expand API capabilities do allow more complete read and write?  It has been a long standing community request to allow creation and modification of lookup, rollup and formula fields. Additionally, many field attributes are not available (readable) via API.  I think the urgency on this is much higher now. Agentic coding currently require 1) manual extraction of the full schema data to give sufficient context to coding agents 2) manual human intervention to create key field types.This is going already beginning to affect the build (traditional database) vs buy (Airtable) decision. Both the development process and the long term maintenance process are moving to agentic AI, which at current, is not fully feasible with Airtable.   

Hi Airtable community! 👋I’m working on a base where I track projects and tasks. I have two tables:✅ Projects – one record per project✅ Tasks – linked to Projects (many tasks per project)In the Tasks table, I have a checkbox field called “Completed”. What I’d like to do is:➡️ When ALL tasks linked to a project are marked Completed, I want a field in the Projects table — like “All Tasks Done?” — to automatically update to checked.➡️ If even one linked task is not completed, then “All Tasks Done?” should remain unchecked.Right now, I’m trying to achieve this with: A rollup field in Projects that counts whether tasks are checked (ARRAYUNIQUE(values) or COUNTALL(values)), A f

Hi,We’re automating invoice creation, and need therefore to create payment reference numbers. I’d prefer to create these programmatically within Airtable.As a basis I wanted to use a autonumbering field we already have for creating unique IDs for the orders. Basically the base number will get an added checksum number, so that electronic banking systems can validate that the payer has entered the correct reference number.I found an Excel formula that creates the reference numbers according to our (Finland) banking standards (have tested, it works in Excel). I have been trying to convert it to Airtable, but I can’t get it to work.ORIGINAL:=IF(ISNUMBER(A2);(10*A2+RIGHT(10-RIGHT(7*MID(10000000000+A2;2;1)+1*MID(10000000000+A2;3;1)+3*MID(10000000000+A2;4;1)+(7*MID(10000000000+A2;5;1))+(1*MID(10000000000+A2;6;1))+(3*MID(10000000000+A2;7;1))+(7*MID(10000000000+A2;8;1))+(1*MID(10000000000+A2;9;1))+(3*MID(10000000000+A2;10;1))+(7*MID(100

Hi everyone! 👋I’m fairly new to Airtable and I’ve been trying to build a base where I can filter records based on values in a lookup field, but I can’t seem to get it working the way I want. I’ve read some community posts and tried a few different approaches, but I’m still stuck — so I thought I’d ask here for guidance. 😊Here’s what I’m trying to do:🔹 Base setup Table A: Projects – Contains project names and related client. Table B: Clients – Contains client details + a lookup field in Table A. In Table A, I have a lookup field that pulls the client industry from Table B. 🔹 GoalI want to filter Table A to only show projects where the client’s industry includes the word “Technology”.I’ve tried: Setting a view filter in Tabl

Hi Airtable community! 👋I’m working on a base where I need status updates in one table to automatically reflect in another table — and I’d love advice on the best way to build this.BackgroundI have two tables:📌 Projects Project Name Status (e.g., “Planning”, “In Progress”, “Completed”) 📌 Tasks Task Name Linked Project Task Status I want to automatically update the Project’s Status based on the status of its linked Tasks. For example: If all Tasks are “Completed”, set Project Status to Completed If any Task is “In Progress”, set Project Status to In Progress Otherwise, Project Status should remain Planning Right now I’m using rollups and

My kanban columns are not in order. How can I change them? I have a labelled order on the data table but this isn’t translating over in my interface kanban view.  

I am trying to create a google doc and populate it with data from airtable. The report pulls from a survey table and a linked responses table (~71 responses need to be organized into pillars and topics in the google doc). I have been trying a combination of automation and scripting or the scripting extension and google app scripts to generate the report. With every attempt so far, I have been blocked by 302 redirect errors. Has anyone been able to successful use the combination of app scripts and air table? I love it for the flexibility on formatting, but am not sure how to proceed. 

Hi everyone 👋I’ve recently started using Airtable to track my daily puzzle performance, specifically for Letter Boxed, and I’m trying to build a cleaner, more automated setup.Right now, I have a simple table with: Date Completion status Number of words used Time taken Notes It works fine, but I’d love to improve it a bit.Here’s what I’m hoping to do: Create an automatic daily reminder to log my results Generate a weekly performance summary (average words, success rate, etc.) Possibly visualize progress over time with charts Maybe even trigger a weekly email report I’m still learning Airtable’s automation and formula features, so I’m not sure what the most efficient structure would be. Should I use a separate “Weekly Stats” table with rollups? Or is there a sm

I am wondering if anyone else is experiencing this issue.  I am noticing that for the past few weeks it can take several minutes to query a view in Airtable using the API.  Is anyone else experiencing this issue, or was some recent change made to degrade service?  It’s been working great for years, and unfortunately I have to update the backend to use cached records in AWS instead of calling the Airtable API directly via the ‘pyairtable’ SDK. Just a lot of work that’s heading me down a migration path of removing Airtable from our stack, since the workaround is literally not to use the Airtable API, which means no Airtable, ultimately.

While testing automation with Airtable, the webpage froze. I closed the page and tried to re-access Airtable, but the homepage wouldn't load. I could access other pages besides the main page, but when I logged in, I saw the screen below. I tried using a different account, but the same thing happened.  

I found something that talked about 216px, but it keeps doing this. 

I get that you can upload a document to Superagent, but will it analyze all of the documents that are attached/uploaded to an Airtable database (i.e., so you don't have to upload them manually)?

Does right now form cannot upload attachments for read only/free users?errror says “You are not permitted to perform this operation”  

Hi Airtable Community! 👋I’ve been working on a small project where I use Airtable to track and analyze my daily Letter Boxed (NYT word puzzle) performance, and I’d love some advice on improving the structure and automations.🎯 What I’m Trying to DoI want to build a base that: Stores daily Letter Boxed puzzles (letters on each side) Logs the words I used to solve them Tracks number of words per solution (2-word solves, 3-word solves, etc.) Calculates average solve efficiency over time Identifies commonly reused word patterns 🗂 Current SetupI currently have:Table 1: Daily Puzzles Date Letters (long text field) Word Count (formula) Difficulty Rating (manual select) Table 2: Words Used Lin

I have a table where I’m recording goods sold off from our inventory with a checkbox and status change. When I change the dropdown to `Sold` or `Donated` - I want to be able to :  Copy certain columns from one table to another (in the same base) Request certain fields to be completed (sale receipt upload, sale price added, etc)Is that at all possible in Airtable? 

Looks like I’m one of the first to do get into it on Superagent. lol I am creating an in depth product training for a beauty brand w/Superagent. I can’t seem to get it to use actual images of the products though, it keeps creating (rather terrible) ones. Is there a way to do this? Or edit by hand?

I’m building two workflows in Airtable, Workflow A and Workflow B.Workflow A includes Task 1, Task 2, and Task 3. Workflow B includes Task 4, Task 5, and Task 6.Task 3 in Workflow A cannot begin until Task 2 in Workflow A is completed and Tasks 4 and 5 from Workflow B are also completed.What’s the best way to set up Airtable so I can track cross‑workflow task dependencies like this? These two Workflow’s overlap with eachother so is there a way I can set up like Status’s for each task that when one task is blocked until xyz tasks are marked as completed?

I am trying to figure out how to show growth of a set of records over time, cumulatively. I have created a column in my table that shows the date of when each new record was added, but when I try to graph that in Interfaces, it seems to only let me show to total number of records added in each given month, I can’t figure out how to make a chart that shows the new monthly total added to the previous monthly total to give cumulative growth over the course of the year. I have found a few previous help questions that were similar, but it seems like no one really got an answer. Is this impossible in Airtable?

Hi to anyone so grateful.I gone through every setting and cannot change the setting so I canadd a record/bottom row or duplicate because its says "you cannot create a new record because it is configured that no one can add a new record? with a lock sign in the bottom left.I have tried unsynching, changing permissions and checked the plan but no luck at all.Any step by step ideas are so welcome?Thanks

I built a fairly complex Airtable architecture about 12 months ago. Since then, both our operational model and my own Airtable knowledge have evolved significantly.I now want to redesign parts of the structure, including primary fields, relationships, automations, AI usage, and reducing manual inputs, so it’s more scalable and aligned with how we operate today. This means that filtering by year or creating views won’t be a viable solution as would break the data schema needed for the old data and built metrics to work.The challenge is that I have 12+ months of historic data that’s critical for KPIs, forecasting, and performance tracking. I don’t want to lose that history, but I’d like to effectively “start fresh” in 2026 with a cleaner structure focused only on new data.Additional considerations: I need to ensure the archive and the live 2026 base are not structurally connected, changes in one must not affect the other. The build

Hi everyone — quick question about Airtable’s native Google Drive sync feature.We use a synced Google Drive table that should refresh automatically about every ~5 minutes. Occasionally, the sync fails or disconnects, but Airtable seems to only surface this through the UI (banner/error state), not through any automation trigger or field.Goal: Send a Slack alert when the sync itself fails at the table level (not tied to individual record changes).Is there any native way to monitor Google Drive sync health or detect sync failures via automations? Or do most teams handle this with a workaround like heartbeat/staleness checks or external monitoring?If this isn’t currently supported, I’d be happy to submit it as a feature request — just want to confirm best practices first.Thanks in advance for any guidance!

Hello, good afternoon.I’m reaching out urgently with this question because I still haven’t received a response from support. In one of our dashboards, we have uploaded files that we share with clients, but for the past 2 days all the file links have been returning an error when downloading.The message we get is directly:“Check if there is a typo in s3.dualstack.us-east-1.amazonaws.com.If it is spelled correctly, try running the Windows Network Diagnostics.DNS_PROBE_FINISHED_NXDOMAIN”Has this happened to anyone else?

Hi, I’m new to Airtable and looking to build a database that holds multiple certificates with obtained dates and expiry dates. Is it possible to set one table with all the types of certificates and then link another table with the employee details so that they all end up with a list of different certificates or will I have to enter a whole heap of individual records? I will be use Softr as the app. Thanks for any advice, I havent found a template that does the trick.