BuiltOnAir

#airtable #on2air #builtonair 6/8/2021 - BuiltOnAir Live Podcast Full Show - S08-E06 ___________________________ The BuiltOnAir podcast is a live weekly show highlighting everything happening in the Airtable universe. Check us out at BuiltOnAir.com/join. Join our community, join our Slack channel, and see what's happening. ------------------------ SPONSORED BY On2Air - Airtable Apps and Integrations to run your business operations in Airtable Start a free 14-day trial of On2Air Apps - https://on2air.com?via=podcast ------------------------ ___________________________ IN THIS EPISODE 🎙 Our hosts today: Alli Alosa - https://www.allialosa.com/ Hi there! I'm Alli :) I'm a fine artist turned "techie" with a passion for organization and automation. I'm also proud to be a Community Leader in the Airtable forum, and a co-host of the BuiltOnAir podcast. My favorite part about being an Airtable consultant and developer is that I get to talk with people from all sorts of industries, and each project is an opportunity to learn how a business works. --- Kamille Parks - https://kamillionaireapps.com/ I am an Airtable Community Forums Leader and the developer behind the custom Airtable app "Scheduler", one of the winning projects in the Airtable Custom Blocks Contest now widely available on the Marketplace. I focus on building simple scripts, automations, and custom apps for Airtable that streamline data entry and everyday workflows. --- Dan Fellars - https://on2air.com I am the Founder of Openside, On2Air, and BuiltOnAir. I love automation and software. When not coding the next feature of On2Air, I love spending time with my wife and kids and golfing. --- Scott Rose - https://www.scottworld.com Scott Rose is an expert Airtable consultant, a Certified FileMaker Developer, and a Registered Integromat Partner with 30 years of database development experience. Scott is the Chief Geek Officer of ScottWorld.com, where he has built a career developing world-class database systems for businesses. Scott is also a member of MENSA International (the high IQ society) and is an accomplished public speaker. In the early 2000’s, Scott traveled around the country for 6 years with Steve Jobs & the Apple Executive Team as one of Apple’s top professional speakers. Scott spoke at all of Apple's major events & retail store openings, where he introduced many of Apple’s new products to the public for the very first time. In his free time, Scott gives motivational & inspirational talks at conferences around the globe. --- AIRTABLE DISCUSSION THIS WEEK 00:00:49 - Round The Bases - Roundup of what's happening in the Airtable communities - Airtable, BuiltOnAir, Reddit, Facebook, YouTube, and Twitter. 00:33:01 - Meet the Experts - Scott Rose - Scott is a popular contributer in the Airtable community and expert in Airtable and Filemaker. 00:42:41 - Automate Create - Airtable Automations - Texting Automation 00:59:39 - Field Focus - Learn about the Switch Function - Kamille goes over within the fomula field you have the option to do either a if or a switch statement if you want to analyze a particular field value in more than one way. Simpler to use a switch function instead of an if. View Full Video - https://youtube.com/watch?v=k08p0R0IYXg View Full Episode Details - https://builtonair.com/podcast-full-S08-E06-06-08-2021 ___________________________ CONNECT WITH US 🤝 Try a free 14-day trial of On2Air Apps in your Airtable Bases - https://on2air.com Join the BuiltOnAir Community - https://builtonair.com

#airtable #on2air #builtonair6/1/2021 - BuiltOnAir Live Podcast Full Show - S08-E05___________________________The BuiltOnAir podcast is a live weekly show highlighting everything happening in the Airtable universe. Check us out at BuiltOnAir.com/join. Join our community, join our Slack channel, and see what's happening.------------------------SPONSORED BY On2Air - Airtable Apps and Integrations to run your business operations in AirtableStart a free 14-day trial of On2Air Apps - https://on2air.com?via=podcast------------------------___________________________IN THIS EPISODE 🎙Our hosts today:Kamille Parks - https://kamillionaireapps.com/I am an Airtable Community Forums Leader and the developer behind the custom Airtable app "Scheduler", one of the winning projects in the Airtable Custom Blocks Contest now widely available on the Marketplace. I focus on building simple scripts, automations, and custom apps for Airtable that streamline data entry and everyday workflows.---Dan Fellars - https://on2air.comI am the Founder of Openside, On2Air, and BuiltOnAir. I love automation and software. When not coding the next feature of On2Air, I love spending time with my wife and kids and golfing.---AIRTABLE DISCUSSION THIS WEEK00:01:06 - Round The Bases - Roundup of what's happening in the Airtable communities - Airtable, BuiltOnAir, Reddit, Facebook, YouTube, and Twitter.00:42:25 - Audience Questions - Airtable Question - What week number of the year does a event take place?00:48:35 - Field Focus - Learn about the Button Field - What Buttons do is they allow you to connect to a couple different things. You can give the name of what you want the Button to say. Action is open URL. You can stylize it. Next segment will show how to run a script off of a button. Other actions include preview URL, send email with SendGrid, send SMS with Twilio.00:54:35 - Scripting Time - Scripting Time: Run Script with Button - Scripts interacting with Buttons.View Full Video - https://youtube.com/watch?v=6jHCYugBVnoView Full Episode Details - https://builtonair.com/podcast-full-S08-E05-06-01-2021___________________________CONNECT WITH US 🤝Try a free 14-day trial of On2Air Apps in your Airtable Bases - https://on2air.comJoin the BuiltOnAir Community - https://builtonair.com

BuiltOnAir Podcast is the live variety show all about Airtable. This weeks segments: Round The Bases, Scripting Time, Field Focus, Air ChefsWeekly Review of the different communities and what is being discussed. We review the following Airtable communities: Airtable, BuiltOnAir, Reddit, Facebook, and Youtube videos.We continue our development of a 2 way sync between bases. This time we dig into the automation script needed to perform either a create or update in the destination table based on a value from the source table. Full code here: https://gist.github.com/on2air/c1f296fa811817a655cc9920d640242eWe do a deep dive into the Rollup field to discover some amazing things that can be done with it. Definitely worth learning about this invaluable field.Hannah and Alli go head to head in the Air Chefs segment. Watch them take a never before seen base (by them) and add new functionality to it in a short amount of time. This friendly competition is great to see how Experts can enhance an existing base. See base they used here: https://airtable.com/universe/expzCCzb2b2Q8RI48/insomniac-events-staffing-templateJoin Our Community at builtonair.com/joinThe BuiltOnAir Podcast is Sponsored by On2Air

BuiltOnAir Podcast is the live variety show all about Airtable. This weeks segments: Round The Bases, Meet the Experts, Automate Create, Audience QuestionsRound The Bases: Weekly Review of the different communities and what is being discussed. We review the following Airtable communities: Airtable, BuiltOnAir, Reddit, Facebook, and Youtube videos.Meet the Experts: Meet Jen Rudd, PMP, founder of GrowWithJen.com. Jen is a Business Coach and Consultant. She is a Cross-Platform Automation expert with extensive background in creating systems and automation for a variety of business types. Find her at GrowWithJen.com Automate Create: Jen Rudd walks through how to handle dates within automations and all the peculiarities surrounding date formatting and dealing with timezones.Audience Questions: Kamille Park walks through a common Audience Question regarding using the Matching Records trigger in Automations and how to use them properly.Join Our Community at builtonair.com/joinThe BuiltOnAir Podcast is Sponsored by On2Air

This week we cover 4 segments:Round The Bases - a look at what is going on in the world of Airtable and review different topics in the communities covering Airtable.Audience Question - We review a specific question often asked in the communityAutomate Create - live tutorial on how to maximize Airtable Automations. This week we continue our review of how the Webhooks Trigger worksIndustry View - a review of how Airtable can work for a specific industry. This week we cover how Airtable can help the Marketing IndustryCheck out our sponsor: On2Air.com - The complete toolset to run your business on Airtable

This week we cover 4 segments:Round The Bases - a look at what is going on in the world of Airtable and review different topics in the communities covering Airtable.An App A Day - a look at an App from the Airtable Marketplace. This week we review Master CalendarAutomate Create - live tutorial on how to maximize Airtable Automations. This week we review how the Webhooks Trigger worksAir Chefs - our friendly competition where 2 hosts build out a base from the Universe to see how it worksCheck out our sponsor: On2Air.com - The complete toolset to run your business on Airtable

Welcome to BuiltOnAir, a podcast and video series about all things Airtable. Each episode, we talk with someone active in the Airtable community to discuss their experiences and showcase an interesting way they’ve used Airtable in their work.In this episode Mariam Hakobyan gives us a deep dive into Softr.io, a platform for creating customized front-end solutions powered by Airtable. Softr allows users to create websites, web apps and client portals complete with out-of-the-box user account management capabilities. Sporting a flexible user interface, Softr even allows you to show or hide page sections or whole pages from unauthenticated users. We talk about more of the platform’s current features, as well as new ones on the horizon like the ability to edit Airtable data directly from within Softr.Start building your own project now at softr.ioFollow Softr on social media @softr_ioSign up for the BuiltOnAir newsletter! View the video demo from this episodeBuiltOnAir is sponsored by Openside. Openside's newest product, On2Air Forms, is the Airtable forms solution you've been looking for. For a limited time, get On2Air Forms FREE when you purchase the On2Air Actions Zapier connector at openside.com.

