![[S09-E08] Full Podcast Summary for 11-02-2021](https://builtonair.com/wp/../uploads/segment_image_1-42.png)
11/2/2021 – BuiltOnAir Live Podcast Full Show – S09-E08
Duration: 61 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.
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.
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.
Hannah Wiginton – I help bold, active entrepreneurs and companies with digital marketing through creative and technical content and systems.
Show Segments
Round The Bases – 00:03:36 –
Following Articles Used in this Segment:
[Airtable Community] October 2021 Product Updates – Announcements – Airtable Community Forum
[Reddit] anyone ever switch from monday.com to airtable? : Airtable
[BuiltOnAir Community] Slack | airtable-dev | BuiltOnAir
[Twitter] (20) Samuel Thompson 🥽 on Twitter: "Build a Twitter CRM in 30 min. Here's how 👇" / Twitter
Automate Create – 00:34:57 –
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 – 00:55:03 –
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”.
Scripting Time – 00:46:22 –
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..
Full Segment Details
Segment: Round The Bases
Start Time: 00:03:36
Roundup of what’s happening in the Airtable communities – Airtable, BuiltOnAir, Reddit, Facebook, YouTube, and Twitter.
Following Articles Used in this Segment:
[Airtable Community] October 2021 Product Updates – Announcements – Airtable Community Forum
[Reddit] anyone ever switch from monday.com to airtable? : Airtable
[BuiltOnAir Community] Slack | airtable-dev | BuiltOnAir
[Twitter] (20) Samuel Thompson 🥽 on Twitter: "Build a Twitter CRM in 30 min. Here's how 👇" / Twitter
Segment: Automate Create
Start Time: 00:34:57
Airtable Automations – Christmas Gift Tracker App
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
Segment: An App a Day
Start Time: 00:55:03
Airtable App Showcase – Page Designer – Learn how to use the Page Designer app for your templating needs
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”.
Segment: Scripting Time
Start Time: 00:46:22
Scripting Time: Create child link records
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..
Full Transcription
The full transcription for the show can be found here:
[00:01:40] Welcome to the BuiltOnAir podcast. [00:01:44] This is season nine, episode eight. [00:01:46] Coming to you live on this Tuesday. [00:01:49] Glad to be with you, I missed last week. [00:01:52] So it's good to be back. [00:01:54] But thanks to Alli and Kamille who [00:01:57] had a great episode last week [00:01:59] and maybe we'll do that [00:02:00] more often where I'm [00:02:01] not there. So I think [00:02:03] people enjoyed that one, [00:02:06] we'll keep that up. [00:02:07] So today's episode, [00:02:08] we have again with this, [00:02:09] Alli Hello, Alli, [00:02:12] good to have you back [00:02:13] and we have a special, [00:02:15] not her first time on the show, [00:02:16] but Hannah Wiginton is with us again. [00:02:20] Hello, Hannah, thanks for jumping on with [00:02:23] us. [00:02:24] Bill couldn't make it with us today, [00:02:27] so we're always happy to have new [00:02:29] faces with us. [00:02:30] So Hannah will be sharing some [00:02:32] cool stuff that she's built [00:02:35] with us later in the episode. [00:02:37] So the BuiltOnAir podcast [00:02:39] is a live show where [00:02:40] we go through four different [00:02:42] segments where we talk [00:02:44] about all things Airtable [00:02:45] quickly run through the agenda for today. [00:02:47] We always start off with Round the Bases [00:02:50] where we talk about what's going on [00:02:52] in the Airtable communities and keep [00:02:53] you up to date on everything new. [00:02:56] Then we'll do a spotlight on our primary [00:02:58] sponsor On2Air. [00:03:00] Well then do an Automate Create [00:03:03] where Hannah will show [00:03:04] a new app that new base [00:03:06] that she's built and shared [00:03:08] with the community [00:03:09] and then Alli is gonna go through [00:03:12] the Page Designer [00:03:13] and we'll learn all about the [00:03:14] how to use the Page Designer [00:03:17] app for your bases. [00:03:19] Another spotlight on our [00:03:20] community, and then we'll [00:03:22] end it with a Scripting Time [00:03:24] going through a script [00:03:25] and how we can use to [00:03:27] create child linked records. [00:03:29] So with that we will [00:03:31] go to Round the Bases. [00:03:33] We always like to start off [00:03:35] with the Airtables community [00:03:38] and see what's going on [00:03:39] and they've been pretty [00:03:41] consistent at the end of each month, [00:03:43] giving an overview of what's [00:03:46] new feature wise for the last month. [00:03:49] So for the month of October [00:03:51] looks like the only listed [00:03:54] four different things, [00:03:55] some of them small, some of them big. [00:03:58] So, anybody want to tackle [00:04:01] any of the big features that got added? [00:04:04] This one is probably the biggest [00:04:09] filtering, yes, very exciting. [00:04:13] It makes for a [00:04:14] lot less work arounds [00:04:16] when you're trying to [00:04:18] filter multiple things. [00:04:20] That's that is a big deal, [00:04:22] I'm really excited about that [00:04:24] one. [00:04:25] Yeah. [00:04:27] Yeah, I always like when I see core [00:04:30] functionality of Airtable improving, [00:04:32] my preference is, there's a lot [00:04:35] that they can fix there instead of kind of [00:04:37] the new apps or add ons [00:04:39] or anything but are extensions [00:04:42] I like to see the core [00:04:44] improving, [00:04:45] so that's a big one. [00:04:47] Some other smaller ones [00:04:50] they added linking to [00:04:54] so I guess Google drive, [00:04:55] I didn't, I guess that's now [00:04:57] available to everybody and [00:04:59] maybe it was in beta before [00:05:01] because I thought that [00:05:02] had been around for a while [00:05:04] and let's see, [00:05:05] I think there's more in here. [00:05:07] Oh yeah. GitHub. So they added syncing [00:05:09] to GitHub issues, [00:05:10] it looks like that one's still in beta. [00:05:13] So they just launched the beta there. [00:05:16] This was one I didn't know about. [00:05:18] I don't remember seeing this one. [00:05:20] So being able, [00:05:21] so this is for slack messages, [00:05:24] within automations so you can [00:05:27] unfurl links so it automatically [00:05:29] like, [00:05:30] creates them as links [00:05:32] if you have a link in your message [00:05:35] that you're submitting [00:05:37] to slack. [00:05:40] I assume that's what it means. [00:05:42] I don't know exactly what unfurled means. [00:05:47] Like open up maybe [00:05:49] or something like that. [00:05:51] Like display more of it, [00:05:53] I think, [00:05:54] right, like shown in the preview, [00:05:55] like how if you put in the [00:05:57] Airtable link into [00:05:57] to slack, it'll have like [00:05:59] the big icon or it's just like a [00:06:02] black background. [00:06:04] Okay, Okay. Yeah, [00:06:05] I know what you're talking about [00:06:07] Gotcha. Yeah. [00:06:08] So you can embed the link message. [00:06:11] Okay, that's a cool feature. [00:06:12] That makes sense. Gotcha. [00:06:15] All right. And then this was another one [00:06:17] that I haven't played with this yet. [00:06:19] Have either of you played with the [00:06:23] being able to use formulas and roll ups in [00:06:26] the automations? [00:06:28] Conditions. [00:06:30] I [00:06:32] literally tried, So was [00:06:35] I'm a little confused about this. [00:06:37] I noticed somebody [00:06:38] actually posted about this [00:06:39] in the Airtable, Rebecca did I think. [00:06:42] And I was like, what does that even mean? [00:06:44] Like, I didn't know that [00:06:45] you couldn't already, but [00:06:47] there was, [00:06:49] there's one thing that [00:06:50] I think it's still a bug that [00:06:52] the dynamic [00:06:55] variables that you can insert [00:06:57] into the like steps [00:06:59] after the trigger step of an [00:07:00] automation. That still doesn't work [00:07:03] for a formula, a roll up field or a linked [00:07:05] record field. Either [00:07:07] it does work for a formula. [00:07:09] My apologies. [00:07:09] Just not a linked record or look up. [00:07:13] Yeah but I don't understand [00:07:15] what this one means. [00:07:16] Yeah I went and looked and I [00:07:18] mean you can definitely [00:07:20] use a formula in a condition. [00:07:22] So yeah I kind of was [00:07:24] the same. I don't I thought [00:07:26] you could always do that [00:07:28] in your automation unlocking [00:07:30] so many new possibilities [00:07:33] for your workflow [00:07:35] using the value [00:07:37] in that condition. [00:07:42] Maybe they just never announced [00:07:44] it and I thought this would [00:07:46] be a good time to do [00:07:47] it and make it public [00:07:49] Yeah. Let's see here. [00:07:54] I think it might be in the, [00:07:57] okay, so I think it's just [00:08:00] with the find record [00:08:03] automation so not the trigger. [00:08:06] So I think that's confusing. [00:08:07] So I think it's if you're [00:08:09] using the find records, [00:08:10] I think there was an issue [00:08:13] where you couldn't use formulas [00:08:16] in your query to find [00:08:18] records [00:08:19] so it looks like that. [00:08:23] Although I don't know I guess I don't [00:08:27] was it like the like a [00:08:29] formula field wasn't available [00:08:32] as a drop down options [00:08:33] and drop down like in here [00:08:35] like in the conditions. [00:08:37] That's weird I guess I never noticed that [00:08:41] so that's interesting [00:08:43] but it looks like sorry go ahead. [00:08:45] I was gonna say it looks like [00:08:48] so this doesn't yet use the new filter, [00:08:50] the advanced, [00:08:52] you know conditional filtering, [00:08:54] this is still kind of using the either or [00:08:57] so you can't do advanced [00:08:59] filtering within these conditions. [00:09:03] So yeah, I wonder if they'll [00:09:05] update that at some point. [00:09:08] Yeah, [00:09:09] this is the option that I need, [00:09:11] I want them to fix. [00:09:12] This is more important to me [00:09:13] than anything. Like [00:09:15] if they could [00:09:16] that dynamic option [00:09:18] if you try and insert after [00:09:20] clicking that plus sign a linked [00:09:23] record field or a look up, [00:09:24] you only get the option to put the length [00:09:27] of whatever the value is [00:09:30] and that's not helpful at all. Yeah [00:09:33] it's really hot but you can [00:09:35] do it with a formula though, [00:09:37] a formula I don't think [00:09:38] a formula [00:09:39] always has worked [00:09:40] but I finally for the very first time [00:09:42] got it to work yesterday. [00:09:44] Yeah. [00:09:47] Anyways, [00:09:49] looks like there's some [00:09:52] new functionality there. [00:09:54] So a few new things [00:09:55] nothing like groundbreaking, [00:09:57] although also in October [00:10:00] they apparently improve [00:10:02] the underlying database [00:10:05] enhancements and did some [00:10:07] upgrades there. So [00:10:09] maybe that's why there [00:10:11] wasn't a ton of new announcements on [00:10:14] functionality so maybe [00:10:16] next month there will be more. [00:10:19] So that's what's new with Airtable [00:10:23] for the month we'll continue on. [00:10:29] Okay this is a post actually [00:10:32] this is Kamille was originally [00:10:34] I was hoping to go [00:10:36] beyond to [00:10:37] talk about this one [00:10:38] but this was posted last year [00:10:40] one of the issues I thought it [00:10:42] would be worth bringing up. [00:10:44] One of the issues with the new with the [00:10:47] edit permissions where you can say [00:10:49] you know only certain people can can edit [00:10:52] these fields. [00:10:54] She was basically saying like [00:10:56] it would be nice if you could [00:10:58] also like not allow [00:10:59] anybody except for a script [00:11:02] or an automation to update a field. [00:11:05] So it's kind of a request for improvement [00:11:08] and people brought that up recently so [00:11:10] it came to my attention [00:11:12] that I would definitely be a [00:11:15] nice feature to add [00:11:17] where you could lock down [00:11:19] you know editing for anybody but [00:11:22] only scripts could or automations [00:11:24] could update a field [00:11:26] currently is not supported. [00:11:28] Yeah I definitely agree. [00:11:31] I've run into issues [00:11:32] trying to use that option [00:11:34] to set it when you set it to nobody. [00:11:36] And it does allow you to say you know [00:11:39] allow this to be modified [00:11:41] through forms or automations [00:11:44] but the scripting app [00:11:45] does not apparently qualify [00:11:47] as an automation so it doesn't [00:11:49] allow you to do that. [00:11:51] And then like [00:11:52] I had one where I had [00:11:54] the user [00:11:57] that owns mini extensions [00:11:58] so you know when you [00:12:00] connect with not just mini [00:12:01] extensions but like Zapier [00:12:03] even it'll say so and so [00:12:05] via api like it still [00:12:06] recognizes that user [00:12:08] as the one that edited it [00:12:10] but even when that person is [00:12:12] allowed to edit the field [00:12:14] it's still it will the automation [00:12:16] will fail like if [00:12:17] it's like [00:12:18] you're trying to edit it through [00:12:19] mini extensions are Zapier [00:12:20] in my experience [00:12:21] that doesn't work, [00:12:22] says insufficient permissions. [00:12:24] Yeah. Yeah. So I think there's [00:12:27] definitely room for [00:12:29] improvement there and we'll [00:12:31] see if that's something they address [00:12:34] good reminder of what you [00:12:36] can and can't do with permissions. [00:12:38] All right, moving on. [00:12:40] We're going to go to [00:12:41] the BuiltOnAir community. [00:12:43] There's just one topic I thought was [00:12:46] worth bringing up also kind of in that [00:12:48] same vein of automations versus scripts. [00:12:51] So somebody asked can you write a [00:12:54] script or an app, [00:12:56] actually this is specific to an app [00:12:59] that is running kind of in [00:13:00] the background [00:13:02] and like a process that can be [00:13:05] updating and both Kamille [00:13:07] and Bill responded to this saying, [00:13:09] you know scripts and apps [00:13:12] well scripting is an app [00:13:15] those only run within your [00:13:17] browser. So those are not [00:13:19] running behind the scenes. [00:13:21] So automations do run behind the scenes. [00:13:23] Those are running on Airtable's [00:13:25] server infrastructure. [00:13:27] So automations can [00:13:28] be running all the time. [00:13:30] But apps and scripts cannot [00:13:32] so just be aware of that [00:13:34] if you think you can have [00:13:35] kind of a script because [00:13:36] there are some apps that only [00:13:39] run that like these [00:13:41] we're mentioning an app that [00:13:43] they were hoping they could [00:13:44] leave it running all the time [00:13:45] to perform some kind [00:13:46] of action. [00:13:47] But it's only gonna work [00:13:49] if you have the browser open [00:13:51] and that app open as [00:13:52] well for it to be running in your browser. [00:13:58] So good to be aware of that [00:14:00] difference between scripts and automations [00:14:03] so [00:14:05] Alright, moving on, this was coming [00:14:08] from the Reddit community asking about [00:14:10] switching from monday.com to Airtable. [00:14:14] Either of you use monday.com? [00:14:18] I haven't. [00:14:20] Briefly [00:14:21] yeah. [00:14:24] And anyway, so this was [00:14:26] actually real quick. [00:14:28] I'll throw up Jen's comments [00:14:31] talking about the previous discussion, [00:14:33] Airtable also limits what scripts you [00:14:35] can run an automation. [00:14:37] So yeah, there's limitations [00:14:39] with scripts, time and [00:14:40] memory. And the api calls [00:14:44] that you can make their so [00:14:48] so yeah, that's a good point Jen. [00:14:53] So yeah, so monday.com is a [00:14:56] I don't know if it's a direct competitor. [00:14:58] I've actually never used it, [00:14:59] but you see the advertising everywhere, [00:15:01] they're heavily advertising especially [00:15:03] on Youtube. [00:15:03] I feel like every ad I see on Youtube [00:15:06] is for monday.com. [00:15:08] I mean it is very to me when I used it, [00:15:12] it was very task base which you know, [00:15:16] while Airtable can do that [00:15:18] and there are workarounds, you know, [00:15:20] monday.com is more focused on the task [00:15:23] where Airtable is more of the [00:15:25] database storing [00:15:27] the information and so [00:15:29] to me their, you can use Airtable [00:15:32] for that but monday.com in some ways [00:15:36] might be better if you really [00:15:38] just want a task management [00:15:40] only. [00:15:42] Yeah, [00:15:44] so yeah, that's so it's kind of more [00:15:47] specific to project management, [00:15:49] so it definitely doesn't have the [00:15:52] extendibility and customization that [00:15:54] Airtable has, which is what the [00:15:56] comments in this thread suggested. [00:15:59] So other people also suggest click up [00:16:02] which I have used in the past, [00:16:05] which is pretty powerful. [00:16:07] So always interesting. [00:16:08] There's so many alternatives out there, [00:16:10] I always like to see how people [00:16:13] use different tools and [00:16:15] how they compare against [00:16:17] Airtable. So I thought this was [00:16:19] worth highlighting [00:16:20] but I think the consensus [00:16:22] was, most people were moving away [00:16:24] from monday to Airtable and felt [00:16:26] like Airtable was a better fit [00:16:28] for people's needs, which [00:16:30] I always like to hear [00:16:32] being more on the Airtable side, [00:16:34] so that was good. [00:16:36] All right, moving on. [00:16:38] Next community is Airtable community [00:16:40] within Facebook [00:16:42] and this way I think Hannah [00:16:44] you're on this thread. So the question is [00:16:46] there a way to have multiple columns lock, [00:16:50] like the primary field is there [00:16:53] and so this I thought [00:16:54] was good to bring up. [00:16:55] So obviously some people didn't know [00:16:56] about it, Some people in this group, [00:16:59] I've used Airtable for like four or five [00:17:02] years and I was like [00:17:04] what I didn't even know you could do that, [00:17:07] so if you go right here and [00:17:12] yeah [00:17:14] I get it. [00:17:15] There you go. Okay, [00:17:17] so you have to be below the header. [00:17:20] So this you see this bar [00:17:21] here. If you drag it over [00:17:24] then it will freeze multiple. [00:17:26] So then when you scroll [00:17:28] then two will stay frozen. [00:17:30] So there's that bar right there [00:17:32] that you can grab [00:17:34] and stretch how many you want [00:17:35] to freeze, so [00:17:39] yeah, so that's a cool feature [00:17:41] if you're not familiar with that, [00:17:43] you know, [00:17:44] that is definitely worth highlighting. [00:17:47] So I thought that was good [00:17:48] to bring up. Yeah Jen. [00:17:50] Yeah, I know, me too. [00:17:57] All right. Looks like we've [00:17:59] got other power users [00:18:01] that are learning new tricks here. [00:18:06] Very cool. [00:18:08] So yeah, I thought that was cool [00:18:10] to show off, so that comes [00:18:11] in handy when you need [00:18:12] to freeze it [00:18:13] now, the better thing would be [00:18:15] is if you could switch which field [00:18:17] you want to display as your primary field [00:18:20] so that I've had it where you know, [00:18:23] I like will shrink this as small as I can [00:18:26] get and then the one [00:18:27] that I really want [00:18:29] isn't the primary key and then and then [00:18:31] you lock it for there [00:18:33] so you almost like try [00:18:35] to ignore that first one. I've done [00:18:38] that before. [00:18:39] That is something I like about Coda, [00:18:42] it allows you to choose what one you want [00:18:44] is your display column [00:18:46] and you can also just hide [00:18:47] anyone that you want too, [00:18:49] you can hide the display [00:18:50] column and still have it existing, [00:18:52] which is definitely a powerful feature. [00:18:55] Yeah. Yeah that would be nice if they [00:18:58] could do that. So [00:19:00] something [00:19:02] another wish list feature. [00:19:04] Alright, moving on, [00:19:05] we'll go to Twitter actually have [00:19:07] quite a few. [00:19:08] Some of these are from [00:19:10] the previous week that I had collected [00:19:12] but just wanted to highlight quickly. [00:19:16] There's some cool Zapier is very [00:19:19] heavy Airtable users [00:19:21] and they're also great [00:19:22] at content marketing. [00:19:23] So if you want to check out [00:19:25] their resources about Airtable [00:19:28] that they have some [00:19:29] good resources [00:19:31] from their team on how they use Airtable [00:19:35] and so we're checking out [00:19:37] if you're in a marketing team [00:19:39] Zapier is amazing at [00:19:41] their content marketing so [00:19:43] how they worth reading [00:19:44] and learning from them [00:19:46] some resources. Here's one, [00:19:48] somebody's calling out their api [00:19:52] you know, as cool as Airtable is, [00:19:55] your api is very limited. [00:19:57] We're having to use embedded [00:19:59] Google sheets because their api [00:20:01] is better. [00:20:03] And so just some [00:20:05] discussion about the api [00:20:08] And and using it relative to [00:20:12] that's also some alternative ways [00:20:15] to get around some [00:20:16] limitations of their api [00:20:17] basic ul is one, sync inc who [00:20:20] just renamed [00:20:21] I can't remember their new name [00:20:23] sequence. [00:20:24] Yeah. [00:20:26] Yeah. So that's a way to leverage [00:20:30] those tools if you really need to to use [00:20:34] that. So just always like to see [00:20:37] how people are talking about it. [00:20:40] There's another thread coming up. [00:20:43] So I thought it was good. Somebody posted. [00:20:46] Why didn't no one tell me [00:20:47] Airtable was the answer to everything? [00:20:49] I think we all feel the same way. [00:20:54] That's great. Yeah. [00:20:55] So it's funny to see people [00:20:58] come to that realization [00:21:01] see that often. [00:21:03] Okay, this was one. [00:21:05] so Hittin shot is a big name. [00:21:08] He's the founder of a couple [00:21:11] of companies Kissmetrics, Crazy egg [00:21:14] runs now he's kind of [00:21:17] big in the crypto world [00:21:20] and so very, very well known [00:21:23] talking about the [00:21:24] pricing model of Airtable [00:21:27] And just getting frustrated [00:21:29] with how expensive. [00:21:30] So he's paying $10,000 a year [00:21:32] for 42 collaborators [00:21:35] and talking about how, you know, [00:21:37] he doesn't even have that [00:21:38] many employees using [00:21:39] Airtable. So he's paying for [00:21:42] external consultants [00:21:44] or anything like that using [00:21:46] it. And I thought it [00:21:47] was really interesting. [00:21:49] There is some high level people, [00:21:50] well known people within [00:21:52] the industry kind of adding [00:21:54] on to that about, [00:21:55] you know, just not being [00:21:56] happy with the pricing model. [00:21:58] And and so I wonder if, [00:22:01] you know, if these big names, [00:22:03] well known people are [00:22:05] putting pressure on Airtable, [00:22:08] if we'll see, [00:22:10] we will see anything [00:22:12] change on Airtable's front. [00:22:17] Absolutely. [00:22:20] It's interesting because they have, [00:22:23] you know, I work at a place where we [00:22:27] use a nonprofit specific database and [00:22:33] It's expensive [00:22:34] and there's probably three [00:22:36] or four users and we pay probably [00:22:38] 10,000 a year for that. [00:22:41] But it's much more of an enterprise level. [00:22:46] And they have all the features for that. [00:22:48] Where I think in some places Airtable, [00:22:51] they have that pricing [00:22:53] but maybe not necessarily [00:22:54] that all the in depth [00:22:56] features at that level. [00:22:58] Yeah. [00:23:00] Yeah. And they, [00:23:02] somebody actually who works [00:23:04] at Airtable reached out and see [00:23:06] what their conversation, [00:23:08] I guess you're just a DM me [00:23:10] and then Coda jumps in on [00:23:11] it and talks about their pricing model, [00:23:14] which is different and they actually [00:23:16] address this. [00:23:17] So I think Coda does have a better [00:23:19] pricing model. [00:23:22] Yeah. [00:23:23] Yeah. Because they only [00:23:25] you only charge for [00:23:26] people who are actually [00:23:27] like building and modifying the structure. [00:23:31] Not actually like editing the content. [00:23:35] Right. And they're even if [00:23:37] they're like a read only user, [00:23:38] they could still get [00:23:40] features that like if you're [00:23:41] a read only user in Airtable, [00:23:43] you can't filter, you can't do anything. [00:23:47] So [00:23:48] that alone is a big game [00:23:50] changer. Yeah, yeah, [00:23:52] yeah. So definitely [00:23:55] some some different approaches [00:23:58] to this. We'll see if [00:24:01] if Airtable responds to this kind [00:24:03] of pushback. Makes you wonder when they're [00:24:07] going to do [00:24:08] some changes after the survey they did [00:24:11] months ago. [00:24:14] Yeah. Yeah, yeah. [00:24:15] We'll see if any of this works. So [00:24:19] trying to think if there's [00:24:21] I know spreadsheet.com [00:24:23] also has similar pricing [00:24:24] model to Coda [00:24:26] so they're kind of have that [00:24:28] maker pricing model so if all [00:24:31] the competitors are doing it, [00:24:33] I wonder if Airtable may [00:24:34] 0 may follow suit 631 00:22:55.1000 --> 00:22:58.180 but it seems to work for Salesforce. [00:24:38] Salesforce is kind of more [00:24:39] similar [00:24:40] but I also know people [00:24:42] don't like that about Salesforce. [00:24:44] Yeah, [00:24:46] so maybe foreshadowing of things to come. [00:24:52] All right, let's see this one. [00:24:55] So why is it so difficult [00:24:57] to populate a select [00:24:59] list from an existing column [00:25:01] in another base in Airtable? [00:25:03] It's so much simpler in Coda. [00:25:07] So I think what they're saying is [00:25:10] generating a drop down list [00:25:13] from like a linked record fields. [00:25:17] What do you think she's talking about? [00:25:20] it could be [00:25:22] anything. I mean it's [00:25:24] I think people get really confused between [00:25:26] a linked record field [00:25:28] and a single select [00:25:29] or multiple select because I guess [00:25:31] you could use one or the other [00:25:33] for many different situations. [00:25:37] I don't know there's [00:25:38] there is some difficulty like if you have [00:25:41] commas in your source data [00:25:43] for example then [00:25:44] turning that [00:25:45] from a text field into a [00:25:47] single select or multi select [00:25:49] won't look very pretty. [00:25:53] There's a lot of things [00:25:54] to try and work around. [00:25:55] I've got lots of little [00:25:56] like weird data massaging [00:25:58] practices that I [00:26:00] do just [00:26:01] but it's hard to kind of get around. Yeah. [00:26:04] Yeah [00:26:06] it would be nice. [00:26:08] Yeah, I think I think you know, [00:26:10] being able to create dynamic [00:26:12] drop down. So apparently in [00:26:13] Coda you can do something like that. [00:26:15] I haven't used that future in Coda. [00:26:18] Oh yeah definitely because you can [00:26:22] you can have the options [00:26:23] be a formula [00:26:24] which is cool. So it's like go and filter [00:26:27] what this linked record [00:26:28] is linked to [00:26:29] and show me the options from that [00:26:31] single select on the other table. [00:26:34] Yeah that would be great. [00:26:36] That would be cool. Yeah very cool. [00:26:39] All right so yeah [00:26:41] added to the feature list. [00:26:45] All right, last one [00:26:47] this was a thread of this [00:26:50] person generate created a crm in [00:26:53] Airtable for Twitter users [00:26:56] and in a tweet thread [00:26:59] walks through how you would [00:27:01] do that in Airtable. [00:27:03] So, thought that was cool [00:27:04] is kind of a mini use case [00:27:06] in just a couple of tweets [00:27:08] on how to build a tool [00:27:11] like this using Zapier [00:27:14] or Integromat and obviously Twitter [00:27:16] and then Airtable to store all the data. [00:27:19] So you can basically extract [00:27:22] all of your followers using [00:27:24] I think he uses Integromat for the [00:27:27] initial download and then Zapier for the [00:27:29] ongoing new ones. [00:27:31] So I guess that made it easier. [00:27:34] Although Zapier with [00:27:35] their new, I think Hannah, [00:27:37] you mentioned the new [00:27:39] Zapier feature to do syncing. [00:27:41] Yeah it's transfer in Zapier now [00:27:44] so where Integromat has really always [00:27:47] had where you can choose a date [00:27:50] to start pulling information [00:27:53] from in the past, [00:27:54] you could do that in Intrgromat, [00:27:56] well in Zapier you were could only start [00:28:00] an automation from, you know, [00:28:02] the day you start the [00:28:03] automation or create the [00:28:04] automation. But now with transfer [00:28:06] you can go back [00:28:07] in the past and choose a date. [00:28:09] So you can pull in information previously, [00:28:13] which is really helpful if you're [00:28:16] trying to start, you know, [00:28:18] basically if you want [00:28:20] to put everything in Airtable [00:28:21] for some reason from the past, [00:28:23] so you can just pull it all in [00:28:26] from previous and then go [00:28:27] ahead and start the automation [00:28:29] from here on out. [00:28:31] Yeah, yeah, it's cool. I played with it. [00:28:34] They do have support [00:28:35] for Airtable in that they [00:28:37] don't have support for [00:28:39] all of their connectors. [00:28:40] So it's still the main ones, [00:28:41] but a big one is Google sheet [00:28:44] to Airtable, [00:28:44] that's what I kind of played with. [00:28:47] And so that's a common one that might, [00:28:50] there's a product out there that [00:28:52] that's kind of all they do [00:28:55] is sync your Airtable to Google sheets. [00:28:57] And so this is another way [00:28:59] you can do that. [00:29:02] So [00:29:03] yeah, so anyway, [00:29:05] so you might not need to use [00:29:06] Integromat if you're using Zapier [00:29:08] so you basically just [00:29:10] download all your followers [00:29:12] and then continually [00:29:14] do them and then using Airtable [00:29:16] as your Crm to filter [00:29:18] locations or whatnot. [00:29:20] So [00:29:21] kind of cool use case [00:29:23] and somebody showcasing [00:29:26] how they are using that [00:29:28] effectively in their marketing efforts. So [00:29:32] that is all we had for Round the Bases. [00:29:38] Bring up our images. [00:29:41] So our next segment, [00:29:44] I'm going to do a spotlight [00:29:46] on On2Air. On2Air is an all in [00:29:48] one toolkit to run [00:29:50] your business on Airtable. [00:29:51] It's a suite of apps that do a [00:29:53] variety of things from backing [00:29:55] up your Airtable to making it easier to [00:29:58] interact with your data in [00:30:00] in Airtable through our Amplify [00:30:03] to manage your schemas [00:30:05] and your database structure [00:30:08] to building external forms [00:30:10] using jot form and also our [00:30:12] automation platform On2Air actions. [00:30:15] So full suite of tools [00:30:16] that help you run your business [00:30:18] check out on2air.com [00:30:19] there's also a BuiltOnAir [00:30:21] promo code you can use [00:30:24] and we'll do that. [00:30:25] Perfect question Jen put that up there. [00:30:29] Can you talk about Amplify, [00:30:30] that's what we're gonna [00:30:31] do a spotlight on for [00:30:32] today. So, good timing [00:30:33] that was not planned. So [00:30:35] with Amplify, Amplify as a tool [00:30:38] to bring up our demo, [00:30:40] so Amplify is a way to [00:30:42] interact at the record level. [00:30:44] You can think of it [00:30:45] as a way to create views for a [00:30:47] single record. [00:30:49] And we have some big [00:30:52] upgrades coming and [00:30:55] one of the features [00:30:56] that I wanted to highlight. [00:30:58] So we have different, [00:30:58] you can create different widgets, [00:31:01] you can navigate record to record. [00:31:02] You can also, it has the full life [00:31:05] cycle of creating new records, [00:31:06] duplicating deleting records [00:31:09] and then you can create [00:31:11] views for each at the table [00:31:13] level and [00:31:15] and set up different layouts [00:31:17] for how you want [00:31:18] to interact with your data. [00:31:20] We have a variety of different [00:31:23] column types to interact with your data. [00:31:26] Either just a standard record editor, [00:31:29] so standard form, you can also edit the [00:31:32] linked record. [00:31:34] So editing data in a linked table [00:31:37] in line with the current [00:31:38] record that you're looking at. [00:31:40] We also have editors for editing [00:31:44] markdown or editing [00:31:46] a long text field as html [00:31:48] or even JSON if you're using [00:31:51] JSON and we also have [00:31:52] editors for interacting [00:31:54] with your Google docs. [00:31:56] But the feature I wanted [00:31:58] to showcase in this snippet [00:32:00] is our search functionality [00:32:03] and this Hannah actually [00:32:05] was talking about this [00:32:06] functionality and how it's almost [00:32:08] like a mini app inside of Amplify. [00:32:10] So I thought it would [00:32:11] be worth highlighting. [00:32:13] So if you click on this this that [00:32:15] allows you to jump back [00:32:16] and forth between records [00:32:18] within the table and you can [00:32:19] configure your search [00:32:21] to determine which records [00:32:24] you want to display [00:32:25] within this search portal. [00:32:28] And you can also configure [00:32:30] which records, it can search across. [00:32:32] So you can configure different [00:32:35] records or different fields [00:32:38] in your table that [00:32:39] are searchable. [00:32:40] So you can select multiple records [00:32:42] and say I want to be able to [00:32:43] search within my notes field [00:32:46] or the source and whatnot. [00:32:48] And then you can [00:32:50] also specify if this is for [00:32:53] everyone or just me [00:32:54] or for all layouts across this table. [00:32:58] So you can set up [00:32:59] these search functionalities [00:33:02] and configure them. And so now [00:33:04] instead of the normal search, [00:33:06] that will only search [00:33:08] well this one will search across [00:33:10] but if you're looking [00:33:11] at like a linked table, [00:33:12] if you can only search for [00:33:14] that the primary key. So this one will now [00:33:17] search anywhere within those [00:33:20] searchable fields, you can find it [00:33:22] and then just quickly double click [00:33:25] on it and then you [00:33:26] instantly jump to the view [00:33:27] the layout for that specific record. [00:33:31] So very powerful [00:33:32] search functionality to be [00:33:34] able to navigate across [00:33:37] your data within Amplify. [00:33:40] Yeah, it's so much more the [00:33:43] Airtable search is super basic [00:33:47] and in Amplify [00:33:48] like it's like a Google search almost. [00:33:52] I mean if you have 25,000 records trying [00:33:55] to find that record based [00:33:58] on the Airtable search is [00:34:00] is very difficult. And with the Amplify [00:34:03] search you can search inside a specific [00:34:06] field or [00:34:07] anything like that. [00:34:09] And so it's a it's a major [00:34:11] advanced search function in [00:34:13] Airtable [00:34:15] Yeah, [00:34:16] yeah. And you can specify which [00:34:17] fields you want [00:34:18] this kind of your primary [00:34:20] field to display the top. [00:34:21] So that's going back to that [00:34:23] comment before of showing [00:34:24] different fields. You can do that [00:34:26] within the search functionality [00:34:28] so check out Amplify [00:34:30] its in the marketplace and [00:34:32] or you can find it on on2air.com [00:34:35] more details. So love to check it out and [00:34:38] hopefully in the coming weeks [00:34:40] we have some big upgrades that will [00:34:44] be very useful for power users [00:34:47] of Airtable so keep an eye out for [00:34:50] updates coming to Amplify. [00:34:53] Okay, [00:34:54] next Hannah, [00:34:55] if you want to get your screen ready, [00:34:57] Hannah's gonna take over the [00:34:58] screen and walk us through [00:35:00] her gift tracking app for Christmas, [00:35:05] it's Christmas time, Halloween's over. [00:35:09] Yeah I'm ready, do I have to [00:35:12] `to share your screen [00:35:14] yes [00:35:21] let me [00:35:23] get set up here [00:35:26] maybe. [00:35:29] Okay [00:35:31] okay [00:35:33] yeah so this is a Christmas [00:35:38] gift tracker in Airtable [00:35:42] so it's probably been a [00:35:46] couple of years ago [00:35:49] I created this because I [00:35:52] I mean obviously it's Airtable [00:35:54] and I can track everything [00:35:56] that I need to but [00:35:56] when you're buying for [00:35:59] 20 people it gets to be a lot [00:36:01] and then you're wondering [00:36:04] how much you spent, [00:36:05] what you bought them [00:36:07] if you bought it in the first place. [00:36:10] And so I created this [00:36:12] tracker in Airtable [00:36:16] and so what I did was [00:36:19] created a record for each person and [00:36:24] in the record I mean you [00:36:27] can put their picture [00:36:29] and then have a linked record to [00:36:32] a gifts table over here [00:36:35] and then in the person [00:36:38] I have a roll up field [00:36:40] that calculates how much I've [00:36:43] spent on each gift. I have a budget, I've [00:36:47] this is a formula field [00:36:49] that calculates how much, [00:36:52] you know the difference [00:36:53] between the total spent [00:36:55] and the budget [00:36:56] so it can kind of keep you on track [00:36:59] of where you're going and all [00:37:01] of these are calculated [00:37:03] from the gifts table and of course [00:37:06] the prettiest view [00:37:07] on this one is the gallery [00:37:09] view because you can see everything [00:37:12] and [00:37:16] so in this what it has is the name, [00:37:20] you can link it to the person that you're [00:37:23] purchasing for [00:37:25] and then in the cost this is where [00:37:28] all the calculations are done [00:37:31] in the person table [00:37:32] uses this cost field and also [00:37:34] the purchase status. [00:37:36] So while you might put in [00:37:37] a cost here but if you haven't [00:37:39] purchased it, it doesn't [00:37:41] it won't calculate in there. [00:37:43] So it's based on you've [00:37:45] purchased it and you've spent the money. [00:37:48] So it's also got a store [00:37:52] drop down here [00:37:54] for a single select field [00:37:56] and I made it that way, [00:37:57] it just seemed easier than [00:38:00] doing a linked record. [00:38:01] It linked records or [00:38:03] that seemed a little too [00:38:05] complicated for it. [00:38:06] But then you can put your [00:38:08] purchase date and a link. [00:38:12] So I also have just different views [00:38:15] grouped by when you purchased it [00:38:17] and grouped by person. [00:38:19] So you can kind of see here [00:38:21] a sum. Now one cool thing [00:38:24] that I added this year [00:38:26] and I don't know why I didn't [00:38:28] think of it before [00:38:30] is I added the web clipper [00:38:34] app [00:38:35] In the base. [00:38:37] So what's neat about this is [00:38:40] say for example you go to Amazon and [00:38:44] you see this cool little MP3 player [00:38:47] that you want to get Jack, [00:38:49] and you can use the web clipper [00:38:51] to automatically grab [00:38:53] all this information and [00:38:54] just put it right into your base. [00:38:58] So I set it up to where it [00:39:00] will grab the page title. [00:39:03] You can put in the [00:39:04] person, it will grab the [00:39:07] image from the page. [00:39:09] So how this works [00:39:12] is [00:39:14] I don't know if I can switch it over. [00:39:19] I think you're just sharing the one. [00:39:22] Just one. Okay [00:39:24] sure. That [00:39:32] window. [00:39:36] Okay you see that? [00:39:39] Okay. So in Amazon basically [00:39:42] what you can do is you use the [00:39:45] web clipper once you've added it [00:39:48] to your base [00:39:50] and you can click add new gift and [00:39:52] here it will automatically [00:39:54] create the item title. [00:39:56] So it pulls it from this [00:39:58] information from the page title. [00:40:00] Then you can select your person, [00:40:03] the store that you're [00:40:05] going to get it from. [00:40:06] Okay well we haven't purchased it [00:40:08] just yet [00:40:11] and then the picture, [00:40:13] you can do multiple options, [00:40:16] add screenshot. [00:40:17] So you can select [00:40:22] exactly what you want in there [00:40:24] and it automatically adds it. [00:40:26] This is genius. [00:40:27] Like I don't know why I [00:40:28] haven't used a web clipper more often. [00:40:32] and then you have some other [00:40:33] options if you just want to select it. [00:40:35] So I had it either way [00:40:37] and then we want to put in [00:40:39] okay it's 22.99 [00:40:40] and okay this is a main gift, [00:40:43] we're purchasing it here [00:40:45] and then a link so then [00:40:46] you go to add the record [00:40:49] and show in Airtable [00:40:54] and there it is [00:40:55] like it's automatically added. [00:40:58] So if you're shopping online, [00:41:00] I mean [00:41:02] this is a great way to quickly add stuff [00:41:05] to the list [00:41:09] and then of course I've created [00:41:12] some summary apps [00:41:13] so can tell okay well this [00:41:15] calculates how much I've already [00:41:18] spent this year and that is [00:41:20] too much, that is probably over budget. [00:41:26] And how many purchase [00:41:27] and then of course a Christmas [00:41:29] countdown and this is up to [00:41:30] date people. So 53 days [00:41:33] were less than two months [00:41:36] away from Christmas. [00:41:39] But those are [00:41:41] that's my Christmas template. It's [00:41:46] really helps you keep track. [00:41:48] I mean it will help you [00:41:50] save money because you know [00:41:52] here we are, Charlie, [00:41:53] he's we're over budget on him already, [00:41:55] so no more presents for [00:41:58] him this year in that. So [00:42:02] that's funny because [00:42:04] you have a it doesn't have [00:42:08] I know you can't with the web clipper [00:42:10] but do you have like a wish list feature [00:42:13] where people can submit their? [00:42:15] So that is actually a great idea, [00:42:19] probably what would be good is to create a [00:42:23] form and send it to everyone with [00:42:27] just a few of the fields, [00:42:30] so probably I would have [00:42:32] the item and then a person, [00:42:36] I mean just to make [00:42:38] it easy and then the link [00:42:40] obviously and then they [00:42:41] could automatically add it [00:42:44] could probably set it to [00:42:50] limit the selection to not [00:42:53] yet purchased [00:42:55] but definitely [00:42:57] could send a link to everyone. [00:42:59] You know now that you say that I had my, [00:43:01] my son send me [00:43:03] a text message with everything [00:43:05] that he wanted and I [00:43:06] should have just had him put [00:43:08] it all into the base here. [00:43:10] Yeah, if you want a gift, [00:43:12] you have two weeks to [00:43:15] send me your list and if not [00:43:18] don't be surprised [00:43:20] you're getting that broom [00:43:24] that's for, that's for little Lily. [00:43:26] So he probably just wants the League of [00:43:28] Legends gift card. [00:43:32] But yeah, that's the Christmas tracker, [00:43:34] there's a free version and then the paid [00:43:36] version if you want all the [00:43:38] budgeting and the web clipper info. [00:43:41] My so I grew up in a big family, [00:43:44] there's there's eight, I've got seven [00:43:46] siblings, so there's eight kids [00:43:48] in my family. [00:43:49] And I always kind of known for [00:43:52] trying to sneak a peek at gifts [00:43:55] under the tree. [00:43:56] And so my mom had to come up [00:43:59] with a numbering system [00:44:01] and she had like random [00:44:03] codes for each kid. [00:44:04] So she just write the code on there. [00:44:07] So you didn't know which kid it was for. [00:44:10] And then she went on Christmas [00:44:12] would have like the [00:44:14] decoder piece of paper. [00:44:16] This code is for this kid, [00:44:18] that's genius [00:44:20] that is very smart for the sneaky [00:44:23] sneaky kid who always [00:44:24] tries to shake the presents and [00:44:28] things like that. [00:44:30] Yeah, Smart mom figured you out. [00:44:33] My kids are much much better [00:44:37] then. I was so they don't, [00:44:39] they aren't tempted like that. [00:44:42] Very cool. Thank you Hannah for sharing. [00:44:45] And how can people find it? [00:44:47] So the best way is to [00:44:53] the link I'll share here, [00:44:55] go to gum road and tap [00:44:57] in Airtable Christmas and it [00:44:59] should come up there. [00:45:01] I don't have a link on my website yet. [00:45:03] Yeah, we'll link it in in our show notes. [00:45:06] So we'll get it out there [00:45:08] with our notes. [00:45:09] So thank you for sharing that. [00:45:11] You bet. [00:45:12] All right. Alli if you want to [00:45:14] start getting ready to share your screen. [00:45:17] So we'll move on to an App a Day [00:45:20] segment on page designer with Alli. [00:45:25] Absolutely. [00:45:30] All right. [00:45:33] Am I sharing? [00:45:35] Not yet. [00:45:37] what's going on? [00:45:45] Oh, sorry guys, my computer [00:45:48] tried to update to Big Sur [00:45:52] last week and my laptop [00:45:55] never turned back on. [00:45:57] Oh, no. And so now I'm on an [00:46:00] older different machine, [00:46:03] a backup machine [00:46:04] and I haven't enabled my screen [00:46:06] recording capabilities for chrome. [00:46:09] So I'm doing that now [00:46:12] I have to leave and come back. [00:46:14] I'm sorry, I'll be right, [00:46:15] we can we can come back. [00:46:17] Want us to come back to you? [00:46:19] Yeah, definitely. I'll be right back. [00:46:22] All right, let's move on to Scripting [00:46:24] Time. So I'm going to do [00:46:26] a Scripting Time segment [00:46:28] while Alli takes care of that. [00:46:30] So we are going to look at [00:46:34] in the marketplace, [00:46:35] they have scripts that are [00:46:37] available mostly are provided [00:46:39] by Airtable, [00:46:40] but there are some third party [00:46:42] people generous enough to share [00:46:43] their scripts. We're going to look [00:46:47] at a script called [00:46:48] create child linked records. [00:46:50] So if you just click on [00:46:52] add an app and then go to the scripts tab [00:46:55] and then you can automatically [00:46:57] add a script into a scripting block [00:47:00] or a scripting app. [00:47:02] And it will bring it right up [00:47:05] and we're gonna look through this [00:47:07] code so we can learn [00:47:09] about how it works and [00:47:10] how we can use it. [00:47:12] So what this does is it will [00:47:15] automatically create [00:47:17] linked records in a child [00:47:19] table. [00:47:20] So we see here the first thing [00:47:22] that if we need configuration [00:47:25] data from the user, [00:47:26] we use this input.config [00:47:29] and you specify the title and [00:47:31] description [00:47:32] and then you give it a list of items [00:47:34] of data fields that you're [00:47:37] essentially asking the user to to select. [00:47:40] And so there's different types [00:47:42] of input fields that you can use. [00:47:44] You can use a table that will, [00:47:46] that will automatically [00:47:47] generate a drop down list [00:47:49] of the tables in the space. [00:47:50] And then you can also do similar [00:47:53] for a field [00:47:54] and you give it the name of the of [00:47:56] the name that you gave [00:47:58] the table in the parent table. [00:48:00] So this whatever you [00:48:02] select in this child table, [00:48:04] it will generate a list [00:48:06] of fields for that table [00:48:07] so that will be the input. [00:48:09] Then we'll have our configuration [00:48:11] that we can then [00:48:11] get from our settings object. [00:48:14] And then [00:48:16] you see here there's a function [00:48:18] to find so this doesn't get [00:48:19] called until you want to call it. [00:48:22] So you got to kind of go pass [00:48:24] that function [00:48:24] and then you see here all we're [00:48:26] doing is just calling that function. [00:48:28] So we're using the await because it's [00:48:30] asynchronous. [00:48:32] And so now inside this function [00:48:35] we are extracting the fields from [00:48:39] our settings so that [00:48:40] now there are variables [00:48:42] and we can use them [00:48:43] as such. [00:48:44] And then we're just making [00:48:47] sure that our field type is a multi [00:48:49] record link [00:48:52] and the linked. [00:48:53] So we're basically checking [00:48:56] to make sure that we have the right [00:48:58] type of field and it's a linked [00:49:02] record to the parent field. [00:49:04] So this is making sure [00:49:06] that the link table ID [00:49:07] is the same as the parent table ID. [00:49:10] And if it's not, [00:49:11] then it generates a message [00:49:13] and ends the function. [00:49:15] So we're all done here. [00:49:19] But if everything's good, [00:49:20] we got the right field [00:49:21] types then we're going to [00:49:22] continue on and then now you'll see, [00:49:24] we're actually going to ask for more [00:49:26] information. [00:49:28] So we're going to ask for a record [00:49:31] to use as our parent record [00:49:34] and we're going to [00:49:40] and basically we're not going [00:49:42] to let them not select a record. [00:49:44] So this while loop is basically gonna, [00:49:47] if you exit out of it it will ask you [00:49:49] again, you have to ask [00:49:50] for a parent records. [00:49:52] So this while loop will just [00:49:53] continue until you actually select [00:49:55] apparent record because you can just close [00:49:58] out and not select one. [00:49:59] So this is kind of forcing you [00:50:01] to select a parent record [00:50:03] and you can't do anything else. [00:50:05] And then it's just going to ask you for a [00:50:08] number of how many new records [00:50:11] you want to create that [00:50:12] are associated with that [00:50:13] with that parent. [00:50:15] And it's going to loop through [00:50:16] that number. So you're just asking [00:50:18] it. It does because it can only [00:50:21] ask for text. [00:50:22] It uses this parson function which [00:50:24] converts text to numerical values. [00:50:28] And so this is converting the text that [00:50:32] you enter into a number, [00:50:34] so you have to enter an [00:50:36] actual number in that input. [00:50:38] And then it can then use that [00:50:40] as a numerical value [00:50:42] and loop through that many [00:50:43] times. And then it's just basically [00:50:46] adding a new set of record data for the [00:50:50] fields. And the only field [00:50:52] that it's populating [00:50:53] is that linked record and it's [00:50:55] linking it back to our parent record. [00:50:57] So it's basically creating that many new [00:51:00] records inside of this. [00:51:02] And then this loop is to [00:51:03] make sure if you if you added like [00:51:05] 100 new records to be created, [00:51:09] the Airtable function [00:51:11] to create records can only [00:51:13] do 50 at a time. [00:51:15] So this max record per call is set to 50, [00:51:18] which is what the [00:51:19] current batch limit is. [00:51:21] And so you have to splice it up [00:51:24] that many times [00:51:25] if you've seen other episodes of this, I [00:51:29] there's a faster way where [00:51:31] you can do this in one [00:51:32] line that I typically like [00:51:34] to do, but this works as well [00:51:36] and then and then it's done, [00:51:38] so that's pretty much all it does. [00:51:40] So you can kind of [00:51:41] like I always mention like [00:51:42] using looking at these scripts [00:51:44] is a great way to learn how to code. [00:51:46] Get familiar with the api [00:51:49] that's available to you [00:51:50] and how you might do [00:51:52] certain things if you're [00:51:53] just beginning your scripting experience. [00:51:57] So let's try it out. [00:51:59] So over here we now have [00:52:01] this running [00:52:03] and so we have to pick our parent table [00:52:06] I believe. [00:52:07] So I'm going to pick a design project [00:52:10] as my parent [00:52:10] and then tasks as my child. [00:52:13] So we're going to create [00:52:15] multiple tasks for a design [00:52:17] project [00:52:20] and this design project, [00:52:23] that's the field that is in [00:52:26] the tasks that links back [00:52:28] to the design project. [00:52:30] Now, this could probably be [00:52:33] smarter because we can know, [00:52:35] actually, probably not [00:52:36] at the input config [00:52:38] you don't know which you [00:52:39] you can't filter this [00:52:41] based off of the type. [00:52:42] So if we were doing it down [00:52:45] below, we could maybe [00:52:47] be smarter about what [00:52:49] fields are in there, but [00:52:52] that is not available. [00:52:53] So anyways, we now have it [00:52:55] configured and you only have [00:52:56] to configure it once. [00:52:57] It will remember these settings [00:52:59] so now we can run it and [00:53:01] so now it's asking us [00:53:02] for a parent record. [00:53:04] So if I go like this and exit out, [00:53:06] that while loop [00:53:07] Continually asks us to to to add one. [00:53:10] So you see here that while loop won't let [00:53:13] me get picking a parent. [00:53:17] So let's do a Gotham city, [00:53:19] we're going to do that. [00:53:21] And now and then here we [00:53:22] determine let's do, let's do 12 [00:53:28] And then you hit next [00:53:29] and then now it's creating [00:53:32] 12 child records associated [00:53:33] with that parent record. [00:53:36] So if we go to our Gotham [00:53:41] where is our Gotham? [00:53:47] There it is [00:53:48] Okay if we click on here, [00:53:50] we should see [00:53:51] a bunch of tasks and they're all blank [00:53:54] because we didn't add anything else. [00:53:56] But now you see there's 12 tasks that got [00:53:58] created [00:53:59] and [00:54:01] typically you would take this [00:54:02] as a starting template [00:54:04] and then maybe you want to [00:54:05] populate it with default names [00:54:07] for those tasks or something of that sort. [00:54:10] So this is a great starting point [00:54:13] for a pretty common use case of creating [00:54:18] you know, tasks for a project [00:54:20] that's pretty common. [00:54:21] Any time there's a new [00:54:22] project, so maybe you want to convert this [00:54:24] to an automation script that will [00:54:26] automate it, any time there's [00:54:28] a new project added to this table [00:54:30] this would be a good script [00:54:32] to use as a starting template, [00:54:33] so [00:54:34] hopefully that's helpful [00:54:36] to get you into the scripting world [00:54:38] very powerful, [00:54:39] opens up a whole new you know, [00:54:42] universe of types of [00:54:44] applications that you can [00:54:45] build with it. [00:54:48] So, we'll do that and now we're gonna [00:54:51] skip back to page designer Alli if you [00:54:54] wanna, are you able to share your screen? [00:54:58] Okay. All right, I'm back. [00:55:01] All right, Yes, let's let's do this. [00:55:05] We'll try again and [00:55:10] Alright, okay, perfect. [00:55:14] All right, so I'm going to do [00:55:16] a very quick demo on my, [00:55:17] one of my favorite apps, [00:55:19] which is the page designer app. [00:55:21] There's a lot of really awesome [00:55:24] things about it, [00:55:25] but there's also some pretty [00:55:26] big cons to it, [00:55:27] which I'm sure a lot [00:55:29] of people are familiar with, [00:55:31] so I'm gonna jump into [00:55:33] my app sidebar here [00:55:34] and I'm gonna add the page designer [00:55:36] app and my dashboard [00:55:40] and it's gonna first prompt [00:55:43] me what table I want to use [00:55:47] and let's actually go with people. [00:55:49] So this is just like a scrubbed version of [00:55:51] an employee database. [00:55:54] So I've got [00:55:56] people, locations, et cetera. [00:56:00] And [00:56:01] the biggest thing that I like to, [00:56:04] the way I like to explain [00:56:06] page designer to people is [00:56:08] one page in page designer is [00:56:10] always going to [00:56:12] correspond with one record. [00:56:14] So one record on a table [00:56:16] and the values that are in that [00:56:19] record or across that row [00:56:21] or linked to it [00:56:23] can be used in [00:56:25] a page designer page. [00:56:27] So just to demonstrate [00:56:29] that really quickly, [00:56:31] if I drop in this full name field, [00:56:35] you've got all these awesome [00:56:37] controls on the side [00:56:39] to format however you want. [00:56:43] And when I start tabbing through here, [00:56:46] it's gonna go down the list. [00:56:47] So it started with [00:56:50] actually if I go up to my very first view, [00:56:54] you can choose which view you [00:56:56] want this to be drawn off of as well. [00:56:58] However, [00:57:00] I have found that if you [00:57:01] pick one that's down below [00:57:02] and then the next time you [00:57:04] come back to your base, [00:57:05] It always reverts to the top one [00:57:08] which I find really frustrating [00:57:12] definitely. [00:57:13] But you can see here as I go down, [00:57:15] we've got Archie then we should have Kim, [00:57:18] and Shandi, Chris, etcetera. [00:57:22] So that's the basics [00:57:24] of how you can see [00:57:26] it only relates to one record at a time. [00:57:31] So I could use this [00:57:32] and I could build a sheet [00:57:34] for just one person at a time and [00:57:36] maybe that's helpful for some scenarios [00:57:38] like I want to know what assets have [00:57:40] assigned that person [00:57:41] and I could print out a sheet [00:57:43] at the time that they're on [00:57:43] boarded. You know, [00:57:45] here's your computer, [00:57:46] your cell phone, et cetera. [00:57:48] But let's actually go [00:57:49] to a different example [00:57:52] and I'm gonna go switch [00:57:54] this to my locations sheets [00:57:57] and here's where things [00:57:58] get really interesting. [00:58:01] So let's say I want to create [00:58:03] a phone list. [00:58:04] So for each location and they can [00:58:06] actually print this out [00:58:08] and have it at their desk [00:58:10] and they can know who else is [00:58:11] out there location with them. [00:58:14] You'll notice I said you can [00:58:16] only use one row, [00:58:17] one record at a time per page. [00:58:19] However, you can also use [00:58:21] anything that's linked [00:58:23] to that location as well. [00:58:25] So because I have all of my people [00:58:27] linked to each record on this table, [00:58:31] I can start by dragging in [00:58:34] let's actually leave that [00:58:35] abbreviation at the top [00:58:37] for each location. [00:58:44] And then [00:58:46] I'd like to make it in the center [00:58:49] there [00:58:49] a drug in my people linked record field. [00:58:53] You'll notice I start to get a list here [00:58:56] and this is where things [00:58:57] can get really, really cool. [00:59:00] So first thing [00:59:03] I can go over to the side here [00:59:05] and I'll just start from the top. I can [00:59:08] sort this list however I want. [00:59:10] So let's say I want to [00:59:13] sort it by department [00:59:15] and then full name. [00:59:19] I can filter this list however I want. [00:59:22] So I can choose a view [00:59:24] and I'm gonna go with all employees [00:59:26] by location because right now this is [00:59:28] showing not just my active employees [00:59:30] but also my inactive. So people that have [00:59:33] left [00:59:36] and then [00:59:38] I can add all the columns that I want. [00:59:40] So I want to add [00:59:43] let's put in like their extension [00:59:50] and this is something that [00:59:51] I kind of wish there [00:59:53] is a little more flexibility on. [00:59:54] You'll notice this is [00:59:56] just a text field, but [00:59:58] I have extensions as a linked record [01:00:00] field and then I have this is a formula [01:00:03] field that's just reading [01:00:04] the linked record field because [01:00:06] this makes it really big and kind [01:00:08] of clunky and you can't get any formatting [01:00:10] around that blue rectangle [01:00:12] and how it displays. [01:00:14] So I usually like to use formula fields [01:00:16] in order to form at this table a little [01:00:18] bit nicer. [01:00:21] And then we can also pull in, [01:00:24] I don't know, let's put in their cell phone. [01:00:29] This is awesome too. [01:00:31] You can rename these [01:00:32] columns however you want [01:00:35] and [01:00:37] I know we're running low on time here. [01:00:39] So this is my favorite thing I've figured [01:00:41] out recently [01:00:43] and for each location [01:00:44] we've got a specific color [01:00:46] because we have everything [01:00:47] color coded. [01:00:49] So I've just put in a little block [01:00:52] like just a little image for each location [01:00:55] and when I do that, [01:00:57] I can drag that in as an image, [01:01:00] I find where the color is [01:01:05] and [01:01:07] I can drag that all the way across [01:01:11] and then if I say I want [01:01:12] this to actually fill [01:01:15] And then some [01:01:16] Jack, That's awesome. That's the culprit, [01:01:21] right? I just figured this out. [01:01:23] I mean it wasn't, [01:01:24] you couldn't do it before. [01:01:25] It was, I think within the last year [01:01:28] they have advanced image option [01:01:31] that they've released [01:01:32] and that is what allowed that [01:01:34] to be able to be possible. [01:01:35] There's a lot you could do with that. [01:01:38] All right. It's super, [01:01:40] super cool. And like the coolest part [01:01:42] about it is when I start tabbing through [01:01:44] now, I've got a different color [01:01:46] for each location. [01:01:49] That's awesome. That's great. [01:01:51] So everything is color coded, [01:01:54] having lists a lot in there either. [01:01:57] That's really awesome to see. [01:02:00] It's super fun. I've had a lot of fun [01:02:03] doing that. We actually like, [01:02:04] and if you're lucky enough [01:02:06] to have signed up for [01:02:08] this beta to share the [01:02:10] apps, [01:02:12] the [01:02:13] table syncing has allowed [01:02:15] another really cool work around. [01:02:17] So I have, [01:02:18] I don't want to give all the [01:02:20] employees access to this [01:02:21] base because there's a lot [01:02:22] of stuff, you know, [01:02:23] like birthdays and stuff [01:02:24] in there that is private [01:02:25] information, [01:02:27] but I've got just the phone list, [01:02:29] just the people and the locations. [01:02:31] This is just a sample. [01:02:32] So I didn't actually resync [01:02:33] the locations table, [01:02:34] but [01:02:35] this, I can share with the entire, [01:02:38] with all the employees, [01:02:39] I have this embedded [01:02:40] right on the internet [01:02:42] and so they get their own, [01:02:43] this is a master phone list [01:02:45] of everybody and then [01:02:46] they've got a master location sheet [01:02:48] with all the locations, phone numbers [01:02:51] and then that [01:02:53] just exactly what we were just working on. [01:02:56] But did you embed the app on the [01:02:58] website, Is that what you did? [01:03:00] Yeah, I did. I embedded [01:03:02] the app and the base [01:03:03] itself so that people [01:03:04] can search through it as well. [01:03:07] So I've got the apps, [01:03:09] I can actually show that quickly. [01:03:10] Can you see this screen? [01:03:12] Yeah. [01:03:14] All right. If I just go into [01:03:16] my staff directory, [01:03:20] so we've got this all embedded in here. [01:03:24] So that way somebody can search, [01:03:27] try and find someone that they're [01:03:29] looking for and also just [01:03:30] go in and print off [01:03:31] there. She [01:03:33] that's really smart. [01:03:35] And what's so cool is this updates [01:03:37] in real time so like, [01:03:39] I don't have to worry. [01:03:39] The only thing I have to do [01:03:41] is periodically come in [01:03:42] and make sure that [01:03:43] nothing like this is happening. [01:03:44] So that's something I need to fix. [01:03:46] I want to shorten up that title [01:03:47] so that it doesn't run on two other lines. [01:03:49] Get too long so that it, [01:03:51] you know, it's not smart enough [01:03:53] to dynamically shrink and grow. [01:03:55] Yeah. [01:03:57] Does it ring up? [01:03:59] It does, it wraps like see how it's [01:04:01] Oh, okay. Yeah, I see. [01:04:04] But I had to make the line height [01:04:06] really small in order to fit everything. [01:04:08] So it doesn't look [01:04:10] very good when it rests, [01:04:13] you have to have like a formula [01:04:15] that cuts it off or something. [01:04:17] Exactly. I have an override field [01:04:20] that I'll go in [01:04:21] and just try and shorten that [01:04:22] title up a little bit. [01:04:26] Yeah, there's just a little bit of [01:04:28] some tips and tricks about page designer. [01:04:30] I've got a ton but I know [01:04:32] we're running out of time. [01:04:34] That's really super [01:04:35] powerful. What are some [01:04:37] limitations of page designer? [01:04:39] Thank you. [01:04:40] I thought I would mention those. [01:04:42] Definitely. Okay so my number one [01:04:44] and I think everyone's number one [01:04:46] is that you cannot [01:04:48] automate this whatsoever. [01:04:49] You can't click a button to grab that pdf [01:04:52] and attach it to a record. [01:04:53] That would be absolutely huge. [01:04:55] I would use it for everything [01:04:57] if we could do [01:04:57] that. It would be awesome. [01:04:59] Another thing, [01:05:00] it's really hard to have multiple pages. [01:05:03] You can kind of set it [01:05:04] up so that it will work for you [01:05:06] on your particular computer [01:05:07] and browser but that [01:05:08] that might not work well [01:05:09] for the next person [01:05:10] that tries to print it on a [01:05:11] different browser. [01:05:14] An additional. Additionally [01:05:16] I wish you could select more [01:05:17] than one item at a time [01:05:18] to drag around the page because [01:05:20] if you need to reformat one [01:05:22] little section [01:05:23] you gotta individually drag every [01:05:25] little thing can't group elements. [01:05:31] Very cool. Alright. [01:05:33] That's awesome. Thank you Alli [01:05:36] for walking through page designer. [01:05:39] It's probably the most [01:05:40] most popular app and [01:05:42] that's used [01:05:43] by people I would imagine [01:05:45] maybe the scripting app is up [01:05:47] there too but definitely one that [01:05:51] everybody should be familiar with and use [01:05:56] so Shea thanks for being with us [01:05:58] and hopefully [01:05:59] that was helpful for you then you [01:06:02] can go deeper into the page designer [01:06:04] so quickly we'll end with just a plug join [01:06:07] are BuiltOnAir community, [01:06:09] builtonair.com. We have a newsletter. [01:06:11] We also have a slack community [01:06:14] where there's people [01:06:15] like Alli and Hanna and Shae [01:06:18] and Jen and Rebecca [01:06:20] who all participated into [01:06:22] this show. They're all in the [01:06:24] BuiltOnAir community. [01:06:25] So amazing people doing [01:06:26] amazing things. We'd love to have you [01:06:29] join and join us at builtonair.com/join. [01:06:33] One final comment from Jen [01:06:36] very cool page designer feedback. So [01:06:41] with that we're getting into November [01:06:44] our last month before we will take [01:06:46] December off, [01:06:47] so we do have four more episodes [01:06:49] that will bring to you the next [01:06:51] four weeks and we hope [01:06:53] that you will join us next time [01:06:55] on BuiltOnAir. [01:06:57] See ya. [01:06:58] Bye. [01:06:59] Thank you.
![[S14-E02] Full Podcast Summary for 04-18-2023 – Freelancer Expert Jason Montoya shares his Project Management bases | Creating date based change logs](https://builtonair.com/wp/../uploads/segment_image_1-95-440x264.png)
BuiltOnAir Podcast
- [S20-E03] Full Podcast for 10-22-2024 - Pivot Tables & Scripting Secrets October 28, 2024#airtable #on2air #builtonair 10/22/2024 - BuiltOnAir Live Podcast Full Show - S20-E03 ___________________________ The BuiltOnAir podcast is a live weekly show highlighting everything happening in the Airtable universe. Check us out at BuiltOnAir.com/join. Join our community, join our Slack channel, and see what's happening. ------------------------ SPONSORED BY On2Air - Airtable Apps and Integrations to run […]
