Ask the Community

I have been working with a free music festival for several years. I’m wondering about using an airtable interface to display our musicians on our publicly facing website and would appreciate any thoughts about that. Wellfleetporchfest.orgThe festivals data is all on Airtable and our website is on Squarespace. We have 60 bands participating at 30 venues. All of this is sorted out and tracked in Airtable. We display bands, with all their publicly relevant data in blog posts on Squarespace. This looks nice, but its a lotta manual data entry every year for an all volunteer crew since there is no way to import data to the blog component.I’ve started to look the the interface option in Airtable and its pretty flexible, but I’m on a free plan and cant see how it actually works - we run this show on a shoe string. Is an interface really embedable? Would  this be a better option for us?Thanks in advance for your thoughts!

Hi,I’m building a work shift calendar for employees to see their own workdays. Hence the calendar access would be based on <current user>, which requires having a user field for the records. However, due to the amount of previous and current employees from different departments, I have built a separate “Staff” table. This way I can show only relevant employees in the work shift planning interface pages, making the UX a lot more convenient.I had hoped I could “produce/distill/populate” a user field based on this “Staff” table, but this seems not to be possible. For example, a Lookup resulting in an e-mail addresse matching the e-mail of a user could be formatted as a user, but this seems impossible.Has anybody found a workaround for this? I know and understand that I could use an automation, but I’m really running out of automations (and I would like to keep this within Airtable). Moreover, it doesn’t seem particularly tempting to waste an automation on such a small thing, even if

Did a search for this and found nothing but wondering if there is anyone else that would see some sort of hierarchy levels functionality like from the list view in timeline views.Not just grouping.Not quite sure of how it would work completely but I keep feeling like it would be useful.

I’m importing data and Airtable determines that one field should be single select. This is totally fine but I’m wondering if it would be better to store the selections in a separate table and use a lookup.Is there a performance or size benefit to keeping all the possible choices for this column in a lookup table vs the single select options in the same table? So far, the largest number of choices from my data is 13 but there could be more.Let’s say I’m importing 8 data sets into new tables, each with a column that could be single select. The single select values would be unique for each table. Would it be worth the effort to populate the values from that column for all 8 tables into a separate lookups table? This raises the question of how to link that column or use a lookup after importing. Is there a programmatic way to do a lookup with a formula?

Hi all! I’m looking for ideas on the best Airtable approach for combining a high-level project roadmap with team capacity planning.I have a Master Projects table that brings together:Actual projects already assigned to the team Potential future projects that may be coming down the pipelineBoth use the same core fields, including Status, Assignee, Project Type, Product, Start Date, and Estimated Due Date. Potential work can represent either a specific expected resource or a larger initiative where we know significant work is coming but don’t yet know all of the individual deliverables.The goal is primarily team-level, monthly planning: helping our manager see committed and potential work together, identify especially busy periods, and gauge whether we appear to have bandwidth for additional work.I’ve tried Kanban, Timeline, and Roadmap Interface layouts, but none has felt quite “right” in terms of capturing both timing + workload. At this point, I also feel like I may be overthinking it

AirTable only facilitates Sunday-Saturday week view in the calendar view window/box. Since most of the world does not use Sunday-Saturday week layout. We’ve been asking for the option to change this to whatever we want. More than 50% of the world uses Monday-Sunday so for that reason (and common sense, e.g. ‘Sat and Sun comprise what most people call the ‘weekend’ is at the ‘end’ of the week’), we’d like the option to toggle that. Also, some people use other week formats.  We have been asking AirTable to fix this for over 7 years. It’s crazy that a tool which emphasises the customisability for users building apps/interfaces can’t facilitate such a basic format rule.  This topic was raised 7 years ago!! (2019) and it’s still unsolved:  Their initial proposal does not work

Looking for the ability to hide or show a button, or field based on the logged in user, against a user field for the record. This is not different than how a filter shows/hides records based on the logged in user. Not having this capability means I need to duplicate the interface I am working on for each user persona, which is not good design. AFAIK there is not a native workaround – AT product team could you please give an update on this function?  Thanks, Enterprise User and MVP

Issue:When using an Airtable Interface with dropdown or filter elements, selecting specific options (e.g., filtering records) resets to default after opening a record and returning to the list view. The interface does not retain or restore user selections, even within the same session. Expected Behavior:The interface should remember or restore the user’s dropdown/filter selections after navigating back to the list view, either automatically or via a “Save View” button.

