Show and Tell

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. Thi

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 config

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

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 defaul

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 follo

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

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 imported

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 innovati

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:

(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

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

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 

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 t

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,

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

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 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. Th

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:

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.

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 t

*Original post has been updated to include a few more notes and screenshots*If you prefer working in the Airtable desktop app and wish you could create shortcuts that opened a base or interface in the desktop app instead of a browser window... I have somewhat of a workaround.The desktop app is essentially a web app. You'll be creating your own web app(s) using Safari 17 or higher. This method will require a Mac running Sonoma or Sequoia. Log into Airtable on Safari and navigate to the desired base or interface page that you want your web app to open to. (You'll be creating as many of these as you need, each opening to a specific base & table view or interface page)Copy the full URL in the address barIn the menu bar, navigate to File>Add to Dock... 

Here's something I created using automations with a script to allow me to get quick totals on any table view for specific values. I have 2 cases listed below and have found it to be a great way of collecting totals without having to create other linked records, rollups etc. Of course I have to hit the recalculate checkbox to get my total for each row, so it's not live, but I can live with that.  Also, you have to make sure your references are correctly spelled (Source Table, Source View, etc).  I hope others find it useful. I've attached the javascript below.let inputConfig = input.config(); let record_id = inputConfig['SummaryRecID']; // Reference the "Summary Table" let summaryTable = base.getTable("Summary Table"); // Fetch the specific record in