Show and Tell

Hi everyone! We're excited to share our latest iOS Shortcut that simplifies the process of saving email attachments directly to your Airtable database.As avid Airtable users, we understand the importance of streamlining data management tasks, especially when it comes to organizing external files attachments. Our new iOS Shortcut bridges the gap between your email client and Airtable, making it easier than ever to store and access important files.Here's a quick overview of how this iOS Shortcut can help you:1. Seamlessly save email attachments – With just a few taps, you can save email attachments directly from your iOS email client to your designated Airtable table and field.2. Customize your data organization – Specify the target table and field names for each shortcut, ensuring your attachments are always stored in the right place and in the format you prefer.3. Save time and effort – Eliminate the need for manual downloads and uploads, as the shortcut automatically transfers email a

Hi, Below is my airtable base.I have grouped the records on basis of my product. I want to find the average of qty in each group. The average should be such that total of all qty in a group divided by no.of.rows in that group. How can i do this on Airtable? For eg - THe average of first group is 68/8 = 8.5 

I have 2 questions to ask:1st being this:I have 2 tables:1. Revelator Sheet Data2. Client InformationThe "Revelator Sheet Data" table holds the music assets of the clients belonging to our business. To map the assets to the clients (in the client information table) I will use the "payee_id" which is present in both "Revelator Sheet Data" and "Client Information" tables.But I can only link 2 tables with primary fields. The "Client Information" has "Client ID" while the "Revelator Sheet Data" has "Id" as the primary fields. So, when I linked the "Client Information" table to"Revelator Sheet Data" table using client_id, how do simultaneously match the payee_id?For example: Above is the Revelator Sheet Data table. I have linked the client information table using client_id. Now I want that if "Payee id" (in Revelator Sheet Data) and "Payee ID" (lookup field from client information) are similar, the client_id is mapped automatically ie I basically want to map client id based on pay

I am aware that you can pick and choose which fields you want visible in a synced base. However, if you already synced a base, but want to limit the fields that are visible is there a way to do that without having to reupload the base?

TL;DR: add a "hello world" script if you want a "condition not met" to end your automation instead of cause it to fail.I created a base for another team in which I'm collaborating with them, and for each record that is created in their base, if it is assigned to me, I want to create it in my personal base via automations.The Find Records approach of identifying the collaborative record that was created and re-creating it in my base was straightforward, but capturing updated collaborative records assigned to me and re-updating it in my base was a bit trickier, as "Find Record to Update" may return zero records, if the collaborative record is assigned to someone else, causing the automation to fail.To get around this failure, I added a Run Script step for the condition in which the length of Find Records = 0, and the script is simply:console.log("Hello, world!"); This way, the automation will always successfully run, even if the collaborative record is assigned to someone else.&nbsp

Check out the guideWe've just published our first of many technical Airtable guides on Mass. This one is our holy grail for automated field copying and building junctions.No scriptsNo duplicates everImpossible to break (you should try)Crack open the demo base in the article and try for yourself.   

I am the Technology Manager for Companion Health. We are a medical practice currently utilizing Airtable. We recently had one of our employees accidentally remove one of our client records which resulted in me having to review a snapshot and pull the data back in.I would like some advice on what I could do to ensure this is prevented as much as possible.Also is there better backup methods for client data other than the snapshots taken in Airtable?

Hello, Airtable community!I'm excited to share a project we've been nurturing at Boltflow: AIRinsights. It's our humble attempt to enrich how we all interact with our Airtable databases by enabling quicker, smarter access to insights.About AIRinsightsWe understand the value of data in our daily decisions and operations. With AIRinsights, we aim to simplify accessing and analyzing Airtable data, offering a way to get immediate, actionable insights from your queries, without the need to even access Airtable.Questions like:"Which products sold the best last quarter?""Access Marketing Base and Finances Base and calculate which campaign holds the highest ROI this year.""What tasks are most overdue, including details on ownership and deadlines?"...can now be answered swiftly, as if you had an analytics manager by your side.Beta OpportunityWe're introducing AIRinsights in Beta and warmly invite this knowledgeable community to be among the first to explore its capabilities.Interested? Please j