Hi everyone, I run a content site called Crab Guide, it has grown to 90+ published pages but not all of them are indexed by Google yet, and I have been tracking this manually in a spreadsheet which is getting messy (columns for publish date, index status, clicks, and which pages still need internal links).I want to move this to Airtable and set it up properly, maybe with a view just for "needs attention" pages. Would a single table with status fields work fine, or does something like this usually need linked tables (like a separate table for keywords or backlink tracking)? Curious how people managing larger content sites structure this kind of tracker.Thanks!

I'm building an Airtable base for my Nintendo gaming website, which focuses on Tomodachi Life and Nintendo 3DS content.I'd like to organize:Game guides Characters & personalities Articles News SEO keywords Publishing status Content ideasI'm wondering what the best database structure would be. Should I keep everything in one table with linked records, or create separate tables for games, articles, keywords, and categories?If you've used Airtable to manage a gaming website or content project, I'd love to see how you've structured your base.Thanks in advance for any suggestions!

 Hello,I am creating public views of an interface page for our partner school districts that are involved in our study of service-learning. I am learning the 3-level list view by trial and error; it just doesn’t work the way I think it should (backwards!). I have somehow set the size of Level 2 (the Course) to large font. Instead, I would like level 3 (Educator) to have the large font, and Level 3 (the Educator teaching the course) to have normal sized font. I must have set this somewhere, but I can’t find it again. Any tips on where to look? Thanks,Pam  

Hi there, I found multiple posts in the community and other blogs that say I can capture submitter IP address in Fillout. It is crucial to my workflow, but I now can’t find this feature? Any help or workaround would be greatly appreciated as it is mission critical!

Hi everyone,I have built an interface dashboard with a list. In the development base I can open a record in the list to view the record details page. However when I try to publish it and use in another base I cannot make the details page appear.  Any thoughts what I could be missing?

Hello,I’m running into an issue with sending emails from Airtable and wanted to see if anyone has experienced something similar.We are manually sending records (not via automation), and one of our users is getting the following error:“This row could not be sent because you have exceeded the number of times you can send emails. Please try again later.”What’s confusing is: Other users in the same base are still able to send emails without any issues Only this one user is blocked We are all using the same setup and process We initially thought it was a general rate limit, but since others can still send, it seems like it might be a user-specific limit or throttle.Has anyone seen this before? Is there a per-user sending limit in addition to the base/workspace limit? How long does this cooldown typically last? Any way to prevent this from happening when multiple users are sending records? Any insights or workarounds would be really helpful.Thanks in advance!

I run an online business (ExpressCanopy.com) that sells custom pop-up tents, logo tents, trade show displays, and event branding products across the USA. We receive many custom orders with different artwork, sizes, and delivery deadlines.I'm considering using Airtable to manage customer orders, artwork approvals, production status, shipping, and follow-ups in one place.Has anyone built a workflow like this in Airtable? Which templates, automations, or integrations would you recommend for managing custom manufacturing or event product businesses?

Has anyone found a reliable way to handle CSV imports in Airtable when the source files are inconsistent?We currently have a custom CSV import flow where users upload files containing customer and account data. Before importing into Airtable, we need to validate required fields, data types, and business rules, then map the uploaded columns to our internal schema.The biggest challenge is dealing with files that don’t follow the expected format. Different customers use different column names, some required fields are missing, date formats vary, and duplicate records need to be identified before the import proceeds. We also need to provide users with clear error messages so they can fix issues without contacting support.Right now, most of this logic is custom-built and becoming difficult to maintain. Every time we add a new import type or validation rule, it requires engineering effort, and edge cases frequently introduce bugs.What’s the best approach for validating, mapping, and processi

Hello,I am writing on behalf of Unito. We are a product that provides deep, two-way sync across work tools. An omission in the API table model prevents us from properly handling dependencies.Summary: `dateDependencySettings` is documented as part of the table model response. It should carry everything needed to handle date dependencies. Which fields are the start date, end date and duration, which field holds the dependency relation, and the rescheduling settings. In practice the property is never returned in the table model response, so there is no way to read a table's date-dependency configuration through the API.Setup: a base on a plan with date dependencies, one table with Start date, End date, a duration field, and a self-linking predecessor field.What I did:1. PATCH /v0/meta/bases/{baseId}/tables/{tableId} with:{  "dateDependencySettings": {    "isEnabled": true,    "startDateFieldId": "fldSTART",    "endDateFieldId": "fldEND",    "durationFieldId": "fldDURATION",    "predecesso

