Ask the Community

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!

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

Hi everyone  I’m Adaugo.I work primarily with Airtable, helping teams streamline workflows using clean base design, automations, and tools like Softr, Make, and Zapier.I recently joined the community to learn from others, share what I know, and help troubleshoot real-world Airtable challenges. I’ve spent a lot of time building portals, document hubs, and automation-heavy setups, and I’m always interested in exchanging ideas or best practices.Looking forward to learning from you all and contributing where I can.

Hey all,I’ve hit a weird snag with one of my users and I’m not sure how to fix it. I have it set up where she has an interface and can create a new project with task templates that can be applied to it. There are a lot of different types of projects we do, so there’s around 6 different task templates.While setting this up and showing it to her (even in her view on the interface page), I was able to see and select all 6 templates. When she started sharing screen and showing me what was going on, 5 out of 6 of the templates said she was getting the message that she did not have the correct permissions to be able to apply them. I’m at a loss on how to fix this as she has editor permissions in the base and the interface, and I don’t remember setting permission levels for those templates in any way. So, any suggestions on what to do with this?Thank you!!

I’m designing a system for a client who produces enviromental survey reports They currently use Word, but non-technical staff keep breaking formatting and formulas. Of course it takes up a lot of time too because different people have to enter information they collected into the word document. What I need is:• Staff enter data via forms only • Calculations happen automatically• The report is generated as a branded, locked PDF• Users cannot edit layout or structure• Supports repeating sections (multiple findings per report) What is the best way to implement this in Airtable?Should this be done with Airtable alone, or via integrations (e.g. Docupilot, Make, Zapier), and what is the most robust architecture to prevent users from breaking templates?

I’m building a restaurant menu website (similar to a Culver-style menu) where all menu data—categories, item names, descriptions, prices, images, and availability flags—is stored in Airtable and fetched dynamically using the Airtable REST API. Each menu category (e.g., ButterBurgers, Frozen Custard, Drinks) is linked to a separate table, and the website consumes this data to render the full menu on the frontend. While the setup works correctly in most cases, I’m running into inconsistent behavior when retrieving records via the API.Specifically, some API responses return only partial data sets or miss linked records, even though those records are present and correctly linked inside Airtable. In certain cases, a category endpoint returns fewer items than expected, and refreshing or re-running the same API request sometimes returns a different result. I’ve verified that the API key, base ID, table names, and view filters are correct, and I’m not hitting documented rate limits.

Hi everyone 👋I’m an Automation Specialist working with Airtable and Make.com (Integromat).I help businesses:• Build scalable Airtable bases• Design and optimize Make.com automations• Integrate Airtable with Microsoft 365, Google Sheets, CRMs, and email systems• Replace manual processes with reliable, documented workflowsRecent experience includes:• Membership & renewal automation systems• CRM sync with WhatsApp and email workflows• Multi-step Make.com scenarios with error handling and loggingI’m currently available for:✔ Freelance projects✔ Long-term automation support✔ Remote contract workIf you’re looking for help or want to discuss a use case, feel free to reply here or send a DM.Thanks!