Author: BuiltonAir Team

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

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