Show and Tell

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/

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

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

I’ve used Airtable to run a couple RPG games and it’s really great. Being able to have a view for my players to look at where I can post images of NPCs or notes is terrific. Here’s how I created the base (this is a Forbidden lands game). And here’s what players can see. It’s challenging to create hidden views that actually show the information I want to share. Hopefully someday there is another step for linked records that allow for a cleaner format.

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

I wrote a Tampermonkey script to allow us to customize the colors of the field headers!(Tampermonkey lets you install scripts in your browser to customize and add functionality to a site, in this case, Airtable! https://www.tampermonkey.net/)To use it, you'll need to set up the exact field IDs and colors that you want those fields to be in this bit:const colorMap = { "fldI5EIoOG25a85F7": { r: 255, g: 224, b: 204 }, "fldxj4ka7M2FwkJAP": { r: 207, g: 245, b: 209 }, "fldAPHkUW98PsaZV3": { r: 255, g: 234, b: 182 }}; For the colors, just google 'Color Picker' and a bunch of options will show up (when I did this Google actually popped up its own Color Picker actually)For the field IDs, right click the field header and click 'Copy URL' and then paste it somewhere, and it'll look something like this: https://airtable.com/appbvEVTtJoARHXPM/tblkT2pj3Ouz1wQRQ/viwKoIZQGVZEAfOap/fldI5EIoOG25a85F7That last bit is what we're looking for 'fldI5EIoOG25a85F7'---Let me know if you have any issue

Hello 🙂I am creating a scenario in Make(Integromat) to resize images, and compress if they exceed 5MB in size.Bellow is the screenshot of the scenario I have created, but it is not working as expected.   I use HTTP to check the resized image size in MB  From here on, I am no longer sure what I did wrong, but Get multiple variables does not give me the resizes and compressed image. If the scenario received two images, one being resized and other compressed, I get two same compressed images.  I would really appreciate help.Thank you, Pjero 🙂

I’d love to see an integration or extension for Airtable that enables automated image generation using data from records. Many teams—especially in marketing, eCommerce, and sales—often need to create social media posts, banners, product visuals, or branded creatives. Doing this manually is time-consuming, especially when the content changes frequently.Use Case Examples: Marketing Teams – Automatically generate social media graphics or ad creatives based on campaign details in Airtable. E-commerce Businesses – Create product banners that update dynamically with new prices, SKUs, or images from Airtable records. Sales Teams – Generate personalized outreach banners using client-specific fields (like name, company, or offer). HR & Internal Comms – Design recruitment creatives, event posters, or announcement banners based on internal data. How It Could Work: Users design image templates with placeholders for text, images, and colors. Airtable data fills in these placeholders dyn

I saw this post from the r/Airtable subreddit and was interested to get our Community’s thoughts on Airtable as a solution to the goal identified by the user.From the Reddit post: Hey guys, I have been using Notion for well over 6 years and I have toted its amazingness for all of those years. However, it has come to the point that I simply need to be able to print a Gantt chart or timeline view straight from the software and it just does not do that. I have asked Notion support 15+ times over those 6 years and I get the same response every time.I have 10 users and we manage around 30 projects in the construction industry at any given time. In Notion I have a database of our projects with properties for information regarding those projects as well as a separate database for just task tracking. The task database has a relation back to those projects so if something is added anywhere its always included in the one database. I've stuck with this format of task tracking purely because the m

Hey Y'all! My name is Louis Piotti from Philadelphia. I work as the CEO of the nonprofit AfterShock Fam (aftershockfam.org) and the CTO & Co-Founder for Polaris Pathways (polarispathways.com) and I also do custom builds for businesses from large manufacturers, festivals, workshops, and schools.I just spend hours banging my head against a wall trying to find how to merge records similar to the De-Dupe Extension but would just do it automatically and just built it.I shared the template for everyone to use along with all the code / prompt history in hopes that less people have to goes through 1000 records 1 by 1 on the De-Dupe extension haha AIRTABLE TEMPLATE: https://airtable.com/appdymmnNJo098vJG/shrssRCuFQcrla1Rc FINAL SCRIPT:// Initialize the table and fieldslet table = base.getTable("Contacts");let query = await table.selectRecordsAsync();let records = query.records; // Define specific field names for non-single-line, single-select, checkbox, or attachment fie

This blog post by Airtable recommends using Airtable as a DAM (digital asset management) tool.My company uses Airtable as a DAM, and when I was a consultant, I worked on projects involving using Airtable as a DAM. Airtable's blog article leaves out a few concepts that you should consider if you want to use Airtable as a DAM.- Most DAMs also provide CDN (content delivery network) services. Airtable has stated that it is not designed to be a CDN. The loss of permanent attachment URLs matches the idea of Airtable not being a CDN. If you want to use Airtable as a DAM, make sure that you don't also need it to be a CDN.- Most of the systems that I have built for using Airtable as a DAM involved at least one third-party service, and some use multiple third-party services. Due to their nature, digital assets tend to be consumed outside of Airtable. Think through how you will integrate your Airtable content with where the content will be consumed. Make sure that wherever is recei

Hi friends we have just launched an iOS app named AirKit on App Store which is just made for Airtable user. The problem it solves is straightforward: it takes so many steps to create a single record in the current Airtable iOS app, why not we let Siri to do it? Just say “Hi Siri, AirKit add Tasks” (e.g. Tasks is one of your table name), you could light fast save important data to your base, check it out on App Store if you’re interested! Download link: https://apps.apple.com/us/app/airkit/id6737947295A detailed introduction of why you will need AirKit:The traditional Airtable mobile experience can be frustrating. Navigating through multiple databases and tables takes time, and adding new records feels like a chore. AirKit solves these pain points with two powerful features that transform how you interact with your Airtable data.Lightning-Fast Record Creation- Add new records instantly through Siri- Use Spotlight search to quickly locate your target table- Skip the lengthy loading

Hi all,As some of you know, CSV Getter is a data export tool designed to work with Airtable.A prime use case is the Airtable/Excel sync. Ensuring your workbooks are easily refreshed with live Airtable data. I wanted to make a 2025 update of how straightforward this is. The platform has come a long way thanks to great feedback from Airtable users on this forum.Check it out on YoutubeAnd if you have any questions, fire me a message or check out the CSV Getter docs.

We’re excited to announce our first Airtable App → :sparkles: SQL Console :sparkles: Install the app in your base and you’ll be able to query your Airtable base using all the power of SQL - right inside Airtable. Backed by a Postgres database and featuring complete syntax highlighting with autocomplete - no query is too complex. You can JOIN, UNION, and SELECT without ever leaving Airtable. If you are coming to Airtable from Microsoft Access or looking to quickly create views or calculate metrics from across your base using SQL, then this app is for you. Use the SQL syntax you already know to work with your Airtable data. You can install the app and start using it for free right in the Airtable Marketplace: SQL Console If you’re curious about how it all works, check out our docs: Airtable App - Sync Inc Docs It’s our first Airtable App release, so we’d love to hear what you think.