Hi, Im looking for tutorials specific for building a database that maps entities - organizations and initiatives, and the connections between them. Tutorials for commercial use are less helpful. thanks

Why do I have to regularly reconnect Slack to Airtable? It happens every few weeks or months, without warning (other than widespread automation-failed notifications). How can I avoid having to reconnect every automation that involves the ones I have set up to sent notifications via Slack?

Hello all!I'm working with a small school that is restructuring how we track staff time-off and homeroom assignments per year. Staff get reassigned to different homerooms each school year, and I need sick/personal-day totals to be tracked and reset cleanly per year without losing history once a school year closes. I was thinking a junction table might work but would love to hear any other options I might have overlooked or if I’m overengineering this!(Bold indicates table, all listed items are the fields. Homerooms, Staff Year Assignments, and Staff Time-Off would be the new additions)Staff (existing table)Homerooms    - Homeroom Name    - Active Status    - Assigned Students (linked to Students table)    - Current Staff Count (rollup from Staff Year Assignments table)    - Min Staff Required (formula)    - Ratio Status (formula for staff per student ratio)Staff Year Assignments (junction — one record per staff member per school year)    - Staff (link)    - School Year (link)    - Home

Long time user. For the past few months, my Airtable Mac app has been broken, not allowing me to view bases within the app. I can only view account settings. When I click on a workspace name, it opens in the browser. I’m on macOS v13.6.7, and Airtable v1.6.6 Universal. Any suggestions how to resolve?

Over the last 5 or more years, I’ve entered many thousands of records in our airtable, which I use to manage our small business services.  Hundreds of entries a week, and I’ve always used a spreadsheet style page to do this.  Then I can hit shift+enter, create new record, start typing to find customer, hit enter then tab to next field and do the same for product/service.  This is using a field type that links to other tables for customers and products/services. Today, I go to do this and something changed that makes this same method seemingly impossible.  It’s like each of the fields is now a separate entity that when you enter it, any tabbing or arrow keys just change position on things within the same cell. Now to do the exact same thing I’ve been doing for years, I have to ‘Shift+Enter’ to create a new record, then hit esc to deactivate the cell, then use arrow keys to get back to the start, then navigate to the first cell and hit enter to activate it, press tab until the search + i

Today, I briefly noticed what seemed to be a new search experience in Airtable, and it was a huge improvement.When I searched for a text value, Airtable not only highlighted the matching text within records, but it also automatically filtered the view to display only the records that contained the search term.This made searching dramatically faster and more intuitive. Instead of scrolling through hundreds or thousands of records with highlighted matches, I could immediately focus on only the relevant records.Unfortunately, the feature disappeared again after a short time.If this was an experiment or a feature rollout, I would strongly encourage the Airtable team to bring it back. It significantly improves usability, especially for larger bases where finding information quickly is essential.Why this behavior is better:It reduces visual clutter by showing only matching records. It saves time by eliminating unnecessary scrolling. It makes search behave more like users expect from modern a

If i Delete my account, will i no longer be billed.  It is not clear and there is no response page.  Very frustrating.  I could not figure out how to cancel after my free trial and have been being billed for ½ year.

Dear all, I’m using a Fillout form to fill data into my Airtable base. It has worked well until recently when there appears to be integration problem between Airtable and Fillout. In the beginning, Airtable tells me I have too many integrations with Fillout. As a result, I have deleted all integrations in both Fillout and Airtable, and create a new connection (First Airtable connection). This one allows me to connect to the base I wanted, but doesn’t allow me to select the table within that base (when I select the table, it shows the error note: Failed to retrieve metadata … - below). After pressing “Reconnect Airtable integration” it seemed to connect, but the next time I try to use this connection (“account”) the same issue happens. Then I created another connection (MAP_xxx), but using that still doesn’t solve the problem. The integrations use OAuth, not PAT.   Given that all my previous integrations have been deleted, I will have to connect all the forms between Fillout and Airtabl