🚀 Exciting News for DareTable 2024! 🌟Join us in New York City on October 25-26, 2024, for DareTable 2024, the ultimate Airtable user conference. Come to NYC to be inspired by enterprise leaders, experience Airtable AI, and network with fellow Airtable users. Secure your spot today—only 300 tickets available!Highlights:🎟️ Ticket Information:Early Bird: $450 (Until May 31, 2024)Regular: $650 (Starting June 1, 2024)Door: $750 (Starting September 2024, if available)🤖 Special Features for 2024:AI-focused sessions and enterprise-level discussions.The introduction of the Consultant Program, enhancing networking and visibility for consultants. Learn more and sign up here!📢 Call for Speakers: Our speaker application is now open! Apply here to share your insights and stories. Multiple speakers are already announced on the website! New tracks for this year are:Enterprise & Business [NEW]Airtable AI [NEW]🤝 Join the Volunteer Program:Dive int

We needed a "quick" way to see that a calendar entry was canceled (in the label, which is a text field named "Short Name") without typing it. (We use a check box to "cancel" the event) Forgive me, I'm new. This may not be the most elegant way of doing this, and I may have missed something I built an automation that when the check box is modified, AND the value of the checkbox is checked (a FIND table with that conditional and the Airtable ID as the record output) THEN run a script to update the text field (because putting the text and the field was not working in the non-script format) I added input parameters of recordID (the airtable ID from the find field) and xText which is the existing text in the field "Short Name" the script looks like this:  let table = base.getTable("Productions_calendar");let config = input.config();let recordID = config.recordID;let xText = config.xText;var c = "Canceled: ";c += xText;let query = await table.selec

Hi we're long user of Airtable, but the iOS application has long loading time, also the official Airtable Web Clipper doesn't work in mobile devices. To miss that gap, we made several iOS shortcuts.To give you a better idea of how these iOS Shortcuts can ease your mobile data management, we've created a short demonstration video. Watch the video below to see how easy it is to capture web content, save images, and input text using Airtable iOS Shortcuts.Capture web content with ease – While browsing the web in Safari, simply activate the Airtable shortcut to save the page's URL, title, and selected text to your designated table and fields. Just like using Airtable Web Clipper on iOS!The shorcut in the demo works 100% well, and there is no any privacy issues. If you're eager to start using these shortcuts along with other 10+ Shortcuts in the Library, please view our site to get them, thanks!

