Show and Tell

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

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

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