On today’s episode, we’re joined by Benjamin Green - Systems Integrator, Youtuber, Airtable Consultant, and co-host for the Clubhouse weekly meetup, “Optimizing your Business and Life”.You may recognize Ben from various Airtable social groups - he’s been busy helping out many users since discovering Airtable just over a year ago. Since then, he’s started his own consulting business, Optimize IS, where he provides digital solutions to business owners frustrated with technology, and a youtube Channel where he breaks down common use cases and formulas for Airtable.A recent graduate of the Kelley School of Business at Indiana University, Ben was the president of his fraternity, and now boasts a degree in Information Systems and Operations. He also comes with a good amount of database experience stemming from Microsoft’s Access.The base Ben demos for us today is his CRM. Here, he tracks his interactions with clients, time spent working on projects, payments made against invoices, and more. He explains how automation has helped his day-to-day workflow, from reminders to clients, to slack notifications when someone signs up for a session or is low on hours, to daily and weekly reports.Check out the show notes for links to learn more about Ben and Optimize IS!Optimize IS Ben Green - Systems Integrator Sign up for the BuiltOnAir newsletter! View the video demo from this episodeBuiltOnAir is sponsored by Openside. Openside's newest product, On2Air Forms, is the Airtable forms solution you've been looking for. For a limited time, get On2Air Forms FREE when you purchase the On2Air Actions Zapier connector at openside.com.

On today’s episode, we travel to Berlin, Germany to speak with Rupert Hoffschmidt, founder of ROY Kombucha! Rupert co-founded ROY Kombucha with his business partner, Fabio, after they both decided to leave their careers in the digital scene.As he tells us all about the fascinating brewing and fermentation process used to make Kombucha, a fermented tea with a rich history, it’s clear to see how passionate and knowledgeable Rupert is about his work. He’s also very excited about the possibilities afforded by Airtable - which has helped him and his team stay on track with orders and production, allowing employees to record data right from their mobile devices.The base Rupert demos for us today is his B2B Order Tracking Base - where he tracks orders placed from grocers, offices and other businesses. He tells us about the challenges faced by many Airtable users when first starting to build a base such as this; realizing he needed a table to track line items per order. Rupert has many plans for the future of his Airtable usage - including building out a fully automated ordering platform from start to finish.Check out the show notes to learn more about Rupert and ROY Kombucha!ROY KombuchaSign up for the BuiltOnAir newsletter! View the video demo from this episode BuiltOnAir is sponsored by Openside. Openside's newest product, On2Air Forms, is the Airtable forms solution you've been looking for. For a limited time, get On2Air Forms FREE when you purchase the On2Air Actions Zapier connector at openside.com.

On today’s episode, we travel to Bloomington, Indiana to chat with Chuck Beckett and Jar Turner of WFHB Community Radio. Chuck, IT Specialist and member of the station’s board of directors, and Jar, General Manager, both began their venture at WFHB by volunteering, and both are passionate about the sense of community provided by their station. When the pandemic hit, WFHB was forced to restrict access to the studios and became ever more reliant on technology - which of course is where Airtable comes to the rescue. The station largely relies on volunteers to do everything from DJing, news reporting, and even radio theatre.Using Airtable’s new Sync feature, they are able to sync their volunteer calendar to several different bases, and securely share these bases amongst their volunteer base. Chuck calls this a game changer, and we have to agree.Chuck demos his Calendar Server base for us today, which is available on the Airtable Universe. The base allows a user to enter a start date and frequency, and yields dates that can be used in a recurring fashion on a calendar.One other project of interest is Chuck’s recently released app, called ORC. ORC is packaged into an Airtable base that is also available on the Universe, and employs the scripting app to output “pretty-printed” formulas - something formula loving users often find is missing from Airtable’s native formula editor.Check out the show notes for links to learn more about WFHB Community Radio, and see Chuck’s bases on the Airtable Universe.WFHB – Bloomington Community RadioRecurring Events Calendar Server - UniverseSign up for the BuiltOnAir newsletter! View the video demo from this episodeBuiltOnAir is sponsored by Openside. Openside's newest product, On2Air Forms, is the Airtable forms solution you've been looking for. For a limited time, get On2Air Forms FREE when you purchase the On2Air Actions Zapier connector at openside.com.

Welcome to BuiltOnAir, a podcast and video series about all things Airtable. Each episode, we talk with someone active in the Airtable community to discuss their experiences and showcase an interesting way they’ve used Airtable in their work.In this episode Carri Craver walks us through the Covid-19 vaccine distribution center search tool she built powered by Airtable and Webflow. Using Airtable as the backend, Carri was able to develop a searchable website where users could find and share feedback on locations which provide Covid-19 vaccines in the state of Texas. Her setup involved an Integromat integration to sync records stored in Airtable as CMS collection list items in Webflow. The result was a user-friendly portal where visitors could quickly view business hours, appointment requirements, and general availability at a glance.Since recording this episode, Carri helped launch a nationwide version of the Vaccine Finder through a partnership with Oracle. Find vaccine distribution centers in the USA hereWatch Carri’s segment on Good Morning America where she discusses the projectSign up for the BuiltOnAir newsletter! View the video demo from this episodeBuiltOnAir is sponsored by Openside. Openside's newest product, On2Air Forms, is the Airtable forms solution you've been looking for. For a limited time, get On2Air Forms FREE when you purchase the On2Air Actions Zapier connector at openside.com.

Welcome to BuiltOnAir, a podcast and video series about all things Airtable. Each episode, we talk with someone active in the Airtable community to discuss their experiences and showcase an interesting way they’ve used Airtable in their work.In this episode Andy Cloke joins us to show off his excellent Airtable app, Data Fetcher. True to its name, Data Fetcher allows Airtable users to manually or automatically import data from any number of APIs directly into their bases. Andy talks about the development process for such a useful app and all the challenges it came with, such as making a wide-release app flexible enough to work for most users. He did so by implementing a robust user interface, which entailed anything from combining multiple pre-made components to creating his own page navigation system. We get a guided walkthrough of how one could set up the app as well as some examples of the app’s implementation. Speaking of wide-release, Data Fetcher is available now on Airtable’s Marketplace so you can try it out yourself. Sign up for Data FetcherGet the data Fetcher App from the Airtable MarketplaceSign up for the BuiltOnAir newsletter! View the video demo from this episode BuiltOnAir is sponsored by Openside. Openside's newest product, On2Air Forms, is the Airtable forms solution you've been looking for. For a limited time, get On2Air Forms FREE when you purchase the On2Air Actions Zapier connector at openside.com.

On today’s episode, we speak with Tanay Pant - author, speaker, educator and head of developer relations at n8n - an up and coming automation platform that can connect Airtable to hundreds of other apps, and boasts features that Zapier and Integromat lovers will no doubt find impressive. Tanay has been in the technology world for years, and is known for his books “Learning Web-based Virtual Reality”, “Building a Virtual Assistant for Raspberry Pi”, and “Learning Firefox OS Application Development” - all published before the age of 22!Tanay tells us about his diverse use of Airtable - both in his personal and professional life. He explains how Airtable and n8n work together - n8n offers an Airtable “node” with all sorts of options that allow the user to grab one or more records, then pass that data on to subsequent steps in the automation to be manipulated or used with other apps.In the demo portion of today’s episode, Tanay shares two examples with us. The first is an app he built using Airtable, n8n, Typeform, and a product called Mindee that can extract data from an image. Tanay demonstrates how he can quickly and easily snap a picture of a receipt, and have that data flow to Airtable - vastly simplifying and streamlining the process of submitting expense reports.The second demo shows us n8n’s creative use of Airtable as an internal tool to help on the back-end of their site. On a daily basis, the company needs to create JSON files for each application that they integrate with. They use Airtable to store each application name and build the JSON files with a nightly job.Check out the show notes to learn more about n8n and Tanay, or follow him on twitter @Tanay1337.Tanay Pant (@tanay1337)n8n.io - Free and Open Workflow Automation ToolSign up for the BuiltOnAir newsletter! View the video demo from this episodeBuiltOnAir is sponsored by Openside. Openside's newest product, On2Air Forms, is the Airtable forms solution you've been looking for. For a limited time, get On2Air Forms FREE when you purchase the On2Air Actions Zapier connector at openside.com.

