Ask the Community

Hi all,I'm excited about the new Deep Matching functionality in AI Labs, but I haven’t been able to get any results yet. Here’s what I’ve tried so far: Tested with both large live tables (10k–50k records) and small test tables (10 records) Used conditional filtering to narrow results down to a single expected record Tried multiple models (GPT-4.1 Mini, GPT-5 Mini, GPT-5) Has anyone been able to get results successfully? If so, I’d love to hear what worked for you.Thanks!

Hi, We’re currently running our business using a software package called Squeegee, but we’ve reached the point where it doesn’t allow us to scale effectively. We’re now looking to build stronger internal systems using Airtable and modern automation tools. The goal is to move away from software limitations and create structured, scalable processes that automate individual tasks wherever possible. At this stage, we’d really value an initial phone call to discuss requirements and explore whether there’s a good fit. Ultimately, we’re looking to build a long-term relationship with the right person, ideally on a retainer basis, where work can be carried out as and when required. If this sounds of interest, please let me know your availability for a short call to understand our requirements and a brief overview of your experience with similar system builds. Kind regards,David Halford 

I keep getting this message and ive done this same thing a bunch of times before: {{Make sure you enabled the following scopes for your token:data.records:readdata.records:writeschema.bases:read}}  Its kind of hard to miss these exact words while comparing them slowly  to ensure accuracy. It just wont attach the scopes to my api token. Im not sure what in missing and i should not be missing anything, its pretty simple to do as ive done before so what changed now when i have changed nothing?

I own a small business with a limited budget. I’m looking a company that can help me build out a Airtable for my small business. 

Hello! I am a new AirTable user and have spent over 30 hours trying to build a worksheet generator for my classes. Since I don’t quite know how AirTable works, Chat GPT has been walking me through all of the steps. But … it isn’t working and after 30 hours I’m feeling like I should give up. Would anyone be willing to take a look at it and help me?

I’ve been building an app through the free trial and have hit a snag. I’m aware Airtable won’t let you create new Linked Records in a form. Fillout doesn’t have the capacity for a price my boss is willing to pay. I’ve been using Gemini quite a bit which has been helpful, and they suggested something that would work but I wanted your opinion (Confidently incorrect AI’s and all that). My tables in question are “Customers” which can have many “Locations” and “Contacts”. Locations can have many “Jobs”. If I create a job and the customer doesn’t exist, I have to leave to make the customer, only to remember that I don’t have the contact or location, so I have to leave and do those, repeat ad-nauseum. Gemini’s suggestion is to create a master intake table. For the customer, I could select from a dropdown (as usual), but if it’s a new customer, I would fill in new fields for the customer information. Repeat with Location, Contacts, and the Job details. Then use automation to parse the data and

I am traying to do the code scanning. In normal code development work flow we do the code scanning for vulnerability or exposed API keys. Is it possible in the airtable

As you can see below, I want to know if the users can comment with text and attachments, because I saw on the dropdown list for choosing the displaying options. I wonder if the users can comment with text and Attachments as proof or something else, it would be beneficial. 

I’m working on an interface page with the list template. One of the fields I’m trying to display in the list is date. I noticed the field had more margin than it needed so I looked for a divider and found what looked like a divider to drag it over to make it more narrow but when I clicked it actually added more width, I tried a gain and it added even more width where the date is now the only visible field and I have to scroll over just to see the other fields in my list. I can’t seem to find any way to make it shorter or even just go back to it’s original width. Could someone please help explain what I’m doing wrong and the correct way to adjust field width in the list interface template? 

Hi, I am looking for help with dates and quarters - we have several date fields across multiple tables that currently use each a LONG formula to calculate fiscal quarters (with specific start and end dates, not just first/last day of the month). I am hoping to find a way to use a table with start/end dates to populate the quarter fields in these other tables. I don’t want to use linked records, I think that would be too difficult to manage given our volume of data. I don’t think I can do it with a formula because I need information from separate tables. Is there a way to do this with an automation? Something like...when X date field is updated, find value from Y table?Thanks for your advice!

We have a master base “template” created with all of the usual requests from a client and different bases per campaign. How can we duplicate a table from the master template to a campaign base with including the formulas? It works when you sync and unsync but somehow when duplicating the formulas are lost. Is there a work around?

I have a text field which I’m manually populating with UUIDv7s. This string is time-ordered by the first sequence of characters.When sorting A-Z on this column, I’d expect that to happen. It isn’t. These two entries sort in this order. 019c607b-60d7-72dd-b925-f76680dae347 019c6051-5b66-7586-85b8-c54c63dbf350What am I missing?

My Airtable usage dashboard shows 881/1,000 API calls, but my third-party connection (Softr) is already returning an 'Exceeded Limit' error. Does Airtable trigger this error before the 1,000 limit is officially reached, or is there a delay in the dashboard reporting my real-time usage?

Hi, everyone! For the last 24 hours, I haven’t been able to download CSV files from any of my bases. I’ve tried in the app (on Mac and Windows), and in multiple browsers. Although I see the “preparing CSV file for download” popup, no file is downloaded. Anyone else experiencing this issue, or have a workaround? (UPDATE: it appears it is specific to my workplace, as I can download files from my home network. Anyone have such an issue with their IT setup blocking Airtable downloads?)Thanks in advance, Carole

Good afternoon, I have a database with a number of different membership categories - e.g. Partner, Society, PAHH - and have set up automations to pass the membership details to generate either a form letter (via MAKE) or email (native Airtable) as a reminder that the membership is due. At the moment, I have multiple automations for each membership category for each of the 4 letters required. This is unwieldy, and there is a lot of scope for mistakes with so many automations and webhooks.All the 4 letters for each membership category are the same, other than the partnership category. I cannot work out how to have just one set of automations for these letters which passes the membership category to either the email or MAKE to personalise them. The problem is that some members are in more than one category, so I cannot, for example, use the membership field as there may be “Partner” and “PAHH” in that field, and I only want the reminder to be sent for one category.Ideally, when the button

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 way to tell a view to sort by t

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 record but it only does one. How can I fix this?I

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 formula field to decide if all tasks are completed. But I’m stuck on getting the formula right so that it reliably returns TRUE/FALSE without manual intervention.Here’s what I’m currently using in the rollup and formula:📌 Rollup (Tasks → Completed):values📌 Formula (Projects):IF({Completed Count} = {Total Task Count}

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(10000000000+A2;11;1));1);1));"") Identified change needs:cell

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 Table A → Lookup Industry contains “Technology” Creating a formula field referencing the lookup Adding a rollup field But none of these filters ever show the expected records when I test it. I suspect I might be misunderstanding how lookup values behave in fil

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 a formula field, but I’m wondering if there’s a cleaner or more reliable approach — especially when tasks are added or changed frequently.Specific Questions Rollup + Formula strategy: Is using a rollup of Task Statuses with a conditional formula the best practice for this? Automations: Would a script in Airtable Automations perform this m

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 smarter way using formulas + grouped views?Would really appreciate any suggestions on table structure or automation flow 🙏Thanks in advance!