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.

FULL EPISODE AUDIO

Listen to the full Audio podcast for this episode here. Or add to your favorite podcast player

Listen On: Apple | Overcast | Spotify


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.

Todays Hosts

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:

[Airtable Community] New automation trigger for form responses – Announcements – Airtable Community Forum

[Airtable Community] I just joined Air Table – why is my dashboard full of someone else's content? – Ask the community / Views – Airtable Community Forum

[Airtable Community] Run custom app without opening sidebar? – Development and integrations / Custom Apps – Airtable Community Forum

[Airtable Community] Best practise with triggering on "When record is created" – Ask the community / Automations – Airtable Community Forum

[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

[Facebook] (20+) Airtable Community : Question πŸ™‚ Is it possible to have a form entry 1- print to PDF, but only the applicable entries within the form, 2- Send PDF attachment + Confirmation email to customer who submitted the form and 3- bcc all members of my team with the form | Facebook

[Twitter] (19) Bruno.vc Brasil Ferrari Faviero on Twitter: "I literally had a dream last night that I could wrap text within @airtable cells. I had to open my laptop and check it as soon as I woke up. Sadly, it still wasn't true." / Twitter

[Twitter] (19) π˜Όπ™‡π™€π™“ π™’πŸ•ΉοΈπ™‡π™π™€ on Twitter: "Airtable Γ— Xbox https://t.co/qmJrHcVimZ" / Twitter

[Twitter] (19) Alex Hayworth on Twitter: "I do the bulk of my work + organizing in Notion, but I made a to-do/task manager in Airtable and it's the first to-do type thing that I've been able to stick to, at all, ever, in my life thus far. Might just be me, and be an attribution error. But who knows. Curious." / Twitter

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

View 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:

[Airtable Community] New automation trigger for form responses – Announcements – Airtable Community Forum

[Airtable Community] I just joined Air Table – why is my dashboard full of someone else's content? – Ask the community / Views – Airtable Community Forum

[Airtable Community] Run custom app without opening sidebar? – Development and integrations / Custom Apps – Airtable Community Forum

[Airtable Community] Best practise with triggering on "When record is created" – Ask the community / Automations – Airtable Community Forum

[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

[Facebook] (20+) Airtable Community : Question πŸ™‚ Is it possible to have a form entry 1- print to PDF, but only the applicable entries within the form, 2- Send PDF attachment + Confirmation email to customer who submitted the form and 3- bcc all members of my team with the form | Facebook

[Twitter] (19) Bruno.vc Brasil Ferrari Faviero on Twitter: "I literally had a dream last night that I could wrap text within @airtable cells. I had to open my laptop and check it as soon as I woke up. Sadly, it still wasn't true." / Twitter

[Twitter] (19) π˜Όπ™‡π™€π™“ π™’πŸ•ΉοΈπ™‡π™π™€ on Twitter: "Airtable Γ— Xbox https://t.co/qmJrHcVimZ" / Twitter

[Twitter] (19) Alex Hayworth on Twitter: "I do the bulk of my work + organizing in Notion, but I made a to-do/task manager in Airtable and it's the first to-do type thing that I've been able to stick to, at all, ever, in my life thus far. Might just be me, and be an attribution error. But who knows. Curious." / Twitter

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

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