Author: BuiltonAir Team

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

6/29/2021 – BuiltOnAir Live Podcast Full Show – S08-E09 Duration: 69 minutes Be Sure...

6/22/2021 – BuiltOnAir Live Podcast Full Show – S08-E08 Duration: 61 minutes Be Sure...

6/15/2021 – BuiltOnAir Live Podcast Full Show – S08-E07 Duration: 68 minutes Be Sure...