Welcome to BuiltOnAir, a podcast and video series about all things Airtable. Each episode, we talk with someone active in the Airtable community to discuss their experiences and showcase an interesting way they’ve used Airtable in their work.In this episode we’re joined by the co-founders of Sync Inc, Eric Goldman & Anthony Accomazzo. Sync Inc is a platform which lets users sync their Airtable base to a Postgres database to permit querying data using SQL. Eric and Anthony walk us through their journey as business partners solving problems, from a waffle-shortage at USC to one of Airtable’s key limitations: external querying. Born from the challenges brought about during their work founding AllTogetherLA, a non-profit helping the community of Los Angeles organize resources in response to the 2020 Covid Pandemic, Sync Inc. allows Airtable data to be accessed programmatically by an even wider range of other services via a real-time synchronization. Eric and Anthony demo the product for us, showing how you can set up your Airtable to Sync Inc connection in under 2 minutes.Learn more about AllTogetherLACheck out Sync IncCheck out Retool, one of many platforms now (technically) compatible with Airtable thanks to Sync IncSign up for the BuiltOnAir newsletter! View the video demo from this episodeBuiltOnAir is sponsored by Openside. Openside's newest product, On2Air Forms, is the Airtable forms solution you've been looking for. For a limited time, get On2Air Forms FREE when you purchase the On2Air Actions Zapier connector at openside.com.

Welcome to BuiltOnAir, a podcast and video series about all things Airtable. Each episode, we talk with someone active in the Airtable community to discuss their experiences and showcase an interesting way they’ve used Airtable in their work.In this episode we’re joined by cultural advocate, author, and operations specialist, Paul Matsushima. We begin with a discussion of how his background in non-profit work helping establish and expand Japanese-American cultural programs in the LA region led to him co-authoring a children’s book and creating a youth summer camp. We then discuss how his role as an operations specialist led him to use Airtable to quickly organize and automate reporting processes with the aid of Zapier to integrate with other productivity apps. Paul showcases two bases for us, the first being a ledger to track annual financial transactions and the second base being a CRM to track contacts, campaigns, and communications. We get a deep dive on both bases, which are available for public use on the Airtable Universe.Get a copy of “Thank You Very Mochi” Paul Matsushima, Sophie Wang, and Craig Ishii. Illustrated by Jing ZhengPaul’s First Base Demo’dPaul’s Second Base Demo’dSign up for the BuiltOnAir newsletter! View the video demo from this episodeBuiltOnAir is sponsored by Openside. Openside's newest product, On2Air Forms, is the Airtable forms solution you've been looking for. For a limited time, get On2Air Forms FREE when you purchase the On2Air Actions Zapier connector at openside.com.

On today’s episode, we speak with William Porter, owner and principal developer of Rucksack Technology, writer, and photographer. You may also recognize him from the Unofficial Airtable Conference thrown by Chris Dancy in September, where William gave a talk about Stacker.William boasts decades of experience in tech, having started developing in FileMaker for law firms in the 90s. In recent years, he has also been very interested in new data-management apps, including Airtable. His knowledge of database development makes for a great conversation about the pros and cons of Airtable’s interface and inner-workings.Over the years, William has written for tech publications such as the notable Macworld.com - and even reviewed Airtable as a “drop-dead-easy relational database management system” back in 2016. William shares a couple different bases with us today. The first is a house-hunting base, which he and his family used together when they were considering a move across their state of Texas. They were able to quickly record homes they were interested in, rate the ones they liked, and create a calendar of visits when it came time to book them.In addition to his work in tech, William is also a photographer. The second base he shows us is home to his camera equipment - where he can track the items he owns, as well as items he wants to sell.Rucksack TechnologyWilliam Porter (@williamporter) Articles by William Porter Airtable review: A drop-dead easy relational database management system Sign up for the BuiltOnAir newsletter! View the video demo from this episode BuiltOnAir is sponsored by Openside. Openside's newest product, On2Air Forms, is the Airtable forms solution you've been looking for. For a limited time, get On2Air Forms FREE when you purchase the On2Air Actions Zapier connector at openside.com.

Welcome to BuiltOnAir, a podcast and video series about all things Airtable. Each episode, we talk with someone active in the Airtable community to discuss their experiences and showcase an interesting way they’ve used Airtable in their work.In this episode we speak with Jen Rudd, an expert in building and maintaining cross-platform systems. Jen helps teams identify how their software and platforms can integrate with each other by first nailing down what the desired outcome is. She explains how this approach leads her clients to systems that meet their needs much more so than out-of-the-box solutions offered by some all-in-one platforms. Jen also specializes in automating repetitive processes, and that’s exactly what she demo’s for us later on in the episode. Today’s Airtable showcase explores Jen’s base designed to track files and data across a placement agency’s application process, utilizing a Zapier integration to automatically send emails to applicants as they advance through the process.Contact Jen at adeptinterfaces.comWatch Jen’s session at the 2020 Airtable Users ConferenceSign up for the BuiltOnAir newsletter! View the video demo from this episodeBuiltOnAir is sponsored by Openside. Openside's newest product, On2Air Forms, is the Airtable forms solution you've been looking for. For a limited time, get On2Air Forms FREE when you purchase the On2Air Actions Zapier connector at openside.com.

Welcome to BuiltOnAir, a podcast and video series about all things Airtable. Each episode, we talk with someone active in the Airtable community to discuss their experiences and showcase an interesting way they’ve used Airtable in their work.Today we speak with Edmund Amoye, the host of low-code centric podcast “CodeLess”. CodeLess explores how people use no-code and low-code solutions in their businesses and everyday lives in the form of excellent interviews conducted by Edmund himself. We explore how he became a figure in the no-code space, as well as discuss the meetup he started called "I Want This to Exist,” where members share products and solutions they would find invaluable but, as the title suggests, do not yet seem to exist. For the today’s demo, Edmund shares his base designed to manage discussion topics for weekly meetups. With the aide of Airtable’s simple forms capabilities, Edmund put together a base to collect routine entry from multiple members that makes every meeting just that much more streamlined.Listen to CodeLessFollow Edmund on TwitterCheck out Edmund’s base on the Universe hereSign up for the BuiltOnAir newsletter! View the video demo from this episodeBuiltOnAir is sponsored by Openside. Openside's newest product, On2Air Forms, is the Airtable forms solution you've been looking for. For a limited time, get On2Air Forms FREE when you purchase the On2Air Actions Zapier connector at openside.com.

Welcome to BuiltOnAir, a podcast and video series about all things Airtable. Each episode, we talk with someone active in the Airtable community to discuss their experiences and showcase an interesting way they’ve used Airtable in their work.Today we’re joined by Mike San Marzano to give us an inside look at Airconnex, a comprehensive tool adding unique features heretofore unavailable with Airtable alone: the ability to create beautiful websites run on a single Airtable base. While Mike is still finalizing Airconnex, the final product will create beautiful front-end websites via an easy-to-use interface for anything from directories to e-shops. Mike talks about the development process and the challenges faced when creating something like Airconnex. We get a demo of Airconnex in its current form, and while some features are still in the works, Mike extends an invitation to join the open beta to anyone who’d like to build their own Airtable-run website today.Check out AirConnex Sign up for the BuiltOnAir newsletter! View the video demo from this episode BuiltOnAir is sponsored by Openside. Openside's newest product, On2Air Forms, is the Airtable forms solution you've been looking for. For a limited time, get On2Air Forms FREE when you purchase the On2Air Actions Zapier connector at openside.com.

On today’s episode, we speak with Matthew Baggetta: Marketing lead and seasoned content strategist. Matthew has a super interesting back story; he spent years in academia, earning himself two degrees in English and starting to work on a third - a Ph.D. in English and Cultural Theory. While working toward his Ph.D. Matthew made a huge life change, leaving academics to start a new career in Marketing.Around the same time, Matthew also started a personal meditation practice and went on to found his own meditation instructor training program.It was within the marketing sphere that he found Airtable. The base Matthew shares with us today is his Content Asset Tracker, which he uses to track content, keywords and meta-data, writer’s assigned posts, and more.One of the most attractive features of his base lies within his Blog Post Assignment Form. The form allows the user to assign a writer, a post title, keywords, pain points, and internal links to be included within the post. SEO and marketing pros know how important it is to include internal links within your website to increase domain authority, and Matthew’s form makes this extremely simple by including a self-linked field to reference previously published stories when planning new content.Matthew Baggetta | Content Marketer & CopywriterMatthew's Meditation Instructor Training ProgramSign up for the BuiltOnAir newsletter! View the video demo from this episode BuiltOnAir is sponsored by Openside. Openside's newest product, On2Air Forms, is the Airtable forms solution you've been looking for. For a limited time, get On2Air Forms FREE when you purchase the On2Air Actions Zapier connector at openside.com.

Welcome to BuiltOnAir, a podcast and video series about all things Airtable. Each episode, we talk with someone active in the Airtable community to discuss their experiences and showcase an interesting way they’ve used Airtable in their work.Today we’re joined by Chris Guthrie, an e-commerce aficionado and another featured speaker from this year’s inaugural Airtable Users Conference. In addition to selling his own line of products on Amazon, Chris specializes in helping other sellers maintain and grow successful Amazon Private Label businesses using the power of Airtable and automation. After discussing how his business began and has managed complications brought on by the Covid-19 pandemic, Chris shows us his Airtable base that helps keep his orders, shipping, and inventory data in check. With some insight into a few scripts he’s written, we explore his unique approach to solving some popular Airtable sticking points from formulas, to Page Designer.Watch Chris’ session from this year’s Airtable User ConferenceSign up for the BuiltOnAir newsletter! View the video demo from this episodeBuiltOnAir is sponsored by Openside. Openside's newest product, On2Air Forms, is the Airtable forms solution you've been looking for. For a limited time, get On2Air Forms FREE when you purchase the On2Air Actions Zapier connector at openside.com.

