Ask the Community

Anybody has tips on how to do that? I have a long text field (cca. 1000-2000 characters including spaces). Beside that another field showing keywords, usually not more than 10-15 keywords. These keywords are typed in through Google API and edited by me manually. These can be keywords (or better say key phrases) are separated by comma. These are the words (phrases) I want to make sure I have them in my long text field in sufficient number of times. I am looking for a way to calculate the keyword density, that is how often do the keywords (the words in the keyword field) appear in the long text field. I do not need to see individual count, sufficient is to have summary count - number of times any keyword appears in the long text. The density count will give me a percentage = number of total keywords(phrases) / total words in the long text I looked at this suggestion here but it seems to me Airtable database would explode if I start generating a tag (which seems to me is essentially a

I am an Airtable First-Timer and am having a really hard time understanding how to build what I want. I think Airtable is the solution, but I’m just an idiot. I own a small business and need help creating a Food Ordering and Management System. I have a project scope, our current SOP to share if someone would help me build it or I would happily pay someone to build this for me! Can you please message me back if you’re interested? Thank you!

Hello Airtable Community,I’m working on an integration where we need to detect if someone updates any field in a Form View (e.g., adds/removes/hides fields). I’ve explored the Airtable Metadata API, specifically the endpoint: bashCopyEditGET https://api.airtable.com/v0/meta/bases/{baseId}/views While this API returns the list of views, including forms, it doesn’t seem to provide: A timestamp or audit log of when a form was last modified Information on which specific fields were updated or reordered Any versioning or update tracking for forms Questions: Is there any way (via API or otherwise) to determine if a Form View’s field configuration has been changed (e.g., which fields are visible/required/ordered)? Can we track when a particular Form View was last updated? Is there a webhook or event system available for view updates? Any guidance or workarounds would be greatly appreciated.

Hi Airtable team 👋  I'm building a master fulfilment dashboard using Interface Designer, based on a table (Partner KPI's) where each record represents daily performance data per partner.One of the most important metrics I want to track is:Cost per Scheduled Consultation = Ad Spend / Number of Consultations ScheduledRight now, this is calculated per day via a formula field on each record. ❌ Problem 1: The dashboard shows an average of the per-record ratiosWhen I display this KPI on an interface, Airtable averages the daily cost-per-consultation values instead of calculating:Total Ad Spend for selected period / Total Scheduled Consultations for selected periodThis leads to completely misleading values, especially if some days have very few or zero consultations, which massively skews the average. ❌ Problem 2: No support for weighted averages or cross-record ratio KPIsI need to be able to calculate:SUM(Ad Spend) / SUM(Consultations Scheduled)...for a given partner and time period filter

Hello everyone,I’m trying to replicate a process I set up a year ago that is working well.  I have a formula that opens a form for a responses table that automatically links it to the main table.  The formula uses the form address and prefill, with the record id of the main table record.  When I open one of those links it works perfectly. It is not editable, but shows the linked record information.I’m trying to replicate it on a new base, but the same prefill option isn’t bringing up anything unless I make the group editable and then anyone with the form would be able to see all our records. Here are the differences I can spot, but I don’t know how to make them match:In my working form I see this in the group settingsThe line “some fields are editable...” doesn’t show in my new form. The other difference is that the new form gives me this warning under Rules, which is not present in my working form, but I think that’s because I had create a filter in the past. Any thoughts on what I mi

Hi everyone! I'm looking for advice on the best way to structure Airtable for my program and project management needs. Should I use one base or split it into multiple bases? Are there any training resources or templates you'd recommend instead of building from scratch?What I'm Managing: I oversee a year-long program with multiple projects that launch each quarter. I need to track everything at both the program and project levels.Program-Level Requirements:Annual roadmap showing all projects by quarter OKR tracking that connects to relevant projects Capacity planning across all projects Status reporting with different views for various stakeholders Risk visibility across all projects Intake form for new project requests into the programProject-Level Requirements:Task management and tracking Task-level status reporting Individual project risk tracking Project capacity planningI'm trying to figure out the best way to link everything together so I can roll up project data to the program le

