Author: BuiltonAir Team

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

Following Articles Used in this Segment:

[Airtable Community] New functionality for managing Airtable at scale – Announcements – Airtable Community Forum

[Reddit] I've created an interface to monitor my sales in Stripe. I really like this new feature! : Airtable

[Reddit] TV Guide style grid template? : Airtable

[Facebook] (20+) Airtable Community | Thanks Aron Korenblit for your inspiration of automating Youtube channel | Facebook

[Twitter] (20) Airtable on Twitter: "🚨 Calling all admins! Today we're announcing new functionality to help manage Airtable at scale: ✅ New Admin Panel experience ✅ Ability to create User Groups ✅ New security controls & audit logs ✅ Improved base performance & mgmt Get the details ➡️ https://t.co/AXQwCO9KBu" / Twitter

[Twitter] (28) Dawn | Story Crafter on Twitter: "Does anyone know how I can reduce an Airtable automation to one email? Cause I have about 30 emails from them about a record created. I only need one." / Twitter

[BuiltOnAir Community] Slack | general | BuiltOnAir

Field Focus –

A deep dive into the Simple Time-interval Reporting Formula – Ever need to get the count of how many records are from a given year? Or quarter? Or month? Take a look at this sample base that uses a few formulas and a simple Automation to automatically link records from one table (i.e. "Log") to all the relevant report records in a dedicated table. 

Learn More Here

Meet the Creators –

Meet Zoltan Peresztegi from TruSource.

Visit them online

An App a Day –

Watch as we install, explore, and showcase the TrueSource App from the Airtable Marketplace. The app is described as “Market & monetize your data. Build data products with no code.”.

View App

Season 9 Episode 10
This weeks Hosts: Kamille ParksAlli AlosaDan Fellars
This weeks Segments:
Round The Bases –

Following Articles Used in this Segment:

[Twitter] (20) Walter Chen on Twitter: "we rolled out @airtable at @AnimalzCo in 2016 to our team of ~15 people. as we grew, new team members struggled to understand and use airtable. we ended up building a web app wrapper around airtable embeds that we've used for 4+ years 👇 https://t.co/6bELh2rSCL" / Twitter

[Twitter] (20) Alex on Twitter: "Well @airtable just finished the game" / Twitter

[Reddit] Biggest news with Airtable in five years: Interfaces! : Airtable

[Web] Ask HN: What do you think about the no-code movement? | Hacker News

[Web] Airtable launched when productivity wasn’t hot. What’s the next move? – Protocol — The people, power and politics of tech

[Airtable Community] Latest Ask the community/Interface Designer topics – Airtable Community Forum

[Web] Designing a LEGO kit for software | by Joel Lewenstein | Medium

[Reddit] Is it just me or do Airtable Timeline's don't have support for time? : Airtable

[Reddit] Interface – Is there a way to make an “Add new Record” function? : Airtable

[Twitter] (20) NoCodeDevs on Twitter: "So @paulharr1983 made some amazing dashboards using @airtable's new interface builder! 🔥🔥 https://t.co/hPb7ny3OOR" / Twitter

A Case for Interface –

Explore Interfaces with “Creating a Dashboard Interface”.

.

Meet the Creators –

Meet Drew Dillon from Burb.

Visit them online

An App a Day –

Watch as we install, explore, and showcase the Burb App from the Airtable Marketplace. The app is described as “Learn how to build a training course managed in Airtable with Burb.”.

View App

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

A Case for Interface –

Explore Interfaces with “Introduction to Interfaces”.

Check out our first look at recently launched Interfaces.

View Script

Meet the Experts –

Meet Ben Green.

Visit them online

Automate Create –

Watch as we review and work through automations. Implement an Automation to create tasks from templates

Season 9 Episode 8
This weeks Hosts: Alli AlosaDan FellarsHannah Wiginton
This weeks Segments:
Round The Bases –

Following Articles Used in this Segment:

[Twitter] (17) Zapier on Twitter: "Our content marketing team lives and breathes @airtable. Here’s how our staff writer learned to navigate the app and make it work for him. https://t.co/gI6MRD2U2A" / Twitter

[Twitter] (17) Ali Moiz on Twitter: "As cool as @airtable is, your API is very limited. It's 2021, and we're having to use embedded google sheets b/c their API is better." / Twitter

[Twitter] (17) JacobMeyer.eth 🍌 on Twitter: "Why did no one tell me Airtable was the answer to everything?" / Twitter

[Twitter] (17) hiten.eth on Twitter: "Hey @airtable, this is insane pricing. wtf. making me think about alternatives now. /cc @Patticus https://t.co/h5Uq9Inqdw" / Twitter

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

[Airtable Community] Field Permissions: No edit privileges except for Scripts/Blocks – Show and tell / Product Suggestions – Airtable Community Forum

[Reddit] anyone ever switch from monday.com to airtable? : Airtable

[Facebook] (20+) Airtable Community | There’s no way to have the multiple columns lock like the primary field is there | Facebook

[BuiltOnAir Community] Slack | airtable-dev | BuiltOnAir

[Twitter] (20) Britney on Twitter: "Why is it so bloody difficult to populate a select list from an existing column in another base in Airtable.. unless i'm missing something? Its so much simpler in Coda." / Twitter

[Twitter] (20) Samuel Thompson 🥽 on Twitter: "Build a Twitter CRM in 30 min. Here's how 👇" / Twitter

Automate Create –

Watch as we review and work through automations. This gift tracker app will keep your Christmas shopping organized, save you money $$$, and keep you on track. You might even finish early this year!

Learn more about the automation

An App a Day –

Watch as we install, explore, and showcase the Page Designer App from the Airtable Marketplace. The app is described as “Learn how to use the Page Designer app for your templating needs”.

View App

Scripting Time –

Explore Scripting with “Create child link records”.

For a record in a "parent" table, this script will create some number of "child" records in another table, where each "child" references the "parent" through a Linked Record field..

View Script

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