Welcome to BuiltOnAir, a podcast and video series about all things Airtable. Each episode, we talk with someone active in the Airtable community to discuss their experiences and showcase an interesting way they’ve used Airtable in their work.In this episode we speak with Shae Redding - Rogers, an architectural photographer based in New York. Earlier this year, Shae was one of several speakers at the first-ever Airtable User’s Conference organized by Chris Dancy, where she showcased her unconventional contacts manager base. Shae gives us a more in-depth view of that base to highlight how it came to be, and how it helps keep track of all the people she meets across professions and social circles. While Shae may consider herself a newbie, she’s not afraid to seek out formulas, Zapier integrations, or Automation scripts to further improve upon her base. In fact, later on in the episode we brainstorm a couple formulas to help automate her work just a bit more.Formulas we talked about in the episode: IF({TheYear} = YEAR(TODAY()), “yes”, “no”)IF({TheYear} = YEAR(TODAY()), “This Year”, IF({TheYear} = YEAR(TODAY())-1, “Last Year”, “no”))SWITCH({Alignment Type}, “Appt”, “emoji”, “Email”, “*another emoji”)Visit Shae’s website hereWatch her session from this year’s Airtable User ConferenceFollow Shae on TwitterSign up for the BuiltOnAir newsletter! View the video demo from this episode BuiltOnAir is sponsored by Openside. Openside's newest product, On2Air Forms, is the Airtable forms solution you've been looking for. For a limited time, get On2Air Forms FREE when you purchase the On2Air Actions Zapier connector at openside.com.

Welcome to BuiltOnAir, a podcast and video series about all things Airtable. Each episode, we talk with someone active in the Airtable community to discuss their experiences and showcase an interesting way they’ve used Airtable in their work.In this episode we’re joined by Lisa-Marie Pierre, a program manager for Ascend NYC, a Bronx Community College program which connects Bronx minority/women-owned businesses with contracting opportunities. Lisa-Marie may be new to Airtable, but that hasn’t stopped her from diving right in to create a base for the program. Like so many of us, the Covid-19 pandemic has thrown a curveball or two at Lisa-Marie that has made project coordination a bit more difficult. Luckily, with the help of Airtable, she was able to organize a catalog of potential new contacts to reach out to. Lisa-Marie has also made an Airtable base which tracks the progress of her ideas for personal projects. She gives a rundown of its set up and how it differs from other progress trackers on the Airtable Universe to reinforce the ease and value of customizing a base to suit your specific needs.Visit Lisa-Marrie’s website hereCopy Lisa-Marie’s idea tracker base from the Airtable UniverseSign up for the BuiltOnAir newsletter! View the video demo from this episodeBuiltOnAir is sponsored by Openside. Openside's newest product, On2Air Forms, is the Airtable forms solution you've been looking for. For a limited time, get On2Air Forms FREE when you purchase the On2Air Actions Zapier connector at openside.com.

Welcome to BuiltOnAir, a podcast and video series about all things Airtable. Each episode, we talk with someone active in the Airtable community to discuss their experiences and showcase an interesting way they’ve used Airtable in their work.Nicolas Grenié, Developer AdvocateIn this episode we’re joined by Nicolas Grenié, a developer advocate at Typeform and veteran Airtable custom block builder. As a developer advocate, he helps developers build upon Typeform’s existing platform to accomplish advanced, or highly specialized use cases. Naturally, when it came time for Typeform to develop one of the first-ever custom blocks released to the official Blocks Library, Nicolas was just the man to build it. More recently, he built one of the 10 winning projects in the Airtable Custom Blocks Contest. A game-changer for E-commerce bases, his “Shipping Block” can take in an order record, retrieve shipping quotes from multiple companies, generate shipping labels from the selected quote, and even track shipments in progress. We discuss how he came up with the idea for the block, how the Custom Blocks API has changed over time, and a look to the future of custom development for both Typeform and Airtable.Check out Nicolas’ winning contest submission, Shipping Block, hereRead Airtable’s announcement post about Nicolas and the other contest winners hereLearn more about Nicolas at his websiteJoin the Airtable Custom Blocks Beta and build something awesome! Sign up for the BuiltOnAir newsletter! View the video demo from this episodeBuiltOnAir is sponsored by Openside. Openside's newest product, On2Air Forms, is the Airtable forms solution you've been looking for. For a limited time, get On2Air Forms FREE when you purchase the On2Air Actions Zapier connector at openside.com.

Welcome to BuiltOnAir, a podcast and video series about all things Airtable. Each episode, we talk with someone active in the Airtable community to discuss their experiences and showcase an interesting way they’ve used Airtable in their work.In this episode we talk to Jennifer Selke, Director of Veteran Programs and Campus Outcomes at Camp Southern Ground, an incredible non-profit which operates as both a summer camp for kids, and a year-round resource center for veterans. Among others, Jennifer directs the Warrior PATHH program, which assists combat veterans in the transition to civilian life through a supportive, mental health-focused approach. In the wake of lockdowns as a result of the Covid-19 pandemic, Camp Southern Ground has had to improvise a way to digitally provide veterans access to all the resources which are available to them. In comes Airtable: Jennifer was able to put together a simple one-table base to curate a list of 100+ resources for military veterans. While we discuss how it isn’t a perfect substitute for in-person support, it’s a clear example of how a tool like Airtable can let newbies distribute information in a visually appealing format in next to no time at all.Check out Camp Southern Ground’s websiteThe base “Military Veteran Resources” is available on the Airtable Universe hereSign up for the BuiltOnAir newsletter! View the video demo from this episode BuiltOnAir is sponsored by Openside. Openside's newest product, On2Air Forms, is the Airtable forms solution you've been looking for. For a limited time, get On2Air Forms FREE when you purchase the On2Air Actions Zapier connector at openside.com.

Hello BuiltOnAir listeners! We’ve got a great show for you this week. On today’s episode, we speak with Aron Korenblit from the Education team at Airtable itself. You may recognize him from twitter, the Airtable forum, Airtable webinars, and his livestream videos; in which he teaches users how to get the most out of the powerful tool we know and love.Aron talks with us today about the exciting release of the Airtable Platform, which launched this week (at the time of this recording). The launch focused on three pillars, Airtable Automations, Airtable Sync, and the Airtable Marketplace, each filled with tons of new features and possibilities.Airtable Automations, which has been around for the last couple of months, has received a slew of new possible actions, including new integration options with external apps, and two new triggers. Airtable Sync is an answer to a long-awaited feature request, allowing one-way, cross-base sync. Finally, the Airtable Marketplace is the new home for Airtable Blocks (now called Apps), and includes custom apps built by users - such as the Scheduler app by our very own Kamille Parks!Today, Aron shows off what the Airtable Platform can do by demoing these new features for us. If you haven’t had a chance to try out the new features yet, this episode is a great place to start! Check out the show notes for more about the Airtable Platform, links to upcoming Webinars, and Aron’s livestreams.Upcoming Live Training SessionsGet Updates on Upcoming Training SessionsAron's LivestreamsSign up for the BuiltOnAir newsletter! Watch the demo for this videoBuiltOnAir is sponsored by Openside. Openside's newest product, On2Air Forms, is the Airtable forms solution you've been looking for. For a limited time, get On2Air Forms FREE when you purchase the On2Air Actions Zapier connector at openside.com.

Welcome to BuiltOnAir, a podcast and video series about all things Airtable. Each episode, we talk with someone active in the Airtable community to discuss their experiences and showcase an interesting way they’ve used Airtable in their work.In this episode we’re joined by Brian Switchkow, a founding citizen at One Inc Cooperative. One Inc operates as a member-owned, member-controlled virtual economy dedicated to fostering a supportive ecosystem of creatives, entrepreneurs, and investors. Brian and his fellow citizens have helped bring dozens of unique projects to fruition, including a very nifty “spell-check for the soul”. But not all contributions are “monetary,” citizen’s can contribute five different types of capital to a project (there’s financial, but also intellectual, spiritual, cultural, and social capital) at any given time. If that sounds like it requires a lot of data, it's because it does! With so many moving parts, it comes as no surprise that Brian’s two Airtable bases have a number of fields, views and tables to manage it all. But, the beauty of Brian’s approach is that it allows citizens to interact with clean, simple interfaces which only show what needs to be shown with the help of a few handy integrations.Become a citizen of One Inc! Learn more about the On2Air suite of Airtable extensions: Watch our episode with Abdul Alzanki, app developer at MiniExtensions, or visit their website.Sign up for the BuiltOnAir newsletter! View the video demo from this episodeBuiltOnAir is sponsored by Openside.

