Ask the Community

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. 

For some people grouped view is cutting off data displayed.  Not a browser issue - has anyone else seen this?  See last few rows  

I have a main database that stores all the data for my company that is collected from various sources (team member input or customer input but all data is entered through forms) and I need help ideally preventing the input of duplicate records, or at the minimum flagging/alerting the person entering the data that a record already exists.To simplify - For my team member forms:Is there a way I can have a script or automation check existing records for matching ‘Project Name’, ‘Customer Name’, and/or ‘Customer Email’ and if any of these exist already, allow them to update/edit the record. Or, if it does not exist, they can create a new one. If there is no ability available to to stop/alert them while they are creating, can an automation be used to send an email after the form is submitted alerting them that it was a duplicate so they can go in a fix it?For the forms being filled out by the customer:Same as #2 above,

Airtable novice here. I hired a consultant to build an app to track assignments for my company (organized by client contracts). The consultant never really finished the job but the app is about 90% useful however, it’s populated with assignments from a closed contract. Is it possible for me to copy the structure of this app without copying all the inputs? The tables, views, automations and interfaces are good but I need to update the data to reflect the current contract (different pricing schedule, assignments, vendors, etc.)

I can’t see a way to do this so presume I am missing something. So here I need to see the average value of a call booked which is different than the avg cash collected per closed call. I want to see Total cash collected divided by total calls booked. How can I make this show on an interface?I think its a bit bonkers you can’t just do a simple sum on an interface with the figures of that interface. Am I missing something or is this actually not possible? Help much appreciated. Cheers 

I’ve been trying to achieve a simple thing. I want to have Table 1 as database where i can store people information like Name, Personal ID, etc. And I want to import selected information from Table 1 to Table 2. It should autofill and whenever i add a new person into Table 1(the database) it should reflect in Table 2 as well. HOW do i achieve that. So far i’ve tried linked records but then i have to manually press on every single person to import their information. Please help an ignorant soul.Example:Table 1 has people personal IDs i want to fill in Table 2 based on these IDs automatically

I am developing a college course and want to have students build an airtable that curates all higher education programs for students with disabilities. Is that possible?

Hi everyone,I'm tracking daily ad performance data (Meta Ads) in Airtable and displaying it in an Interface. Each row represents one day for one ad set, containing raw metrics like Spend, Impressions, Clicks, and Conversions. The problem:I need to display metrics like CPM, CPC, and CTR for flexible date ranges (sometimes 2 days, sometimes 70 days, always varying). However, Airtable Interfaces only offer "Average" as an aggregation option, which gives mathematically incorrect results for these metrics.For example: The correct CPM for a period should be (Total Spend / Total Impressions) × 1000, not the average of daily CPMs.What I've tried:I can display "Sum" for Spend and "Sum" for Impressions separately, but there's no way to divide these two aggregated values within the Interface to get the correct CPM.My question:Is there any native Airtable workaround to calculate form

Hello everyone,I’m running a website that relies heavily on the Airtable API to manage and sync dynamic content such as product data, categories, and status updates. Recently, I’ve started facing inconsistent behavior when making API requests from my website to Airtable, and I’m struggling to identify the root cause.In some cases, API calls that previously worked without issue are now returning partial data, delayed responses, or unexpected empty fields, even though the records clearly exist in the base. Other times, the same endpoint works correctly on a manual test (using tools like Postman), but fails or behaves differently when called from the live website environment. This incon

Hi, I’m another newbie that’s too inexperienced with Airtable to find what I need in this forum. I have tried and tried to solve a problem I have but with no success so I wonder if anyone who knows Airtable well could help me please?I have managed to set up 1 master table and 3 other tables that have data related to the master table. All tables have a common record. I am trying to link the tables, as you would do for example in a relational database like Micrsoft Access, in order to create a view where for each line of data I choose/expand in the master table, the related data from the other 3 tables is also displayed. I just can’t get this to workI suppose the problem might be in the way I have tried to link the tables together?If anyone could spell out in very simple terms what I need to do to sort this out, I’d be very grateful. Thanks 

The last discussion about this I found was from 2023 when it was initially implemented.I have a couple airtable embeds in Squarespace. They have been working fine for several months. All of a sudden today, every time the embed is viewed, I get the Cookie Popup. Every single time. Clicking X or accepting doesn’t make any difference.I’m not sure why this has started up after months. Has Airtable addressed the implementation? Can I either turn it off or at least once the popup has been answered make sure it doesn’t activate every single time the page opens?

Is there a way to wrap the text in a filed name?

I have an Automation that sends an email when conditions are met that includes Update Record link for Fillout. However the link is emailed as a text field - e.g.  https://forms.fillout.com/t/zzzz?id=xxxxHow do I modify so it sends as a clickable link.I have tried  "<a href='" & {Your Formula URL} & "'>Open link</a>"  and it did not work. 

