Show and Tell

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

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