BuiltOnAir

#airtable #on2air #builtonair 10/12/2021 - BuiltOnAir Live Podcast Full Show - S09-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 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. --- 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. --- AIRTABLE DISCUSSION THIS WEEK 00:03:16 - Round The Bases - Roundup of what's happening in the Airtable communities - Airtable, BuiltOnAir, Reddit, Facebook, YouTube, and Twitter. 00:36:55 - An App a Day - Airtable App Showcase - Embed - Look at content from all over the internet without leaving your base. Just enter a URL and the page, video, livestream, feed, post, or widget will appear in a frame on your dashboard. You can even embed other Airtable view or base share links in an embed app! 00:40:36 - Field Focus - Learn about the Field Filters - We cover the recently released Field Filters for Views and how you can take advantage of them 00:47:14 - Automate Create - Airtable Automations - Customer Feedback Loop - Part 3 View Full Video - https://youtube.com/watch?v=vSlPJ9Prrtk View Full Episode Details - https://builtonair.com/podcast-full-S09-E05-10-12-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 #builtonair 10/5/2021 - BuiltOnAir Live Podcast Full Show - S09-E04 ___________________________ 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. --- AIRTABLE DISCUSSION THIS WEEK 00:03:23 - Round The Bases - Roundup of what's happening in the Airtable communities - Airtable, BuiltOnAir, Reddit, Facebook, YouTube, and Twitter. 00:37:55 - An App a Day - Airtable App Showcase - Timeline - Airtable recently released Timeline as a new View to showcase date based data in a timeline UI. Alli will walk through how to use this new view in your bases. 00:48:14 - Audience Questions - Airtable Question - CSV Download Converts Currency to Text 00:53:44 - Automate Create - Airtable Automations - Customer Feedback Loop - Part 2 View Full Video - https://youtube.com/watch?v=uNEs8vWS5SY View Full Episode Details - https://builtonair.com/podcast-full-S09-E04-10-05-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 #builtonair 9/28/2021 - BuiltOnAir Live Podcast Full Show - S09-E03 ___________________________ 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: 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. --- AIRTABLE DISCUSSION THIS WEEK 00:03:08 - Round The Bases - Roundup of what's happening in the Airtable communities - Airtable, BuiltOnAir, Reddit, Facebook, YouTube, and Twitter. 00:33:47 - Meet the Experts - Kuovonne Vorderbruggen - I'm an Airtable enthusiast with experience in both relational database designs and writing computer scripts 00:38:21 - An App a Day - Airtable App Showcase - Ready Made Formulas - This app includes over a dozen "ready-to-use" formulas for common tasks such as · formatting numbers and dates as text strings to include in reports · generating urls for prefilled forms and prefiltered shared views · extracting attachment filenames and urls · manipulating dates · consolidating data from multiple fields into JSON format 00:56:58 - Automate Create - Airtable Automations - Creating a Customer Feedback Management Site View Full Video - https://youtube.com/watch?v=j9gQzKevzHw View Full Episode Details - https://builtonair.com/podcast-full-S09-E03-09-28-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 #builtonair 9/21/2021 - BuiltOnAir Live Podcast Full Show - S09-E02 ___________________________ 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: 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. --- AIRTABLE DISCUSSION THIS WEEK 00:02:58 - Round The Bases - Roundup of what's happening in the Airtable communities - Airtable, BuiltOnAir, Reddit, Facebook, YouTube, and Twitter. 00:28:54 - An App a Day - Airtable App Showcase - Matrix - The Matrix app from Aitable allows for viewing 2 dimensional data by creating lanes for the intersection of 2 fields. 00:32:08 - Audience Questions - Airtable Question - Estimated Delivery Date from todays date or date Payment is Received (nested if formula) 00:41:10 - Scripting Time - Scripting Time: Meta API View Full Video - https://youtube.com/watch?v=VElslbZw9Ro View Full Episode Details - https://builtonair.com/podcast-full-S09-E02-09-21-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 #builtonair 9/14/2021 - BuiltOnAir Live Podcast Full Show - S09-E01 ___________________________ 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: 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. --- AIRTABLE DISCUSSION THIS WEEK 00:02:57 - Round The Bases - Roundup of what's happening in the Airtable communities - Airtable, BuiltOnAir, Reddit, Facebook, YouTube, and Twitter. This weeks Round Up: We review the last 4 weeks of updates and conversations happening in different Airtable communities 00:44:06 - An App a Day - Airtable App Showcase - Junction Assistant - Quickly build junction table records linked to one or many records 00:54:23 - Scripting Time - Scripting Time: Dealing with Common Scripting Warnings - The scripting block provides warning messages when the code does not meet Airtable's criteria. Here we tackle common scenarios on how to deal with those common warnings. Including the new addition of requiring fields to be passed into table.selectRecordsAsync() method 01:06:36 - Audience Questions - Airtable Question - View Full Video - https://youtube.com/watch?v=FrdnrN27YKk View Full Episode Details - https://builtonair.com/podcast-full-S09-E01-09-14-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 #builtonair 7/27/2021 - BuiltOnAir Live Podcast Full Show - S08-E12 ___________________________ 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. --- AIRTABLE DISCUSSION THIS WEEK 00:01:22 - Round The Bases - Roundup of what's happening in the Airtable communities - Airtable, BuiltOnAir, Reddit, Facebook, YouTube, and Twitter. 00:35:19 - Automate Create - Airtable Automations - Wedding RSVP System with Airtable & MiniExtensions 00:41:37 - An App a Day - Airtable App Showcase - Airtable: Dedupe - The dedupe app allows you to identify duplicate records in your base and delete or merge them. Start by picking a table, a view (if desired), and one or more fields that will be used to determine which records should be considered duplicates. Once you're happy with your criteria, you can review and resolve sets of duplicates manually: delete unneeded records, preserve records that aren't actually duplicates, and merge individual fields from duplicate records. 00:47:01 - Field Focus - Learn about the Duration Field - The Duration field can be useful to work with date/time fields and Formula fields to calculate new date/time values. This episode walks through the things to watch out for in dealing with the Duration field. View Full Video - https://youtube.com/watch?v=J_pq7s6JDjI View Full Episode Details - https://builtonair.com/podcast-full-S08-E12-07-27-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 #builtonair 7/20/2021 - BuiltOnAir Live Podcast Full Show - S08-E11 ___________________________ 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. --- 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. --- AIRTABLE DISCUSSION THIS WEEK 00:00:59 - Round The Bases - Roundup of what's happening in the Airtable communities - Airtable, BuiltOnAir, Reddit, Facebook, YouTube, and Twitter. 00:28:35 - Meet the Creators - - 00:51:15 - Scripting Time - Scripting Time: Single Select Buttons - Using single select options in a script. 00:58:14 - Field Focus - Learn about the Last Modified Time - A time stamp of when the recorded was last touched. View Full Video - https://youtube.com/watch?v=UJzzbS4nAKs View Full Episode Details - https://builtonair.com/podcast-full-S08-E11-07-20-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 #builtonair 7/13/2021 - BuiltOnAir Live Podcast Full Show - S08-E10 ___________________________ 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. --- AIRTABLE DISCUSSION THIS WEEK 00:00:44 - Round The Bases - Roundup of what's happening in the Airtable communities - Airtable, BuiltOnAir, Reddit, Facebook, YouTube, and Twitter. 00:41:39 - Audience Questions - Airtable Question - How to use an automations after someone submits a form. 00:47:09 - Field Focus - Learn about the Formulas in Lookup Fields - 00:51:57 - Automate Create - Airtable Automations - Automations - At Scheduled Time Triggers View Full Video - https://youtube.com/watch?v=JsS059aTwSw View Full Episode Details - https://builtonair.com/podcast-full-S08-E10-07-13-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 #builtonair 6/29/2021 - BuiltOnAir Live Podcast Full Show - S08-E09 ___________________________ 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. --- AIRTABLE DISCUSSION THIS WEEK 00:00:32 - Round The Bases - Roundup of what's happening in the Airtable communities - Airtable, BuiltOnAir, Reddit, Facebook, YouTube, and Twitter. 00:37:41 - Audience Questions - Airtable Question - How do you tell an automation to run at a certain time? 00:44:07 - Scripting Time - Scripting Time: Randomized Values - Allows you to insert random values into cells. Running a script. 01:00:43 - Air Chefs - Alli Alosa vs Kamille Parks improve the Airtable base, Sales CRM Dashboard View Full Video - https://youtube.com/watch?v=kF2Ea8ySlEg View Full Episode Details - https://builtonair.com/podcast-full-S08-E09-06-29-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 #builtonair 6/22/2021 - BuiltOnAir Live Podcast Full Show - S08-E08 ___________________________ 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. --- AIRTABLE DISCUSSION THIS WEEK 00:00:44 - Round The Bases - Roundup of what's happening in the Airtable communities - Airtable, BuiltOnAir, Reddit, Facebook, YouTube, and Twitter. 00:35:19 - Scripting Time - Scripting Time: Monthly Inspector - Be able to inspect one type of interaction at a time. 00:41:42 - An App a Day - Airtable App Showcase - Batch Update - Need to increment all the values in a numeric or date field? Looking to remove a particular collaborator from every record, or alphabetically sort all the options in a multiple select field? With the batch update app, making changes to your records en masse is easier than ever before. You can line up multiple update actions to execute with a single click, and the app will remember the actions the next time you use it—making it great for repeated workflows, like approving every item in a view or re-sorting select options. 00:52:02 - Industry View - Airtable for the Industry View Full Video - https://youtube.com/watch?v=9DPE5oBnzh4 View Full Episode Details - https://builtonair.com/podcast-full-S08-E08-06-22-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 #builtonair 6/15/2021 - BuiltOnAir Live Podcast Full Show - S08-E07 ___________________________ 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: 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. --- AIRTABLE DISCUSSION THIS WEEK 00:00:53 - Round The Bases - Roundup of what's happening in the Airtable communities - Airtable, BuiltOnAir, Reddit, Facebook, YouTube, and Twitter. 00:37:56 - Field Focus - Learn about the Last Modifided Date - Kamille shares insights on how to use last modified date and last modified by field types. 00:47:20 - Automate Create - Airtable Automations - 2 way sync 00:58:47 - An App a Day - Airtable App Showcase - Web Clipper - Save text, links, images, and more directly to an Airtable base with just a few clicks. With a Web Clipper app and the official Chrome browser extension, you can create new Airtable records from content on any web page—without needing to leave your current browser window. View Full Video - https://youtube.com/watch?v=nOEEzNfvMkI View Full Episode Details - https://builtonair.com/podcast-full-S08-E07-06-15-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 #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.