The show and tell space is a place to showcase your work and have conversations about what you’ve been creating in Airtable.
Recently active
A few weeks ago, @Mirek_Walton posed a question to other Airtable MVPs that hit close to home for many: what do you do when your organization has become so dependent on you and your Airtable build that you genuinely can't step away?Happy that people are using Airtable, crying because everyone is pinging you about AirtableThirty-two replies and 165 views later, it's clear this is one of the defining challenges of being an Airtable power user! Whether you're in a 12-person startup or a 700-person enterprise, the pattern is the same: you champion the tool, build something that works, and suddenly everything runs through you.So here's what our MVPs had to say on the subject. The single-point-of-failure problem is real — and documentation alone won't fix it@Helen_Fletcher put it plainly: great docs require someone who can both understand them immediately and have the drive to follow through. @elijahcg went further, noting that in most orgs there simply isn't a bench of technical people wh
I run a small content pipeline for 9:16 vertical meme reels and Shorts, and keeping track of story templates, character variations, and publishing dates quickly gets messy in plain folders. Here is the lightweight Airtable setup I have been using to stay organized:Episodes table: tracks the story hook (for example, an auction battle or grand entry), target platform (Instagram Reels, YouTube Shorts, WhatsApp status), and status (Draft, Generated, Scheduled, Posted). Character & Rival variants table: stores linked records for visual traits like mane color, rival animal, and the prize item so we do not repeat the same combination twice in a row. Prompt & Export log: keeps the exact prompt tweaks and final 15-second video links next to each episode.When it is time to generate the actual vertical clip with sound, I pull the structured fields from the Airtable record into an AI reels generator and paste the final download status back into the base. Having the character traits and sto
When a team reviews public social posts in Airtable, the useful columns are usually the original post, a title, the platform and a short media summary. Copying a full API response into a long-text field makes that review harder. Temporary media URLs also make poor long-term reference fields.Here is a small Python adapter that turns a saved JSON response into one CSV row. The CSV can be imported into a review table; this version makes no network calls and needs only Python’s standard library.Disclosure: I maintain EasyDown, the paid developer API whose response contract this example uses. AI assisted with drafting and code. Verification for this example consists of ten local tests using synthetic data; an import into a live Airtable base has not been performed for this write-up.Input and outputUse a saved response from the common POST /api/v1/parse endpoint. Its successful envelope has an integer status of 200, with the normalized media object directly in data. Platform-specific endpoin
Airtable Canvas is now on every plan, so let's see what you're making! Post a screenshot or a short screen recording of an app, report or deck, and tell us:- What it's for and who uses it- Roughly the prompt you started with- One thing you'd like Canvas to do next Please use sample data or blur anything sensitive (!). We'll pick a few for a roundup next week, and we'll ask your permission before featuring anything. Happy building!
Hi all I (relatively) recently built and launched FastUKCompanySearch - Airtable extension to look up Companies House data and UK Company Financials. It allows UK companies and company officers to be looked up by name, number or by financials, as well as serving as a due date tracker for accountants. Really pleased to see it finally live and available to download.The extension , behind the scenes uses another one of my product , convert-ixbrl.co.uk which is basically an api that makes the UK company financials available as json. What’s interesting, to me, is the development experience. It just so happens that I was also building a similar extension for a very large sales CRM portal, lets say its name ends in Force. The development experience difference was literally night and day. The previews, the build speed and iteration available via Airtable SDK is light years ahead of what that other platform had to offer. I think I have sunk in 4 time more the amount of time building that other
"Can I pull data from a website into Airtable?" comes up here every few months, so here is a short map of the options I have tried, with the point where each one stops working well.Disclosure first: I make the three Universe bases linked at the end, so read it knowing that. Everything below works without them.1. CSV export + importWorks on every plan. Most review sites, Reddit tools and job boards can give you a CSV somehow.Where it stops: it is manual. Re-importing creates duplicates unless you have a stable ID field and merge on it.2. Scripting (extension or "Run script" automation action)fetch() can call any public JSON API and write records. Good for small, clean APIs.Where it stops: most sites have no public API or block plain requests, automation scripts have a short run-time limit, and the Scripting extension is not on the Free plan. You also own the maintenance when the site changes.3. Sync / fetch extensions and Zapier-style toolsGood when the source already has an API or an i
I’m a certified bookkeeper who builds databases, and I built a base for owners who keep their own books. Sharing the structure, because the design choices are the part that took longest.Every transaction needs only two links: one to an Account (the chart of accounts) and one to a Bank Account. Category, tax line and bank balances all come from those two. Vendor and invoice links are optional and only feed the 1099 and invoice pages. Two links is the most I’ve found an owner will reliably keep up with.The chart of accounts carries the tax line. Each account record holds its Schedule C line, so picking the account is the only categorizing the owner does, and the tax totals group themselves.Transfers are their own type (Income, Expense, Transfer), so money moved between your own accounts doesn’t inflate income or expenses.Interface pages do the “alerts”: This Month, Unreconciled, Open Invoices (oldest due first, with days past due), Tax Prep Ready (expenses grouped by tax line) and 1099 C
Wanted to share something fun instead of client work for once. My family plays Five Crowns pretty regularly, and I got tired of losing score notebooks, so I built a proper tracker in Airtable.How it's structured:Log Scores — one row per player per game, with a column for each card value (3s through Kings). Game Total is a formula summing across all the value columns per row. Games — one row per game, pulling in all players via linked records, with a formula surfacing the Winner (lowest score wins in Five Crowns) and Lowest Score. Leaderboard — rollup/formula-driven view showing Games Played, Total Wins, Win Rate %, and Total Points per player, so bragging rights update automatically. (My data currently confirms one very smug family member is undefeated. 👑)It's genuinely nothing fancy — no automations, no interfaces layered on top — but it was a fun small problem to solve with linked records + rollups, and I figured other card-game households might get some use out of it.Grab your own
If your hiring manager already works in Airtable, this setup brings in first-round screening results from short one-way answers (video, voice or text), so nobody has to copy scores across by hand.The baseCandidates: name, email, job, total score (1.0 to 5.0), label (next round / maybe / not a fit), review link, submitted at, and the candidate ID from the screening tool as the primary key. Jobs: one record per open role, linked from Candidates. Views: one grid per job sorted by score, a "Next round" view filtered on the label, and an interface page for the hiring manager.How the data gets inThe screening app is AnswerReel. It has three Zapier triggers (Candidate Submitted, Scores Ready, Label Changed), so two Zaps do the work:Scores Ready → Airtable "Find record" by candidate ID → create it if it isn't there, otherwise update the score and review link. Label Changed → find the same record → update the label.Keying on the candidate ID matters. Scores Ready can fire again if a result is r
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
This keeps coming up, so here is a rundown of the options. I make one of the tools at the end (Basecellar), so read it knowing that.An automation or import overwrote a field in many records:- Revision history shows the old value of each record. Fine for a handful, slow for hundreds.- A snapshot restores the whole base as a new base. You can copy the damaged column back, but records edited since then get overwritten too, so sort carefully and check first.Records were deleted:- The base trash keeps them for seven days. Use it first: it is free and the quickest way.- After that, a snapshot (again as a new base), then copy the records over. They come back as new records, so links need fixing.Copies outside Airtable:- CSV download per view: free, but manual, and attachment links expire within hours.- A scheduled export through the API: a script or an automation platform. You own the failures and the restore.- A backup service. Worth asking each one: where do the copies live, can it put back
I’ve been using Airtable as a prototype + implementation surface for visual-asset workflows. The working AP-ASK demo is now public.The key value proposition is that Airtable is not merely organizing or tracking an AI image workflow. Rather, Airtable carries the workflow end to end, with image generation inside Airtable >>brief >> shots >> generate candidates >> review >> accept1/ Products + ReferencesThe base holds the product truth + the visual references directing the work.Each reference states the role it plays, what it may decide + what it may not decide.2/ Briefs + ShotsThe brief + its shots assemble the production standard:- what the image is for;- what direction it follows;- what may vary;- what must remain true;- where the accepted image will be used.3/ Image generation inside AirtableFrom a shot, the user clicks Generate new candidate image.Airtable then:- creates the candidate record;- preserves the current standard, prompt + source inputs;- che
This question keeps coming up here, and the old threads are closed to replies, so here's a rundown for whoever lands here next. I make Airtable to Sheets, a Google Sheets add-on, so read it knowing that.Why the built-in automation makes duplicates: the Google Sheets action in Airtable automations can only add a row. It can't find a row and update it. So "When record updated" plus "Add row" gives you a new row on every edit.The options:CSV export. Download the view and import it into Sheets. Fine once a month. Attachment links in the file expire within hours. Make or Zapier. Put the Airtable record ID in a sheet column and search for it. Update the row when it's found and add one when it isn't. It works. Deletes won't carry over unless you build that path too. A sync add-on inside Sheets. It lives in the Sheets sidebar: choose a base, table and view, and the records come in. That's what I build.Limits that apply whichever tool you go with:Google lets a Sheets add-on run on its own about
Hi, I am a project manager for a creative team of 11 people (designers, videographers, editors, and strategists) working on an in-house marketing team. We currently use Airtable to track our work- using a job input form to collect project details, and project status fields to keep track of our work. We use a separate program for our internal creative reviews (Workzone). We are exploring what it would look like to move our entire process on to Airtable, ever since learning more about the proofing features, and portals- to work with freelancers. As we start to make a plan it would be sooo helpful to see a real life example of how other creative teams have organized their environment and workflow. I am looking for a video or screenshots of a REAL life example from a real creative team that is doing this already. How did you set up your resources and attachments? How do you collaborate/comment/review? Would love to see some ideas to help my team get excited about what is possible.
Hello! WVU researchers are interviewing people who have built, configured, managed, or used Airtable applications for a study. Interested, or know someone who might be? Details are in the original post 👀
Can i build an erp system for my mattress factory?
Put together a video tutorial on generating PDFs of shipping labels from your Airtable data that might be useful for people. Approach taken:Shipping label template designed in DocuPotion PDF of shipping label generated via an Automation (triggered whenever user checks checkbox associated with record) Shipping label automatically uploaded to an Attachment field in the tableOther topics touched on:Database setup for generating shipping labels (3 different tables used) Including data from linked records in the PDF Any questions let me know 🙂Alex
Hi friends of Airtable,I’m running free live sessions on turning Airtable records into PDFs (and Google Docs / Word), including line items, writing the file back to an attachment field, and e-sign.Two coming up, both Thursday 17:00 CET / 11:00 ET, 40 minutes: Intro to DocsAutomator (101) — 27 Aug. One record in, a finished document out. Same flow works for Airtable. Register: https://luma.com/ycthd84p Signed Contracts from Airtable — 17 Sep. A record changes, the signed contract lands back on that record. Register: https://luma.com/r8fij78y Would love if you’d join, or send someone on your team.Best,RupertFounder of DocsAutomator
I've been seeing questions about managing complex contracts in Airtable - where each agreement needs different clauses, exhibits, or terms depending on the deal. Maintaining separate Word or Google Docs versions for each variation doesn't scale.The approach: Instead of duplicating documents, each clause and exhibit is a reusable Airtable record. The PDF generation uses TypeFlow, which reads the linked records and assembles the full contract automaticallyHow the base is structured:MMA List - one row per agreement (vendor, effective date, status, signers) Contract Chapters - 30+ chapters linked to a version record Clauses - sub-sections linked to their parent chapter Definitions - third level, linked to their parent clause Exhibits - parallel structures (Confidentiality, Purchase Orders, Quality Control, etc.)That's 3 levels of nesting, all managed from Airtable. How it works in practice:Operations picks the vendor and selects the contract version All chapters, clauses, and definitions
Important note: Today’s challenge will utilize interactive prototypes. This feature is currently only available in AI Labs, so be sure to turn this on before getting started. Learn more about this feature and AI Labs here.🎁 Welcome to Day 5 of the 12 Days of AI Plays!Today we’re heading into one of the busiest corners of Santa’s operation: the Packages table — home to boxes, bows, gift tags, and all the metadata needed to keep holiday deliveries moving smoothly.Your challenge focuses on AI-powered UI prototype generation to design the perfect digital workstation for Santa’s packaging crew.Get ready to imagine what the ideal Wrapper Workstation interface should look like — and have Omni turn that vision into a proposed Airtable Interface layout. Your Mission Open your copy of the Holiday Operations HQ (or make a copy here) Navigate to the Packages table. Add a new “Build prototype” field agent to create a prototype based on the AI Wrapping Instructions and AI Packaging Notes fields
I have been working on a quote-to-invoice workflow with our users in Airtable and wanted to share the setup in case it helps others building a similar process.The common issue is that a quote and its final invoice contain much of the same information: client details, products or services, quantities, prices, tax, and totals. Once a client accepts the quote,manually recreating that data for an invoice creates duplicate work and can introduce errors. Workflow overviewThis is the flow I use:Create a Quote record in Airtable with the client, line items, totals, and related project information. Change the quote status to Sent. An automation generates a PDF quote and emails the client an e-signature link. The client reviews and signs the quote from that link. Once every signer has completed the signature, a field on the linked Invoice record updates to Accepted. That Invoice status change triggers a second automation that generates the invoice PDF and emails it to the client.The result is th
Problem:The ‘Find Record’ action only lets us search with static values, and so we can’t use another record’s date field value at all: Solution:Convert both Date field values into numeric Unix timestamps, then compare those numbers! The step by step guide can be found below, and here’s a link to an example base. You can duplicate the base into your own workspace to poke at it as well! Table setup:We’re starting off with ‘Start Date’ and ‘End Date’ date fields: Create a new formula field with the following formula for the Start Date field DATETIME_FORMAT({Start Date}, 'x') + 0 Explanation: DATETIME_FORMAT() with the "x" format converts the date into a Unix timestamp measured in milliseconds (docs here) However, DATETIME_FORMAT() returns the result as text, and so we add + 0 to convert the text into a number. Now that it’s a number, in the Find records action we can use comparison operators like >=, =, etc If we left it as text, we’d only be able to use the text operato
I’m working with various fashion companies to spec out and develop PLM systems. People in Fashion loves Excel, so one of the great things about Airtable is for onboarding you can make it feel a bit like Excel.Another thing people in fashion love is printing. Lots of printing. Especially product images with annotations that explain exactly how a garment should be made or changed and is a core part of the production process. Those printouts often end up on a sewing machine somewhere on the other side of the world, where the person making the garment doesn't have access to Airtable.And this is where things become difficult. Airtable can feel like Excel, but it's not Excel. One area where it still falls short is image annotation. You can add simple annotations, but producing flattened, print-ready images isn't really possible. This however, Excel is surprisingly good at.You can annotate an image, save it, and come back six months later to update it. It gets a bit clunky with larger files,
Hello everyone,I'm new to this community and excited to be here! I'm looking forward to learning from your experiences, sharing ideas, and connecting with other members. I hope to contribute to discussions whenever I can and learn more from all of you.
Hello everyone,At TypeFlow, I built a way to generate cross-tabulation tables (pivot tables) directly from Airtable linked records - no formulas, no scripts, no manual formatting.You pick a linked record field as your data source, set a row field, a column field (any single select), and choose Count or Sum. TypeFlow reads the single select options from Airtable and generates thecolumns dynamically. Add a new option in Airtable, it appears in the next document automatically.It also supports grouped column headers - two levels of columns for more complex breakdowns. For example, Male/Female on top, then race categories underneath.Here's a quick demo with two real use cases: A garment supplier with a size-quantity grid (sizes as columns, styles as rows) An HR compliance report with 191 employees grouped by occupational level, race, and gender Our doc: https://www.typeflow.us/help/document-generation/pivot-tablesOur website: https://www.typeflow.us/The table is generated inside your PDF
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.