Author: BuiltonAir Team

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

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