Show and Tell

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

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 fields let 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 fields const emailFie

Fixed! For a bit more of a ‘domestic’ application: Airtable Allowance and Chore Tracker - Airtable Universe Keep track of chores done, money earned, and money spent by "Bank of Mom" with mobile-friendly forms and views. ​ Spreadsheets only go so far. ​ This... Since Airtable allows its forms and gallery views to be easily accessible on mobile phones, it’s a lot easier to give the kids credit for chores done. Inspect the work, whip out your phone and fill out the ‘Chores Completed Form.’ Likewise, if they spend money (or if you have older teens with their own checking accounts), you can easily record when they purchase something via “Bank of Mom” or if you transfer the money. The kids can view their individual balances via a custom ‘gallery’ view. Can add kids, change the chores list and payouts, etc. to fit your family. A lot easier than a spreadsheet.

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 table Automation: Triggers when attachmen

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 receiving the fil

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/id6737947295 A 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 ti

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 Youtube And 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.

*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 bar In the menu bar, navigate to File>Add to Dock... In the dialog box that appears, enter the name of your web app in the upper space and paste the full URL into the lower space. Click "Add" to add a shortcut to the web app to your dock. (It will also be added to Launchpad.) Opening the we

Hello :wave: Over the years I’ve discovered you can do all sorts of amazing things with Webhooks. …and with Airtable introducing their native Webhooks feature, it just removed a bunch of “hoop jumping” pain that was required for me to get my data into Airtable :star_struck: With this post I wanted to do a quick walk through of how I use the new Airtable Webhooks feature with native Webflow forms. Now, I can submit my Webflow forms directly into Airtable without using services like Make, Integromat, or Zapier :exploding_head: Let’s build! Setup Airtable Standard stuff here. New Airtable base with a “name” column in it. Automations Flip over to the “Automations” tab. The Magic Here’s the magic :star_struck: Our new Webhook trigger. I copy the new Webhook URL to my clipboard. Webflow Form I create a generic Webflow form. Nothing special here. With the default form block I get a name and email field. For this quickie run through, I blow them away and just leave the forms submit button. Nex

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 "Summary Table" let summaryRecord = await summaryTable.selectRecordAsync(record_id, { fields: ["Source Table", "Source View", "Field", "Value"] }); if (!summaryRecord) { console.log("Record not found in Summary Table."); return; } // Load fi

Hi Airtable Community, I urgently need clarification on the best Airtable plan for selling templates. I recently had a video call with the Airtable team, but my main concern wasn’t fully addressed, and I need to make a decision ASAP since I’m actively selling a product. My situation: I’m creating and selling Airtable templates that my clients should be able to fully edit—entering data, modifying records, updating menus, etc. Essentially, they need to use the template independently within their own workspace. I know that the Teams plan does not provide this level of flexibility, so I need to determine whether the Business or Enterprise plan is the right fit. While I have pricing details for the Business plan, I still don’t know the monthly cost of the Enterprise plan. My question: Which plan allows me to sell templates where my clients can fully edit and use them within their own workspaces, starting from my initial setup? I would appreciate a clear and direct answer, as I need to final

Hey everyone! We are organizing monthly Airtable meetups in Mexico City If you are around, feel free to come! https://lu.ma/zre49y4z

This is less of a Show and Tell and more of a "check out this cool resource." I found myself wanting to brush up on my RegEx in response to an ask for help on the forums. I found RegEx One to be an incredibly helpful site/mini-course, whether you're learning RegEx for the first time or just wanting to get some practice in. Enjoy!

Hey all, I just wanted to share our new Filters Feature for Shareables , a tool for turning Airtable data into customisable templates that you can embed on any website. You can now add client-facing filters to all templates, to extend the functionality for users interacting with your data. Filters come with a variety of customisations: Different styles for filters (dropdowns or tags) You can toggle each filter's style based on what suits the layout and design you're going for. Filters and their labels also have the standard text and color styling Alignment and Sizing Filters can be aligned Left, Center or to the Right of the content and you can adjust the overall filter sizing as well Choose between multi-select and single-select for each filters P.S Search Bars are also coming very soon as well! Shareables is free to use! All you need to do is, head to www.shareables.ai Choose a template that you can plug your Airtable data into. Use the editor to customize it to fit your needs. When

