Author: BuiltonAir Team

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

Season 11 Episode 5
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

[Airtable Community] Calendar enhancements 📆 – Announcements – Airtable Community Forum

[Airtable Community] Creating an automation to send out emails every first Monday of the month? – Ask the community / Automations – Airtable Community Forum

[Airtable Community] Prospects & Leads under the same Base – Ask the community / Base design – Airtable Community Forum

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

Meet the Creators –

Meet Alex Radley.

Trained as a Chemical Engineer and worked primarily in Foodtech and Edutech startups. Currently Chief Product Officer of a Plant Based Jerky startup, where all systems apart from Accounts and Inventory control are setup on Airtable. Passionate about improving the prosperity of the land of the Kiwi’s (New Zealand which still has more sheep than people). Government is just beginning to think how it can transform its Advance Manufacturing Industries and through my site rad.kiwi presenting use cases for applications of Airtable tools should be used.

Visit them online

Base Showcase –

We dive into a full working base that will

Automate Create –

Watch as we review and work through automations. Learn how to create summary tables of time stamped data

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

Meet the Creators –

Meet Matthew Busel from Whalesync.

Co-Founder of Whalesync

Visit them online

An App a Day –

Watch as we install, explore, and showcase the Whalesync App from the Airtable Marketplace. The app is described as “Instantly two-way sync and connect tools like Airtable, Webflow, and Notion.”.

View App

Scripting Time –

Explore Scripting with “Find & DIsplay all Broken Fields”.

Alli shares this script she wrote that will find any “broken” fields – the ones that have the little red triangle next to the name – in your base, then display the field name, table, and any applicable field description.

View Script

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

Meet the Creators –

Meet Tim Alexander from DataFetch.

Tim Alexander is a long time integrations expert having worked for Thomson Reuters, TIBCO, and Splash

Visit them online

An App a Day –

Watch as we install, explore, and showcase the DataFetch App from the Airtable Marketplace. The app is described as “Configure the /datafetch Slash Command to empower your Slack users to easily access data from your applications and databases.”.

View App

Scripting Time –

Explore Scripting with “Field Meta Data”.

How to extract the IDs and name of all the fields in a table for use with scripts/automations and more..

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

An App a Day –

Watch as we install, explore, and showcase the Timeline App from the Airtable Marketplace. The app is described as “Jen Rudd (from growwithjen.com) will walk us through the new features available in the Airtable timeline view”.

Automate Create –

Watch as we review and work through automations. Kamille will show how to autofill her financial tracking tool with categories based on tagging.

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

Meet the Creators –

Meet Russell Bishop.

Frontend UX Designer @ Lighthouse

Visit them online

Automate Create –

Watch as we review and work through automations. how to build automated summary tables

Learn more about the automation

A Case for Interface –

Explore Interfaces with “Buttons in Interfaces”.

Interfaces now supports actionable Buttons to perform some limited functionality.

View Script

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

Field Focus –

A deep dive into the Rollup HTML Data Rollup – How to use the Rollup field to generate HTML for a list 

Meet the Creators –

Meet Andy Cloke from DataFetcher.com.

Andy Cloke is the one man SAAS Builder behind DataFetcher.com

Visit them online

An App a Day –

Watch as we install, explore, and showcase the DataFetcher App from the Airtable Marketplace. The app is described as “Connect Airtable to any application with no-code.”.

View App