Show and Tell

YES! Yes, yes, yes! They are finally here!!! Airtable is a relational database. As such, it allows you to link records from one table to record(s) from a different table and keep such relationship on both sides.However, there are interesting use cases in which you’d want to link records from one table to records from the exact same table. For example, you might want to have one unique table for Tasks and handle hierarchy between them (e.g. Parent task, and Sub Task(s)).When creating a linked record field to its own table, you would have seen that only one field was created (the one you did manually). You would call this field Child Tasks for example, and link through it the child tasks to any parent task. However, the inverse relationship (backlink) would not be tracked anyway -meaning which are the parent tasks for each child tasks. To such effect we used to have to create yet an additional linked record field to the same Tasks table, and create all sort of nasty automations and scrip

Put together this video tutorial on automatically generating PDFs of invoices from your Airtable data using DocuPotion: The approach involved is:Create a reusable invoice template Map template fields to your Airtable data Trigger generation via either 1) an Airtable Automation or 2) via button / formula clickHope it’s useful and any questions let me know.Alex

Put together this video tutorial on automatically generating PDFs of invoices from your Airtable data using DocuPotion:The approach involved is:Create a reusable invoice template Map template fields to your Airtable data Trigger generation via either 1) an Airtable Automation or 2) via button / formula clickHope it’s useful and any questions let me know.Alex

When sharing Airtable with clients, vendors, or partners, many teams end up adding paid seats — even when those users only need limited access.I put together a simple Airtable seat cost calculator to estimate:- Monthly seat cost- Yearly seat cost- Based on plan + number of external users + access frequencyIt’s a small utility meant to help teams understand the cost side before deciding how to share data.Tool link:https://www.clientlybase.com/tools/airtable-seat-cost-calculatorHope this is useful for anyone thinking through Airtable access and pricing. 

Hey everyone — sharing something I built and would genuinely love this community's feedback on.The problem I kept hitting: letting someone outside your workspace update an Airtable record is harder than it should be. Interfaces work, but now cost a paid seat per editor. Native forms only create new records, not edit existing ones. And the third-party form-builders, while powerful, are a lot to set up when all you want is "send this person a link to update their record."What I made: editlink.io  You connect Airtable, pick which fields are editable, and it gives you a signed link for any record. You send the link; the recipient updates their own record — no account, no login, no access to your base. You get an email when they save. Setup to your first link is about 5 minutes.Honest take vs alternatives: if you need a full form-builder with logic, payments, multi-step, etc., tools like Fillout or miniExtensions are more powerful and I'd point you there. EditLink deliberately does one thin

 Hello everyone,At TypeFlow, I built a way to print inventory labels with barcodes directly from Airtable data - no Zapier, no code, no external barcode generator needed.The barcode is generated automatically from any field in your Airtable (SKU, product ID, serial number). You design the label layout in a drag-and-drop template builder - pick your label size, add fields, position the barcode, adjust fonts and spacing. Then map your Airtable fields and hit generate.It supports Avery sheet formats (like 5160 - 30 labels per page) so you get multiple labels on a single A4 sheet, ready to print on label paper. Labels with missing data are automatically skipped - so if a record doesn't have a barcode or a required field, it won't show up as a blank label on the sheet.It also handles quantity - if you have a "Qty" field in your table (e.g. 50 units in stock), it prints that many labels per record automatically. No duplicating records.Same approach works for shipping labels, mailing labels,

Hi all, I've pretty much got Airtable now doing exactly what I need it to. However, the one sticking point that I have is the custom view that I have created just misaligns then attempting to print it. Which is a critical thing in our business. I tried reaching out to support but wasn't able to get any help.I have tried the few responses to questions that I found on here but it didn't seem to fix it for me. I wonder if upgrading from the free plan to the base paid plan will solve the problem? We will need to upgrade anyway but I wanted to make sure the solution worked properly before upgrading.Any help greatly appreciated.

Additional record tabs in a record detail Additional record tabs let you organise data related to a record across multiple tabs.Each record detail can expose a different section of content with it's own views, buttons and revision history.You can even reveal dynamic data (e.g. “5 new updates”) on the tab itself.Have a play with the demo base and read the guide on how to set them up yourself.

Hey! Some weeks ago I built a super simple, yet very very powerful automation, for helping a friend parse invoices, and thought it would be helpful for others to post a basic guide (and open the discussion for improvements) here. Proof of Concept: By uploading an Invoice to Airtable. An automation would use AI to extract, Invoice Line Item Descriptions, Quantity and Totals. Then the automation would create the corresponding records with precise information. Therefore my friend can now get all insights from the invoices his company receives (how much they’re spending, what they’re spending on, and a clear picture of overall finances).  Needs:Airtable paid plan for scripting and AI features.  Areas of improvement:Prompt for AI, as well as Json output would need some iterations to allow handling multiple different invoice formats. Prompt for AI should include an example Json. Many others for sure  High-level setup:Invoices Table Invoice Line Items tableAutomation: Triggers when atta