Here's a Tampermonkey script that'll let you set the colors of the columns! (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, as well as the opacity when hovering over the row / having a cell selected: const opacity = 0.4 const colorMap = { "fldI5EIoOG25a85F7": { r: 255, g: 224, b: 204 }, "fldxj4ka7M2FwkJAP": { r: 207, g: 245, b: 209 }, "fldAPHkUW98PsaZV3": { r: 255, g: 234, b: 182 } }; I've placed instructions on how to get the field IDs and RGB color codes in the code itself. Let me know if there are any bugs and I'll get them sorted! I've also got another script that lets you customize the headers itself in this other forum post --- // ==UserScript== // @name Airtable Column Colors // @namespace http://thetimesaving.company // @version 22-Jan-25 // @description Changes the column color in

Hey everyone. Exporting Airtable manually as CSV and saving to Dropbox can be quite manual for an important systematic process that needs to happen regularly. In addition, enabling it with tools like Make and Zapier can also be fiddly. Here is a way of doing it in one click, all in one platform: https://www.csvgetter.com/blog/export-airtable-to-dropbox Let me know what you think!

Hi Airtable Community! 👋 Courtney Lall here and I’m excited to invite you to our next Onboarding Office Hours , happening February 12th at 10am PST. These small-group, virtual sessions are designed to help new and existing users explore Airtable's onboarding resources, ask questions, and get expert advice to ensure you're set up for long-term success with Airtable. 🚀 ✨ What to Expect: A recap of recent, important Airtable news and announcements A guided walk-through of essential onboarding resources A hand-picked best practice for building your app in Airtable Open Q&A where you can ask questions and get tailored advice from an Airtable Onboarding CSM (aka, me!) Practical tips and recommendations to help you unlock Airtable's full potential 💡 Have Questions? Submit Them Now! Help us make the session as relevant and helpful as possible by posting your questions in the comments below. This will be where our Onboarding Office Hours session starts—so posting your question here is the be

Hello! Powersave - a chrome extension that allows to save to Airtable right from the browser, should now display a rich text editor for all text fields which have rich text formatting enabled. You can use markdown shortcuts in the editor and all Airtable markdown subset features are supported - bold text, italics, links, lists, headers, even checklists. Powersave can also update records as you browse so this can effectively be used for content management... I'm using it to manage content for my website as I click around now. But you can also use it for content audit, for example checking checkboxes on different pages. Happy to hear any feedback on this!

Hi everyone, I’ve been working on an overengineered but functional solution to send SMS reminders for my school’s classes. It’s a little unconventional, but it works for now! I’d love to hear any feedback or suggestions for optimising it further, especially from anyone with experience automating communications through Airtable. The Problem:We have hundreds of students across dozens of classes every day, and sending SMS reminders manually is no longer feasible. Hiring a communications manager isn’t in the budget yet, and solutions like Twilio are not cost-effective for us in New Zealand. The Current Workflow: Airtable as the Data Hub: Airtable stores all our class schedules, student rosters, and contact info. An automation sends an email 8 hours before each class, containing: The subject line: Key details like the class time, group name, and teacher. The email body: A list of student phone numbers. Generating SMS Content with ChatGPT: The email triggers an iOS Shortcut that: Extracts th

Hi, After spending 20 years in the Salesforce community, I have moved on and have become enamored with Airtable. I am getting started in being an active part of this community and am sharing my efforts at scotthemmeter.com. I wanted to share my latest blog post which provides a workable example for obtaining Crypto prices from the Coinbase Pro API and populating it into Airtable. See the link below. https://scotthemmeter.com/2021/09/28/get-crypto-prices-with-airtable-scripts/ Hope you like it! Scott

I'm building a database for students in college. So the main table has Student ID, Name, Course 1, Course 2, Course 3, and so on, up to the highest number of courses a student is taking. I then want to create individual tables for each row in the main table in which I could report on student's progress in their respective courses each semester. Eventually, I want a reporting table with progress updates from all students that I can sort using semesters to report on students' progress in different semesters. I thought this should be the easiest thing to do but I have not been able to accomplish it. Can anyone point me to a guide or explain the main steps to do so. What are the limitations to this approach and is there a better way to do so?

I'm trying to use the trigger function in Airtable to determine the webhooks module in Make.com, but it's not working. I'm using the paid versions of both Airtable and Make.com. Interestingly, the same functionality works perfectly on another page in Airtable. I have no idea what the issue could be. What should I check to resolve this problem? Please help me.

The automation currently we are using only works on new records. Is there any way to push the automation to run on existing records in the same table? Right now, when form received, it will create new record. Goal is when form received, it will auto fill out the existing records in the table. Appreciate your help. Thank you!

Hey all! Wanted to share something we built: a plugin for connecting Gravity Forms to Airtable. Gravity Forms is one of the more popular form builders in WordPress, and we (Gravity Wiz) build plugins for Gravity Forms (yes, plugins for plugins, inception). If you build using Gravity Forms, this Airtable connection lets you send Gravity Forms data straight into Airtable and use Airtable's features with that data. We wrote a blog post about the connection here. If have questions, hit me with them. And I'd love to hear if there are any Gravity Forms builders in here. 😄