Author: BuiltonAir Team

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

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

Meet the Creators –

Meet Chris Zantis.

Chris Zantis is a Registered Architect in the UK (ARB) and Cyprus (ETEK). He is a graduate of the Department of Architecture of the University of Cyprus and holds an MA in Enterpreneurship from Goldsmiths University of London. He has worked in several award-winning practices in London, participating in the design and delivery of a wide range of structures and spaces, such as Private Residences, Hotels, Skyscrapers, Commercial/Office Spaces, Manufacturing Facilities, Shopping Centres and Retail.Since 2019, he has repatriated to Cyprus after several years working in London and is currently working as an Architect in Limassol. His current interest is the induction of innovative design technologies in the analysis, composition and organisation of Building Information.He discovered Airtable while working for back in 2017 and immediately fell in love with it. Since then he’s been using it to build bases that are either targeted to support Design Operations, or as a tool to organise and analyse Building Data, Project Budgets, and Client Reporting.

Base Showcase –

We dive into a full working base that will Chris will showcase some bases he uses in his Architectural Practice

A Case for Interface –

Explore Interfaces with “Google Drive Interface”.

Kamille will showcase an interface to interact with her Google Drive files..

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

Following Articles Used in this Segment:

[Airtable Community] Product Update: Improvements to Base Navigation – Announcements – Airtable Community Forum

[Airtable Community] Improvements to Automations – Announcements – Airtable Community Forum

[Airtable Community] New Filter Options for Linked Records – Announcements – Airtable Community Forum

[Airtable Community] Forms in Interface Designer – Announcements – Airtable Community Forum

[Airtable Community] New: Quick Groups – Announcements – Airtable Community Forum

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

[Reddit] (1) How would you describe what AirTable is to your grandfather? : Airtable

Audience Questions –

Kamille Parks answers the Airtable question: “Formula to move word”

View the question in the community

Answer: Yes, actually. Using REGEX you can do this with a relatively simple formula: TRIM(REGEX_REPLACE({Text Field}, "(^A |The )(.*)", "$2, $1"))

A Case for Interface –

Explore Interfaces with “Exploring New Forms in Interfaces”.

Interfaces now allow for creating new records via forms.

–

Season 11 Episode 10
This weeks Hosts: Kamille ParksDan Fellars
This weeks Segments:
Round The Bases –

Base Showcase –

We dive into a full working base that will Guest Rebecca Elam will showcase a base she built to perform manual app testing for her company.

An App a Day –

Watch as we install, explore, and showcase the Glide App from the Airtable Marketplace. The app is described as “Kamille will showcase how she uses Airtable and Glide Apps to build her website”.

View App

Season 11 Episode 9
This weeks Hosts: Alli AlosaKamille ParksDan Fellars
This weeks Segments:
Round The Bases –

Scripting Time –

Explore Scripting with “Understanding Async/Await”.

For beginners to Javascript, one thing that is difficult to understand is how/when to use asnyc/await. We will explain the concept and when to use them..

Audience Questions –

Kamille Parks answers the Airtable question: “Nested IF Referencing Multiple Fields with String Return”

View the question in the community

Answer: Kamille walks through how to manage nexted Ifs

Field Focus –

A deep dive into the Advanced Linked Record Filters – Airtable recently launched ability to select specific items within Linked Records as part of the filters 

Season 11 Episode 8
This weeks Hosts: Kamille ParksDan Fellars
This weeks Segments:
Round The Bases –

Field Focus –

A deep dive into the Formulas & Linked Records Formulas, Linked Records – How to use Formulas and Linked Records to display unpaid balances for work performed in an Invoicing base. 

Automate Create –

Watch as we review and work through automations. Using Make.com (formerly Integromat) to bill customers through Stripe

Learn more about the automation

An App a Day –

Watch as we install, explore, and showcase the Barcode Generator App from the Airtable Marketplace. The app is described as “Use this app to quickly generate barcodes using data from your tables. Once generated, barcodes appear as attachments in a separate field.”.

View App

Season 11 Episode 7
This weeks Hosts: Alli AlosaKamille ParksDan Fellars
This weeks Segments:
Round The Bases –

Following Articles Used in this Segment:

[Reddit] Do you think AirTable’s pricing strurue is be a barrier to future growth? : Airtable

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

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

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

[Twitter] Leo Guinan on Twitter: "@CSMikeCardona @arvidkahl @airtable I'll +1 for Mike building it. You won't be disappointed with the result. 👍" / Twitter

[Airtable Community] Other collaborators can see my personal views – Ask the community / Views – Airtable Community Forum

Meet the Experts –

Meet Charlie Melendez from ProfitGrab.

Visit them online

Base Showcase –

We dive into a full working base that will A crypto algorithmic trading bot. Find out more at https://www.profitgrab.com/

Field Focus –

A deep dive into the Display Unpaid Balances Formulas & Linked Records – Use Formula and Linked Record fields to display unpaid balances for work performed. 

Season 11 Episode 6
This weeks Hosts: Alli AlosaKamille ParksDan Fellars
This weeks Segments:
Round The Bases –

Following Articles Used in this Segment:

[Twitter] Mike Cardona 🤖⚡️ on Twitter: "How to learn @Airtable formulas for free 😛 💡The best way to learn Airtable and formulas is by building something. 💡The best way to stick with it is by building something you’d use. Formula learning blueprint 👇🏼" / Twitter

[Twitter] Aayush Bhaskar on Twitter: "Some clients might prefer to use self-hosted solutions due to the sensitivity of their data. Other clients might want a cheaper alternative. Best Open-Source Airtable Alternatives https://t.co/rDq80eBy0a via @HashDork" / Twitter

[BuiltOnAir Community] Slack | general | BuiltOnAir

[Web] Migrating Airtable to MySQL 8.0. By Doug Forster, Bin Gao, Brian Larson… | by Andrew Wang | The Airtable Engineering Blog | Jun, 2022 | Medium

[Twitter] Airtable on Twitter: "We're excited to launch our first national ad campaign 🎉 Keep an eye out for videos like this and other digital & physical ads spotted in the wild 👀 #ThisIsHow https://t.co/ganVeMOFRY https://t.co/KN6DpfxI8s" / Twitter

[Twitter] Airtable on Twitter: "Your Friday just got more exciting! Check out this free template below ⬇️" / Twitter

[Reddit] Airtable vs Google Sheets: the ultimate guide (TLDR Airtable = awesome) : Airtable

[BuiltOnAir Community] Slack | airtable-help | BuiltOnAir | 1 new item

[BuiltOnAir Community] Slack | airtable-help | BuiltOnAir

Automate Create –

Watch as we review and work through automations. One limitation of Airtable automations is the inability to loop through a list of records returned from a search step. Scott Rose shows how to implement looping capabilities through the use of another automation.

Field Focus –

A deep dive into the MultiSelect as Tags MultiSelect – How to utilize Multiselect fields to enable personalized tagging 

Automate Create –

Watch as we review and work through automations. Sometimes you need multiple automations to run sequentially one after the other. Alli walks through how to implement that technique with Automations.

Learn more about the automation