I had a database from another location that had an existing {Item#} field. I want to keep and continue from the last existing Item# with autonumbering. The problem is that when I change the Item# field to autonumber, it renumbers from 1. Is there anyway to change the field to autonumber and then revert the original numbers?

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 there, I usually see people asking “how to share view with edit access” or “how can i share some part of my Airtable base”. Well, long story short, i had the same need for my business so i built a tool internally to solve that. I sync part of my base to clients, let them edit some fields and sync the data back to the master base. I think it’s cool tool and many users would like it, so i’m sharing it here. It’s still in beta, with a small price ( side project ), so if you would like to try it out, write me a message on the chat. Syncing bases with client and partners has been a game changer and i’m now moving almost everything to Airtable. Cheers

Hi all!I wrote up a post on my personal blog about how to sync a SharePoint list / Microsoft List with Airtable using Power Automate. If that sounds handy, check it out!How to sync SharePoint lists to Airtable via Power Automate 

Put together this video tutorial on how to create PDFs of certificates in Airtable with DocuPotion.  Topics covered include:Structuring your table Designing the PDF template Linking the automation to a specific record Triggering the automation when a user checks a ‘Generate Certificate’ checkbox Using your own ‘template’Any questions just let me know!Alex

In Illinois, the state's Evidence-Based Funding (EBF) formula calculates what each of 851 school districts actually needs versus what it gets. Roughly 600 districts are below adequacy. The aggregate gap is $6 billion.I built an Airtable base to hold all of it — every district's adequacy percentage, funding gap, enrollment, revenue breakdown, tier status, redistribution projections.Then I built seven Hyperagent agents on top of it.Each agent has a role in a pipeline that takes a single district from raw data to a stakeholder-ready investment memo:EBF Analyst — pulls the district's numbers from the Airtable base and places it in statewide context District Intelligence — enriches with web research (leadership, community, demographics, recent board decisions) Funder Match — screens the district against three philanthropic investment archetypes Policy Simulator — models dual scenarios (current funding versus aspirational) with redistribution math Stakeholder Briefer — produces the investmen

We recently completed an org-wide planning and goal-tracking project at the Doris Duke Foundation, and wanted to share the pattern in case it’s useful to others tackling similar challenges. The problem we were solvingLike many mission driven organizations, we don’t measure success with revenue or sales targets. Instead, we organize around long-term strategic goals (“North Stars”). And, I know the companies I’ve worked for need to track Objectives and Key Results in addition to revenue.The challenge was that our strategy lived across PDFs, decks, and docs: making planning slow, fragmented, and hard to translate into action. What we builtUsing Airtable’s app-building capabilities, we built Horizon: an org-wide planning and goal-tracking system that serves as a single source of truth for: Long-term strategic direction (North Stars) Annual enterprise objectives Team goals Projects, ownership, and timelines Everyone accesses the same structure, sees how their work connects, and plans

Sharing a build from the last few days that genuinely surprised me at the workflow level.I work on K-12 education funding policy. I had an Airtable base called Adequacy that was supposed to model public school funding gaps state by state, but the v1 build was rough — Oregon residue in field descriptions, hardcoded formula constants, an "ADMw" field name baked in from one state's terminology, no real per-district adequacy targets.The goal was to point Hyperagent at a clean version of this base and get it to produce publication-grade adequacy analysis.Step one: terraforming with Claude + Airtable MCPThis is the part of the workflow I want to flag for this audience. I connected Airtable to Claude through the MCP connector, then worked with Claude in conversation to rebuild the base. Claude made the edits — updating field descriptions to state-neutral language, renaming ADMw to Weighted Enrollment, adding a new Adequacy Target Per Student input field, rewriting the Adequacy Target formula

This walkthrough will show you how to:Use the ‘Generate Structured Data with AI’ action to extract data from multiple fields Use that array in a Repeating Group to create multiple records in a different tableAllowing you to turn data like this, which:Tries to do too much in a single row (multiple children’s data in a single record instead of one record each) Important info stuck in free-form text fields (favorite toy and age should be in different fields)Into this, where each child is its own record and the data is organized in the correct fields:Note how we’ve extracted the favorite toy and the age from the same text field!Here’s the completed example base for reference, and we can easily adapt this to extract data from long blocks of text, PDFs, etc.1. Set up your automation triggerTo start with, we’ll create a checkbox field that we’ll use to trigger the automation on each record:2. Add a ‘Generate structured data’ step by clicking ‘Add advanced logic or action’, hovering over ‘Gene

Simple version (so you can cut and paste, and put to use) Link to demo base:TestLab Status Airtable TestLab Status - Airtable Explore the "TestLab Status" base on Airtable. Table 1: Latest Status LEFT( RIGHT(status_&"", LEN(status_&"") -FIND({Last Updated}&"",status_&"")-23 ), FIND({Last Updated}&"", RIGHT(status_&"",LEN(status_&"") -FIND({Last Updated}&"",status_&"")-23) )-1 ) Last Updated is just pulling the latest date for the linked records in Status Update Records. TheStatus_ is looking up all of the status-helpers for the linked records so they can be searched through by the Latest Status formula. Table 2: Helper-status field is simply {Status Date}&Status&{Status Date} Its easy enough to repeat for multiple fields, I recommend using notepadd++ to copy the Latest Status formula to find&replace old field name the new one. . . . . Detailed Version broken down version

Hi Airtable builders (and Shopify merchants) 👋 Many of our users asked for a way to sync Shopify product and variant images to Airtable.So we built this new feature with SyncBase (our Airtable-Shopify integration)! How does it work? Our app creates a “Products” table inside a new base (or inside an existing one if you prefer). On this table, you’ll now find an “Images” field (Attachment field type) containing all your product images from your store. You can add or remove any image directly from Airtable.  => And best of all, it syncs instantly! ⚡  I hope this new feature helps some of you build your own Shopify PIM, ERP, or custom workflows inside Airtable. You can of course install and try the app for free. We’re also about to release a feature that syncs all your Shopify files and media (including images) into a single Airtable table (with fields like file ID, alt text, and more) so you can manage everything from one place.Always happy to hear your feedback, so let me know if thi

 I created a short video tutorial showing how to generate PDF documents directly from Airtable using the CraftMyPDF extension.In the tutorial, I walk through how to:Prepare your Airtable base with the required fields Install the CraftMyPDF extension Design a reusable PDF template with a drag-and-drop editor Map Airtable fields into the PDF document Generate the final PDF and save it back into an Airtable attachment fieldThis workflow is useful if you want to automate document generation without manually copying Airtable data into Word, Google Docs, or PDF templates.Here’s the video tutorial:https://www.youtube.com/watch?v=KGhycaaelksAny questions, feel free to let me know.

I’m from Ukraine, so bare with my English.) For some months I develop game-mechanics and for a few weeks I try an implementation on Airtable. And I have some issues and some problems here. So I would be quite grateful for some help. My DB consists of lots of tables, among them are ASPIRATIONS (what I try to achieve by my actions), ACTIONS (list of actions I presume to be potentially helpful if practiced regularly), QUESTS (taking an action for some exact number of repetitions during a period of time), DAYS (every record is a day of game with according events), REPETITIONS (each repetition of each quest must be there), TRANSACTION (each gain or loss of points must be accounted for). For example I add an Aspiration like “Lose 10 kilos of body weight”, then I add Actions wich I see helpful with such a target like “Run a mile a day”, then I may take a Quest with this Action. If I see subjective difficulty of this Action as 3 (of 10), than taking this Action in a Quest for a week will cost

