Author: BuiltonAir Team

Season 9 Episode 7
This weeks Hosts: Alli AlosaKamille Parks
This weeks Segments:
Round The Bases –

Field Focus –

A deep dive into the Autonumbers Autonumber – Learn about autonumbers and how to fake them 

Automate Create –

Watch as we review and work through automations. Write an automation to generate autonumbers

Scripting Time –

Explore Scripting with “Scripting autonumbers”.

An advanced way to build auto numbers via a script.

Season 9 Episode 6
This weeks Hosts: Kamille ParksDan Fellars
This weeks Segments:
Round The Bases –

Following Articles Used in this Segment:

[Reddit] is dark mode a thing? : Airtable

[Twitter] (12) VentureBeat on Twitter: "Starting soon! "How @Zapier Uses @Airtable To Transform Product Development & Deliver Great Customer Experiences" with @aofstad, @chrisgeoghegan, and @wendyschuchart. Watch now: https://t.co/a7axrORCeH https://t.co/1ZZHOaVpSe" / Twitter

[Airtable Community] Folders, folders, folders – Show and tell / Product Suggestions – Airtable Community Forum

[Airtable Community] Account Switching – Show and tell / Product Suggestions – Airtable Community Forum

[Facebook] (20+) Airtable Community | Airtable's Billy Littlefield talking about the long tail for @airtable uses | Facebook

[Twitter] (21) John Hashem 🚢 on Twitter: "Any business, (or app) I start, starts with Airtable https://t.co/eHEjDZFDYk" / Twitter

[Airtable Community] Scheduled maintenance and downtime on October 15 – Announcements – Airtable Community Forum

Scripting Time –

Explore Scripting with “Delete Duplicates Script”.

We will perform a deep dive into an existing script from the marketplace to see how it works and analyse the code to learn and improve as scripters..

View Script

Field Focus –

A deep dive into the Button Field Button – We review the Button field, its uses, and how it works within a synced table environment to reference back to the source table record. 

Learn More Here

Industry View –

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

No Code is becoming quite the buzzword around the Internet. We look into its meaning, how Airtable fits into that description, and what it means for you.

Click Here

Season 9 Episode 5
This weeks Hosts: Alli AlosaDan Fellars
This weeks Segments:
Round The Bases –

Following Articles Used in this Segment:

[Web] Rowy: Open-source Airtable alternative on Google Cloud | Hacker News

[Web] Inside Airtable's Plan to Double Its Workforce to Over 1,000 Employees

[Airtable Community] New Feature: Advanced Filtering – Announcements – Airtable Community Forum

[Airtable Community] Setting an Automation to only trigger during working hours – Ask the community / Automations – Airtable Community Forum

[Airtable Community] URL Parameter for filter on a view – Ask the community – Airtable Community Forum

[Airtable Community] OOPS: Joy PREMATURE… Airtable team: Thank you so much for allowing more than 500 fields in the table – Ask the community / Base design – Airtable Community Forum

[Reddit] Can anyone help with this formula, please? Why am I getting this error? : Airtable

[Facebook] (20+) Airtable Community | I have a linked record that I want to separate/locate the first text | Facebook

[BuiltOnAir Community] Slack | airtable-help | BuiltOnAir

[Twitter] (20) Ross Simmonds on Twitter: "If you’re a SaaS marketer, you need to study Airtable. The SEO & growth strategies they used become a $5B startup and reach 1M users are so impressive. Here's a few things you can learn from them 🧵" / Twitter

[Twitter] (20) Airtable on Twitter: "How can you get new insights from your Airtable data? Connect them to your #dataviz tools 📊 such as #Tableau, #GoogleDataStudio and #MSPowerBI: https://t.co/tm8Ocg07AR @tableau @googleanalytics @MSPowerBI" / Twitter

An App a Day –