I wrote a tampermonkey script to customize the width of the Sidesheet in the Interface for myself, inspired by this feature request, figured I'd share it in case someone found it usefulAnd here are some examples of what the UI looks like at different widths:Width Screenshot 680px (default) 800px 1000px You can customize your width by just modifying the value of 'sidesheetWidth'.  Main caveat is that we lose the nice animation of the sidesheet sliding in and out thoughTo use the script you'll need to install Tampermonkey as a browser extension (https://www.tampermonkey.net/) and then just paste the script below inBug reports welcome!  I threw this thing together as a fun side project; tested it a bit and seems to work fine, but there are very probably things I've missed! // ==UserScript==// @name Airtable Sidesheet Width Customizer// @description Set custom sidesheet width// @author Adam - The Time Saving Company// @match https://airtable.com/*// @gr

Hi friends, I am reaching out to inquire about your most frequently used features on the iOS Airtable app. Currently, I am in the process of developing an iOS Shortcuts library aimed at simplifying the usage of Airtable on mobile devices. The library already includes 9 shortcuts, already implemented Web Clipper, Save Image,  Save File, Clip Social Media Content, they allow people automate the process of creating new record in Airtable. But I am seeking input from the broader audience to determine the next steps for its development. If you have any suggestions or insights regarding your most utilized features or if there are specific functionalities that would enhance your experience with Airtable on iOS, I would greatly appreciate it if you could kindly share them with me. In return for your valuable input if it's adapted, I am offering free access to the library as a token of my appreciation for your contribution.Your feedback will be instrumental in shaping the future enhancemen

Hi Airtable Community,  is it possible to filter the shown Data in an Interface dynamic by user groups and if yes, what license do i need for this?  Thank you and bestMirko 

Hi we're long user of Airtable, but the iOS application has long loading time, also the official Airtable Web Clipper doesn't work in mobile devices. To miss that gap, we made a Comprehensive iOS Shortcuts Library for Airtable.To give you a better idea of how these iOS Shortcuts can ease your mobile data management, we've created a short demonstration video. Watch the video below to see how easy it is to capture web content, save images, and input text using Airtable iOS Shortcuts.Capture web content with ease – While browsing the web in Safari, simply activate the Airtable shortcut to save the page's URL, title, and selected text to your designated table and fields. Just like using Airtable Web Clipper on iOS!Save images on the go – Quickly add images from your photo library or camera to your Airtable database, making it easy to organize and access visual assets  Streamline text input – Effortlessly transfer text snippets from any app to your Airtable fields, elimi

Hi we're long user of Airtable, but the iOS application has long loading time, also the official Airtable Web Clipper doesn't work in mobile devices. To miss that gap, we made several iOS shortcuts.To give you a better idea of how these iOS Shortcuts can ease your mobile data management, we've created a short demonstration video. Watch the video below to see how easy it is to capture web content, save images, and input text using Airtable iOS Shortcuts.Capture web content with ease – While browsing the web in Safari, simply activate the Airtable shortcut to save the page's URL, title, and selected text to your designated table and fields. Just like using Airtable Web Clipper on iOS! Save images on the go – Quickly add images from your photo library or camera to your Airtable database, making it easy to organize and access visual assets Streamline text input – Effortlessly transfer text snippets from any app to your Airtable fields, eliminating the need for manual copy-an

HelloI am in the Northern Rivers region of NSW Australia and am looking to find people to help with extra integration with Airtable.Firstly using air table automation and gmail. The maybe further integration with wix shop sites and LinkedIn. is there a way to integrate with less cost than a service like Zapier?Regards -Tom

Hey folk! Joel here the founder behind Paytable 👋We're working on something new to visualise Airtabl e that gives you the full editable code you can embed or use on any site builder, LMS or tech stack called basefront app. So basically input your airtable creds and the generator creates a frontend which you can apply custom css and all the good stuff like tweaking the code to add webhooks or whatever you like.More about it here: https://x.com/J__Rosen/status/1773027720731013221?s=20Hoping to launch with the next few months:Check it out https://basefront.app 

TLDR: i built something that syncs all the pages from your websites sitemap to an airtable base and keeps it up to date---In the last months I've been more involved in marketing at our company. The first thing I noticed is that outside of the CMS we don't have an overview of all the pages on our website. This makes it hard to answer simple questions like:- what are the newest 5 pages on our website?- how many case studies do we have published?- what's the most outdated/last outdated page on our website?We're using contentful in the background and I know I could log in and look for published pages, but even then some of those questions can't be answered without setting up filters and understanding the content model.As a long term airtable fan I wanted to coordinate all the marketing work (todos, reviews, new content) in an airtable base. With the power of interfaces, forms, views I could set up a great workflow to keep track of our efforts.Turns out that if you have over 100 pages

I have created a table with days off of the team. BUT for instance a person takes 2 days (22-23//24) the airtable count it as 1 day. Is there any other way to count is as 2 cuase actualy the person will be off 22 and 23.Thank you

Hi, Myself and another team member are on the business plan and under the same domain. I have an option of sharing just an interface but another team member under my same business plan and domain cannot.  When they try to share just an interface, it's saying, they need to be on a paid plan. However, they are, they are on my business plan.Any help/guidance is greatly appreciated. 

Hi everyone!Here's a new application I just made with Airtable: a meeting room booking system for offices.  This has two interfaces: one for front end users to reserve slots in a room for their meeting; another for back end users (receptionists, assistants, etc) to organise and reschedule meetings on request.  The back end interface also includes a calendar for public display so that people can easily see where and when their meetings are scheduled, and what rooms are currently free.Using the "repeating group" function in automations, slots are wiped at 1am each day and reused for the day after tomorrow.  This means that at any given time users can book slots either for today or tomorrow, with no further back end configuration, i.e. no need to create new records each day.Available here: https://amazingairtable.gumroad.com/l/mtgrm 

Hello Airtable Community,For this particular task, I need to audit hundreds of pages and I want to link those pages in this task. I have a tab for our URL master list linked in the affected URL column. Is there a more efficient way to do this rather than adding the affected URLs manually?