Author: BuiltonAir Team

Season 13 Episode 5
This weeks Hosts: Alli AlosaKamille ParksDan Fellars
This weeks Segments:
Round The Bases –

Following Articles Used in this Segment:

[BuiltOnAir Community] general – BuiltOnAir – 3 new items – Slack

[BuiltOnAir Community] airtable-tricks – BuiltOnAir – 3 new items – Slack

[Airtable Community] See what Make scenarios are in a base – Airtable Community

[Reddit] Pro Version of Air WP Sync, the plugin who connects and syncs Airtable To WordPress is out : Airtable

[Reddit] 🗺️ I made an extension that lets you visualize your records on a custom map : Airtable

[TableForums] Quick summary of consecutive records – Show and Tell / Tips & Tricks – TableForums: The Unofficial Airtable Discussion Community

[TableForums] Linked Records Secondary fields – Airtable Questions / General Airtable Questions – TableForums: The Unofficial Airtable Discussion Community

[Twitter] Kelly Claus on Twitter: "Would love to spend an hour just observing the person at @airtable who thought this sentence was necessary to include in their docs. https://t.co/y0Gwh71sPO" / Twitter

[BuiltOnAir Community] general – BuiltOnAir – 2 new items – Slack

Scripting Time –

Explore Scripting with “Scripts for Meal Planning”.

Kamille will showcase her Meal Planning Base and how she utilizes scripts to enhance the base.

Automate Create –

Watch as we review and work through automations. Alli shares how she uses automations to categorize data into buckets that is useful for reporting purposes.

Field Focus –

A deep dive into the Synced Fields on Record Deletion Buttons & Formulas – A useful trick is no longer available. Airtable synced tables used to allow for knowing when the source record was deleted by utilizing a RecordID formula 

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

Following Articles Used in this Segment:

[BuiltOnAir Community] general – BuiltOnAir – 2 new items – Slack

[BuiltOnAir Community] general – BuiltOnAir – 2 new items – Slack

[BuiltOnAir Community] general – BuiltOnAir – 2 new items – Slack

[Twitter] Lenny Rachitsky on Twitter: "Don’t underestimate the power of great swag Love this story from @zoelle about Airtable’s early days https://t.co/Y8bBShP9mO" / Twitter

[Airtable Community] ⚡️Automation Ace | Troy Tessalone on Twitter: "@kalenjordan Current limits: You can add up to 50 automations to a base. Note: Automations that are turned off (inactive) still count against this limit of 50 automations. https://t.co/eMX6amq6f6" / Twitter

Meet the Experts –

Meet New Source of Airtable Answers.

Some of the top Airtable experts are launching a new forums site to help give back to the community – Check out https://air.tableforums.com

Visit them online

Automate Create –

Watch as we review and work through automations. Kamille will showcase how to use UTM tracking url parameters to pass info to and from Calendly so airtable records can be updated accordingly (utilizing Make.com)

An App a Day –

Watch as we install, explore, and showcase the Softr.io App from the Airtable Marketplace. The app is described as “Alli with demo how to use URL Parameters to prefill forms within Softr”.

View App

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

Following Articles Used in this Segment:

[Airtable Community] New API capabilities now in GA and upcoming API ke… – Airtable Community

[BuiltOnAir Community] Add Comment Shortcut

[BuiltOnAir Community] Personal Access Tokens WhoAmI

Automate Create –

Watch as we review and work through automations. Jen Rudd will showcasae how she creates bitlinks FROM Airtable, and automate reporting for clicks!

A Case for Interface –

Explore Interfaces with “Button Hacks in Interfaces”.

Alli will share a cool hack for how to use Buttons inside an Interface.

Scripting Time –

Explore Scripting with “Using JSON for Current View”.

Kamille will demonstrate how to use the Scripting Block to generate the current view as JSON.

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

Scripting Time –

Explore Scripting with “Select Options in Scripts”.

Kamille demonstrates how to work with creating new options for single or multi select fields when creating or updating records from a script.

An App a Day –

Watch as we install, explore, and showcase the Send SMS Easily App from the Airtable Marketplace. The app is described as “Send SMS Easily lets you send SMS messages from Airtable without having to sign up for a third-party SMS service. No complicated logins, phone number purchases, and API keys!”.

View App

Automate Create –

Watch as we review and work through automations. Quickly Send Group Texts with just individual responses back using TextBelt

Learn more about the automation

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

Following Articles Used in this Segment:

[Airtable Community] New beta: Sync API – Airtable Community

[Airtable Community] Product update: See who fills out your form – Airtable Community

[Web] Scaling for the Enterprise: Top 5 Lessons on the Upmarket Journey with Airtable CEO Howie Liu and Coatue Management General Partner Caryn Marooney (Pod 618 + Video) | SaaStr

[BuiltOnAir Community] Secret Upload Feature

[Facebook] (20+) Airtable Community | 👋 Former Airtable engineer and long time user (since 2014 | Facebook

[Facebook] (20+) Airtable Community | EXCITING ANNOUCEMENTS COMING | Facebook

[Web] Airtable – Layoffs.fyi Tracker (layoffs.fyi/tracker)

An App a Day –

Watch as we install, explore, and showcase the On2Air Forms App from the Airtable Marketplace. The app is described as “We will build a working demo of how to use On2Air Forms to create a form for 2023 Predictions for the Airtable community.”.

View App

Automate Create –

Watch as we review and work through automations. Kamille will walk through how to use advanced Make.com features to generate a form with custom HTML that saves to Airtable.

Scripting Time –

Explore Scripting with “Display Editable Values”.

Alli shares her script that displays all the editable values of a chosen record. Use case: Use case: trying to determine if a record is safe to delete without unhiding all necessary fields/scanning a large table.

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

Meet the Creators –

Meet Sam Ruiz from Aureo.

I’m the co-founder of Aureo, a platform that connects freelancers and brands for project-based work. I’m a marketer-turned-entrepreneur and recently built our entire platform using Airtable. Prior to launching Aureo, I ran an e-commerce focused marketing agency called, Tgthr Collective.

Visit them online

Base Showcase –

We dive into a full working base that will Sam will showcase a base she uses with her startup: Aureo (https://meetaureo.com)

A Case for Interface –

Explore Interfaces with “Interface for Teachers”.

Kamille showcases an interface she built to help with her college course she teaches..

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

Meet the Creators –

Meet Alex Tellez.

Alex Tellez works with Sterling Administration, an independent health savings accounts administrator

Visit them online

Base Showcase –

We dive into a full working base that will This 2 part demo will showcase how to do both 1-way and 2-way chatbot messaging within Airtable with your customers.

Field Focus –

A deep dive into the Displaying commas in number fields Currency Fields – Using a currency field instead of number field allows for comma based formatting. 

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

Meet the Experts –

Meet Bill French.

A longtime player in the field of data manipulation and automation, Bill is a guru in Airtable setup and backend. He uses the API and custom scripts to make tools and functionality for his clients to get the most out of their databases. One such is a project called Airborne, which allows unified search across multiple bases, tables and documents in Airtable (see link below for more details).

Visit them online

Industry View –

Learn all the ways you can use Airtable within the State of Airtable Industry. From pre-made bases, apps, automations, and custom bases, we’ll show you how to set up bases and get your State of Airtable organization established in Airtable.

High level discussion of where things are in the world of computing, no/low code platforms, Airtable and more. Gain valuable insights from industry veteran Bill French

–

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.