Watch as we install, explore, and showcase the Embed App from the Airtable Marketplace. The app is described as “Look at content from all over the internet without leaving your base. Just enter a URL and the page, video, livestream, feed, post, or widget will appear in a frame on your dashboard. You can even embed other Airtable view or base share links in an embed app!”.

View App

Field Focus –

A deep dive into the Field Filters View Filters – We cover the recently released Field Filters for Views and how you can take advantage of them 

Learn More Here

Automate Create –

Watch as we review and work through automations. The final installment to bring our Customer Feedback loop together and create a UI for the customer to interact with the feature requests, all built entirely in Airtable with no 3rd party tools.

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

Following Articles Used in this Segment:

[Airtable Community] New Feature: Timeline view – Announcements – Airtable Community Forum

[Airtable Community] Update to Automations pane – Announcements – Airtable Community Forum

[Airtable Community] September 2021 Product Updates – Announcements – Airtable Community Forum

[Airtable Community] Prevent duplicates in primary key field : Airtable

[Facebook] (20+) Airtable Community | Hello, I need a help to Update Multiples records in a View. I can find the records ID, they came all together with Comma separation. but when i used those in Update record Automation it is not working. Kindly check it and let me know. Kindly check the Screenshot. Thanks | Facebook

[Facebook] (20+) Airtable Community | Hi Everybody, Can anyone tell me why I am getting an error when I try to write these records from a Template table into a new table. It works fine when I comment out the field Operation. However, I need that value to pull over for each record as well. It is a single select field. Thanks. | Facebook

[Facebook] (20+) Airtable Community | So what's up with taking apps and making them views | Facebook

[Facebook] (20+) Airtable Community | Cool news! I got written up by Makerpad for all my Airtable work | Facebook

[Web] The Top Sessions of SaaStr Scale: CEOs of Okta, Airtable, Safegraph, BlackLine and More!! | SaaStr

[Airtable Community] Scheduled maintenance and downtime on October 15 – Announcements – Airtable Community Forum

An App a Day –

Watch as we install, explore, and showcase the Timeline App from the Airtable Marketplace. The app is described as “Airtable recently released Timeline as a new View to showcase date based data in a timeline UI. Alli will walk through how to use this new view in your bases.”.

View App

Audience Questions –

Kamille answers the Airtable question: “CSV Download Converts Currency to Text”

View the question in the community

Answer: Make a simple table that had four test fields: a number, currency, formula formatted as currency, and a text field that looks like a currency.

Automate Create –

Watch as we review and work through automations. Part 2 of this series to build a Customer Feedback Loop application to request feedback from customers on your product, using On2Air as an example use case.

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

Following Articles Used in this Segment:

[Airtable Community] Escaping of data in formulas for API calls? – Development and integrations / API – Airtable Community Forum

[Airtable Community] The ability to add a comment to any given field for any given record – Show and tell / Product Suggestions – Airtable Community Forum

[Airtable Community] New Scripting API calls: Selecting records by recordId – Development and integrations / Scripting app – Airtable Community Forum

[Reddit] (1) A mess of charges : Airtable

[Reddit] (1) I built a tool to send Tweets from Airtable automatically : Airtable

[Twitter] (20) ⚓️ Matt Lane on Twitter: "This seems undesirable @airtable (I don't know any of these Megans, but now I do know their email addresses) https://t.co/3ayEhnbEy4" / Twitter

[Twitter] (20) David Hoang on Twitter: "Anyone else call shared @Airtable bases…Sharetables? "I'll send you a Sharetable."" / Twitter

[Twitter] (20) Ankit Gordhandas on Twitter: "@ChrisJBakke 8 Figure revenue: Airtable" / Twitter

[BuiltOnAir Community] Slack | airtable-help | BuiltOnAir

Meet the Experts –

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.

Visit them online

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 ”.

View App

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

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

Following Articles Used in this Segment:

[Airtable Community] Airtable front-end builder release? – Ask the community – Airtable Community Forum

