6/29/2021 – BuiltOnAir Live Podcast Full Show – S08-E09
Duration: 69 minutes
Be Sure to Subscribe to the podcast!
To get all the latest videos and demonstrations from the BuiltOnAir Podcast, subscribe and get notified on our Youtube channel here and our newsletter/community here.
FULL EPISODE VIDEO
Watch the full video of the show. See below for segment details.
The BuiltOnAir Podcast is Sponsored by On2Air – Integrations and App extensions to run your business operations in Airtable.
In This Episode
Welcome to the BuiltOnAir Podcast, the live show.ย The BuiltOnAir Podcast is a live weekly show highlighting everything happening in the Airtable world.
Check us out atย BuiltOnAir.com. Join our community, join our Slack Channel, and meet your fellow Airtable fans.
Alli Alosa – Hi there! I’m Alli ๐ I’m a fine artist turned “techie” with a passion for organization and automation. I’m also proud to be a Community Leader in the Airtable forum, and a co-host of the BuiltOnAir podcast. My favorite part about being an Airtable consultant and developer is that I get to talk with people from all sorts of industries, and each project is an opportunity to learn how a business works.
Kamille Parks – I am an Airtable Community Forums Leader and the developer behind the custom Airtable app “Scheduler”, one of the winning projects in the Airtable Custom Blocks Contest now widely available on the Marketplace. I focus on building simple scripts, automations, and custom apps for Airtable that streamline data entry and everyday workflows.
Dan Fellars – I am the Founder of Openside, On2Air, and BuiltOnAir. I love automation and software. When not coding the next feature of On2Air, I love spending time with my wife and kids and golfing.
Show Segments
Round The Bases – 00:00:32 –
Following Articles Used in this Segment:
[BuiltOnAir Community] Sending Emails in Automation Limits
[BuiltOnAir Community] Find Record or Creation
[Reddit] My automation tests fine, but doesn't run when turned on : Airtable
[Reddit] How do I create a multiple-lookup table? : Airtable
Audience Questions – 00:37:41 –
Kamille Parks answers the Airtable question: “How do you tell an automation to run at a certain time?”
View the question in the community
Answer: The solution to this is usually to add a formula field to check if the now is after the date field in question. It's best practice to set the times zones for date fields. Automation is looking for, if there is a checkmark in this field, then run the automation. If there is no check mark in the field do not run it, becasue it hasn't happened yet.
Scripting Time – 00:44:07 –
Explore Scripting with โRandomized Valuesโ.
Allows you to insert random values into cells. Running a script..
Air Chefs – 01:00:43 –
Watch as Alli Alosa takes on Kamille Parks to improve the base Sales CRM Dashboard from the Airtable Universe, and make it even better with automations, different field types, and apps from the marketplace.
Full Segment Details
Segment: Round The Bases
Start Time: 00:00:32
Roundup of what’s happening in the Airtable communities – Airtable, BuiltOnAir, Reddit, Facebook, YouTube, and Twitter.
Following Articles Used in this Segment:
[BuiltOnAir Community] Sending Emails in Automation Limits
[BuiltOnAir Community] Find Record or Creation
[Reddit] My automation tests fine, but doesn't run when turned on : Airtable
[Reddit] How do I create a multiple-lookup table? : Airtable
Segment: Audience Questions
Start Time: 00:37:41
Airtable Question – How do you tell an automation to run at a certain time?
Kamille Parks answers the Airtable question: “How do you tell an automation to run at a certain time?”
View the question in the community
Answer: The solution to this is usually to add a formula field to check if the now is after the date field in question. It's best practice to set the times zones for date fields. Automation is looking for, if there is a checkmark in this field, then run the automation. If there is no check mark in the field do not run it, becasue it hasn't happened yet.
Segment: Scripting Time
Start Time: 00:44:07
Scripting Time: Randomized Values – Allows you to insert random values into cells. Running a script.
Explore Scripting with โRandomized Valuesโ.
Allows you to insert random values into cells. Running a script..
Segment: Air Chefs
Start Time: 01:00:43
Alli Alosa vs Kamille Parks improve the Airtable base, Sales CRM Dashboard
Watch as Alli Alosa takes on Kamille Parks to improve the base Sales CRM Dashboard from the Airtable Universe, and make it even better with automations, different field types, and apps from the marketplace.