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
Hi, Many of my automations that worked for months are failing after the recent update. Is anyone else experiencing this?
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 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.
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
AirTable is not allowing me to upload my CSV file. I click on the + sign, select “CSV file” under “Add from other sources”. I drag in my CSV file under the “Local Files” section and click “Upload 1 file”. It seems to work, I select “Create a new table” under the “Import your file” dropdown. It shows me a beautifully created base with all the column's I’d like. However when I click “Import” I get an error sign saying “Can’t import CSV file” with the statement “Invalid data” underneath. Does anyone know what might be going on / how I can fix this. The only option airtable gives me is to click a button saying “Okay” and I’m back to the start.
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!
I have a bunch of columns/fields that use the same list of single-select values. I have changed the colors of the selectable values in one of the columns and I want to apply the same change (colors) to all the other columns with the same range of values. How can I do this short of manually edit the colors on all the other columns?
I’m trying to make an extension that generates a file using base data and then re-uploads that file back to Airtable. However, I’m not able to find any way to access the upload attachment HTTP endpoint from within the Blocks SDK. The API reference only shows examples of “uploading” attachments using public URLs.Is there any way to access this functionality (properly) from within a blocks extension? Or alternatively some sort of internal PAT or similar I can use to make the POST request without hardcoding something that will be exposed in the browser?
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
Why did anyone think that changing the interface to a smaller, lighter font was a good idea? I have a lot of trouble reading it now (desktop). How can this be changed? It’s really affecting our productivity. People should leave well enough alone!
Hi, I’m building a page to track hours — comparing what we’ve budgeted versus the actual hours spent. We’re tracking time in Harvest, and at the moment I’m manually entering that data to match it up, which means there’s no direct link between the two systems. We use the same standard phases for every project (example: B01-B09). Each time a client signs a fee proposal, I want to add these same phases to the new project and allocate the initial budgeted hours. In Excel, I’d simply copy and paste multiple rows, but in this system I can’t duplicate more than one row at a time, which is slowing things down.Ideally, I’d like to be able to duplicate all phases (B01-B09) and assign them to a new project in one go, then input the hours. I also update the actual hours weekly, so it needs to be easy to maintain. I’ve been exploring whether an interface with a button (plus an automation) could do this — so that with one click it would add all the phases for me — but I’m a bit stuck on how to set t
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.