On today’s episode, we speak with Jason Humphrey, software developer and career coach in Boston, Massachusetts. Jason is the founder of Coding Career Fastlane, an online community focused on improving developers’ skill sets by offering personalized feedback and creative approaches to handling a job search.In addition to Coding Career Fastlane, Jason works full time as a Principal Software Engineer, runs his own YouTube Channel, and is extremely active on LinkedIn. He uses Airtable for everything from planning content for YouTube and LinkedIn posts, to a tool for his coaching business.Jason shares two bases with us today, both of which are part Coding Career Fastlane’s 10-Day Job Hunt Challenge. The base is a Job Hunt Tracker, which features a table of positions the user is interested in, as well as tables to track resumes, interview questions, and message templates. Jason demonstrates how he has impressively programmed the web clipper block to seamlessly add job positions, companies, and contacts found on LinkedIn to this base.The second base is an overview of the 10-Day Job Hunt Challenge. This base offers directions for each day of the challenge, and includes places for the user to track things like important keywords being used in their industry of choice. Together, these bases leave no stone unturned, truly covering every step of the job hunting process. Check out the show notes for links to Jason’s bases on the Airtable Universe, his LinkedIn Profile and more about Coding Career Fastlane.Coding Career FastlaneCoding Career Fastlane's 10-Day Job Hunt ChallengeJason’s Universe PageJason’s LinkedInSign up for the BuiltOnAir newsletter! View the video demo from this episodeBuiltOnAir is sponsored by Openside. Openside's newest product, On2Air Forms, is the Airtable forms solution you've been looking for. For a limited time, get On2Air Forms FREE when you purchase the On2Air Actions Zapier connector at openside.com.

On today’s episode, we travel virtually to Phoenix, Arizona to speak with Jérémy Chevallier: designer, builder, and marketer. From founding and running several businesses to dabbling in the creative arts, Jérémy is truly a jack-of-all-trades. Today he takes us through his entrepreneurial journey, and how Airtable helped him run his entire business.Jérémy studied at Arizona State University with a combined major of Business Marketing and Graphic Design. After graduating and working for different marketing agencies, he decided to start his own. This allowed him to learn even more about the marketing world, and greatly contributed to his ability to build creative solutions that not only look great, but function in a business environment.Jérémy discovered Airtable through his friend and co-founder, Matt. Together they ran their business, PubLoft, almost entirely through Airtable. In today’s screen share portion, Jérémy shows us the base that he credits with helping PubLoft get to $24,000 a month in revenue in just seven months.Today, Jérémy is working on projects such as Crash.Co, a job-hunting site with a personalized twist, and GigLoft, which teaches freelancers how to run their own business. Check out the show notes for links to learn more about Jérémy, and see his base on the Airtable Universe.Thanks for watching! If you enjoyed the episode, be sure to give it a like or hit us up on social @BuiltOnAir! We always love to hear your comments and suggestions. And don’t forget to subscribe to catch new episodes when they release. It helps us keep the podcast going!Jeremy's WebsiteBuild & run an entire agency - UniverseGigLoftCrash.CoSign up for the BuiltOnAir newsletter! View the video demo from this episodeBuiltOnAir is sponsored by Openside. Openside's newest product, On2Air Forms, is the Airtable forms solution you've been looking for. For a limited time, get On2Air Forms FREE when you purchase the On2Air Actions Zapier connector at openside.com.

Welcome to BuiltOnAir, a podcast and video series about all things Airtable. Each episode, we talk with someone active in the Airtable community to discuss their experiences and showcase an interesting way they’ve used Airtable in their work.In this episode, Dan Fellars returns to give us a deep-dive into some newer products offered by his company, Openside. Openside not only sponsors BuiltOnAir.com, which of course hosts this very podcast, but offers Airtable consulting services as well. To help their clients step up their Airtable game, Openside created a suite of products called On2Air which takes the guesswork out of automating many Airtable tasks. Tried-and-true fan favorites like On2Air Actions and On2Air Forms are now joined by a host of other premium extensions including On2Air Schemas. Dan showcases the power of Schemas, which allows users to track every bit of metadata associated with a particular base over time, and gives us a run down of how this new extension could save you a headache or two in the future.Thanks for watching! If you enjoyed the episode, be sure to give it a like or hit us up on social @BuiltOnAir! We always love to hear your comments and suggestions. And don’t forget to subscribe to catch new episodes when they release. It helps us keep the podcast going!Sign up for the On2Air product suite! Sign up for the BuiltOnAir newsletter! View the video demo from this episodeBuiltOnAir is sponsored by Openside. Openside's newest product, On2Air Forms, is the Airtable forms solution you've been looking for. For a limited time, get On2Air Forms FREE when you purchase the On2Air Actions Zapier connector at openside.com.

Welcome to BuiltOnAir, a podcast and video series about all things Airtable. Each episode, we talk with someone active in the Airtable community to discuss their experiences and showcase an interesting way they’ve used Airtable in their work.In today’s episode, we speak with Andy Wingrave: Automation and Airtable enthusiast. Andy’s experience comes with over ten years of digital solutions and problem-solving; and apps like Airtable and Zapier have largely informed his work. He is a certified Zapier Expert and has even worked with Airtable themselves to develop a use case for the web clipper block, which he displays in one of the many bases he’s published to the Airtable Universe.Andy is often found on the Airtable Forums helping other users to develop their bases and solve problems. Like many Airtable users, he considers it a fun hobby to design base templates for others to use. He also runs a blog site - Saastronomical, where he’s published articles and how-tos on automations.Andy shares a few projects with us today, and it’s immediately evident how much care he puts into the organization of his workspaces and bases within. One project of note is his Music Finder Base, which shows how a back-end of an app such as Spotify might look if housed within Airtable. A table of [Events] lists possible interactions one might have with an app, such as a song being played, while a table of [Event Properties] shows what we might want to know about that event, such as the Artist or the Plan the user playing the song belonged to.Learn more about Andy by checking out the show notes for links!Check out Andy's Blog - Saastronomical See Andy's Universe Bases Follow Saastronomical on TwitterSign up for the BuiltOnAir newsletter! View the video demo from this episode BuiltOnAir is sponsored by Openside. Openside's newest product, On2Air Forms, is the Airtable forms solution you've been looking for. For a limited time, get On2Air Forms FREE when you purchase the On2Air Actions Zapier connector at openside.com.

Welcome to BuiltOnAir, a podcast and video series about all things Airtable. Each episode, we talk with someone active in the Airtable community to discuss their experiences and showcase an interesting way they’ve used Airtable in their work.In this episode, we chat with Veronica Picciafuoco of 8020.inc, an agency that helps businesses move faster without code. We talk about how no-code app solutions like Airtable can help just about anybody achieve their goals. In Veronica’s experience, there’s no such thing as one-app-fits-all, and oftentimes half the battle is nailing down exactly how many bells and whistles a solution really needs. Indeed, part of Veronica's job is to help her clients decide whether their ideal solution is a “car” when a “bike” will meet all the client’s needs at a fraction of the cost. Speaking of which, the base Veronica shares with us was made to help a friend keep track of her horse training business. Looking for a simple, mobile-friendly way to log each horse’s daily exercise to better plan for the horse’s activity level the next day, Veronica put together a flexible little Airtable base which does just the trick.Visit 8020’s websiteCheck out Veronica’s base on the Airtable UniverseSign up for the BuiltOnAir newsletter! View the video demo from this episode BuiltOnAir is sponsored by Openside. Openside's newest product, On2Air Forms, is the Airtable forms solution you've been looking for. For a limited time, get On2Air Forms FREE when you purchase the On2Air Actions Zapier connector at openside.com.

Welcome to BuiltOnAir, a podcast and video series about all things Airtable. Each episode, we talk with someone active in the Airtable community to discuss their experiences and showcase an interesting way they’ve used Airtable in their work.In this episode, we’re joined by Nicole Dyer, a professional genealogist, lecturer, and creator of FamilyLocket.com and the Research Like a Pro Genealogy Podcast. Nicole explains the ins and outs of genealogy research, and how she’s able to help people find out more about themselves and their family’s history. We get insight into the meticulous research she conducts, and how putting together the pieces of the past can quickly result in over a thousand data points. So, to ease the data collection process, Nicole uses Airtable to organize her extensive research. We get a rundown of a couple bases she uses to collect the data, and even how she begins to draw her conclusions. Nicole tells us all about the collaborative nature of the genealogy field, so it comes as no surprise that she’s added templates of her research log bases to the Airtable Universe.Visit Nicole’s website and portfolio.See her podcast, Research Like a Pro.Check out her bases on the Airtable Universe.Sign up for the BuiltOnAir newsletter! View the video demo from this episodeBuiltOnAir is sponsored by Openside. Openside's newest product, On2Air Forms, is the Airtable forms solution you've been looking for. For a limited time, get On2Air Forms FREE when you purchase the On2Air Actions Zapier connector at openside.com.