[Airtable Community] Create scripts / automation through AirTable API – Development and integrations / API – Airtable Community Forum

[Airtable Community] Problem on my Script Suddenly – Ask the community / Automations – Airtable Community Forum

[Reddit] Can I sell my airtable? : Airtable

[Airtable Community] New Scripting API calls: Selecting records by recordId – Development and integrations / Scripting app – Airtable Community Forum

[Twitter] (18) Amy Hoy on Twitter: "airtable is so awkward" / Twitter

[Reddit] Linking Records Across Bases / Pages : Airtable

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 Aitable allows for viewing 2 dimensional data by creating lanes for the intersection of 2 fields.”.

Audience Questions –

Kamille answers the Airtable question: “Estimated Delivery Date from todays date or date Payment is Received (nested if formula)”

View the question in the community

Answer: Kamille shows how to optimize the formula to be shorter and not repeat the field used (i.e. the DRY concept of Dont Repeat Yourself)

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 1
This weeks Hosts: Kamille ParksDan Fellars
This weeks Segments:
Round The Bases –

This week, we review: {Summary}}

Following Articles Used in this Segment:

[Airtable Community] July product updates – Announcements – Airtable Community Forum

[Web] Airtable: The $7.7B Roblox of the Enterprise | Sacra

[Reddit] What is the benefit of creating multiple select vs a new linked table? : Airtable

[Reddit] Is Airtable the answer?? : Airtable

[Reddit] Have to send an email 5 minutes after a form is submitted, but NOW() function is does not refresh often enough. Workaround? : Airtable

[Reddit] Spreadsheet slowness, does Airtable solves the issue? : Airtable

[Twitter] (19) Airtable on Twitter: "📣 We’re excited to announce the acquisition of #nocode #dataviz tool @BayesData! Get the details via @TechCrunch: https://t.co/mchV4U5fos h/t @ron_miller" / Twitter

[Web] B2B Case Study: Airtable's Ability To Attract 3M Searches

[Airtable Community] Blocks CLI beta: custom bundler & Webpack? – Development and integrations / Custom Apps – Airtable Community Forum

[Airtable Community] New: create tables, create fields, and update field options from the Scripting App – Development and integrations / Scripting app – Airtable Community Forum

[Airtable Community] Table/Tab selection update needs work IMHO – Show and tell / Product Suggestions – Airtable Community Forum

[Airtable Community] August Product Updates – Announcements – Airtable Community Forum

[Airtable Community] Pricing – Scripting App No Longer Free – Development and integrations / Scripting app – Airtable Community Forum

[Twitter] Andrew Davison on Twitter: "Heads up! 🚨 The @Airtable integration in @Zapier appears to have been updated with a breaking change 😐 As of this AM, column fields are now nested in a 'fields__' item. TLDR; all your Airtable-triggered zaps are now broken." / Twitter

[Twitter] (8) Seth Fannin🛠💻 on Twitter: "I have a need for a use case in airtable but can't find a solution. ✅Hotjar for Airtable Sometimes a database is a product and your users are freely using. I want to know what rows there clicking and what content they like more. Would you pay for this? #nocode" / Twitter

[Twitter] (17) FRANK on Twitter: "When you realize #airtable replaces $3k worth of apps you've already purchased. https://t.co/F1YrfDOD9L" / Twitter

[BuiltOnAir Community] Slack | general | BuiltOnAir

[BuiltOnAir Community] Slack | airtable-dev | BuiltOnAir

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”.

View App

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 Questions –

answers the Airtable question: “”

View the question in the community

7/27/2021 – BuiltOnAir Live Podcast Full Show – S08-E12 Duration: 55 minutes Be Sure...

7/20/2021 – BuiltOnAir Live Podcast Full Show – S08-E11 Duration: 63 minutes Be Sure...

7/13/2021 – BuiltOnAir Live Podcast Full Show – S08-E10 Duration: 56 minutes Be Sure...