Author: BuiltonAir Team

Season 12 Episode 11
This weeks Hosts: Alli AlosaDan Fellars
This weeks Segments:
Round The Bases –

Meet the Creators –

Meet Alex Tellez.

Alex Tellez works with Sterling Administration, an independent health savings accounts administrator

Visit them online

Base Showcase –

We dive into a full working base that will This 2 part demo will showcase how to do both 1-way and 2-way chatbot messaging within Airtable with your customers.

Field Focus –

A deep dive into the Displaying commas in number fields Currency Fields – Using a currency field instead of number field allows for comma based formatting. 

Season 12 Episode 10
This weeks Hosts: Alli AlosaKamille ParksDan Fellars
This weeks Segments:
Round The Bases –

Meet the Experts –

Meet Bill French.

A longtime player in the field of data manipulation and automation, Bill is a guru in Airtable setup and backend. He uses the API and custom scripts to make tools and functionality for his clients to get the most out of their databases. One such is a project called Airborne, which allows unified search across multiple bases, tables and documents in Airtable (see link below for more details).

Visit them online

Industry View –

Learn all the ways you can use Airtable within the State of Airtable Industry. From pre-made bases, apps, automations, and custom bases, we’ll show you how to set up bases and get your State of Airtable organization established in Airtable.

High level discussion of where things are in the world of computing, no/low code platforms, Airtable and more. Gain valuable insights from industry veteran Bill French

–

Season 12 Episode 9
This weeks Hosts: Alli AlosaDan Fellars
This weeks Segments:
Round The Bases –

Following Articles Used in this Segment:

[BuiltOnAir Community] Airtable – 💬 Inquiry Tracker

Meet the Experts –

Meet Julian Post from 3rings.

Julian is an Airtable Consultant and a former farmer. He became passionate about Airtable while using it to manage New England’s largest hop farm. Now he helps other small and medium-sized businesses build Airtable systems. You can find his educational videos on TikTok and YouTube.

Visit them online

Automate Create –

Watch as we review and work through automations. Airtable lacks a looping mechanism in Automations. Julian Post will walk through a few ways to overcom that. The first is a formula I wrote which solves a payroll use case, and the second is a system for sending email sequences.

An App a Day –

Watch as we install, explore, and showcase the Softr App from the Airtable Marketplace. The app is described as “Alli will demo how to use Softr to build a website with your Airtable data. Softr helps you build custom apps for your business.”.

View App

Season 12 Episode 8
This weeks Hosts: Alli AlosaDan Fellars
This weeks Segments:
Round The Bases –

Following Articles Used in this Segment:

[Twitter] Alex Oppenheimer on Twitter: "Check out the VC & Angel Operating Systemin Notion and Airtable. Sharing the work we've done over the last couple years to run our investing operation https://t.co/PPoBvWfUgg by @Alexoppenheimer and @fvgriss h/t @benln for hunting!" / Twitter

[BuiltOnAir Community] Slack | airtable-help | BuiltOnAir | 2 new items

[BuiltOnAir Community] Slack | general | BuiltOnAir | 1 new item

[BuiltOnAir Community] Slack | general | BuiltOnAir | 1 new item

[Airtable Community] New: Deep link a cell – Announcements – Airtable Community Forum

An App a Day –

Watch as we install, explore, and showcase the Docupilot App from the Airtable Marketplace. The app is described as “Create documents using customizable, intelligent templates and data from your base. Docupilot allows you to create your Contracts, Sales/Purchase Orders, Invoices, Employment Offer Letters, Real Estate Agreements, Marketing material and many more professional documents in PDF, Word, Powerpoint, Excel and other formats.”.

View App

A Case for Interface –

Explore Interfaces with “Inquiry Tracker interface”.

Alli will showcase her inquiry tracker interface.

Automate Create –

Watch as we review and work through automations. A limitation of Automation scripts is the inability to create new single/multi selection options from the Script. This demo will showcase how to work around that limitation.

Season 12 Episode 7
This weeks Hosts: Kamille ParksDan Fellars
This weeks Segments:
Round The Bases –

Following Articles Used in this Segment:

[Web] AirOps Masters Training

Air Chefs –

Watch as Scott Rose (Make.com) takes on Ben Green (Zapier.com) to improve the base Invoice Generation from the Airtable Universe, and make it even better with automations, different field types, and apps from the marketplace.

Automate Create –

Watch as we review and work through automations. Kamille Parks will demonstrate how to auto assign tasks to the collaborator who created a record

Season 12 Episode 6
This weeks Hosts: Kamille ParksDan Fellars
This weeks Segments:
Round The Bases –

Following Articles Used in this Segment:

[Reddit] Airtable interface sharing with external peeps : Airtable

[Reddit] Change Log for Project Management : Airtable

[Twitter] Rohit R Abbadi on Twitter: "After a long long wait! 😅 Thanks @airtable team for working with us through the launching of Docupilot to AT’s marketplace. It’s inspiring to see waht amazing processes our customers have been creating with the beta extension we had been floating around for months. #docgen" / Twitter

[Twitter] Samar Owais on Twitter: "@kronda opening our eyes to the wonders of Airtable and how easy it makes marketing automation. https://t.co/M1PtnaFvpS" / Twitter

[Airtable Community] Introducing the Airtable Connected Apps Platform™ – Announcements – Airtable Community Forum

[Twitter] Business Automated on Twitter: "#Airtable attachment URLs will start expiring from Nov 8th, so I build a hack to prevent it. Particularly proud of the BONUS 😄#nocode #justatinybitofcode #make #integromat #automation #tailwindcss https://t.co/VnCZYQse1C https://t.co/O1TpmFYOKo" / Twitter