Welcome to BuiltOnAir, a podcast and video series about all things Airtable. Each episode, we talk with someone active in the Airtable community to discuss their experiences and showcase an interesting way they’ve used Airtable in their work.In today’s episode, we speak with James Jackson. James describes himself as a product designer with really excellent taste, and we have to agree. His website is full of colorful, eye-catching designs, peppered with blog-style posts on his life and his work in the technology industry.In 2013, James was a content writer reporting on arts and culture in North Carolina. He befriended an engineer, and so began his foray into “building things” with tech. He changed roles from a content writer to a junior developer, and after a few years, packed up and moved to the big city: New York. After taking a couple of classes, he fell in love with design.Adding up all of his talents yields a recipe for success: James brings together content, design and development to solve problems. He has always been a proponent for finding the right tool for the job, and Airtable checked all of the boxes.The project James demos for us today is his Weekly Summary Base. The power of this base lies in its simplicity: team members have access to a form that is filled out on a weekly basis, and managers have access to see the responses. With only two tables, James has set up an easy and compelling way for managers to see what’s going on within the projects they manage.Check out the show notes for links to see James’s designs and his website, which includes a write-up on his Weekly Summary project, complete with screenshots and explanations.Learn more about James below!James’s WebsiteJames's Designs (Dribbble)Airtable Weekly Summary for Managers | James DarinSign up for the BuiltOnAir newsletter! View the demo from this episodeBuiltOnAir is sponsored by Openside. Openside’s newest product, On2Air Forms, is the Airtable forms solution you’ve been looking for. For a limited time, get On2Air Forms FREE when you purchase the On2Air Actions Zapier connector at openside.com.

Welcome to BuiltOnAir, a podcast and video series about all things Airtable. Each episode, we talk with someone active in the Airtable community to discuss their experiences and showcase an interesting way they’ve used Airtable in their work.In today’s episode, we speak with Jon Letts: a man with a passion for organization and communication. Jon spent his college years focused on and sometimes giving presentations on the “Productivity Triangle”: Calendar, Email, and Task Lists. It was his belief that if these three things were kept in sync and organized, that nothing would go unnoticed. After discovering Airtable, he realized that there was something missing from the Productivity Triangle - People. Airtable allowed him to seamlessly add another layer to his life-system by linking each email, task, or calendar event to a person. In his words, Airtable and Zapier changed his life - a sentiment to which I’m sure many listeners will agree.Jon calls his system and subsequent Airtable Base, “Contuity” - a name representative of his passion about creating and understanding connection. As it covers areas of his life such as relationships and thoughts, Jon equates it to a Personal CRM. When he adds a contact to his iPhone, they’re also added to his base. He uses a simple form to add what he calls “Jots”, turning the base into a Bullet Journal of sorts. By using Airtable’s single and multi-select fields, he’s able to categorize each Jot into what he calls “spaces” of his life. All of this culminates into a color-coded chart showing what he spent time thinking about or doing over the last year. Jon shows us the chart and points out what stands out to him the most, such as how his “friendship” category shot way up after his recent move.There are tons of cool bells and whistles to Jon’s base, which he has published to the Airtable Universe. Check out the show notes for a link!Contuity - UniverseSign up for the BuiltOnAir newsletter! https://builtonair.com/subscribe View the video demo from this episode | https://youtu.be/QU6Fqdi36w0 BuiltOnAir is sponsored by Openside. Openside's newest product, On2Air Forms, is the Airtable forms solution you've been looking for. For a limited time, get On2Air Forms FREE when you purchase the On2Air Actions Zapier connector at openside.com.

Welcome to BuiltOnAir, a podcast and video series about all things Airtable. Each episode, we talk with someone active in the Airtable community to discuss their experiences and showcase an interesting way they’ve used Airtable in their work.In today’s episode, we speak with Hannah Clark: Marketing and Communications Manager, Clothing Swap Runner, and Airtable aficionado. Hannah hails from the Twin Cities in Minnesota, where she uses Airtable to help not just her work life, but her home life as well.Hannah discovered Airtable about nine months ago, and in those nine months has managed to amass an impressive amount of knowledge about the product, and even was selected as a winner of Airtable’s recent Block Ideation contest. Like many users, she started out by modifying one of Airtable’s templates, the Social Media Content Calendar, to match her needs. After getting a bit more comfortable, she started building her own bases from scratch.She has since published three bases to the Airtable Universe, with uses ranging from fun to practical. She shows us these three bases today: Her Personal Budget and Debt Tracker, Movie & TV Log, and Home Improvement Database. Most striking in these bases is Hannah’s creative use of the gallery view. For many of her bases, she has created beautiful cover images using the app Canva, and used these to quickly identify each record. For example, each summary record in her Personal Budget and Debt Tracker has a pretty cover image of the month and year.She also shows us a bit of the base she uses to run her clothing drives: Big Fat Super Swap and Inbetweenie Super Swap, which has a mission of providing clothing options for plus-size people of all genders. Last year, they were able to distribute and hand-deliver over 34 winter coats, an important staple of winters in Minnesota. Bravo, Hannah!Learn more about Hannah below!Hannah ClarkHannah’s Clothing DriveHannah’s Published Universe Bases:Personal Budget Tracker MonthlyMovies & TV Log and RatingHome Project TrackerSign up for the BuiltOnAir newsletter! View the video demo from this episode BuiltOnAir is sponsored by Openside. Openside's newest product, On2Air Forms, is the Airtable forms solution you've been looking for. For a limited time, get On2Air Forms FREE when you purchase the On2Air Actions Zapier connector at openside.com.

Welcome to BuiltOnAir, a podcast and video series about all things Airtable. Each episode, we talk with someone active in the Airtable community to discuss their experiences and showcase an interesting way they’ve used Airtable in their work.In this episode, we’re joined by Justin Barrett, who tells us the interesting career path he took from animator to actor to sports team community relations director. In addition to all his work, Justin is also an Airtable Community Leader who spends much of his free time helping people better understand the program in the community forums. A testament to his unique approach to problem solving, Justin shows us a task tracking base with formulas, filtered views, and categorization all aimed at showing him only what he needs to see at any given time. Far and above the ordinary task tracker, its robust setup accounts for repeating tasks, and organizes everything to help the user build good daily habits through repetition, encouraging the tackling tasks in a particular, consistent order.Visit Justin’s website and portfolio.Watch Justin’s YouTube Channel, All About That Base.Sign up for the BuiltOnAir newsletter! View the video demo from this episode BuiltOnAir is sponsored by Openside. Openside's newest product, On2Air Forms, is the Airtable forms solution you've been looking for. For a limited time, get On2Air Forms FREE when you purchase the On2Air Actions Zapier connector at openside.com.

Welcome to BuiltOnAir, a podcast and video series about all things Airtable. Each episode, we talk with someone active in the Airtable community to discuss their experiences and showcase an interesting way they’ve used Airtable in their work.In this episode, we chat with Jeremy Oglesby, a software developer, and Airtable Community Leader. Jeremy recalls his experience searching for a way to simplify the data-entry process for cataloging equipment for his job, and how that search led him to Airtable. Today, Jeremy is a familiar presence on the Airtable Community forums, and he uses his adept knowledge to help newbies and developers alike in troubleshooting their own bases. He explains how he uses Airtable for just about anything, including scoring board game results. That’s right, Jeremy walks us through an Airtable base he made to ease the game-night headache of accurately reporting the winner after a game of “7 Wonders,” a complex board game with so many variables in the scorecard that only a database would do.Visit Jeremy’s website and portfolio.Sign up for the BuiltOnAir newsletter! View the video demo from this episodeBuiltOnAir is sponsored by Openside. Openside's newest product, On2Air Forms, is the Airtable forms solution you've been looking for. For a limited time, get On2Air Forms FREE when you purchase the On2Air Actions Zapier connector at openside.com.

Welcome to BuiltOnAir, a podcast and video series about all things Airtable. Each episode, we talk with someone active in the Airtable community to discuss their experiences and showcase an interesting way they’ve used Airtable in their work.Today on the podcast, we chat with Chris Dancy. Chris’s lifestyle of tracking personal data - from his heart rate and step count to social interactions and household inventory - has earned him the moniker of “The Most Connected Man on Earth”. Seriously, Google the words, “Most Connected”, and see who comes up!Chris has made a name for himself as a speaker, author, and professional in the technology and health care industries. He has been featured across numerous platforms including Showtime’s ‘Dark Net’, the BBC, NPR, and Wired Magazine. When our interview was scheduled, Chris’s impressive resume and the topic of his “Life Stack” - which he has been tracking in Airtable now for over a year - was to be the primary focus of our chat. Enter coronavirus.With many of his events postponed due to the pandemic, Chris decided to use the extra time to do something to serve his community. Using Airtable, he created a “Neighborhood Volunteer and Help System”. The Base makes use of form views to capture submissions from neighbors, who can share what resources and skills they have to offer in the event of an emergency. He shared a link to the base on NextDoor (a neighborhood-based social media platform), and then a templated version with the Airtable Community. Airtable themselves reached out to Chris and published the template on the Airtable Universe. It is now being used in neighborhoods across the globe.In today’s episode, Chris demos his Covid-19 Neighborhood Base, as well as his “Life Stack”. All of his data is color-coded and categorized according to Maslow’s Hierarchy of Needs - making it visually appealing and easy to sort through. This episode is surely not one to be missed!Chris's Website Neighborhood Support for COVID19 - UniverseSign up for the BuiltOnAir newsletter! View the video demo from this episode BuiltOnAir is sponsored by Openside. Openside's newest product, On2Air Forms, is the Airtable forms solution you've been looking for. For a limited time, get On2Air Forms FREE when you purchase the On2Air Actions Zapier connector at openside.com.

