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
Hey everyone,I'm a developer exploring a new SaaS tool specifically for agencies and consultants who build on Airtable, and I'd be grateful for your expert feedback.From my research, a recurring pain point seems to be managing multiple client bases at scale. The manual process of updating formulas or adding fields across 15+ duplicated bases sounds like a maintenance nightmare, and Airtable's native sync has its limits.The solution I'm building is a simple utility called BaseFoundry. The concept is a dashboard where you can define a "master" base and then push structural updates (like a new field or a changed formula) to all your client "instances" in one click without us touching any of your unique data.For the agency owners and ultimate users here: Does this solve a real problem for you? Is this a "nice to have," or a "give it to me now" kind of tool? Am I missing a key feature that would make this indispensable? I've put up a one-page site explaining the idea here: https://subsc
Sharing here because obviously the team I’m working for can’t appreciate it as much as you all will!! And the Airtable community is amazing!! Took me a hot minute and it’s a bit convoluted with lots of helper fields (if you have a better/cleaner way, please share!!), but I finally figured out how to get a linked field into a nice list with comma separators and an “and” just before the last item. I use this in a template email. I may do a Loom video if anyone wants it, just let me know in the comments. Requirements: 2 tables linked :slightly_smiling_face: In table 1: First Name Field First Name Length Field - This is essentially a character count of the length of the first names. If your scenario may have more than 99 characters you’ll need to add two zeros in front of the numbers less than 10, and other formulas later may need to change. Thanks to Airtable forum for this formula: IF( LEN( {First Name} )<10, ‘0’ )&LEN( {First Name} ) In Table 2: Linked Records Field Rollup
Early this year I wrote a script1 to help a user organize some sequential events, where one event would start when the previous event ended. Rather than continue to post updates to that original thread, I felt it would be best to start a new one. This script lets you go from this: …to this: Change durations and re-run the script to re-calculate the relevant start and end times (no need to clear fields first!) Choose as many fixed start times as you wish, and those times will remain untouched while the others calculate based on the end time of the previous record Tip: use record coloring to mark records with fixed start times, then hide the checkbox field for a cleaner view Download the latest version of the script here: gist.github.com https://gist.github.com/justinsbarrett/2ebae3bd1c0a1e3956bfb3338ac6aeda setSequentialEventTimes-scriptApp.js // Allow user to select the table and view to use, and which fields will be affected const config = input.config(
Recently I tried out a few experiments using AI to do SEO analysis on competitor websites and formulate a strategy that can be used to beat them. This performed really well for most internal SEO teams as they got new and insightful strategies based on current data All you need is a keyword and a backend workflow scraps all the pages ranking for that keyword. The content and site structure is analysed by AI and a strategy on how to go about the strategy is providedThe next step is creating a new blog based on a combination of different strategies from the above steps to generate a unique high-quality blog postIf you would like to test it or have a custom AI integration feel free to PM or email me at zacharia@effibotics.com
This a product I build on airtable, and automated the backed using n8n to create powerful SEO manager that can automate basically all your SEO tasks from keyword research, competitor research, write AI blogs and publish to wordpress.I liked Airtable as its much easier to use and manage with the free tier, and can be easily automated to create complex systemsYou can access the template here
Hello everyone,I've built a document generation for Airtable, using Google Docs for templating. Today, this product, Typeflow.us, is available as an Airtable extension.Thanks to it, you can bulk generate PDFs directly in Airtable in a few clicks. I built this extension, because many of you struggle to generate PDFs automatically with Airtable Page Designer.It's also possible to generate PDFs using:Airtable Automation our API to generate PDFs with Make / Zapier just to generate PDFs directly with a button in Airtable.We have many features to cover your use case:line items => perfect for invoices, quotes, reports. nested line items => perfect for complex invoices loop table => perfect for Product Catalog Accessing Multi-Level Linked Records effortlessly (stop using hacks / rollup fields) E-Signature (still in beta)And many other features!You can try our product for free (30 docs per month for free):https://typeflow.us/
I need many subscriptions for my operations, and I need to collect the invoices every monthSo I have accurate reporting, and for my accountant of course.So I built this system to solve my own problem - hope it’s useful to others too! Download link to all material used is in the video description.
TL;DR:I’m a non-technical cartoonist who built a fully chat-controlled editorial system using Airtable’s API and OpenAI Actions (via ChatGPT Teams). I can manage my entire cartoon workflow—images, captions, submissions, rights, and tagging—just by talking to it. No middleware, no third-party tools. It handles flexible inputs, reads image fields, and edits any table or field naturally. Happy to share details if anyone’s doing something similar.Why I built it:I draw single-panel, black-and-white gag cartoons (like what you’d find in The New Yorker). I needed a way to track and submit work, manage captions, analyze themes, and stay organized across multiple stages of a cartoon’s life. I had no editor or agent—so I built one.What it does:Reads and analyzes cartoon images alongside their captions Tags tone, subjectivity, and humor style Edits any field across multiple linked tables (submissions, rights, cooldowns, etc.) Works from vague or partial prompts like: “Update BalloonBomb’s caption
Includes spanish characters. LOWER( SUBSTITUTE( SUBSTITUTE( SUBSTITUTE( SUBSTITUTE( SUBSTITUTE( SUBSTITUTE( SUBSTITUTE( SUBSTITUTE( SUBSTITUTE( SUBSTITUTE( SUBSTITUTE( SUBSTITUTE( SUBSTITUTE( SUBSTITUTE( SUBSTITUTE( SUBSTITUTE( SUBSTITUTE( SUBSTITUTE( SUBSTITUTE( SUBSTITUTE( SUBSTITUTE( SUBSTITUTE( SUBSTITUTE( SUBSTITUTE( SUBSTITUTE( SUBSTITUTE( SUBSTITUTE( SUBSTITUTE( SUBSTITUTE({Título},"¿",""),"?",""), “!”,""), “¡”,""), “-”,""), " “,”"), “(”,""), “)”,""), “á”,“a”), “é”,“e”), “í”,“i”), “ó”,“o”), “ú”,“u”), “ñ”,“n”), “/”,""), “#”,""), “:”,""), “”",""), “””,""), “.”,""), ““”,""), “,”,""), “ª”,""), “º”,""), “Á”,“a”), “É”,“e”), “Í”,“i”), “Ó”,“o”), “Ú”,“u”))
We’ve been using Airtable as a backend for lightweight apps — like a project dashboard for clients, or a form submission portal that touches multiple tables.Interfaces help a bit, but they don’t quite support login, user-based permissions, or multi-table forms. We ended up building a role-aware portal layer that connects to Airtable and lets users view, edit, or create records based on their role — it’s now ClientlyBase, but it started as a personal workaround. Just curious if others here are building similar “mini apps” on Airtable. What tools are you using — Interfaces, Softr, Glide, or something else?
TL;DR version: Airtable’s recently added capability to limit linked-record selection to a specific view allows users to incorporate, to a degree, conditional logic. The specifics: ‘Conditional logic’ can mean a lot of things: Any use of an IF() or SWITCH() statement is a form of conditional logic. Here, I’m using it in what’s become an increasingly common manner: to mean the limiting of available options based on an earlier choice. For example, take a look at the following diagram. The user selects one of five categories. Based on that selection, he or she is allowed to choose from a subset of five subcategories, taken from an overall population of 25 subcategories. This conditional restriction of choices not only helps reduce a potentially unwieldy array of options to a smaller, more manageable group, it also helps ensure the subcategory chosen is appropriate given the category already selected. Admittedly, a 25-element list may not present an insurmountable challenge to the user — e
Hey everyone! We recently shipped two features for BaseQL that I’m really excited about.For those that don’t know, BaseQL provides a GraphQL API for Airtable that makes it easier to build custom apps with your Airtable data.These new features came directly from user feedback about workflow pain points.TL;DR: You can now query Airtable views directly and have full control over filtering/sorting related records in a single API call.Querying Airtable ViewsBaseQL now supports querying specific Airtable views using the new _view argument. This feature leverages Airtable’s powerful ability to create custom views with specific sorting, filtering, and grouping configurations.Why this mattersMany BaseQL users were manually implementing sorting through rank columns or creating complex filter combinations to match what they had already configured in Airtable views. Now, you can simply:Configure your data organization visually in Airtable using drag-and-drop Query that exact configuration with a s
Just returned from Asia's largest Apple ecosystem expo where we showcased AirKit for Airtable. What an amazing experience connecting with so many passionate Airtable users across Asia! The energy was incredible as visitors from China, Korea and beyond stopped by our booth. We were genuinely surprised by how many people are using Airtable for everything from personal projects to enterprise solutions. Many users shared their frustrations with the slowness and navigation complexity. It was validating to demonstrate how our AirKit app solves these exact pain points by enabling quick record additions and table access through Siri commands and Spotlight search. The conversations were enlightening - we learned so much about how people are using Airtable in different contexts and cultures. Several visitors even showed us their unique Airtable setups! I've created this vlog to share highlights from our experience. If you're an Airtable user struggling with the mobile experience, check out our
Long text preview too small? Not anymore!This script lets you resize the modal and set your own default width / height. To use it, you’ll need to use Tampermonkey (https://www.tampermonkey.net/) Happy to fix any bugs or issues, please let me know about them and I’ll do what I can! Inspired by this post here: // ==UserScript==// @name Resizable Airtable Multiline/RichText Modal// @namespace adam@thetimesaving.company// @version 0.1// @description Make multiline/richText modals resizable with default size// @match *://*.airtable.com/*// @grant none// ==/UserScript==(function () { 'use strict'; // === config === const DEFAULT_WIDTH = '500px'; const DEFAULT_HEIGHT = '500px'; const MAX_TEXTBOX_HEIGHT = '80vh'; const css = ` .cell.expanded.shadow-elevation-high[data-columntype="multilineText"] .contentEditableTextbox, .cell.expanded.shadow-elevation-high[data-columntype="richText"] .contentEditableTextbox { height: 100% !important; max-
Using chatGPT in an Airtable automation. In my use case, the automation triggers on when an Airtable record matches conditions,then follows with 2 actions, run script and update record. Adjust the first part of the promptwith your own use case. Tip: Use chatGPT to help you write a prompt for chatGPT (!) let inputConfig = input.config(); text = `${inputConfig.text}`; var key = "openai-api-key"; var url = "https://api.openai.com/v1/completions"; prompt = "Reword this text to grade 9 reading level: " + text; var gpt = { model : "text-davinci-003", prompt : prompt, temperature : 0, max_tokens : 1024 }; response = await fetch(url, { method: 'POST', body: JSON.stringify(gpt), headers: { 'Content-Type': 'application/json', 'Authorization': 'Bearer ' + key, } }); answer= await response.json(); data=answer.choices[0].text; output.set('your-airtable-field',data);
A custom script that helps you integrate Airtable with the OpenAI API without using any 3rd party tools like Zapier or Make - possible even with the free Airtable account. Just copy-paste the "script" and start getting responses from gpt-4/3.5, immediately.What can you do with the “script”?You can bring the power of OpenAI language models (GPT-4 and GPT-3.5) to your Airtable base and utilize them to create content for 1000s of rows at once.For example:Generate product descriptions based on several data pointsCreate personalized emails for 1000s of guests based on available dataDo programmatic SEO by creating super-optimized AI contentGenerate content for anything and everything that follows a patternLearn more about the script here: https://invertedstone.com/store/airtable-to-openai-api/
I know a lot of you including myself on the forums wish there was a way to attach dropbox image links so you can maintain your digital assets locally such as this post: Choose Dropbox or Google Drive for attachment storage Product Suggestions I would love for my attachments to get sued in my Dropbox. This would allow me to use Airtable as a digital asset manager Or even renaming uploaded files (in bulk though) Rename Uploaded Files Product Suggestions I think it would be great to be able to update the names of files once they’re uploaded; this is especially needed when linking images or files from online instead of uploading since you have no control on the naming structure for those external files. I’ve recently found that searching a base includes what’s in the filename and this is becoming problematic since I often link to images on the web that have a lot of text in the filename that I would prefer not to be there. I th
Hey community !We just redesigned and relaunched Data Fetcher, and I wanted to share it for anyone who might find it useful. What is Data Fetcher? It’s a no-code Airtable extension that pulls data from APIs directly into your bases. Think of it as connecting Airtable to your external data sources without the complexity of coding or leaving Airtable. Why we built it: We kept hitting the same wall: Airtable is great for organizing data, but getting external data in (and keeping it updated) was always a hassle. What it does:Import from any REST/GraphQL API Schedule automatic updates (up to every 5 minutes) Chain requests together into sequences for complex workflows Handle authentication & pagination Transform data as it’s importedReal example: One of our customers, Fox Logistics, increased their shipment processing from 1,800 to 2,500 per week after connecting their external systems with Airtable through Data Fetcher - all without adding headcount.We’ve put together a list of pre-bui
My client just spent 5 minutes raving about how a small fix genuinely improved the quality of life for their staff. So thought to share.They run a medical services biz. For managing charts, appointments, etc., they use "Jane," which is super HIPAA compliant (so no API, of course). For the extra workflows Jane can't do, they export PHI-stripped data to Airtable weekly and also use Asana for patient-specific tasks.The problem? Practitioners in Jane needing to see Asana tasks for a patient had this annoying little dance: copy PatientUID from Jane URL, tab over to Asana, paste, search, pray. Took barely a minute, sure, but multiply that by X times a day... and it becomes a real point of friction in their workflow!So, I figured there had to be a no-code way. Whipped up a super basic Chrome extension using Windsurf (one of those AI builder things – I wanted to explore these AI builders anyway, so good excuse!).It's not going to win any innovation awards, and it's definitely not a unicorn Saa
Hi everyone! 👋I’m excited to finally share that I completed my Airtable certification back in February (https://verify.skilljar.com/c/7k9pzk4zucj9), and I'm now looking to integrate Airtable into my freelance services.I'm Shuaib, a business process automation freelancer with a background in Computer Science and I work with automation platforms like make.com.Earlier this year, I earned my Airtable Certification, and while I quietly celebrated it in February, I'm now ready to make it part of my public tech stack and service offerings.🔗 Here’s a look at my work: My PortfolioI'd love to hear from others in the automation space:How have you integrated Airtable into your services?What kinds of systems have you built with Airtable that are tightly coupled with automation tools like Make or Zapier?I'm especially interested in use cases like CRMs, inventory or asset management, and other backend systems that benefit from Airtable’s flexibility and structure.If you're using Airtable as the cor
(So, since I’m a “New” user even though I’ve used airtable for years, I can only post 5 images per post, so I’m breaking this up into multiple responses. ) Hi guys! I encountered a need to have this solved, and the nature of the problem just doesn’t mesh well with creating a formula to fix it. Here’s a topic that was looking for a good answer on this, and one that gives an answer that I think can be improved upon: Rolling Customer Number Based On Year Base design I need to create a customer number that includes the year, and an accruing customer number. E.g. 2020-0001, 2020-0002, etc. The thing is, every year, the year has to change in the customer number, and the four numbers after it have to reset. So if the last number of 2020 is 2020-1234, the first number of 2021 will be 2021-0001 again. I can get the year from the Created Time field The problem is the numbers after the year… I figure I can’t use an autonumber because it won’t reset each year. …
Hello everyone 👋.FlexiPage extension is now live in Airtable Marketplace. It is created as an alternative for Page Designer. It comes with a rich text editor, tailor made for Airtable. You can easily bring in fields from Airtable and create document templates.Overcome limitations of Page DesginerCreate multi-page documents of any length Automate your document generation workflow, using FlexiPage and Airtable AutomationWhat can you do with FlexiPage?Create and automate business documents within Airtable extension Store the generated PDF in an attachment field Easily convert linked record items to table rows, display images from Airtable, with our built in componentsHow is it different from other providers?Zero learning curve. You don't have to learn any template syntax. It just works. Our rich text editor is deeply integrated with Airtable. Invoice design from scratch - Marketplace extension - https://airtable.com/marketplace/blkxiBhC4JLMwyIaZ/flexipageCheckout our Website - www.flexip
If you’ve ever wanted to create an approval workflow using Airtable that includes electronig signatures and automatic creation of PDF files, you could always piece together different tools to make that happen.For example, you could piece together a solution that combines DocuMint or PDFFiller, along with DocuSign and Make. Or, you could combine eSignatures.io with Make.But I wanted to see if there was a way to combine everything together with just one platform, and it turns out that you can do all of the above with just one tool: Fillout’s advanced forms for Airtable!On this episode of the BuiltOnAir podcast, I show how to use Fillout to create the ultimate approval workflow for Airtable!Hope you enjoy! If you’d like to hire the best Airtable consultant to help you with anything Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld
May 2023 Update: AirToWoo is now Connect for WooCommerce. We have a demo Airtable base here which you can copy, and you can sign up here.Hi fellow Airtabler’s (and Woocommerce lovers!).I’m excited to share a brand new integration between Airtable and Woocommerce, which allows you to manage all your products, categories, tags, orders (and more) for Woocommece from within Airtable.We’ve shared it with a few of our contacts, and the average speed saving has been 10x. If you’ve ever used Woocommerce, you’ll know how slow it can be to go through and edit products one by one, so it was a no-brainer to tap into the ease and speed of Airtable, and make it possible to easily sync to Woocommerce.Withour further ado, I bring to you: Connect for WooCommerce!Any input would be greatly appreciated 🙂
I’ve been at my company for about two years and our content team’s workflow has changed pretty drastically in that time. We decided we needed a new Airtable base and to switch to an Interface for ease of tracking projects with multiple components across multiple teams. We finally have the visibility we’ve been lacking for full team transparency. Whereas before each team has its own tab in the data layer that were linked but didn’t really talk to each other, all deliverables now live in one tab and each content piece (based on an Updates tab from the Content Calendar template) lives in a second tab and is automatically created based on content type. There is also (based on the template) a separate area for when external stakeholders request content so that we can vet it for all required information before pulling it into the team workflow. Using interfaces has also allowed us to better share calendars and status updates with external stakeholders, giving them only access to the informat
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.