Author: BuiltonAir Team

Season 17 Episode 3
This weeks Hosts: Kamille ParksDan FellarsScott Rose
This weeks Segments:
Round The Bases –

Audience Questions –

Scott Rose answers the Airtable question: “How to DeDupe Duplicate values without the DeDupe App”

Answer: Scott Will share a trick using linked records, rollup fields, and lookup fields that lets you quickly delete a ton of duplicates in one fell swoop

Field Focus –

A deep dive into the Many to Many Relationships Linked Record –  

Automate Create –

Watch as we review and work through automations. Kamille will continue her invoicing demo (check out how to do eSignatures in last weeks episode). This week she shows how to generate invoices in Stripe and connect to Airtable.

Learn more about the automation

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

An App a Day –

Watch as we install, explore, and showcase the Aeropage App from the Airtable Marketplace. The app is described as “A nocode platform for fast creation and unlimited customization.”.

View App

Automate Create –

Watch as we review and work through automations. Kamille will showcase how to use an eSignature for sales quotes driven from Airtable and using 3rd party tools.

Meet the Creators –

Meet Mike San Marzano from Aeropage.

I’m most passionate about making cool stuff, and technology, and everything I do pretty much involves both. I started with automations and tools in the early 2000s working in Architectural studios, writing scripts and building custom tools to speed up the drafting and documentation processes. After about 10 years that become boring so I shifted to web development with a big focus on data driven websites, but the tools available were pretty tedious so I was always looking for ways to make it easier and faster. I started with Zapier very early and eventually discovered Airtable- then I immediately started replacing my databases with it via API connections. After a while I figured my tools might make a good product, so I showed them at Chris Dancy’s Airtable conference in (2019?) and through that an enterprise reached out to me to ask about how it was going. I hired some developers and built a ‘proper’ product, which they signed on for a few years before they decided to move away from Airtable. Now after almost four years its (almost!) ready.

Visit them online

Season 17 Episode 1
This weeks Hosts: Kamille ParksDan FellarsScott Rose
This weeks Segments:
Audience Questions –

Scott Rose answers the Airtable question: “Unable to open linked records in a synced database”

View the question in the community

Answer: Scott walks through this approach on how to convert field types on synced fields.

Base Showcase –

We dive into a full working base that will Sean will be sharing internal apps built in Airtable for both his Short Term Rental Business

Meet the Creators –

Meet Sean McGregor from Stay Work and Play.

Sean McGregor has learned how to use NoCode Tools to free himself from the tedious tasks in his business (Stay Work And Play aka SWAP CoHosting). Now, he wants to help educate Entrepreneurs and NoCoders on how to Automate the Annoying things in their lives and businesses so they can focus on working on the things they love and spending time with the people they love.

Visit them online

Round The Bases –

Season 16 Episode 8
This weeks Hosts: Kamille ParksDan FellarsScott Rose
This weeks Segments:
An App a Day –

Watch as we install, explore, and showcase the TabGraph App from the Airtable Marketplace. The app is described as “Dan walks through a few different ways to visualize the Airtable Data, including TabGraph from the ecosystem.”.

View App

Round The Bases –

Following Articles Used in this Segment:

[Reddit] How to provide your Custom GPT with access to any Airtable base

[Airtable Community] Introducing AI in Automations – Airtable Community

[Reddit] I built a Custom ChatGPT to help with Scripting. : r/Airtable

[Airtable Community] Re: How can I get rid of the cookie popup in the e… – Airtable Community

[Twitter] (14) Rahul Mathur on X: "Airtable has been the subject of intense debate in the past few months: (1) Parted ways with ~ 20% of workforce in Sept ‘23 – 2nd time in last 12 months (Dec ‘22 was also ~20% of workforce) (2) Announced focus on Enterprise Sales & de-prioritization of their core PLG (bottoms…" / X

[BuiltOnAir Community] Impact of changing the primary key

[BuiltOnAir Community] Clear Data feature

[BuiltOnAir Community] Discussion on new AI Automations

[BuiltOnAir Community] Number of runs this month added to automations

An App a Day –

Watch as we install, explore, and showcase the SimpleTexting App from the Airtable Marketplace. The app is described as “Scott Rose will showcase how to use Airtable with Make and SimpleTexting for your texting needs.”.

View App

An App a Day –