[Twitter] Andy Wingrave on Twitter: "Just realised.. I'm actually doing a thing that people might be interested in 🤔. I'm selling all my possessions so I can travel round the world 🌎 💫 Come watch me do that with @airtable! Would appreciate the Share/Retweet – (Just this once) 🙏 https://t.co/6s6ptrV0E8" / Twitter

[Facebook] (20+) Airtable Community | I made a gallery of my most frequently used Airtable formulas 🧮 Hope they help | Facebook

A Case for Interface –

Explore Interfaces with “Legal Non Profit Database & More”.

Learn how the AirOps team uses Interfaces with its clients to accomplish Workflow Zen. .

View Script

An App a Day –

Watch as we install, explore, and showcase the Docupilot App from the Airtable Marketplace. The app is described as “Create documents using customizable, intelligent templates and data from your base. Docupilot allows you to create your Contracts, Sales/Purchase Orders, Invoices, Employment Offer Letters, Real Estate Agreements, Marketing material and many more professional documents in PDF, Word, Powerpoint, Excel and other formats.
”.

View App

A Case for Interface –

Explore Interfaces with “Latest Features of Interfaces”.

Kamille will highlight all the new feature releases for Interfaces.

Season 12 Episode 5
This weeks Hosts: Alli AlosaKamille ParksDan Fellars
This weeks Segments:
Round The Bases –

A Case for Interface –

Explore Interfaces with “My Wardrobe Interface Contest Winner”.

Contest Winning Interface from Russell Bishop.

View Script

An App a Day –

Watch as we install, explore, and showcase the Page Designer App from the Airtable Marketplace. The app is described as “Learn some advanced tricks from Alli Alosa on how to utilize the popular Page Designer App by Airtable.”.

View App

Scripting Time –

Explore Scripting with “Templated Sub/Junction Record Links”.

Kamille will showcase a script that looks at a record and what sub/junction records are required by a template, and adds the ones that are missing.

Season 12 Episode 4
This weeks Hosts: Alli AlosaKamille ParksDan Fellars
This weeks Segments:
Round The Bases –

Following Articles Used in this Segment:

[Airtable Community] Announcing the winners of the Interface Designer contest 🏆 – Announcements – Airtable Community Forum

[Airtable Community] New: Add a Kanban element to your Interfaces – Announcements – Airtable Community Forum

[Airtable Community] New: Updates make creating and collaborating easier in Airtable – Announcements – Airtable Community Forum

[BuiltOnAir Community] Slack | general | BuiltOnAir | 1 new item

Field Focus –

A deep dive into the Extracting Name Elements & Combining Values with seperators Formula – Kuovonne will walk through how to utilize Formulas to split out first, middle and last names from a full name field as well as combining values from different fields into a list without extra spaces of commas 

An App a Day –

Watch as we install, explore, and showcase the Retool App from the Airtable Marketplace. The app is described as “Kamille will walk through how to use Retool to build a client facing scheduling application”.

View App

A Case for Interface –

Explore Interfaces with “Charts in Interfaces Part 2”.

Alli revisits her Interface Chart Hack from previous episode with new advanced functionality.

Season 12 Episode 2
This weeks Hosts: Alli AlosaKamille ParksDan Fellars
This weeks Segments:
Round The Bases –

Following Articles Used in this Segment:

[Airtable Community] "Email me a copy of my responses."…. Really? – Show and tell / Product Suggestions – Airtable Community Forum

[BuiltOnAir Community] Slack | general | BuiltOnAir | 2 new items

[Airtable Community] Introducing Document Automator – Announcements – Airtable Community Forum

[Airtable Community] New Beta: Record Templates – Announcements – Airtable Community Forum

[Airtable Community] Call Center Software – Using Interfaces – Showcase – Show and tell – Airtable Community Forum

[Facebook] (20+) Airtable Community | Anyone else wake up to Interface Designer errors | Facebook

[BuiltOnAir Community] Slack | general | BuiltOnAir | 1 new item

[Twitter] (1) Peter Kazanjy on Twitter: "Now that I've been angel investing for nearly a decade, I thought I'd start doing some writing on it (in all my free time. Lol.) First post: Airtable. https://t.co/3HoXpyTTD7" / Twitter

Meet the Experts –

Meet Lorenzo Lee from LoticDigital.

Lorenzo Lee is an Engineer by trade. After spending over 15 years in software as a developer, architect, director and CTO for various companies from Fortune 500 to startups he founded LoticDigital.Originally LoticDigital was focused on custom software solutions for startups and small businesses but organically pivoted to fast development with an array of emerging NoCode solutions.Today LoticDigital focuses primarily on Airtable and the advanced use-cases extending and enhancing Airtable experiences around a variety of applications across the web

Visit them online

Base Showcase –

We dive into a full working base that will Lorenzo Lee will showcase a full working platform to handle dispatching of drivers to assist with community needs for transporting people to different locations.

A Case for Interface –

Explore Interfaces with “Charts in Interfaces”.

How to hack charts inside interfaces.

Season 12 Episode 1
This weeks Hosts: Alli AlosaDan Fellars
This weeks Segments:
Round The Bases –

Field Focus –

A deep dive into the Formula Progress Bars Formula – Using Formulas to generate Progress Bars 

Base Showcase –

We dive into a full working base that will Provide a form to select a timeslot available from Airtable. See solution here: https://community.airtable.com/t/how-to-create-a-single-date-calendly-like-reservation-form/30614/2?u=scottworld

Automate Create –

Watch as we review and work through automations. Technique for linking two synced tables back together