Welcome to BuiltOnAir, a podcast and video series about all things Airtable. Each episode, we talk with someone active in the Airtable community to discuss their experiences and showcase an interesting way they’ve used Airtable in their work.In this episode, we’re joined by Kuovonne Vorderbruggen, who discusses with us her journey from teaching herself coding to ultimately producing multiple scripts recognized by Airtable and the Airtable Community for their merit. Drawing on her experience as a technical writer, Kuovonne’s scripts come well-documented with detailed explanations of the script’s methodology, and have a consistent, intuitive structure which makes them easy to follow. We discuss the joys and headaches that come with problem-solving through coding. Later, Kuovonne shares her spectacular process to create preformatted, multi-page PDFs using a combination of Airtable, Excel, Microsoft Access, and Word. With Airtable as the user-friendly database, Kuovonne shows us how she’s able to ultimately get dozens of records exported from Airtable to be displayed perfectly with rich text in Word with the aid of Visual Basic coding. While it’s a bit of a complicated process, it’s an excellent example of how Airtable can be used as just one step in a larger workflow to accomplish something great.Visit Kuovonne’s website and portfolioCheck out a couple of Kuovonne’s scripts shared on the Airtable Community forums:New Record WizardDelete Empty RecordsRecord Info Helper FunctionSign up for the BuiltOnAir newsletter! View the video demo from this episode BuiltOnAir is sponsored by Openside. Openside's newest product, On2Air Forms, is the Airtable forms solution you've been looking for. For a limited time, get On2Air Forms FREE when you purchase the On2Air Actions Zapier connector at openside.com.

Welcome to BuiltOnAir, a podcast and video series about all things Airtable. Each episode, we talk with someone active in the Airtable community to discuss their experiences and showcase an interesting way they’ve used Airtable in their work.On today’s episode, we speak with Bill French: technology innovator and entrepreneur. Bill founded Global Technologies Corporation in 1981, giving him over 30 years of experience in software products and services. You may recognize his name from the Airtable Community Forum, where he regularly shares his advice, professional insight and tools he has built with Airtable.When a company using Airtable reached out for Bill’s help in 2016, he was quickly compelled by the product’s logical and sleek design. He could see the value that a “no-code” environment provides users. However, Bill also expertly points out that “no-code” is also code for “potentially limiting”, which is where he comes in.When it comes to adding new features, Bill often tells his clients to “add plumbing, rather than a second kitchen sink”. He thoughtfully applies this to Airtable’s new scripting block. If Airtable is a kitchen sink, the scripting block is new plumbing allowing us to build what we want. We discuss the block at length, and get to see some of the awesome things he has built.Bill shows us a few scripts he has written for the new block, complete with many tips and tricks. He demonstrates “BlockChaining”, in which he is able to run one block after another. Check out the show notes for a link to the post Bill wrote about this. He also shows us “Dot”. “Dot” is a program he wrote in the scripting block, which he calls a tribute to an early program called dBase, which was navigated by a dot prompt line. Dot allows Bill to drill down into his tables to sift through his data in more advanced ways.Learn more about Bill and Global Technologies CorporationBill’s Airtable Community Forum ProfileBill’s Post About BlockChainingSign up for the BuiltOnAir newsletter! View the video demo from this episode BuiltOnAir is sponsored by Openside. Openside's newest product, On2Air Forms, is the Airtable forms solution you've been looking for. For a limited time, get On2Air Forms FREE when you purchase the On2Air Actions Zapier connector at https://openside.com

Welcome to BuiltOnAir, a podcast and video series about all things Airtable. Each episode, we talk with someone active in the Airtable community to discuss their experiences and showcase an interesting way they’ve used Airtable in their work.On today’s episode, we speak with Gabe Caldwell - Director of Partnerships at Formstack. You may have heard of Formstack before; they are a huge player in document automation, esignatures, and data collection. And now, thanks to Airtable’s recent release of 5 new partner blocks, Formstack Documents can seamlessly become part of your Airtable base.Since the release of the block, Gabe says they’ve been delighted to see the various use cases and creative ways Airtable users are employing the integration. From invoices and proposals to letters or receipts, Gabe walks us through how easy it is to create documents from your Airtable records with the Formstack Documents Block. After just a few steps to create your account and connect it to Airtable, your document templates are pulled directly into the block in your base.From here, users can select a record - or multiple records - to fill in their document template. You can even save these documents right back to the records in your base; a feature that is noticeably missing from Airtable’s native Page Designer.It doesn’t stop there, either. Formstack offers tons of tools to automate your processes; including Formstack Sign, and Formstack Forms. Check out the show notes to learn more about Formstack and the exciting new integration with Airtable.About FormstackFormstack's Airtable IntegrationAirtable's Blog Post About New Partner BlocksSign up for the BuiltOnAir newsletter! View the video demo from this episode BuiltOnAir is sponsored by Openside. Openside's newest product, On2Air Forms, is the Airtable forms solution you've been looking for. For a limited time, get On2Air Forms FREE when you purchase the On2Air Actions Zapier connector at https://openside.com

Welcome to BuiltOnAir, a podcast and video series about all things Airtable. Each episode, we talk with someone active in the Airtable community to discuss their experiences and showcase an interesting way they’ve used Airtable in their work.In this Bonus Episode, we explore Airtable in Spanish. This is our first Spanish episode for the Spanish speaking community. Please be aware there is a slight disconnect from our audio to video. We are joined by Elias Gomez, from Bilbao Spain. He is a technology and Wordpress developer as well as a DJ. In this episode, we learn about Elias' love for Airtable and how he uses it to run his entire DJ Events business, from managing his song library, his customers and events, to invoicing and sales. It’s a great insight to using Airtable to run a complete business all in one place.English:Elias is 36 years old and lives in Bilbao, Spain. He studied Application Development and has worked a short period as a programmer, starting his own Web Development Studio called Estuio NS, where he has worked for more than 10 years, especially with Wordpress and now has a podcast covering it.On the other hand, one of his passions has turned into a career: music. Since 2004, Elias has been a professional DJ, having done more than a decade of weddings and events, completing more than 600 parties and events.In addition, as a fan of technology, he has started a podcast about the internet and technology, is a former Google Product Expert, a member of the Wordpress Community in Bilbao, among many other interests.Spanish:Elías tiene 36 años y vive en Bilbao. Estudio Desarrollo de Aplicaciones Informáticas, y tras trabajar un breve tiempo como programador, fundio su propio estudio de diseño y desarrollo web llamado Estudio NS, en el que ha trabajado más de 10 años, especialmente con WordPress y ahora teine un podcast.Por otro lado, una de sus pasiones se ha convertido en una actividad laboral: la música. Desde 2004 Elias es Dj profesional, y lleva más de una década amenizando bodas y eventos como Dj animador, habiendo realizado más de 600 eventos y fiestas.Además, una de sus aficiones es la tecnología, lo que se ha llevado a empezar un podcast sobre internet y tecnología, a formar parte del programa Expertos de Productos de Google, y a ser miembro de la comunidad WordPress Bilbao, entre otras muchas cosas.See more on Elias here. Sign up for the BuiltOnAir newsletter! View the video demo from this episode BuiltOnAir is sponsored by Openside. Openside's newest product, On2Air Forms, is the Airtable forms solution you've been looking for. For a limited time, get On2Air Forms FREE when you purchase the On2Air Actions Zapier connector at openside.com.

Welcome to BuiltOnAir, a podcast and video series about all things Airtable. Each episode, we talk with someone active in the Airtable community to discuss their experiences and showcase an interesting way they’ve used Airtable in their work.In this episode, we chat with Hannah Wiginton of Abilene, Texas, the Communications and Grants Director for New Horizons, a non-profit organization for foster families. We discuss the various programs New Horizons offers for prospective foster parents, as well as for the foster kids themselves, from family placement to counseling. In addition to her work at New Horizons, Hannah also freelances as a web designer and content creator. Hanna gives us a rundown of how she’s able to balance these two careers, and the day-to-day experience as both a non-profit grant writer, as well as a freelancer. Later, Hannah walks us through her Book Tracker Airtable base, which has allowed her to stay organized around her third passion: reading. Her base tracks the books she’s read, books she’s been recommended, and the ones next on her “to read” list. Her base employs a metrics table and several views to give her the rewarding feedback of not only how many books she’s read year-over-year, but the number of words too! Hannah put her base on the Airtable Universe to help others who need a simple way to set a goal, like reading more, and tracking their progress on reaching it.Learn more about New Horizons. Visit Hannah’s website and portfolio.Copy Hannah’s Book Tracker base from the Airtable Universe. Sign up for the BuiltOnAir newsletter! View the video demo from this episode BuiltOnAir is sponsored by Openside. Openside's newest product, On2Air Forms, is the Airtable forms solution you've been looking for. For a limited time, get On2Air Forms FREE when you purchase the On2Air Actions Zapier connector at openside.com.

