Show and Tell

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

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.

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 code 002. Because it’s the first of its kind, its full combined code is 002-1. If we then introduce a third variant of product 001, it would end up with a comb

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.Original Solution:Each Team had a synced table (Table B) of the Table A in their Team Base. They had created a field (Field A) in Table A as well as a "duplicate" editable field (Field B) in the Table B. A new synced table (Table C) in the Main Base was created, synced from Table B. Finally an Automation would run to edit

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:   

👋 Hi all - wanted to share something I thought you might enjoy!We just launched Whalesync 1.0 - the easy way to 2-way sync Airtable with your CRM, DB, spreadsheets, and other tools.https://whalesync.com/Hundreds of fast growing companies, like Webflow, Descript, and Clay, use us to bring the power of Airtable to their other apps with true 2-way sync.Popular use casesWhen you can two-way sync Airtable with your other apps, you basically unlock super powers. A few pretty awesome use cases include:Creating programmatic SEO pages in WebflowUpdating leads in HubSpotConnecting project teams in Notion/Google Sheetshttps://www.whalesync.com/connector/airtableTools you can 2-way sync with AirtableWe support >15 connectors you can two-way sync with Airtable includingGoogle SheetsNotionSalesforceHubSpotZoho CRMSupabaseMS DynamicsWebflowTry it outWe have 2-week free on all our plans which you can try out here -> https://app.whalesync.com/If ever have any questions, also fee

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 PDF Maker to test it yourself.As always, feel free to reach out with any questions!

I built directly in Airtable a way to let users schedule an automation run at a certain time with unlimited time options, e.g. "run a send an email automation on X day at Y time" where that datetime is infinitely dynamic (great for situations where the regular "scheduled an automation" doesn't work).Typically this use case is when you need some kind of "job queue" or "message queue" system that is handled in most traditional software development with cron jobs and message or event streaming queues like Sequin, Kafka, QStash, RabbitMQ, etc (or in the Airtable community, with Make.com automations). But I wanted to build this natively in Airtable with no dependencies on external tools to keep it really simple. Airtable's fastest "cron job" is 15 minute intervals so that doesn't work by itself. Being a set interval, it's also not relative to the scheduled time so theoretically it could create up to a 14 min 59 second delay.So below I'm sharing my first iteration quick test o

Hey all,we've just added a Mailchimp connector to https://syncgrip.com, our integration platform that connects Airtable with other apps. It will allow you to manage your Mailchimp audiences straight from Airtable via real-time, two-way data syncing.Here's a short demo taken from BuiltOnAir podcast last week, where we showcased Syncgrip.It takes <5 mins to get started and we're still in free Beta, so give it a try!

Hi there!I am thrilled to officially announce the release of Air WP Sync for WooCommerce, the ultimate plugin for seamless WooCommerce management and synchronization with Airtable.Discover it now!Building upon our legacy of innovative solutions like Air WP Sync – Airtable to WordPress, WP connect is evolving to offer a powerful tool for E-commerce business. This new plugin is not just an addition to our suite; it’s a leap forward, offering a more sophisticated, feature-rich platform for online store management. 🛠️  Key Features✅  Support for Simple, Variable & Downloadable, External/Affiliate, and Grouped Products✅  Seamless integration with ACF and the 4 major SEO plugins✅  Manual & Recurring Syncs per connection (with Instant Sync via webhook coming soon!)✅  Real-time orders synchronization✅  Expanded support for posts, pages, and custom post types✅  Downloadable logs for each connectio

I need to pull some data from a computed field (actually a filtered lookup field) in Airtable to prefill a form in Jotform. It should be easy as Jotform have introduced the feature (bizarrely under the publish menu) but despite several ways of trying, it will not map to computed fields.My inteded workaround is to map it to a long text field which an automation would update with the value from the lookup field, triggered if the lookup field is not empty. On mapping the fields in the automation, Airtable greys out the lookup field {Instruments} reporting the same issue as occurred whilst trying to mp directly from Jotform, that the field cannot be used because it's computed.I've spent a whole week on this. I've tried converting to text, using a string, an array, and concatenating, but of course, they all need computed fields to hold and reference them.  Anyone know a workaround? Post edit/after thought....Perhaps I can use a script with the same trigger but I'm not really a scr

 Hi guys, Overwhelmed with all the invoices, payments and accounting entries you've got to do manually? Then this is for you! This 👉 new demo video 👈 is a sequel to a first video I had recorded on the topic of invoice management automations. This one will more specifically show you:the integration between Airtable and an accounting software (Pennylane)payment links sent through Stripe and automatic payment updatesSlack notifications when a teammate comments on an invoice This set of automations had my client save 5 to 7 hours a week (yay!). If you have improvements to suggest, I'm all ears. Take care. JBJ🌊Keep the Flow (👈 to see the first video on the subject and other demos)

Wasn't really sure what I was trying to ask here, so hopefully someone understands what I am trying to achieve1We are building a custom CRM for a Financial Planning Business - probably 80% of the way there, just working out the last bits.Where I am getting unstuck - we have client attached to a client group (thing husband and wife) and we have their investment accounts linked to them. Some providers have a unique Client ID and then can have multiple underlying accounts linked to that Client ID.Currently we have a Client Group Table, Client table (for the individual members), Platform Client ID Table (to link the members to their unique ID with any providers), and a Platform account table (where individual accounts are linked back to the unique Client IDs).This all works great, until we have an account that is owned jointly between members, and we end up with a double up (and the value is counted twice).I have looked at so many things:- trying to have it group by three ways, primary cli

Hello,A few weeks ago, I created an interface by a layout where I could display all my datasets from Table (1) as a Record List on the left side. On the right side, I could flexibly arrange the data from the table as well as insert data from another Table (2) that is linked to the records of Table (1). (See screenshot)Recently, I can no longer find this layout configuration. Either I select Record Review but then I can only insert the data from Table (1) and only the direct linkage from Table (2), and that too can only be arranged in groups.OrI select Blank Layout, and here I can only insert a Record Picker but no Record List on the left side.Was there an update to interfaces and this layout is no longer possible, or how can I now create an interface that is set up exactly like the one in the screenshot I attached?