Watch as we install, explore, and showcase the Master Calendar App from the Airtable Marketplace. The app is described as “Kamille will highlite some upcoming enhancements to her popular Master Calendar app.”.

View App

Season 16 Episode 7
This weeks Hosts: Kamille ParksDan FellarsScott Rose
This weeks Segments:
Round The Bases –

An App a Day –

Watch as we install, explore, and showcase the Calendly App from the Airtable Marketplace. The app is described as “Jen Rudd will walk through how to integrate Airtable and Calendly for your scheduling needs.”.

View App

A Case for Interface –

Explore Interfaces with “New Interface Forms”.

Kamille will walk through how to use the new Forms in Interfaces.

Field Focus –

A deep dive into the Global Fields – Scott will walk through a technique to create global fields 

Season 16 Episode 5
This weeks Hosts: Kamille ParksDan FellarsScott Rose
This weeks Segments:
Round The Bases –

Meet the Experts –

Meet Mecca Parker from Park West Digital.

Founder & CEO @ Park West Digital

Visit them online

Automate Create –

Watch as we review and work through automations. Weston is a database management tool that helps Airtable consultants win more client projects without heavily investing development time and resources up front. Weston turns system requirements into a functioning proof-of-concept with the click of a button so that consultants can save costs on business development and close deals more deals, more quickly. It was built almost 100% without code using Airtable and ChatGPT

Learn more about the automation

An App a Day –

Watch as we install, explore, and showcase the Mac Controls & Mobile Alerts App from the Airtable Marketplace. The app is described as “Scott demonstrates how to control your Mac from Airtable as well as how to send actual alert-style notifications from Airtable to your Mac, PC, iPhone, iPad, or Android.”.

Season 16 Episode 6
This weeks Hosts: Kamille ParksDan FellarsScott Rose
This weeks Segments:
Round The Bases –

Scripting Time –

Explore Scripting with “Synced Collaborator Field Limitation”.

Kamille will share a script that works as a work around for the limitations with synced collaborator fields..

Automate Create –

Watch as we review and work through automations. Scott will walk us through the complexities of dealing with arrays in Airtable and how to work with them in Make.com

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

Automate Create –

Watch as we review and work through automations. Jen Rudd shows how to build an auto proposal generator using Airtable, Fillout Forms, and Make

A Case for Interface –

Explore Interfaces with “Interface Detail Pages”.

Kamille will showcase updates to the new interface details page.

Field Focus –

A deep dive into the ARRAYSLICE Formula – Understanding the new ARRAYSLICE Function 

Learn More Here

Season 16 Episode 3
This weeks Hosts: Alli AlosaKamille ParksDan Fellars
This weeks Segments:
Round The Bases –

An App a Day –

Watch as we install, explore, and showcase the Fillout Forms App from the Airtable Marketplace. The app is described as “Scott will demo how to use Fillout forms with Airtable.”.

View App

Scripting Time –

Explore Scripting with “Field Search”.

Alli will share a script that can search all the fields in a base for a particular word/phrase.

Field Focus –

A deep dive into the ARRAYSLICE Formula – Understanding the new ARRAYSLICE Function 

Learn More Here

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

Meet the Creators –

Meet Melanie Smith from Blue Tree Data Consulting.

Visit them online

Base Showcase –

We dive into a full working base that will It started as a way to document our data/tech stack and data wrangling processes for our clients. The Vault has continued to grow in usefulness now that we have good metadata about our clients’ setups. Out of this, we’ve created an easy way to track tech renewals, budgets, license costs, user assignments, and privacy policy links, with other (typically un-fun) things on the roadmap. It sends notifications to Slack and Clickup at increasing frequencies the closer a renewal date gets, and I’m working on a snooze button with the new actionable Slack message to make it stop if the reminder is no longer needed or desired. We keep an internal base that feeds each Client’s Tech Vault using sync’d tables, where we keep a master table of tech tools and their metadata handy to minimize Client data entry. From the Client’s base, they can choose to link into it or not, and if they don’t find what they want in it, the client can one-click request new additions or corrections to our dataset using AirTable forms. We also have Web Clippers attached to this base so that when we find new tools and vendors to add to our database, it’s easy for us as well. We’re also able to clip articles and attach them to those tools for reference later.

Automate Create –

Watch as we review and work through automations. Kamille follows up with her automation base from last week and covers the n8n automations to complete the project.

Learn more about the automation