Welcome to BuiltOnAir, a podcast and video series about all things Airtable. Each episode, we talk with someone active in the Airtable community to discuss their experiences and showcase an interesting way they’ve used Airtable in their work.In this episode, we’re joined by Christine Prefontaine, the co-founder of Loup Design & Innovation and co-inventor of StoryEngine.io. Loup is a consultancy with a mission to help private sector and non-profit firms alike better serve their clients through “human-centered design,” which places an emphasis on open communication and frequent reflective learning. In order to help her own clients reach their goals of becoming stronger teams, Christine began using Airtable to help keep her own team on track. We briefly go over two articles written by Loup team members, which discuss their strategies for project and asset management, with Airtable as the CRM. Christine walks us through their CRM base, which allows the team to group tasks and subtasks together from all phases of a project, from ideation to completion. Later, Christine shares how her team was able to use an Airtable base with just one table to track interviewees across the run of a community outreach project or recruitment process.Read the article on Program ManagementAnd the article on Asset ManagementSign up for the BuiltOnAir newsletter! View the video demo from this episode BuiltOnAir is sponsored by Openside. Openside's newest product, On2Air Forms, is the Airtable forms solution you've been looking for. For a limited time, get On2Air Forms FREE when you purchase the On2Air Actions Zapier connector at openside.com.

Welcome to BuiltOnAir, a podcast and video series about all things Airtable. Each episode, we talk with someone active in the Airtable community to discuss their experiences and showcase an interesting way they’ve used Airtable in their work.In today’s episode, we speak with Victor Feliciano, a true jack of all trades with expertise in Operations Management. Victor has run a national call center in the hospitality industry, owned his own pool league, and now is the founder of Master Book Flippers: an online service that helps Amazon Book Sellers source their products.After getting frustrated with the limitations of Google Sheets and Excel, Victor found Airtable and began using it to manage his book inventory in the summer of 2017. Since then, he’s added numerous bells and whistles and even has started helping other online booksellers to create and manage their own Airtable databases.The Base Victor shares with us today is his Customers and Subscription Tracker, where he has expertly made use of junction tables to accurately track his subscriptions and the versions and rates of each. Included in this base is a Daily Emails Table, where he uses Zapier to automate the sending of links to the individual bases he creates for each of his customers.Another great feature of Victor’s base is his creative use of Views. As a workaround for the lack of organizational tools when it comes to a base with many Views, Victor uses emojis in his View names to break the list into easily distinguishable sections.Check out the show notes for links to learn more about Master Book Flippers and Victor’s Airtable Consulting.Learn more about Master Book FlippersVictor’s Airtable ConsultingSign up for the BuiltOnAir newsletter! View the video demo from this episode BuiltOnAir is sponsored by Openside. Openside's newest product, On2Air Forms, is the Airtable forms solution you've been looking for. For a limited time, get On2Air Forms FREE when you purchase the On2Air Actions Zapier connector at openside.com.

Welcome to BuiltOnAir, a podcast and video series about all things Airtable. Each episode, we talk with someone active in the Airtable community to discuss their experiences and showcase an interesting way they’ve used Airtable in their work.In this episode, we talk to Chris Ortolano of MilwaukieRIP, a community outreach organization that works with urban planners and other community members on land use and transportation planning efforts in Milwaukie and Portland, Oregon. Chris has been active in his community for over 20 years, and specializes in summarizing for the greater public the important takeaways from the many, many public meetings relating to a planning project. We discuss some of the biggest issues faced by Milwaukie today, the benefits of infill development, and the challenges to creating affordable neighborhoods through city-driven initiatives. Chris shares his perspective on common roadblocks to the implementation of planning initiatives, such as access to public transit and community weariness to change.In a major city like Milwaukie, there could be many different agencies attempting to tackle pressing issues like housing affordability at once, but these agencies may not always be working in tandem. Chris shares with us his solution, which uses Airtable to store, categorize, and share information on the numerous planning efforts going on in the City. His Urban Planning Tracker base allows him to have a contact list, a meeting tracker, and a precedent library in an all-in-one easy-to-use solution.See Milwaukie RIP’s Facebook pageConnect with Chris on LinkedInSign up for the BuiltOnAir newsletter! View the video demo from this episode BuiltOnAir is sponsored by Openside. Openside's newest product, On2Air Forms, is the Airtable forms solution you've been looking for. For a limited time, get On2Air Forms FREE when you purchase the On2Air Actions Zapier connector at openside.com.

Welcome to BuiltOnAir, a podcast and video series about all things Airtable. Each episode, we talk with someone active in the Airtable community to discuss their experiences and showcase an interesting way they’ve used Airtable in their work.Our guest on the podcast today is Cherry Yang, automation pro and developer. Cherry started using Airtable a couple of years ago while working in an operations role, and quickly saw its potential. She and a couple of colleagues put together their first base, a product information database, and before long the entire company was using it.Ever since then, Cherry says she feels like she’s told every single person in her life about Airtable, including her mom (editor’s note: for the record - this is something I can totally relate to). Today, she’s an Airtable consultant, working on projects on her own as well as with GAP Consulting. The project Cherry shares with us today is an event planning base she created for a music festival in Portland, Oregon. With Airtable, she is able to track stages, event times, and volunteer work. This base is complete with all the bells and whistles, including an email function to send volunteers detailed information about where they need to be, and when. Cherry also shares with us a serendipitous story about how she came to start working on this project; it’s worth the listen!Learn more about Cherry’s Airtable consulting here. Sign up for the BuiltOnAir newsletter! View the video demo from this episode BuiltOnAir is sponsored by Openside. Openside's newest product, On2Air Forms, is the Airtable forms solution you've been looking for. For a limited time, get On2Air Forms FREE when you purchase the On2Air Actions Zapier connector at openside.com.

Welcome to BuiltOnAir, a podcast and video series about all things Airtable. Each episode, we talk with someone active in the Airtable community to discuss their experiences and showcase an interesting way they’ve used Airtable in their work.Today on the BuiltOnAir podcast we travel to France to chat with Ambroise Dhenain: start-up cofounder, CTO, developer, and more. Ambroise has always had a passion for technology and worked for years as a front-end/full-stack developer before co-founding his start-up, Unly.Unly focuses on providing access to education to students, and among many of his roles with the company, Ambroise heads up the technology team as CTO. He says he was introduced to Airtable by another non-profit organization, and immediately saw the potential in it’s easy to understand and intuitive interface. They didn’t dig in until a couple of months later, but soon they were using it regularly for everything from risk assessment to time tracking.One thing that Ambroise, and many Airtable users alike, grew frustrated with, was the lack of capabilities with regards to backing up data. In an attempt to fill some of that gap, Ambroise and the team at Unly released an open source software for managing Airtable backups. He demos his product for us today, showing us how a little technical knowledge can help you set up timed backups that will capture entire bases, at whatever time increment you set.Check out the show notes to learn more about Ambroise, Unly, and their backup software!Find Ambroise’s Community Forum Post about their software here: Unly Releases an Open Source Software for Airtable Managed backupsCheck out UnlySign up for the BuiltOnAir newsletter! https://builtonair.com/subscribe View the video demo from this episode | https://youtu.be/4C0U7pfNgNU BuiltOnAir is sponsored by Openside. Openside's newest product, On2Air Forms, is the Airtable forms solution you've been looking for. For a limited time, get On2Air Forms FREE when you purchase the On2Air Actions Zapier connector at openside.com.

Welcome to BuiltOnAir, a podcast and video series about all things Airtable. Each episode, we talk with someone active in the Airtable community to discuss their experiences and showcase an interesting way they’ve used Airtable in their work.In this episode, we talk to Abdul Alzanki, a mobile app developer at Khan Academy hailing from the Bay Area who has developed a series of no-code feature extensions for Airtable called miniExtensions. As a long-time Airtable user, Abdul discusses his path toward developing software, and his goal to make Airtable even more accessible to beginners and experts alike. He explains how doing a simple coding exercise for his brother expanded to developing the now 18 extensions he provides on his website to the greater public, with even more on the horizon. Anything from downloading attachments in-bulk to even machine learning is now possible thanks to his work. Abdul demos for us several of his tools in action, showing just how quickly you can add long-awaited features to your bases for a fraction of the cost of developing a custom webapp from scratch.See Abdul’s website here.Sign up for the BuiltOnAir newsletter! View the video demo from this episode BuiltOnAir is sponsored by Openside. Openside's newest product, On2Air Forms, is the Airtable forms solution you've been looking for. For a limited time, get On2Air Forms FREE when you purchase the On2Air Actions Zapier connector at openside.com.