Show and Tell

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

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 s

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.

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

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💡 H

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

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.

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-friend

i created the sample project  the hello world when ever i visit https://localhost:9000  its gives me a whole project files in the browser instead of hello world any idea what it could be  ?im attaching the screen shot for referencewell im trying to create a custom extension

Summary This setup allows Airtable to automatically number collections of items that may not be in sequential order. Item length can be either fixed or variable, with only minor changes needed to the core system to accommodate the latter. Example To borrow from the thread that inspired this endeavor, say you’re building product codes that have a variant sub-code, and want that sub-code to automatically increment each time an item of a given product code is added in a new record. However, it needs to auto-increment each product’s sub-code separately, even when product codes are added out of order. For example, the first product code is 001, and its initial sub-code is 1, so the full combined code is 001-1. When you add a new variation of product 001, the sub-code bumps up by 1, creating 001-2. Now a new product is introduced with

My company uses Airtable to join multiple tables, calculate statistics, and automate the linking of values between linked fields in different tables using the "Run Script" automation feature. Occasionally, we encountered failures due to the 30-second execution time limit for the "Run Script." However, starting in December, the limit was extended to 60 seconds, which has effectively resolved this issue. We are grateful for Airtable's continuous efforts to improve its performance.

Hi! here's a formula that I used for tracking progress in a rich text field, maybe someone will find it useful, cheers!( (LEN({Checklist}) - LEN(SUBSTITUTE({Checklist}, "[x]", ""))) / LEN("[x]") + (LEN({Checklist}) - LEN(SUBSTITUTE({Checklist}, "[X]", ""))) / LEN("[X]") ) / (LEN({Checklist}) - LEN(SUBSTITUTE({Checklist}, "[", "")))https://www.linkedin.com/feed/update/urn:li:activity:7266910744263168000/

Hi All! My name is Leah Ackerman and I work on the Education team here at Airtable. When I joined the team earlier this year I decided to move my book review tracking into Airtable as a way to help myself become more familiar with the product (you can see the public interfaces here and here). As a tribute to Spotify Wrapped, I decided to create my own version using my app, so thought it would be fun to share here as well 🙂 Maybe a bit of a deviation from the typical use case, but IMO still worth it. I've attached some screenshots, but you can see the whole thing here - it's just over two minutes long. Happy viewing!  

Ever run into an issue where you need to edit a record in a synced table, but the origin table is also a synced table?Well, here's a workaround solution. Let's start out with the specific use case I ran into...I was working with a table (Table A) in a large base (Main Base) that was receiving it's initial data from an Email sync. That data was being accessed by several Teams and each team had their own workflows in Team Bases. Each Team had specific data points they needed to edit in the Main Table, based on data in their Team Base. They needed a way to utilize their Team Base data to edit the Main Table.

Hey all,If you are not familiar with csvgetter.com it is a super powerful platform for performing operations like automatically exporting Airtable to Google Sheets. I have made a quick Youtube video to demo the Google Sheets example:https://youtu.be/mU2my6U3vZUCheck it out for an interesting watch!

I don't know if this is actually that revolutionary, but I struggled to find examples on the forum but couldn't find one, but I was able to come up with a thing that works. Sharing this, it'll either be "duh, we all know that", or maybe something that others haven't done yet, my bet is on the former.I have a form that people post URLs. I want others to be able to click on that link on other forms.I have a url field (task link) and a another formula field called ClickLinkFormula: (note, I hardcoded the label for this test)Then when I added it as a header field on the fillout form, it allows me a link that users can select:

csvgetter.com has added another powerful feature - embeddable Wordpress snippets! Dynamically (and rapidly) produce embeddable Wordpress snippets in a few clicks, custom code blocks powered by Airtable data, that slot into your Wordpress seamlessly. We demo it here!https://youtu.be/jH1qydLuYHU 

Hi all, we're excited to announce a brand-new version of PDF Maker, designed to make document creation even more seamless with Airtable! This update introduces enhanced features that will streamline your workflow and offer more flexibility in generating PDFs.Here’s what’s new:Run History: Keep track of every document generation process with our new run history feature, so you always have a clear record of past actions.Line Items (View  Selection): Select views on linked Airtable tables to apply filtering and sorting, making it easier to handle line items and rows in your documents.PDF Preview: You can now preview PDFs directly within the app without it counting toward your document quota.Want to see it in action? Watch our demo video here  or head over to