Hey everyone, first post here! But I thought that this would be a good spot to share what I have been working on here in Airtable. I am a social entrepreneur within the education social impact space that has been using AI to reimagine how to better allocate education funds to reach benchmarks such as adequacy, equity and joy via our education investments.This is my third project and this time i tried to make it a little more simple meaning not aiming for a “full stack” product. So, recently I built a redistribution simulator for state education finance using Airtable as the entire backend and interface layer.The aim is for the platform to enable policymakers describe a redistribution goal in plain English and receive a structured policy analysis — what the move accomplishes, what it costs, who supports it, who opposes it, and whether to proceed.It is using real data from all 500 Pennsylvania school districts, representing a $4.5 billion statewide adequacy gap identified after a 2023 co

 Hi everyone!I’ve just launched a new Airtable extension called Text Cleanup Tools on the marketplace, and I’d love to get some feedback from the community.It’s designed to make bulk text manipulation simple - things like: Capitalisation / title case Find + replace Adding prefixes/suffixes Whitespace cleanup URL slug generation + URL encoding …plus a bunch of other handy utilities. A couple of nice quality-of-life features I’m proud of: Full undo/redo support Live preview before you commit changes We’ve been using it internally for a while and it’s already saved us a heap of time, but I’d really appreciate feedback from other real world users. Things we might be missing, workflows we haven’t thought of, or edge cases we should support.You can find it here:https://airtable.com/marketplace/blkhN5rtH7lR6D7q6/text-cleanup-toolsThere’s a generous free tier (I hope!), but as a thanks for any feedback in advance, here’s a coupon that unlocks the pro features for free: IWMJM1NA (curr