Ask questions, get answers and engage with your peers
New here? This is a great place to start
Get support directly from your peers
Celebrate your Airtable wins
Forge connections with other Airtable users
Explore and RSVP for upcoming events
Read the latest news the Airtable team
I am a photographer and cinematographer. As such, I have innumerable external drives with images and clips on them. Each drive has a top level file ‘listing.txt’ that has the entire folder structure, down to each filename. This can have tens of thousands of lines. I want to create a base that lists all of my drives and has ‘listing.txt’ as an attachment. Easy. BUT!!! I want to make the base searchable, so if I type in ‘badger’, the base will return the drives that have a file or folder that contains the word badger. Can I make the listing.txt file searchable? Or, do I need to break it up into 100000 character chunks and have numerous long text fields. (I have tried unsuccessfully to do this - but I don’t really know what I am doing!). Insights welcomed, and thanks in anticipation,Roy Dunn
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?
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! 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,Regarding the new UI changes, I really dont care very much about new buttons disposition, but changes in appearence colouring have been a downgrade in my PoV.The new Light appearance is extremely Light, and the Beta Dark mode, in my POV, is currently not good enough (contrasts, especially with coloured dropdowns are not good yet).Boxes marked in green used to be filled in predetermined color (in my case, green), but now it has been changed all to white. Couldn’t find a way to change that with the current UI changes.If someone knows how to, please let me know. Thanks!
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.
Hey everyone!Welcome to the new Airtable Community experience! My name is Maddie, and I’ve been your community manager since summer of 2023. I absolutely love this community, and want to say thank you to everyone for your ongoing enthusiasm for Airtable; it truly means a lot, and it makes me so happy to see how many people here are willing to lend a hand to help your peers in this space. I’d love for us all to introduce ourselves, leveraging this template:Name: Company/Role: Favorite hobby: Most used emoji: How has Airtable helped unlock your workflows? Or if you’re just getting started, how do you hope to use it? I’ll go first! Name: Maddie Company/Role: Sr. Community Program Manager, Airtable Favorite hobby: Yoga Most used emoji: ✨ How has Airtable helped unlock your workflows, or how do you hope to use it? One of my biggest use cases in Airtable is event management so I can best run our community events program! Whether it’s a user group or onboarding office hours event, they’re a
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.
Welcome to the July 2025 edition of The Airtable Effect—a monthly roundup of what’s new, what’s inspiring, and what’s possible with Airtable. Whether you're an everyday builder, a certified pro, or just getting started, this newsletter is for you.In each rendition of the newsletter, we’ll bring you:New product and program launches and updates The latest educational content from Airtable Academy Highlights from the Airtable Community Upcoming events you won’t want to missYou can find The Airtable Effect every month:In your inbox (are you opted into marketing emails?) On LinkedIn (make sure to subscribe to this newsletter!) In the Airtable Community (check the Onboarding Resources section)Let’s take a look back at what happened in Airtable last month. ✨ Meet The New Airtable: AI That Builds With YouForget siloed chatbots and disconnected tools. Airtable now brings AI directly into your data and workflows, so you can turn ideas into apps, automations, and insights—instantly.Create custo
I have been looking everywhere for this answer and I swear I have watched 100 Youtube videos to no avail. Hoping someone on here can help me :)I currently have a “projects” table and a “tasks” table in my base. The projects table is configured so when I add a task to that project it adds it in the tasks table to be tracked. However, if I add that same task to multiple projects it tracks it in the tasks table as one record. Therefore, I can’t individually track the same tasks for several projects. Basically, I want to select the same tasks for several projects and then track those tasks separately. Example:Project A tasks:-solicit bids (complete)-draft contract (in process)-hire sub (on hold)Project B tasks: -solicit bids (in process)-draft contract (on hold)-hire sub (on hold) Thank you so much in advance!! I really appreciate any help that can be provided. This seems so simple but I just can’t figure it out.
A quick question - I have a KanBan view, with a ‘Month’ field as the stacking field: JAN 24, Feb 24, Mar 24 …. etc.I want to be able to filter down my Kanban view, to just show recent activity, eg) 2025, but filtering the corresponding records for the view leaves the empty stacks in place. I know I can use the ‘hide empty stacks’ toggle, but it will hide any recent, relevant empty month stacks that I may want to use, and not just those in the past (2024, etc.) Any ideas?
Hi,I’m newbie so I really need help on changing or renaming the records of my table. As far as I know, you can name the records while creating a table, but whatif I already have a table, what should I do to changing the name of my records?
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
Does anyone know how to get Airtable to go back to a previous look. The new look with the status bar on the left has made airtable more difficult to work with. Left Bar down the entire window instead of across the top.
Hi, I want to track employee annual leave via Airtable. They’ll input Date From & Date To (including time). There will be individual calculation fields for each leave type (e.g sick, annual leave etc) and an approval status. So this formula would be wrapped in IF conditions; IF Type = ‘Annual Leave” and Status = “Approved” this calculation will apply. Formula needs toonly calculate weekdays (ignore weekends) understand 1 day = 7.8 hours only needs to count hours if the time differs between date from & date to fields. Understand working hours are 8:30-5pm (time zones differ) So outputs for the following would be;17 June 2025 3:00pm → 17 June 2025 5:00pm → 2.017 June 2025 3:00pm → 18 June 2025 3:00pm → 7.817 June 2025 3:00pm → 18 June 2025 5:00pm → 9.817 June 2025 3:00pm → 24 June 2025 3:00pm → 46.8 I’m open to doing this more simply via the base design if the formula is too difficult to write (e.g having the employee select from a drop down to say ‘full days
Accelerate your learning journey with comprehensive learning paths and validate your knowledge with Airtable certifications.
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.