Author: BuiltonAir Team

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

Meet the Creators –

Meet Rob Weidner from https://prettysim.pl/.

Drawing upon my unique background in the entertainment industry and a strong entrepreneurial spirit, I focus on transforming business processes, enhancing productivity, and scaling operations. My approach involves streamlining workflows, eliminating bottlenecks, and deploying efficient systems and automations.

Visit them online

Base Showcase –

We dive into a full working base that will Film Gear South Africa is an ecommerce store that was founded in 2015 with the goal of creating a marketplace for new high-end film equipment in the South African market. The founder, who worked as an assistant cameraman in Cape Town at the time, faced challenges in finding reliable resellers for different brands of film equipment in South Africa. Leveraging their background in computer science, they decided to build a platform to address this problem and provide a solution for others in the industry. From the beginning, Film Gear South Africa was built on the Shopify platform. Shortly after starting the store, the founder realized that the value of the platform would increase by incorporating new products from various brands as they were released. However, they encountered several business problems that needed to be solved. One challenge was offering an end-to-end local currency solution in South African Rand, even though the base prices of the products were in other more stable currencies. Another challenge was the fluctuating value of the items throughout the day, as the store didn’t hold any inventory in the country. To address these challenges, the founder took matters into their own hands. They started by scraping various websites to gather up-to-date pricing and product information. This allowed them to set the prices themselves and eliminate the need to rely on distributors for information. Additionally, they developed a tool to perform currency conversions every three hours, minimizing foreign gains or losses. Initially, the founder manually loaded CSV files into the Shopify store to update prices, but this approach wasn’t scalable due to the varying formats of the CSV files from different brands. This led to another realization that website scraping could provide the information they needed. They discovered a tool called ParseHub, which allowed them to automate the scraping process and collect the data. To manage the collected data, the founder turned to Airtable, as Excel and Google Sheets weren’t sufficient for their needs. They needed a tool that could handle the translation of different pricing models and facilitate the transfer of data from one system to another. That’s when they discovered Make (formerly Integromat), which served as the bridge between ParseHub and Shopify. With this combination of tools – ParseHub, Make, and Shopify – the founder could gather information on-demand or on a schedule, at an affordable price. This enabled them to quickly onboard new brands and products with just a few clicks, while their competitors were still manually copying and pasting outdated information. Overall, the founder’s innovative use of technology, their knowledge of the film industry, and their persistence in finding solutions to business challenges led to the successful establishment of Film Gear South Africa as a thriving ecommerce store for high-end film equipment.

Field Focus –

A deep dive into the Synced Field Types All Types – Alli will review some tips and tricks when changing field types of a synced table. 

Season 15 Episode 2
This weeks Hosts: Alli AlosaKamille ParksDan Fellars
This weeks Segments:
Automate Create –

Watch as we review and work through automations. Scott Rose will showcase how to use Make.com to automate the process of importing and exporting Airtable data as CSV

Round The Bases –

A Case for Interface –

Explore Interfaces with “Detail Pages”.

Kamille will walk us through some recent changes in how detailed/side bar pages work in Interfaces.

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

Automate Create –

Watch as we review and work through automations. Alli will walk through how to set up 2 way sync and what to be aware of

Learn more about the automation

Audience Questions –

Lisa Bauer answers the Airtable question: “Create new records for each week of another record’s timeframe”

View the question in the community

Answer: Kamille will walk through this question and provide a working solution.

Field Focus –

A deep dive into the Progress Bars Percentage – Percentage Fields can now be displayed as progress bars 

Learn More Here

Season 14 Episode 8
This weeks Hosts: Kamille ParksDan Fellars
This weeks Segments:
Round The Bases –

Following Articles Used in this Segment:

[BuiltOnAir Community] general – BuiltOnAir – Slack

[BuiltOnAir Community] Formula Output Text Limit

[Airtable Community] New: Improvements to Timeline View – Airtable Community