As recently as a few days ago, Airtable’s What’s New page let us know the new features that Airtable was adding but now the page shows a 404? You can still find the base here, updated as recently as this month (February ‘26) here, but hopefully that base keeps getting updates?

I have been trying several Airtable alternatives to try to build my app stack options to select from and commit to build my first initial version of a functional app.During the Airtable’s free Teams trial period, I came to realization that there are additional, especially 3rd party forms & automation, applications are required to build a functional & manageable application based on Airtable.I’m just a start up. No special category like .edu, non-profit, etc.I cannot provide any verifications because I have not focused on social profiles & not willing to t provide any official documentation at this moment.AI answers were that there are no discount codes to apply at a checkout and were not able find any discount links, including from utube creators.As with any startup, any discount helps. Thank you in advance.

Im problem solving some workflow issues and finding that lots of lookup fields are not populating data for the vast majority of records. From what i can tell its only populating data for about 1000 records foir each of the fields i checked thus far. I also happened to notice that base views now have a new “showing the first 1000 records of XXXX. Load All Projects” warning/button combo at bottom of screen. Perhaps it is tied to this? This is critical malfunction for our system … hoping someone has a solve here?

Hey all. I have a client to which I am creating some template tasks.  The problem I am facing is that.When the client changes its status, I need to create x amount of tasks. Example attached. I have an automation that adds another relation to Client-Tasks that displays the immediate next task So client has 2 relations to tasks. One to all tasks, one to just the next task, which uses the field.Next task for search to find the right taskThe problem I have is that after my automation creates the template tasks it sort them randomly 

my company and i are interested in upgrading to enterprise and tried to get in contact with their online form to set up a meeting, but still haven’t gotten a reply back. is there another way to contact them? do they have a phone number i can call?

I would like to start off by saying that I have been researching, watching how-to’s and reading the forum for a few weeks now trying to wrap my mind around this issue and I am humbly asking for a hand with this issue I know can be solved (but not by me, apparently) Attaching a diagram to hopefully give the jist of how my current base is laid out. It’s more complicated but this illustrates what I’m struggling with. I am a chef, working on a tool for our restaurant to track costs and recipe development trial and error. I have three tables set up - one for ingredients (has metrics like cost, case size, purveyor, etc). Then there’s an Inventory table, which is effectively looking up ingredients and attaching additional attributes like whether or not something is ‘on hand’ or whether it’s been prepared in one way or another. These r

Hi!Is there any way to create collapsible sections or groups in Airtable Interfaces when building one from scratch?We’d like to keep the interface clean, while still having access to additional or less frequently used fields when needed.If this isn’t supported natively, does anyone have a good workaround?Thanks!

I reviewed the following related topic but would like to do a quick check to make sure I’m on the right track…I work in natural resources but essentially have an inventory type question. I have locations (preserves) with sub-locations that I am tracking inventory from (both receiving and outgoing). I am still building my base and recently realized that I should probably move the locations into its own because multiple tables/records are related to the location AND it’s a bit more complex than a short list of 5 items. As I started building the location (preserve) table, the problem of sub locations came up. I’ve included a couple screenshots of how I have it setup at the moment. Does this look okay from a design/structure standpoint? Ultimately I will have seeds coming from these locations and plants going back to the same or different locations. 

Hi everyone,Looking for real-world experience / benchmarks from folks running large Airtable bases.I’m currently redesigning our team’s base. We’re at ~330k records today (hard limit is 500k) and we’re already seeing performance issues (slow loads, sluggish automations/scripts at peak times, recalculation lag, etc.). Our first version was built to meet immediate needs, and we’re now rebuilding with a more best-practice / scalable approach.Airtable Support mentioned (and we’re also observing) that even with ~170k record “headroom,” the base can still struggle well before 500k depending on schema + computation complexity. We suspect a big contributor is heavy rollups / formulas / long calculation chains across linked records.What we’re considering / already doing: Reducing rollups + nested formulas, especially ones that fan out across many li

Hi everyone 👋I’m trying to use Automations → “Generate structured data” to extract structured data from a file that’s attached to a record (e.g., CSV / PDF / image). My automation is simple: When a form is submitted → Generate structured data.The confusing part: when I select the Attachments field as the input, Airtable only lets me choose attachment properties like URL / Filename / Size / Type / Attachment Viewer URL / Expiring Download URL (see screenshot). It’s not clear to me whether the model can actually read the file contents, or if it can only see metadata/links.My questions: Is it possible for “Generate structured data” to ingest an attachment and parse its contents (e.g., read a CSV and ou