Hi, I would like to copy a table (a specific view) to paste it into a table format into an email, but I can’t seem to figure it out. It seems that if I were to copy the records in an AirTable, it just converts into plain text when I paste it into email, instead of a tabular format. I tried a bunch of different ways, but the only way that ended up working was downloading into csv, applying borders to my table in csv, and then pasting it into Gmail. Surely there is a better/faster way to do this? Hoping someone could help here!

When working with building automation systems outside of Airtable, a lot of use cases involve taking actions on Airtable data. These are currently done via custom Airtable API calls and actions that require a lot of configuration. They’re difficult to set up, maintain, get right, and scale.It would be a huge advancement if, instead of hooking up all those API calls and configurations ourselves, we could just provide our base and table and provide our request to Airtable Omni via the API and let it do the agentic work on our data.For example, the automation might look something like:ClickUp trigger > Airtable > Airtable Query: “Look through user feedback data in table X in base Y and provide a summary report of the 3 most important areas of improvement according to Z criteria” > Upload the PDF and upload to Microsoft OneDrive.”The parts in bold is where it would be very helpful to simply provide that as a query to Airtable’s AI/Omni via API.If not via the API, is it possible to

bonjour la communauté, la nouvelle mise à jour des champs de formule permet des sorties à sélection unique pour les champs de formule. J'ai un champs ou est concaténé plusieurs informations incluant une sélection unique. J'ai testé cette nouvelle fonctionnalité et apparaît la sélection unique en couleur, mais les autres informations concaténer n'apparaissent plus.merci de votre retour 😉

I have an email automation set up so that when an attachment is added to a field, an email is triggered to a project manager with a copy of that attachment.Currently, we delete the old attachments before dropping a new one in so you do not receive multiple attachments with the email that gets triggered.Now with the new Versions feature, I want to keep the old attachments in the field but only have the latest attachment added to the email. Is there any way to limit the attachment field in the email automation to only the latest one that was added?

I’m clicking and holding on a field to move the fields into a different order on my interface but it won’t move.

Hello, I am wondering if I stumbled upon a bug, or if this is a setup error or limitation of some kind: I have a dashboard interface with a pivot table, and while it looks great on desktop, it shows up on the mobile view, but missing some key elements - the labels for all columns and rows display as “(Empty)” even though on desktop those values show up just fine. Any ideas why that is?  My only guess is that maybe it’s because the fields I’ve chosen are not supported somehow? I’m using a lookup of a single-select value, maybe that’s the issue? Any ideas or fixes welcome. Thanks so much!  

Is anyone else having this experience? The new UI (besides for being a steep learning curve) is loading base and interfaces really slowly???Best part of AT was the instant response….

