Ask the Community

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! 

Hi everyone!I’ve been experimenting with Airtable as a way to organize and share daily word puzzles inspired by the NYT game Letter Boxed. The idea is to create a base where: each day’s puzzle layout is stored, community submissions (solutions) are logged, performance (time/words/points) can be tracked, and users can filter or sort challenges by difficulty or date. So far it’s been really helpful for keeping everything structured and allowing others to contribute solutions easily.A couple of things I’ve set up in the base: Grid view for daily puzzles with letter sets and status Form view so players can submit solutions Leaderboard view sorted by points or speed I’m curious how others here might use Airtable for game-like engagement, daily cha

Hi everyone!I’ve been experimenting with Airtable as a way to organize and share daily word puzzles inspired by the NYT game Letter Boxed. The idea is to create a base where: each day’s puzzle layout is stored, community submissions (solutions) are logged, performance (time/words/points) can be tracked, and users can filter or sort challenges by difficulty or date. So far it’s been really helpful for keeping everything structured and allowing others to contribute solutions easily.A couple of things I’ve set up in the base: Grid view for daily puzzles with letter sets and status Form view so players can submit solutions Leaderboard view sorted by points or speed I’m curious how others here might use Airtable for game-like engagement, daily cha

We use Airtable to manage trailer rentals and insurance compliance. Customers periodically upload updated Certificates of Insurance (COIs), and we need to retain all past COIs for audit and compliance purposes. The issue is that Airtable automations overwrite attachment fields when updating records. When a new COI is uploaded, it replaces the previous file, which causes us to lose historical documents.What we want is for a “Misc Attachments” field to act as an archive, where: Any new file added to the COI field is copied into Misc Attachments Existing files in Misc Attachments are preserved No previously uploaded documents are deleted Requirements: Both fields are attachment fields in the same table The process should be automatic (triggered when a COI is added) The archive m

Hello Airtable Community,I am currently exploring ways to enhance our workflow by integrating Airtable with Microsoft Copilot. My goal is to be able to ask questions related to our Airtable data directly within Microsoft Copilot, which already has access to our other business files like emails and documents.Use Case: We use Airtable extensively for managing various aspects of our business. Having the ability to query Airtable data directly in Microsoft Copilot would streamline our processes significantly. For example, I would like to be able to ask questions such as "What are the latest updates on table x".Questions:Has anyone successfully integrated Airtable with Microsoft Copilot for similar use cases?What are the best practices or tools (e.g., APIs, automation platforms) to achieve this integration?Are there any specific challenges or limitations I should be aware of when settin

Hi Everyone, I'm Meenu Hinduja and my husband Dheeraj Sudan, run a business. I’m running into automation errors in my Airtable base. Could you please share your suggestions on how to troubleshoot and fix them?RegardsDheeraj Sudan and Meenu Hinduja