The show and tell space is a place to showcase your work and have conversations about what you’ve been creating in Airtable.
Recently active
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 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
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.
*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
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
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.