Author: BuiltonAir Team

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

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.

–