[TableForums] Max length in URL for pre-filled form is 16000 characters for Airtable Form – but may depend on browser – Airtable Questions – TableForums: The Unofficial Airtable Discussion Community

[TableForums] Jobs/roles related to creating with Airtable – General Discussion – TableForums: The Unofficial Airtable Discussion Community

[TableForums] AI-First Attitude Adjustment – Airtable Developers / Scripting – TableForums: The Unofficial Airtable Discussion Community

Industry View –

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

Jen Rudd will walk through how Airtable can be used within the NGO/Non-profit world.

Base Showcase –

We dive into a full working base that will Kamille will showcase a demo of a prototype for the character listing of a Table Top Role Playing Game.

Audience Questions –

Jason G answers the Airtable question: “How does the scripting handle record ids if not in the view”

View the question in the community

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

Meet the Experts –

Meet Lorenzo Lee.

Lorenzo is the Founder

Visit them online

Meet the Experts –

Meet Bill French.

Visit them online

Industry View –

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

Our panel of experts will dive deep into the world of AI and how it relates to Airtable.

Click Here

Season 14 Episode 6
This weeks Hosts: Alli AlosaKamille Parks
This weeks Segments:
Meet the Creators –

Meet Daretable Attendees from Daretable.

We interviewed a handful of Daretable attendees on how the conference has gone.

Visit them online

Season 14 Episode 5
This weeks Hosts: Kamille ParksDan Fellars
This weeks Segments:
Round The Bases –

Meet the Creators –

Meet Chris Talley and Steven Zhang.

Chris and Steven are both former Airtable developers who have joined forces to build new apps on Airtable. Check out their latest projects at https://www.warntracker.com/ and https://www.climatetechlist.com/

Visit them online

An App a Day –

Watch as we install, explore, and showcase the Calendar Sync App from the Airtable Marketplace. The app is described as “Chris and Steven share how to implement Calendar syncing in Airtable.”.

Automate Create –

Watch as we review and work through automations. Kamille explains the repeater functionality in Automations.

Season 14 Episode 4
This weeks Hosts: Alli AlosaDan Fellars
This weeks Segments:
Round The Bases –

Following Articles Used in this Segment:

[BuiltOnAir Community] Airtable sunsetting extensions Hangouts, Whereby, Name Quiz – General Discussion / Airtable News & Announcements – TableForums: The Unofficial Airtable Discussion Community

Scripting Time –

Explore Scripting with “Secrets to Scripting”.

Scripting expert, Kuovonne, will share some ways to dive into the world of Airtable Scripting.

View Script

Base Showcase –

We dive into a full working base that will Alli will share how to build a simple invoicing base with line items.

Field Focus –

A deep dive into the Record Templates – Dan will walk through the new Record Templates and how they work. 

Learn More Here

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

Base Showcase –

We dive into a full working base that will Scott Rose will showcase some ways to incorporate AI and ChatGPT within Airtable.

Audience Questions –

answers the Airtable question: “How to build an Inventory check in/out system”

View the question in the community

Answer: Kamille will walk through how to manage the process of checking in/out items from inventory.

Field Focus –

A deep dive into the Formula Best Practices Formula – Alli will share some best practices for working with formulas 

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

Meet the Creators –

Meet Jason Montoya.

As a follower of the Way, the Truth and the Life, I am also a husband, father, teacher and storyteller.
I believe in sharing good, and not so good, stories from my journey through this website as a way to process ideas and inspire others.
In my journey, I have personally experienced and seen others experience the life of surviving in isolation. In these times of need, others helped and inspired me when I needed it. As a result, my personal aim is to inspire others to a place of thriving and togetherness.

Visit them online

Base Showcase –

We dive into a full working base that will Jason Montoya showcases a few bases he uses to run his business. These will demonstrate how to use Airtable for Freelancer Project Management and another for SEO Optimization Marketing.

Scripting Time –

Explore Scripting with “Date Based Change Log”.

Kamille will walk through a script that generates a change log for one or more date fields..