Dear Airtable Community,I am refining a project management base, established in June 2025, to streamline task tracking for a small marketing team using Airtable’s Professional plan. While the base effectively organizes tasks, I seek to optimize automations to sync status updates across linked tables efficiently. Your expertise in this area would be greatly valued.My base comprises three tables: “Projects,” “Tasks,” and “Team Members,” structured per the Airtable project management template (https://www.airtable.com/templates/). The “Tasks” table links to “Projects” and “Team Members” via linked record fields, tracking approximately 200 tasks for 10 projects and 5 team members.I configured an automation in the Airtable Automations panel to update a task’s status in the “Projects” table when its corresponding record in “Tasks” changes to “Completed.” The automation uses a “When a record is updated” trigger and an “Update record” action, referencing the linked project record.However, duri

Hi, can someone please help with my formula? I’d like to calculate the number of days between two dates, but if the dates are the same then they should display 0. The formula below works to show the ones with the same date as 0, however it then shows the ones with different dates as being one figure too little. DATETIME_DIFF(  {Post Sale Date},  {Auction Date/Time (Local)},  'days') To fix this I added +1 to the formula, which of course, solves the latter issue but not the issue for same dates need to show 0. DATETIME_DIFF(  {Post Sale Date},  {Auction Date/Time (Local)},  'days') +1 Can someone please assist 😊

Bonjour à tous,Je suis tout nouveau sur Airtable et je découvre petit à petit l’outil, que je trouve vraiment intéressant.J’aurais besoin de votre aide pour un point précis : j’ai une base dans laquelle j’ai déjà enregistré plusieurs prix de vente, et je voudrais faire la somme totale de ces prix.Je ne sais pas encore comment m’y prendre correctement. Pouvez-vous m’indiquer la méthode la plus simple pour faire ce calcul dans Airtable ?Merci d’avance pour votre aide précieuse !Bien cordialement,

 This is an Opt-in / Reference Check form:https://airtable.com/appDms8x0QIhxU2F5/pagg3esZJjn6ytUSK/form For some reason, its no longer clickable.. you can’t type on any field. I already made a dupe and its still the same. I tried to revert to yesterday’s version and the old form worked. But Im trying to find out the difference on the settings and visibility, there’s no difference. Im just confused.. another problem is that we sent out this form to plenty of people already that doesnt work.. Can anyone help me please?

Hello!In the data layer, I can no longer find how to toggle on the setting to view other user’s Personal Views. There used to be a gear icon to the right of “Find a View”, however, I can no longer find it or figure out how to toggle this setting on/off.Can someone please help?Thanks!Sarah

Hi - I am trying to create a field with unique hyperlinks that can be used in an interface (we don’t want a button or field that has a static name for every record).I want to use the {link to content} field for the URL, and the {content title} for the display.I am having trouble figuring this out, but I am sure there is a way to do it.I would appreciate any help.Thanks!

Hi all, this might sound trivial but we are having an issue with Airtable opening on an old base instead of our newest one.  The old base is called Jan 2025 and the newest one, which we are working from, is June 2025. Previously, whichever base we closed the app, logged out or closed the browser on, was the same base Airtable opened on next time.Since creating the June 2025 base, Airtable always opens on the old Jan 2025 base. It’s happening for each user who logs in so it’s a universal thing. We’ve deleted the cookies, logged out properly, logged in again but no joy.I’ve tried searching but can’t find an answer. Any ideas please anyone?

I'm working with a database structure that has three tables: Publications, Artworks, and Individuals. I'm running into an issue with a Rollup field and hoping someone can help me find a solution.My Table Structure:Artworks table: Has a field that references one or more Individuals Publications table: Has a field that references one or more Artworks Publications table: I want to create a Rollup field that shows all Individuals associated with the Artworks in each PublicationThe Problem:When I use a Rollup field with an ARRAYUNIQUE() formula to get the individuals associated with the artworks, I'm getting unexpected results.For example, if a Publication contains 10 Artworks, and each Artwork has 1, 2, or 3 associated Individuals (sometimes different ones), the Rollup field returns each combination of individuals rather than each individual individually.What I Want:I want the Rollup to return each unique Individual associated with any of the Artworks in the Publication, not the combinatio

Hi! I have some pivots in Excel that I’m attempting to re-create in Airtable. It has multi-level categories in the rows (Region, Country) and then 4 different metrics that I convert to a %. (In Progress, Successfully Completed, Previous Week Successfully Completed, and Increase Amount) I have all of the line-detailed data that you’d need to get this in Excel (Record ID, Region, Country, and binary 1/0 for In Progress, Successfully Completed, Previous Week Successfully Completed, and Increase Amount.)  I cannot for the life of me figure out how to replicate this in Airtable and then add it to an interface. The closest I’ve been able to get is a grouped view of the data that I show as a grid and then removing the “0”s and changing the values of those metrics to be % Filled. This is almost fine, but it doesn’t stay grouped and expands too much. Is there a better way to do this?  

Hi! Does anyone know a trick about how to get the email of a user, that filled a form with a “Restrict access to an email domain” activated? When this feature is on, the user must sign up and login into AirTable to fill the form. If the user’s email domain belongs to the one accepted at the form settings, then he can view the form, fill and submit it. So my question is: since the user have just signed up and login, is there a way we can save the email address used, inside the created record? Thank community!

Hi all, I already know Airtable doesnt allow you to share interfaces with non-users (not a good move, Airtable!) but i'm trying to not give up on the beautiful dashboards i made.Other than taking a screenshot, are there any extensions/third-party tools that i can use to share my dashboards with others that are not on Airtable? We want to share it with our board, funders, etc.

Can anyone explain what this error message means? “Field cannot accept the provided value: Could not find matching rows for string.” Trying to fill a linked column with an automation, however, sometimes there is no information to fill.