Show and Tell

*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... 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 Launchpa

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 submi

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

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 finalize my

Hey everyone!We are organizing monthly Airtable meetups in Mexico CityIf 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 stylingAlignment and Sizing Filters can be aligned Left, Center or to the Right of the content and you can adjust the overall filter sizing as wellChoose between multi-select and single-select  for each filtersP.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.aiChoose a template that you can plug your Airtable data into.Use the editor to customize it to fit your

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-dropboxLet 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 announcementsA guided walk-through of essential onboarding resourcesA hand-picked best practice for building your app in AirtableOpen 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 q

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 the subject l

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

I'm starting to get really good at the scripting thing and am really having fun with this platform. If you aren't paying for the upgraded plan to be able to use scripting, you should consider it. There are so many things that I have been able to fix or create that I couldn't with the general platform for general tasks.As I am building up a large number of automations, I sometimes have difficulty remembering what I may have done 2 weeks ago, etc. I have a paid ChatGPT account and asked it to document my code and to put it into dokuwiki format so I could host it on our wiki page for other team members to help debug, etc.It's pretty incredible how well it does it.  You can see the output here: https://wiki.chattlab.org/code_breakdown for one of the sample cases.In another case, I asked it to look at the code and make a text based flowchart of it, and it gave me the block below.  It's such a great tool to help document code and find issues.Start | v Load Inputs (Rec_ID, Meeti

Hey all! A few months ago I posted about the tool I built that lets you customize and embed Airtable data on any website.I've implemented the feedback I got from here (Thanks again!) and am excited to share a new template that lets turn Airtable records into a Logo Slider.This template is a great way to showcase logos from customers.You can:Adjust the speed of the sliderTurn the logos grayscale or colorPause the slider on hover (this can be turned off)Add hyperlinks to the logos >> This is done via the action menu in the sidebarThe template is free to use!All you need to do is, head to www.shareables.aiChoose the Logo Slider template that you can plug your Airtable data into.Use the editor to customize it to fit your needs.When you're ready, install the iframe into your websiteAll feedback appreciated!Here's an example of the slider (and demo here too)  

Hey Airtable community! I'm new to Airtable and still learning all the ins and outs. I'd like to create a grid view (for my leadership) that pulls from multiple grids across different bases. Is this possible? If not, is there another way to think about solving for this use case? Appreciate the help!Sarah

A question arose recently that’s come up a few times in the past: is it possible to give form users the ability to either pick an item from a predefined list or add their own “other” option, and have manually-added options actually appear in the list for later form users? For most of Airtable’s existence so far, this wasn’t possible (at least not without delving into the API, and even then I’m not completely sure that was doable). However, it can be done using Airtable’s automation feature. Here are two methods you can use: Method 1: Single Select Field Most of the time this question comes up, the user is probably thinking of using a single select field. While this will work, it comes with a couple caveats that actually make the second method preferable IMO. That said, some of the details that I share here will also be used in the second method, so I still recommend reading through this one. First, define your single select options as you wish, with an option named something like “Othe

Hi Airtable Community! 👋Anisha Prema here and I’m excited to invite you to our next Onboarding Office Hours, happening January 14th at 10 AM 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 announcementsA guided walk-through of essential onboarding resourcesA hand-picked best practice for building your app in AirtableOpen 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 qu

Hi, I'm trying to create the same table that's pictured, but I am unsure of how to create the "header" in the first row circled in red (see pic). 

Unlock the full potential of Airtable with Voice-Prompt.io, the ultimate voice intelligence platform that transforms your spoken commands into powerful, AI-driven actions.🎥See Voice-Prompt.io in Action: Watch the DemoSay goodbye to manual data handling and hello to seamless, hands-free operations!🔊Effortless Voice Navigation – Move between tables, views, and records without lifting a finger.🛠️️ Instant Table & Field Creation – Build and customize tables on demand.📊Real-Time Data Insights – Generate interactive charts and visual reports in seconds.⚡Boosted Productivity – Automate workflows and eliminate repetitive tasks.🤖AI-Powered Efficiency – Context-aware voice commands tailored for smarter operations.Whether you're a busy professional, a data-driven team, or simply someone who values convenience, Voice-Prompt.io is designed to supercharge your Airtable experience.🔗Join for free today: voice-prompt.io#VoiceTech #AI #Aut

Visit the resource hub here: https://shortcuts.sequentialroutine.com/resourcesHi friends, we're excited to share something new with all of you! 🎉 We've just added a dedicated Resource section on our website, designed to gather the most common and useful resources for Airtable users like you. Our goal is to make it easier for everyone to find helpful tips, tricks, and tools that can enhance your Airtable experience.We'd love for you to check it out and let us know if there's anything we've missed or if you have other resources you'd recommend adding. Your feedback would be incredibly valuable!Feel free to dive in and explore, and while you're at it, visit our homepage for more details. We're always looking to improve and make things better for the community.

Hello Airtable community, 3 years ago we published the first version of Pro Backup for Airtable (see original post). Since a lot has changed since our launch I thought I'd give on update and tell what has been improved in the last year. What has been improved since the launch? Our integration is now available as an official integration on the Airtable app marketplaceThe User interface has been redesigned and rebuilt from scratch making the experience more intuitive & faster.You can now manage the backups of multiple SaaS apps within one Pro Backup account.The Backups page now allows to easily compare versions for reach record / data type: For example you can easily compare the versions of each of your tables, comments & field configurations.Improved restore capabilities: It is now possible to restore entire tables but also to perform more granular restore requests such as restoring a specific field or comment back to the existing table. Improved click-t