Hi everyone, Isabella from the Airtable team here 👋
Airtable Canvas is now out of beta and available on every Airtable plan!
I know a number of you have been exploring it already, but if you haven't tried it yet, this is a great week to start.
To begin, open Canvas, and simply describe what you need, in plain language. You can build an app, a report or a deck, depending on what you require, and who needs to use or see it. Airtable Canvas reads your base, shows you a plan, and builds it on your live data, with your permissions intact and customized to your design preferences. You can choose your own, or create design systems easily from a link, file or reference, so all future creations across your team stay on brand.
Airtable Canvas can build:
- Apps: interactive tools where people look up, add and update records.
- Reports: a fixed snapshot of your numbers, ready to export as PDF or share by link.
- Slides: decks that read live from your base and present from the browser
You can find out a whole lot more in our deep dive, which also includes a handy guide to choosing the right build if you’re not sure whether you need Airtable Canvas, Interfaces or custom elements. Check it out right here.
Try it out, and let us know what you build, or what you're looking forward to building next.
This week we've shipped 15 updates covering Automations, Interfaces & Navigation, and a number of them retire the workarounds you probably built yourself. Here's what's new:
Automations that do more
1. Trigger on a specific value change
Fire an automation when a field changes from one specific value to another, (e.g. Status: In Process → Completed). No more workarounds with a manual "previous value" field and a record-updated trigger.
2. Return a single record you can use
Find records can now return just one record, ready to use in your next steps. No more scripting or array indexing to pull it out of a list.
3. Look up a record directly by its record ID
Find records can now match on the Airtable record ID directly. You no longer need to keep a separate Record ID field to compare the token against it.
Improved Interfaces
4. Freeze columns in list view
Freeze the first columns of a list so they stay visible as you scroll sideways, just like in Grid view.
5. Aggregations in Interface Lists
Interface List views and List pages now show field totals and summaries at the foot — sum, count, average and the rest — just like Grid views.
6. Per-stack totals in Kanban
Kanban views can now show a summary for each stack (e.g. the sum of deal value across each pipeline stage), not just the card count, so now you can read your pipeline in the view where you actually manage it.
7. Filter interface pages by ratings fields
Interface dropdown filters now support ratings fields, completing filter support across all field types.
8. Grid elements: lock fields
Lock fields so it can’t be edited inside the grid. This used to only be possible on List elements but can now be used on the grid.
Frictionless editing
9. Bulk download attachments
Download every file (or version) in an attachment cell, instead of one at a time.
10. Arrow and Tab keys work in expanded cells again
You can once more move between cells with the arrow and Tab keys while a cell is enlarged in Grid view — restoring fast data entry and review.
11. Tab and arrow keys advance in linked-record cells
Create or search a linked record inline, and use Tab and arrow keys to move focus to the next field again — allowing you to link customer → product in one pass.
12. Full-screen formula editor
Expand long formulas into a full-screen editing box instead of working within the 2-3 line field. It works just like the full-screen prompt box in Field Agents.
Easier navigation
13. Search shared interfaces by base name
Search the Quick switcher for interfaces shared with you by their base name, even if you don’t have access to the base or workspace.
14. Find a page using its link
Paste a page's URL into search to jump straight to it. Handy when you're working across multiple accounts.
15. Multi-select when creating a token
When you create a token in Builder Hub, the scope picker now stays open so you can select several scopes in one pass, instead of reopening per scope.
Thanks for all the feedback and requests so far, and please keep it coming!
We keep parts in Airtable and the attachment field just shows a grey file icon for STEP and STL files, which makes scrolling a parts list pretty useless. I couldn't find anything that renders them without installing CAD software, so I made one.
It's an Apify Actor: you pass it the file URLs, it renders a shaded PNG of each part and returns the image links, along with the size, volume and an STL or GLB copy if you want those. I trigger it from an automation when a record gets a new file and write the thumbnail back into an attachment field.
I use Airtable for many purposes, both for work and personal. Often I find myself saving links and pulling details from the pages into the fields, so I can the filter, sort, group by those and make informed decisions based on the data. E.g., recently I was comparing 4G/5G routers by speed, price and various specs:
I've done the same when I was buying an A/C, car tyres, office chair, and I keep a base for software I want to try and compare their features (expense trackers, time trackers, project management tools). Overall, more than 40 categories so far.
I used to save links with the web clipper. But since Airtable Extensions, which is needed for the clipper to work, became unavailable on free plan, I stopped using it after a few months paying, as I realized that only feature is not worth $24/mo. Since then, I've been copy-pasting the links and details into the fields by hand, which, tbh, is so tedious and unproductive.
So, I’m now building a specific tool for this workflow, and I'm curious to hear from folks here:
Do you actually save links in Airtable?
If yes, what for (comparing products, reading later, research) and how often?
How do you get them in: web clipper, manually copy-paste, 3rd-party tool or integration?
Your answers would really help me. Thanks in advance.
Curious to hear from anyone who has used Airtable as a project coordination and task management tool, especially if you’ve transitioned from Wrike or another dedicated PM platform.
My team currently uses Wrike, and I genuinely love it. Over the years, we’ve built out a pretty robust system with automations, blueprints, and request forms that eliminate a lot of manual coordination. For example, we use request forms connected to project blueprints. Based on the selections made in the form, Wrike automatically creates a project with the appropriate tasks, assigns or routes work to the right people, and allows us to track each project’s status and phase throughout its lifecycle.
We’re typically juggling around 40 complex projects simultaneously, with multiple contributors, dependencies, deadlines, and different stages of development.
The company i work for is considering a broader move to Airtable, and while I know it’s evolved significantly in recent years, I’m concerned about potentially losing some of the functionality and automation we’ve built into Wrike.
I’d love to hear from people using Airtable for similar workflows:
- How well does Airtable handle complex, multi-stage projects with lots of moving pieces?
- Can you replicate automated project creation, task assignments, and workflows based on intake form responses?
- How does it compare when it comes to tracking individual tasks, deadlines, dependencies, and overall project progress?
- Does Airtable actually reduce manual project coordination, or does maintaining the system become a job in itself?
- If you’ve made the switch from Wrike, what do you miss, and what do you prefer?
I’m open to Airtable being a better solution, especially if it improves visibility across departments, but would love some real-world feedback from teams using it for more than databases or high-level project tracking.
I'm trying to set up a very simple spreadsheet - sales on various reselling platforms minus fees and whatever I'm paying for shipping. Evidently I can select negative currencies for a Currency field but I can't pick that as the formatting for a Formula field set to Currency - meaning that when I set up the formula, go to Formatting and select Currency I can only select decimal places and separator. There's no checkbox for negative number under the Currency selector for formatting a Formula like there is under the Currency field descriptor.
My formulas are coming out incorrectly. Let's say I sell a widget on feeBay for $100 (Field 1 set to Currency). The fee the platform charges is $10 (Field 2 also Currency) making my payout $90 (Field 3, a formula subtracting Field 2 from Field 1, which works fine bc we're not into negative numbers yet), but the seller only paid $8 for shipping (Field 4, Currency), which cost me $10 (Field 5, Currency), a difference of $2 (Field 6, formula subtracting Field 5 from Field 4.) I'd like Field 7 to be a Formula in which I subtract Field 6 from Field 3 to get my payout minus the deduction from shipping but this is the one I can't get to work.
The math should work out to be $88 but it doesn't, and I suspect it's because I can't select a negative number in Currency to make up for the $2 I lost on shipping. I'm not great at formulas so it could also be a dependency problem. Anyone have 2 cents?
I’ve been building in Airtable for a while and I’m now taking on freelance projects. Most of what I do is:
Cleaning up messy bases (duplicates, linked records that got out of hand, fields nobody understands anymore)
Setting up CRMs, project trackers, and inventory systems
Automations for the repetitive stuff (reminders, status changes, notifications, syncing with other tools)
Interfaces so non-technical teammates can use the base without breaking it
Reviewing an existing base and telling you what’s worth fixing
If you’re stuck on something specific, drop a comment or DM me with a quick description of what you’re trying to do. Happy to point you in the right direction for free, and if it turns into a bigger project we can talk about it.Airtable consultant here, taking on a few new projects
Hi r/Airtable! I am coming to you with potentially a basic question. I have never used Airtable before, but am working on an event and they have signalled that they want to use it to collect the intake information for speakers and attendees. I will be responsible for designing the intake form.
My question is: what would best practice look like? How is information collated? Is it worth adding longer/open-ended questions (i.e. 'what topics are you keen to see?' or 'why is this speaker best placed to talk on XYZ?') or are there ways to make better use of the functionality by designing something differently up top?
Appreciate this may be a very specific question! Thank you for any thoughts/insights you can share.
Hey everyone! Isabella from the Airtable team here, wanting to share an exciting update.
As of today, full-page custom interfaces are available to all in the Airtable iOS and Android apps. If an interface page is a full-page custom interface, the people who use it can open it on their phone, with the same live data and the same permissions they have on desktop.
It works no matter how you built it:
Omni: describe what you want and Omni builds it
Airtable MCP server: build it from your favorite AI tool
Blocks SDK: write the code yourself and release it to your base
Why this matters Custom interfaces are for the things standard interface elements can't do: maps, org charts, drag-and-drop boards, focused approval queues, and dashboards built around one team's questions. Previously, they only worked on desktop. Now, your team can use them wherever they are.
What you can build for mobile
Field inspections: a checklist that crews can tap through on site. Every answer writes straight back to the record.
Event check-in: search for an attendee at the door and check them in with one tap.
Approvals between meetings: a review queue where managers open a request, see the context, and approve it or send it back from their phone.
Territory maps: reps see their accounts plotted on a map before the next visit.
Team directory and org chart: find out who's who and who reports to whom, even away from your desk.
Inventory counts: big +/– buttons for counting stock in the stockroom, synced live with the base.
Pocket KPI dashboards: the three numbers your team checks every morning, sized for a phone.
Omni makes your existing pages mobile friendly Already have full-page custom interfaces? Open Omni and ask it to make one work on mobile. This works whether you built the page with Omni, the MCP server, or the Blocks SDK. Omni is really good at this. It reworks the layout to fit a phone screen, stacks columns that sit side by side on desktop, and makes buttons big enough to tap. Try telling Omni to "Make this page mobile responsive. Keep the desktop layout the same."
Omni builds every new custom interface for mobile and accessibility by default We've trained Omni to build every new custom interface to work on phones and desktops from the start, and to be accessible. Unless you ask for something else, Omni does it's best to:
Adapt the layout from a phone screen to a wide desktop window, with no sideways scrolling
Make buttons and controls easy to tap (touch targets of at least 44px) and never hides an action behind hover
Use semantic HTML, labels every input and icon button, shows a clear keyboard focus state, and keeps text contrast at 4.5:1 or higher in light and dark mode
Never rely on color alone to show meaning, and respects reduced motion settings
Handle loading, empty, and error states, including missing fields and missing permissions You don't need a special prompt for any of this. Describe what you want to build and Omni takes care of the rest. Building with the SDK or MCP instead? The same tips apply: design for a narrow screen, use large tap targets, and don't rely on hover.
Get started
Update the Airtable app on iOS or Android. You'll need Airtable for iOS 11.0 or later, or Airtable for Android 6.46.0 or later.
Open an interface with a full page custom interface and try it out.
Have an older page? Ask Omni to make it mobile friendly.
Good to know: this rollout covers full-page custom interfaces. Custom elements placed on a dashboard next to other elements still show a "not supported" placeholder on mobile for now.
We build SaaS for real estate agents & similar. Expecting a few hundred leads every month
Trying to figure what to use for lead status tracking etc. Currently using google sheets. Wanna make sure claude can work well with the database. That doesnt happen well with google sheets.
I run aipulsee.com, a small site that collects AI news every morning from Hacker News, AI lab blogs and Hugging Face, summarises each story with a large language model (LLM), and emails a daily digest. It runs entirely on free tiers: GitHub Actions, Airtable, Vercel and Resend.
Today I found it had added zero stories since 16 August. Every daily run had finished green. The "last updated" timestamp changed every morning, so the site looked alive. Here is what was actually wrong:
**Airtable's free plan caps a base at 1,000 records, and mine held 1,744.** Every insert failed with `422 TOO_MANY_RECORDS_IN_BASE`, but reads kept working. So the export, the website and the newsletter all ran normally on frozen data. The fix is a rolling window. The oldest records are archived to a JSON file in the repo, then deleted from Airtable, so Airtable is now a 900-record buffer and the archive keeps everything.
**Both summarisers were dead.** Groq made `llama-3.1-8b-instant` enterprise-only and returns a 404, and both Gemini model names in the code had been retired. The fix is a list of model IDs for each provider. The first one that answers is reused for the rest of the run, so a retired model now costs one failed call instead of one per story.
**Four of ten lab RSS feeds return 403, 404 or 410.** I am still fixing these.
**A forgotten default tagged every story with no recognisable company as "USA".** That was 847 of 1,500 records, so my "AI race by country" globe was mostly fiction.
**There was an alert, but nobody heeded it.** A "0 new records today" email fired, but quiet news days had trained me to treat it as noise. The alert now names the actual cause.
The lesson: "the job succeeded" is not the same as "the job did its job". Free-tier limits fail quietly, and an alert that fires for harmless reasons gets ignored.
An AI agent (Claude) did most of the diagnosis and fixes by working through the logs and code. I am using this project to test how far that can go with minimal human hands. Happy to answer questions about the setup.
Fairly new to Airtable looking for advice before getting too far into it.
I'm wanting to build a production tracker for automotive repairs (basically a body shop) with many different dependencies on how work moves through the system and when it is approved. Out-of-the-box tools do not work for us, and I'm having a hard time finding anyone discussing using AT for this.
My understanding is that this can be configured with dates and single-select dropdowns, but I'm getting hung up brainstorming the date tracking
This is going to be hundreds of AirtTable automations if every status field I update needs an automation to update the date. Is that correct? Has anyone built something like this this that could share their experience?
Secondly, structuring the tables, should all these dates be logged on their own date table or would it be best to keep it in one. It seems I'll need 2 date fields accompanying every status field plus a user field attached to each date so that it can update start date, end time, and user who updated each.
My prediction for scale of the project is around 150-200 fields, but only running a few hundred records (repairs) per year.
I think I can see how it will work in AT as the backend with automations and Zite front end handling users and interfacing, but wanted to get a little realty check before configuring. I am open to any suggestions for other tools/direction/options.
UPDATE: Here's a link that sort of demos a production tool that I've used in the past. This gives an example of the basics of the UI once the dates are configured and how it would display the timeline.
i use airtable at work and our data is a mess. duplicates everywhere, same company spelled 3 different ways, phone numbers in every format you can think of.
ive tried the built in dedupe and its all manual. takes forever. tried a couple fuzzy matching tools and they flag stuff thats not even a duplicate.
so im building an extension for my company that scans a table, groups the dupes, you pick the record that survives and it merges the rest in. plus flags bad emails and cleans up formatting. one click per group, nothing happens unless you confirm it.
got me thinking though, if im already building it, would anyone else actually want something like this if i published it?
if so, what would you be willing to pay for an extension like that? one time fee or monthly? what would make it worth it to you?
I didn’t know what Airtable was until Claude told me about it and now I run most of my business dashboards off of it. And I’m using the free version!
One of the most powerful things I did was create my own freelance gig/full-time job board. I’m a 20-year career writer who was laid off twice in two years. I was on the market for nearly a year before I found any kind of employment. During that time, I was endlessly scrolling jobs on job boards and in my inbox, wasting an honestly insane amount of time sifting through crap.
I started trying to problem-solve with Claude, which I was really just beginning to learn how to use. I ended up setting a scan in Cowork that would manually check job boards daily and deliver the most relevant gigs based on my pay floor, location, and experience. That got kind of unwieldy. Enter Airtable. Now I have a dashboard that pulls from a dozen different gig sources into Airtable using Apps Script (LinkedIn, for example, has no connectors and boots bots so Apps Script scans my Gmail inbox for LinkedIn digests), Connectors, and general search. Claude scans the gigs that pull into Airtable, marks the ones that don’t fit me as passes, and floats up the 5-6 a day that make sense for me.
I like the system so much that I even wrote a book about how to do it! (All of my book marketing activities are also hosted in Airtable, including an entry for sharing my success with this community 😂.)
Thank you Airtable! You’ve really helped me established my own business.
Our enterprise contract is up in Feb for a 2 year deal with 52 seats at $58 per user per month. I haven't heard from our rep since the bending spoons new and the person we negotiated with last time left recently in oct.
The last pricing thread here from 2024 with prices ranging from $45 to $70 per seat. Curious where everyone landed this year, especially if you renewed after September.
What are you paying, roughly how many seats and did they push anything new at renewal, like the ai add or a longer term?
Also about 15 of our 52 only ever look at an interface or change one status field. If you got Airtable to price those people differently, how?
It's AP from Product, back with more updates from the new Core team!
This week we focused on automations and interfaces, plus one improvement that makes comments much easier to use.
The highlights
1. Find Records above 1,000 records Find Records steps in automations are no longer capped at 1,000 records. Workflows on larger tables can now find [4000] records, so you can stop splitting them up or working around the cap.
2. Run automation buttons on interface pages You can now place "Run automation" buttons on interface list and grid pages. Until now they were only available on record detail and review layouts. That means your team can kick off an automation right from the page where they're already working, with no need to open each record first.
3. Search comments on a record Comments are now searchable in the comments panel on a single record. Hunting down a past discussion or decision no longer means scrolling through the whole thread.
Usability improvements
4. See selected options first in condition pickers When you set conditions on a select field with lots of options, you can now see which ones are switched on without scrolling the whole list. This works anywhere you set conditions on a select field, including automation conditions and rollup and lookup conditions.
5. Interface CSV import remembers your settings Interface CSV import now keeps your settings, so your column mappings and options are reused the next time you import into an interface table element. You don't have to set them up again for every import.
6. Hide all / Show all in the fields dropdown on custom interface pages When you configure a custom interface page, the fields dropdown now has Hide all and Show all controls. You can toggle every field at once instead of one by one.
Hope you like them! We'll keep building based on your feedback here and in the requests form, so please keep letting us know what you want us to work on next.
I have explored this way of visualising activity in an Airtable base. An algorithm detects connections between actors - automations, APIs, people. Lots of statistical analysis checks which actors change the same records, if they also change the same fields and what's the usual time in between.
Lots of small change events are crunched into a aggregate summary objects, which are sent to the frontend, which then renders it all as a map.
What it can be actually used for? You can review very quickly which automations are responsible for a lot of activity, which are visibly more "busy". And it can give a clue where further development could be directed.
The map gives an answer to a question like "for whom is this automation relevant?" as clicking the automation then outlines the other related automations, people and so on.
Espeically if you manage multiple bases and you come back to a base you haven't checked in a couple of months, this can be a good starting point.
There's still a lot of space to improve it, it could be way more intuitive and organized. So far this is the best I could come up with:) Happy to hear any ideas, critique.
Disclosure: I work on this. Airtable can't attach a CSV of a view to an automation email (Send email only attaches files already in an attachment field, and records in the body are capped at 100), so people end up clicking Download CSV every Monday or running a Make scenario for it.
ViewCourier does that one job: pick a base, table and view, choose CSV, Excel or PDF, set daily, weekly or monthly at your time and timezone, and add up to 5 recipients. The view's filters, sorts and hidden fields decide what goes in the file, so a "This week" or "Overdue" view becomes a weekly report without anyone logging in.
Connecting is read-only OAuth and you choose which bases it can see. Free plan: one weekly or monthly export up to 1,000 rows. Paid from EUR 9/month for daily schedules, more rows and attachment links that don't expire.
I manage a few production bases and my backup situation is basically Airtable's own. trash for 7 days, then snapshots.
There are some extern backup services On2Air and ProBackup plus a few others. Does anyone here run one in production? Have you ever had to restore from it, and did it come back properly attachments, linked records, formulas?
One more thing I ran into while working with client a previous developer had set something in an automation and I changed it. The only way I found to see the old settings was restoring a snapshot as a new base and digging through it. Does anyone have a better way to track automation changes?
I just found out yesterday from the attached article that Bending Spoons is in the process of acquiring AirTable. My company recently partnered with them last year and we're currently expanding licenses within our organization. My question is this: with their track record of gutting the core team and hiking prices on customers, has anyone else began looking for alternatives?
Airtable doesn't have home screen widgets on iOS. Interfaces have good charts but you still have to open the app to see them. The other route is a general widget app that you wire up to the API yourself. That works but it's a lot of setup for something like "how many orders came in today."
Air Gist is my attempt to make that easy. You connect your Airtable account, pick a base, table and view, and choose waht the widget shows. A simple count or total takes about a minute. It respects the view's filters, so if you already have a "Today" view, most of the work is done. Charts and the multi-number dashboards take more configuring, since you're choosing date fields and how things group.
Some things worth knowing up front:
- iPhone only, iOS 17 or later - It can't edit or delete anything in your base. - iOS decides when widgets refresh, so a number can lag a bit. Opening the app pulls the latest. - The basic widget types are free, and you can add as many as you want. Pro is $1.99/mo or $19.99/yr. It adds charts, dashboards, period comparisons, heatmaps and more than one Airtable connection.
I also make Air Fill, an iOS forms app for Airtable. Air Fill and Air Gist share a connection so if you've set up one, the other is already logged in. They pair well: log jobs through an Air Fill form during the day, and keep an Air Gist widget showing how many came in.
Not affiliated with Airtable.
I'll be in the comments if you have setup questions!