In this recap we will review season nine, episodes one through three of the BuiltOnAir podcast.

Season 9, Episode 1: 9-14-2021

Hosts Dan Fellars and Kamille Parks go over the segments Round the Bases, An App a Day, Scripting Time, and Audience Question in this episode.

Round the Bases- The hosts discuss what’s happening in the Airtable, Twitter, Reddit, and BuiltOnAir communities.

An App a Day- Watch as we install, explore, and showcase the Junction Assistant App from the Airtable Marketplace. The app is described as “Quickly build junction table records linked to one or many records”.

Scripting Time- Explore Scripting with “Dealing with Common Scripting Warnings”. The scripting block provides warning messages when the code does not meet Airtable’s criteria. Here we tackle common scenarios on how to deal with those common warnings. Including the new addition of requiring fields to be passed into table.selectRecordsAsync() method.

Audience Question- “Hi everyone! We’re trying to build out our company database and are stumped on a couple things. We do one invoice item by zip codes which are broken down into 8 different zones. Based on the user form input how can we match that zip code to the zone and retrieve the price for that zone. How should we setup at table for products that contain unique access codes. So, the product is the same, however each client receives a code to access the product after purchase, that code can only be used once. What is your suggestion on how to setup this in Airtable?”

Answer: “Hi Chafen, To better answer your first question, I need to understand how you assign the zone. Can you please explain that a bit more? For this, I recommend setting up a table where the access code is the first column or “Name” of the record. That provides a unique identifier for each record. Then use the product and client as attributes.”

Season 9, Episode 2: 9-21-2021

Hosts Dan Fellars and Kamille Parks go over Round the Bases, An App a Day, Audience Question, and Scripting Time segments in this episode of the BuiltOnAir podcast.

Round the Bases- The hosts go over what’s happening in the Airtable, Reddit, and Twitter communities.

An App a Day- Watch as we install, explore, and showcase the Matrix App from the Airtable Marketplace. The app is described as “The Matrix app from Airtable allows for viewing 2-dimensional data by creating lanes for the intersection of 2 fields.”

Audience Question- Kamille answers the Airtable question: “Estimated Delivery Date from today’s date or date Payment is Received (nested if formula)”

Scripting Time- Explore Scripting with “Meta API”. We highlight how to use the new meta apis in the scripting app to create new tables and fields. We discuss the shortcomings of the api and what is possible. We use live code examples to showcase these apis…

Season 9, Episode 3: 9-28-2021

Hosts Dan Fellars and Kamille Parks along with special guest Kuovonne Vorderbruggen go through the Round the Bases, Meet the Expert, An App a Day, and Automate Create segments on this episode of the BuiltOnAir podcast.

Round the Bases- The hosts discuss what’s happening in the Airtable, Reddit, Twitter, and BuiltOnAir communities this week.

Meet the Expert- Meet Kuovonne Vorderbruggen. “I’m an Airtable enthusiast with experience in both relational database designs and writing computer scripts. I have built databases and written scripts for small businesses, large companies, non-profits, hobbyists, solopreneurs, start-ups, and even other Airtable consultants. Clean design and custom code can take your Airtable base to the next level.”

An App a Day- Watch as we install, explore, and showcase the Ready-Made Formulas App from the Airtable Marketplace. The app is described as “This app includes over a dozen “ready-to-use” formulas for common tasks such as

  • formatting numbers and dates as text strings to include in reports
  • generating urls for prefilled forms and prefiltered shared views
  • extracting attachment filenames and urls
  • manipulating dates
  • consolidating data from multiple fields into JSON format ”.

Automate Create- Watch as we review and work through automations. This is a quick and easy way to collect user/customer feedback with just Airtable.