Show and Tell

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? 

Hello Airtable Community,We (iOS Shortcuts library) haveve recently discovered a new shortcut for all of us who frequently use Airtable on our iPhones. We all know the struggle of accessing our desired Airtable interface – navigating through the app, finding the right base, and locating the exact table and view we need. It's not the most efficient process.But here's some exciting news! We've introduced a free shortcut called "Pin Interface on Home Screen" that allows you to place any Airtable interface directly on your iPhone's home screen. With just a single tap, you're instantly transported to your chosen interface. No more unnecessary steps!This shortcut utilizes Apple's official Shortcuts app, which is designed to enhance the functionality of your iPhone. The best part? It’s completely free for everyone to use! Free Download Link is here!To see this in action, check out the video. 🎥Imagine having your favorite Airtable interface accessible with just one tap, right from your

I wanted to share a free little browser extension I built to solve a personal workflow issue, and I thought it might be helpful for others here too!The tool lets you save and quickly access several of your most used forms, and quickly fill those out directly from your browser's side panel. It saves time by removing the need to switch tabs, you can keep forms handy while working on something else. It works with Airtable forms and other form platforms like Fillout, Typeform, Jotform, etc.My use case was to quickly create tasks into Airtable from data in my email. I also shared it with a client of mine who wanted the ability to create contacts and tasks into Airtable, from their CRM tool. This doesn't access their CRM, but allows quick data entry on the same tab as the CRM. Features:Save and organize form links in a simple UI. All data (Form name and URL) is saved locally. No backend server is set up at my end. And it doesn't see what you're filling.Open forms directly

Hi all, I wanted to share with you the new (paid) extension that I created :slightly_smiling_face: This extension will help you batch rename attachments based on the record filed values, I created it because there wasn’t a simple way to do it in Airtable already. The extension supports custom and advanced names, for example, you can automatically name the files with a “file count” of the attachment, e.g. “file_1_of_2”. Really hope with would be handy for someone here in the future ZekTec - Airtable Extensions

Ciao a tutti avrei bisogno di aiuto per il perfezionamento di una tabella ordini cliente che mi permetta di ragguppare per cliente e poi di poter eseguire una stampa ordine su carta. Se ci sono più ordini dello stesso cliente mi compaiono nello stesso foglio di stampa grazie a chi mi aiuterà.....

Is it possible to add multiple spreadsheets at once?I have around 250 spreadsheets that we need to import for analysis. Can this be done using native functionality in Airtable, or will I need to use extensions?Knowing this information is crucial for our decision regarding the Airtable subscription purchase. If this functionality is not available, we will not proceed with Airtable.I look forward to your prompt response. Thank you!

Hey Airtable community! 👋I'm excited to share something I've been working on that's made my life so much easier with Airtable, especially when dealing with multiple tables.Like many of you, I manage dozens of tables (about 100 in my case), and finding the right table to add a record quickly has always been a pain point. That's why I started building AirKit, an iOS app that lets you create records using Siri.Here's what it looks like in action:Just say "Hey Siri, AirKit, add tweets" to add content to your social media tableOr "Hey Siri, AirKit, add ideas" for your business ideas tableNo more navigating through multiple bases and tables!What makes it special:Works with any table in your Airtable workspaceCustomizable field prompts (you choose which fields Siri asks for)Quick favorites list for your most-used tablesSeamless integration with Siri and Spotlight searchWe're currently putting the finishing touches on the app and planning to release it this winter. Register our wait li