11/16/2021 – BuiltOnAir Live Podcast Full Show – S09-E10

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

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.

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.

Show Segments

Round The Bases – 00:03:12 –

Following Articles Used in this Segment:

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

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

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

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

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

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

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

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

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

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

 

A Case for Interface – 00:25:47 –

Explore Interfaces with “Creating a Dashboard Interface”.

.

Meet the Creators – 00:46:53 –

Meet Drew Dillon from Burb.

Drew Dillon has spent his career leading Product teams at companies like Yammer, Fond, and Skedulo. He now applies that experience as CEO of Burb, a pre-seed startup that helps creators build recurring revenue through courses and engaging membership communities. No code has helped Burb rapidly iterate to support clients and, as big believers in open source, they’re excited to share all these templates with the BuiltOnAir community.

Visit them online

An App a Day – 00:56:42 –

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

View App

Full Segment Details

Segment: Round The Bases

Start Time: 00:03:12

Roundup of what’s happening in the Airtable communities – Airtable, BuiltOnAir, Reddit, Facebook, YouTube, and Twitter.

Following Articles Used in this Segment:

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

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

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

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

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

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

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

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

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

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

 

Segment: A Case for Interface

Start Time: 00:25:47

Creating a Dashboard Interface

Explore Interfaces with “Creating a Dashboard Interface”.

.

Segment: Meet the Creators

Start Time: 00:46:53

Drew Dillon –

Meet Drew Dillon from Burb.

Visit them online

Segment: An App a Day

Start Time: 00:56:42

Airtable App Showcase – Burb – Learn how to build a training course managed in Airtable with Burb.

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

View App

Full Transcription

The full transcription for the show can be found here:

[00:01:41] Welcome to the BuiltOnAir podcast.
[00:01:44] This Tuesday we're coming at you live.
[00:01:47] We've got the full crew with us.
[00:01:49] Welcome Back Alli.
[00:01:51] Yeah, was out last week
[00:01:53] and as always, welcome Kamille
[00:01:56] and myself, Dan Fellars.
[00:01:58] We're good to be with you, this Tuesday,
[00:02:00] this is season nine, episode ten
[00:02:02] of the BuiltOnAir live podcast,
[00:02:05] we come live each Tuesday
[00:02:07] at 11 a.m. Eastern
[00:02:08] and we always do four segments on
[00:02:11] our show.
[00:02:12] We'll start off with Round the Bases
[00:02:14] segment where we talk about what's going
[00:02:16] on in the Airtable communities.
[00:02:18] Then we'll do a quick spotlight
[00:02:21] on our primary sponsor On2Air.
[00:02:23] We will then dive into the new Interfaces
[00:02:27] and learn a new interface that Kamille
[00:02:30] has built and showcase that.
[00:02:33] We will then have a
[00:02:34] special guest joining us,
[00:02:36] Drew Dillon and he is a creator and
[00:02:39] builder of a product that is
[00:02:41] built on top of Airtable.
[00:02:43] So we'll get a sneak
[00:02:44] peek at what he's working on.
[00:02:46] We'll also do another
[00:02:47] spotlight on On2Air, our
[00:02:49] primary sponsor
[00:02:50] and then we'll dive into
[00:02:52] what Drew has prepared for us
[00:02:55] to show. So we'll,
[00:02:56] he'll be joining us midway
[00:02:58] through the episode today.
[00:03:00] So as always, with Round the Bases,
[00:03:03] we kick off on what's going on
[00:03:05] in the Airtable
[00:03:07] community. And we always start
[00:03:08] with Airtable's own community.
[00:03:10] I thought I would highlight the fact
[00:03:14] that they have a new segment in or a
[00:03:18] new channel within their community,
[00:03:21] All about the new Interface Designer and
[00:03:25] you last week we dove deep into
[00:03:29] that as it just came out the day that we
[00:03:33] aired last Tuesday.
[00:03:34] So check out that episode
[00:03:36] if you haven't already and you'll
[00:03:38] see our initial reactions to it.
[00:03:39] But Alli since you weren't
[00:03:41] with us last week,
[00:03:42] what are your impressions
[00:03:43] now that you've played with it for a bit?
[00:03:46] Oh well, I was hoping for like,
[00:03:50] like ah ha moment I guess,
[00:03:53] but like, I don't know,
[00:03:55] and it's still in beta so
[00:03:57] hopes are high that they'll
[00:03:58] add a lot to it. But like,
[00:04:00] I mean there's the obvious, you know,
[00:04:03] shortcomings that I've seen a lot of
[00:04:04] people complaining about,
[00:04:06] like they were really hoping
[00:04:07] that this would be
[00:04:07] something to replace like their
[00:04:09] third party tools
[00:04:10] to share with people outside
[00:04:11] of the base.
[00:04:12] I could survive without that for now.
[00:04:14] Like I'm happy with my mini extensions and
[00:04:16] stacker at the moment,
[00:04:19] but like, I don't know,
[00:04:20] I wish there was a little more
[00:04:21] flexibility like we were
[00:04:22] just talking about adding apps to it like,
[00:04:25] and not just the chart
[00:04:27] like, and I also could go on and on
[00:04:29] about how I don't
[00:04:30] like the chart that is in
[00:04:32] interface
[00:04:33] builder, but
[00:04:35] if they had like pivot tables or like,
[00:04:38] like literally like just
[00:04:40] the ability to add apps
[00:04:41] because I've been really
[00:04:42] into those dashboards recently
[00:04:44] and I was hoping that this would be like
[00:04:46] the cool new dashboard to build
[00:04:48] but really it's super limited.
[00:04:51] But yeah,
[00:04:52] I see a lot of potential
[00:04:55] Kamille a couple of days later
[00:04:57] any other impressions
[00:04:58] you've had in general?
[00:05:00] I think I like where it's going,
[00:05:03] right now I have a different set of
[00:05:05] limitations so the ability
[00:05:08] to add or delete records
[00:05:11] in certain instances I think
[00:05:13] is limited. I think in a way
[00:05:16] I think
[00:05:17] they limited it
[00:05:19] because of the way the beta was launched,
[00:05:22] I can't imagine it would remain
[00:05:24] limited.
[00:05:25] I think they were just trying
[00:05:27] to get people to start using it without
[00:05:30] doing something destructive to their base,
[00:05:32] if that makes sense.
[00:05:33] Like suddenly accidentally creating
[00:05:35] a whole bunch of records are suddenly
[00:05:37] accidentally deleting a whole
[00:05:38] bunch of records, which would be worse.
[00:05:39] But I have used it enough
[00:05:41] where I'm pretty sure
[00:05:43] I know when I'm trying to
[00:05:45] build, so it's frustrating
[00:05:47] that some of the options
[00:05:48] that I want to be there,
[00:05:50] aren't there yet.
[00:05:51] There's a lot of
[00:05:55] I don't know, I'm going to
[00:05:57] Rebecca says she misses
[00:05:58] the right click options, I would agree.
[00:06:01] there's a couple of things
[00:06:03] that are in that is in Interface Designer
[00:06:05] that isn't in dashboards
[00:06:07] or other pieces of the product
[00:06:09] that I'm going to do my
[00:06:10] best to sort of mention
[00:06:11] while I go over an example
[00:06:13] that I build when we get
[00:06:14] there.
[00:06:15] Yeah, yeah,
[00:06:16] yeah, I think that's,
[00:06:18] you know, with anything new,
[00:06:20] it's cool and exciting
[00:06:21] and it definitely has a visual
[00:06:23] wow factor to it
[00:06:24] and then you start digging into
[00:06:26] it and you're like, oh,
[00:06:27] what about this?
[00:06:28] What about that? And so
[00:06:30] you can see, you know,
[00:06:32] in just a short week,
[00:06:33] the list of items and questions
[00:06:36] and feature requests,
[00:06:38] Wish list items is growing exponentially.
[00:06:42] So I think that will continue to happen.
[00:06:47] So if you want to stay on top of
[00:06:49] the updates to Interface Designer and
[00:06:52] provide your feedback,
[00:06:53] there's a special channel just for that.
[00:06:55] So,
[00:06:57] I wasn't gonna go through all of these,
[00:06:59] but there's definitely a lot the
[00:07:01] common ones that have
[00:07:02] already been talked about,
[00:07:04] but there's quite a few
[00:07:07] Getting lots of discussion
[00:07:09] buttons not working.
[00:07:11] That's another huge one.
[00:07:12] Well, that one I'll go over,
[00:07:15] you know, buttons and stuff.
[00:07:17] There's another one that I'm going to make
[00:07:18] reference to relating to in
[00:07:20] Interface Designer. You can
[00:07:22] filter by current user
[00:07:23] and someone was like,
[00:07:24] why can't I do that in views?
[00:07:26] And my response is,
[00:07:27] it doesn't make any sense at all
[00:07:28] for views and I'll explain
[00:07:29] why when I get there.
[00:07:30] Yeah, yeah.
[00:07:33] Another comment from Scott,
[00:07:34] not a fan of how it takes over
[00:07:36] the home screen and
[00:07:37] yeah, if you go to the home screen,
[00:07:39] it's right there on top and it's kind of
[00:07:41] jarring, place your attention,
[00:07:43] it's pushed, it's positioned oddly,
[00:07:46] I think Kuovonne said it
[00:07:47] that she thinks it's there
[00:07:49] because they want people to see it
[00:07:51] and they don't want it
[00:07:53] to be buried but you
[00:07:54] know logically it makes the most sense
[00:07:57] to be you know, placed in whatever
[00:07:59] workspace the base it's based off of
[00:08:01] is in because they're tied together
[00:08:04] explicitly.
[00:08:07] Yeah,
[00:08:09] I also really get bothered by,
[00:08:11] I feel like they could,
[00:08:13] I just miss my Airtable
[00:08:14] icon in the top left corner
[00:08:15] like I want to be able to go
[00:08:17] back to my workspaces
[00:08:18] really quickly without having
[00:08:20] to go base then workspaces. Exactly,
[00:08:23] yeah, why? I agree,
[00:08:24] that one's weird. Yeah, yeah, for sure.
[00:08:28] Hopefully they are taking all
[00:08:30] this feedback and
[00:08:32] continue to iterate on it.
[00:08:33] So we'll see,
[00:08:34] we'll see what the future holds
[00:08:36] for Interface Designer.
[00:08:39] So yeah, so lots of discussion on that.
[00:08:43] Most of last week I think was most
[00:08:47] of the interesting topics
[00:08:49] were relating to Interface Designer
[00:08:51] also across other communities,
[00:08:54] other, you know, Reddit obviously every
[00:08:57] community is talking about it.
[00:08:59] So I have links
[00:09:00] that will be in the show notes
[00:09:02] if you want to see
[00:09:04] all the different reactions
[00:09:06] of everybody talking
[00:09:08] about Interface Designer.
[00:09:09] So that's kind of yeah,
[00:09:11] lots of discussion on that.
[00:09:13] There was a lot of
[00:09:15] discussion that, Alli
[00:09:16] I think you mentioned of
[00:09:18] does this replace the stacker
[00:09:20] and softer and other platforms
[00:09:23] that people rely on
[00:09:24] and mini extensions for
[00:09:26] interacting with your data
[00:09:28] outside of Airtable
[00:09:30] and some people say, you know,
[00:09:31] this is the beginning
[00:09:33] of the end for some of
[00:09:33] those others,
[00:09:35] I know I listened to Garret's video,
[00:09:38] he, you know,
[00:09:38] he doesn't think that those
[00:09:40] are going away anytime soon.
[00:09:42] So depending on who you ask,
[00:09:44] you'll get different responses
[00:09:46] of what this
[00:09:46] means regarding third party apps,
[00:09:48] but as of now,
[00:09:49] in its current state it does
[00:09:51] not for sure,
[00:09:52] does not replace those products.
[00:09:57] There's a also this is a little
[00:09:59] off topic but I was looking
[00:10:01] at the screenshots
[00:10:02] that they have for Interface Designer,
[00:10:04] like the Airtable released and there was
[00:10:06] one where there was a chart
[00:10:08] and there were lines across the chart
[00:10:10] that were like
[00:10:10] goal, it was like,
[00:10:13] you know, they were able to add
[00:10:14] like a reference point
[00:10:15] to the chart that was
[00:10:16] like this is the goal and this is where
[00:10:18] the bar chart is reaching it,
[00:10:19] which is just not something
[00:10:21] that's ever been possible
[00:10:22] at Airtable charts.
[00:10:23] So that makes me excited.
[00:10:25] But also annoyed because I'm like,
[00:10:27] why would you put that in the
[00:10:28] screenshot if you can't do it?
[00:10:30] There's also screenshots
[00:10:31] showing the or chart app or
[00:10:36] not an app, an element.
[00:10:38] It's a it's a different thing
[00:10:40] but remarkably similar
[00:10:41] to the orc chart app
[00:10:43] within an interface. So you know,
[00:10:46] that could mean
[00:10:47] a couple of different things.
[00:10:49] Either they're converting more
[00:10:50] apps into elements
[00:10:52] or they're going to erase the line
[00:10:54] that exists between them.
[00:10:55] I don't think that,
[00:10:56] I don't think the latter
[00:10:58] is going to happen because that's
[00:10:59] difficult.
[00:11:02] and you would have to rewrite,
[00:11:03] I think every single app
[00:11:04] in order to do that and
[00:11:05] I don't foresee them
[00:11:07] making that leap.
[00:11:09] I hope you're wrong, Kamille,
[00:11:11] I mean I'm frequently wrong, I think we've
[00:11:14] established that I am horrible
[00:11:16] at guessing Airtable based items,
[00:11:19] but you know, I'm just thinking of
[00:11:23] you know,
[00:11:24] you have to do some re hooking
[00:11:26] and some of those apps
[00:11:28] are complicated and all
[00:11:29] third party apps,
[00:11:30] Dan and I both were going to
[00:11:33] have to rewrite all ours too.
[00:11:35] Yeah, but I think the, and Alli had
[00:11:37] mentioned this maybe before the show of,
[00:11:40] you know, the difference,
[00:11:41] like looking at the chart app
[00:11:43] like that looks like
[00:11:44] they completely rewrote the chart app.
[00:11:47] It wasn't just a clone of the app in the,
[00:11:49] in the app marketplace,
[00:11:52] which tells me that
[00:11:53] you would think if they had kind of
[00:11:56] that idea of moving apps
[00:11:57] in that they would have used,
[00:12:00] you know, the chart app
[00:12:01] that they already have.
[00:12:02] So that's kind of,
[00:12:05] it's kind of,
[00:12:07] there appears to be a trend of
[00:12:10] using
[00:12:13] apps as they sort of existed
[00:12:14] and then building something
[00:12:16] more fluid out of them,
[00:12:17] like Gant and timeline
[00:12:19] used to be absent now they're views
[00:12:21] and the code is very
[00:12:22] similar, but we know when timeline
[00:12:24] was made into a view,
[00:12:25] they added a whole
[00:12:26] bunch of features
[00:12:27] because you could do more
[00:12:28] with a view than you could with an
[00:12:30] app with the elements in interface,
[00:12:33] it's not quite the same. It's very similar
[00:12:36] but it's different
[00:12:37] because of the environment
[00:12:39] that interfaces allows.
[00:12:41] Whereas dashboards and apps
[00:12:42] are somewhat limited
[00:12:44] they're insular and they
[00:12:45] only look at themselves
[00:12:46] as opposed to the entire environment
[00:12:48] that they're placed
[00:12:49] in. So I don't know
[00:12:50] the exact direction they're going to
[00:12:52] but I just know whenever
[00:12:54] you convert something
[00:12:55] into something else you are,
[00:12:56] you know, there's a fair
[00:12:58] bit of work involved.
[00:12:59] Yeah, for sure. So
[00:13:02] yeah, so definitely
[00:13:04] lots of discussion there
[00:13:05] Rebecca mentions if you can embed
[00:13:07] the interfaces
[00:13:09] then you would just embed them
[00:13:11] into the apps
[00:13:12] dashboard to be able to get
[00:13:13] all the functionality of the apps as well.
[00:13:16] So
[00:13:17] interface could become
[00:13:18] an app that gets embedded.
[00:13:20] Every interface that is published
[00:13:23] has a link and the embed app lets you
[00:13:26] embed anything that has a U R L.
[00:13:28] So I think you can already do this.
[00:13:30] You will be loading I think
[00:13:33] the entire base inside
[00:13:35] of the entire base so your
[00:13:37] computer will be slow but you can do it
[00:13:41] correct, yeah,
[00:13:42] but it wouldn't be tied to
[00:13:44] the table view that you'd be looking
[00:13:46] at. Like no,
[00:13:47] it would it would be divorced,
[00:13:49] it's unlike, unlike Openside's
[00:13:51] Amplify where you can
[00:13:53] sort of say look at whatever view
[00:13:55] I'm currently looking at
[00:13:56] and have that update
[00:13:57] my app.
[00:13:58] They would be separate from another
[00:14:00] and that's not interfaces really.
[00:14:02] That's the embed app.
[00:14:04] The embed app has no way
[00:14:05] to pass what it's seeing
[00:14:07] versus what's in it. It's complicated.
[00:14:10] Hopefully that makes sense.
[00:14:11] Yeah.
[00:14:12] Alright, moving on.
[00:14:14] So more discussion on Reddit,
[00:14:16] you know, there's questions
[00:14:17] here similar to the Airtable community,
[00:14:20] you know, the ability to add a
[00:14:22] record seems like that's
[00:14:24] a pretty common request
[00:14:26] and I know Kuovonne has showed
[00:14:28] multiple workarounds for that.
[00:14:30] Setting up automations to
[00:14:32] to create your records.
[00:14:33] So there's definitely ways around it,
[00:14:36] but definitely not
[00:14:38] ideal to, you know,
[00:14:40] have to leave the interface
[00:14:42] to then create a new record.
[00:14:47] Alright, moving on.
[00:14:48] So outside of interfaces,
[00:14:50] some other things going on in
[00:14:52] different communities.
[00:14:55] this was a question asking about
[00:15:00] so actually, so the timeline
[00:15:02] doesn't have support for time,
[00:15:04] meaning what I took
[00:15:05] from this and
[00:15:07] although it says calendar shows time,
[00:15:09] I think they're saying the calendar view,
[00:15:11] you can see the time. Yeah,
[00:15:14] FYI, that's me,
[00:15:15] this is one of the few times
[00:15:18] where I interact on Reddit. Yeah,
[00:15:20] depending on what calendar view type
[00:15:22] you're looking at. Well that's confusing.
[00:15:24] If you're looking at a calendar view
[00:15:26] depending on the interval of time you're
[00:15:28] looking at,
[00:15:29] it will show you the hours in the day.
[00:15:32] So day view,
[00:15:33] I believe the three day view,
[00:15:36] will show you
[00:15:38] by time.
[00:15:40] Week might be wrong,
[00:15:41] I don't think weak shows you the hours,
[00:15:44] but three day and day I believe do
[00:15:46] okay.
[00:15:48] But you cannot
[00:15:49] set your timeline to be like
[00:15:52] a day where you see the time.
[00:15:56] Yeah, I noted that when timeline
[00:15:58] first came out,
[00:15:59] it was the same thing with the
[00:16:01] app. You couldn't do it
[00:16:02] in the app version either.
[00:16:04] But in the view version,
[00:16:05] you know, it would be nice
[00:16:07] to have smaller increments
[00:16:08] other than week,
[00:16:09] even if it was,
[00:16:10] even if the smallest increment was
[00:16:12] day. I don't know if we need
[00:16:14] to get all up in the hour per se,
[00:16:16] but
[00:16:17] it would be nice to see a smaller
[00:16:19] interval of time for people
[00:16:20] who are scheduling,
[00:16:22] you know, like conferences or something,
[00:16:24] which is, I think a common use case
[00:16:26] for Airtable scheduling events.
[00:16:29] You sometimes you can't look at things
[00:16:32] at week level.
[00:16:33] Yeah, yeah, for sure.
[00:16:35] You know, the calendar view
[00:16:37] actually works pretty well for that.
[00:16:39] But I would like to see it
[00:16:41] as a timeline too
[00:16:42] like you could the calendar,
[00:16:43] it's kind of nice,
[00:16:45] you can break it down by day,
[00:16:46] three day et cetera.
[00:16:47] But I mean,
[00:16:48] I like the look and feel
[00:16:50] of the timeline.
[00:16:51] Yeah, I can kind of see
[00:16:53] what they're going for
[00:16:54] with timeline
[00:16:55] seeing things at a wider scale.
[00:16:57] Like imagine like a project manager
[00:16:59] sort of thing.
[00:17:00] You're not going to look at a
[00:17:01] project by the hour per se.
[00:17:03] You're going to look at it over
[00:17:05] this project is going to take
[00:17:06] x amount of months
[00:17:07] yada yada and I think that's
[00:17:08] what they had in mind.
[00:17:09] But you know,
[00:17:10] just to make it more flexible,
[00:17:12] I think they can add a smaller
[00:17:14] increment of time.
[00:17:15] Yeah, yeah, for sure.
[00:17:18] Alright, moving on to
[00:17:21] Twitter again, more
[00:17:24] more
[00:17:26] discussion. Although this one, let's see
[00:17:30] so this one was a discussion,
[00:17:33] so that's a good, you know,
[00:17:36] mini use case that
[00:17:37] that somebody talked about
[00:17:39] how they built their
[00:17:40] their product on Airtable.
[00:17:42] So they go through
[00:17:44] all the different steps so if you
[00:17:46] want kind of a proven use case
[00:17:48] of a company using Airtable
[00:17:50] and how they do it.
[00:17:53] that's a pretty nice thread
[00:17:56] they're talking about it.
[00:17:58] Animals Co,
[00:17:59] so that one, let's see what else we got.
[00:18:03] So this is feedback based off of the
[00:18:09] the launch last week,
[00:18:10] just finished the game.
[00:18:12] I don't think I'd go that far.
[00:18:13] Yeah, I wouldn't
[00:18:15] I think they started the game,
[00:18:17] I think they did the coin
[00:18:19] toss in the, you know,
[00:18:22] jump ball. They haven't finished the game.
[00:18:25] It's a beta, even if you loved
[00:18:27] everything about interfaces now,
[00:18:30] you know, net positive overall.
[00:18:32] It's not done. There's more
[00:18:35] Yeah,
[00:18:36] so here's one
[00:18:37] so they're kind of on the side
[00:18:38] that this will be the end of the
[00:18:40] stacker and co but
[00:18:42] definitely pushed back there so
[00:18:45] the top comment there
[00:18:47] is one of is my boss,
[00:18:49] that's fine. Cool,
[00:18:50] we are heavy stacker users for sure.
[00:18:56] Nice,
[00:18:57] so he's getting in on that as well.
[00:18:59] Yeah, so you'll definitely,
[00:19:00] it's not the first time
[00:19:01] there's been an opinion
[00:19:02] on Twitter that you don't agree
[00:19:04] with. What?
[00:19:09] I do think it's really smart
[00:19:10] that stacker I think awhile like right,
[00:19:12] when I mean remember
[00:19:13] when stacker was air portal
[00:19:15] and then they rebranded and I
[00:19:17] think
[00:19:18] they were really smart to add
[00:19:20] in their like other data
[00:19:22] sources like Justin did
[00:19:23] go down the path of like,
[00:19:24] you know, Airtable is just
[00:19:26] going to swallow it all up.
[00:19:26] Like they still have salesforce
[00:19:29] google sheets etcetera,
[00:19:30] keep them well now their
[00:19:31] own they're launching
[00:19:33] their own back end.
[00:19:35] Yeah, so there,
[00:19:36] I think they, you know, I think
[00:19:39] especially when they raised
[00:19:40] a ton of money,
[00:19:41] they kind of knew they were going
[00:19:42] down that path.
[00:19:45] for sure, so
[00:19:47] some more so showcasing some
[00:19:49] some dashboards of what you could build,
[00:19:51] I mean you could have built,
[00:19:53] you know this in the dashboard view
[00:19:56] but this is built in interfaces so
[00:19:59] it's kind of cool to see
[00:20:01] what people are doing
[00:20:02] what they're building
[00:20:04] in Airtable
[00:20:05] and sharing that with the world, so
[00:20:09] just yeah, lots of feedback,
[00:20:10] lots of discussion there.
[00:20:12] There's several threads
[00:20:13] on Twitter about the launch
[00:20:15] from interfaces and in general,
[00:20:17] I think most people
[00:20:19] are excited about it,
[00:20:20] I think they see the shortcomings,
[00:20:22] but in general I think
[00:20:24] people are happy with
[00:20:25] much needed, you know,
[00:20:27] path that Airtable needed to go down.
[00:20:32] So a couple more threads
[00:20:34] that we've got going on here, we've got
[00:20:38] this is from hacker news,
[00:20:41] which is a pretty technical
[00:20:43] forum and lots of
[00:20:45] developers and whatnot.
[00:20:47] And we had this discussion,
[00:20:49] I believe it was me and
[00:20:50] Kamille talking a couple of weeks ago
[00:20:53] about no code movement
[00:20:55] and what that meant.
[00:20:56] There was a pretty interesting thread
[00:20:58] that I thought was worth sharing
[00:21:00] in our show notes, if you want to dive
[00:21:02] deep into it,
[00:21:03] you know, a lot of people kind of,
[00:21:05] you know, say no code
[00:21:07] is just a buzzword and so we've kind of
[00:21:11] hash that topic in the past,
[00:21:13] but I found this thread recently and we're
[00:21:16] sharing with the community
[00:21:19] what else we got here.
[00:21:21] So this was an article with
[00:21:24] an interview with the CEO
[00:21:27] of Airtable, Howie
[00:21:29] Liu and talking about
[00:21:33] you know, just the path of building it.
[00:21:36] I'm always a fan, I've shared other
[00:21:37] articles and interviews
[00:21:39] with Howie in the past, but
[00:21:41] so I was like reading these
[00:21:43] and kind of trying to
[00:21:45] gain insight into where he's
[00:21:47] thinking the future of Airtable is
[00:21:50] going. So it's a good interview,
[00:21:51] talking about that
[00:21:52] and talking about how the
[00:21:53] pandemic really helped Airtable
[00:21:56] with growth and companies adopting it
[00:21:59] during that period. So
[00:22:02] it was kind of an inflection
[00:22:04] point for them.
[00:22:06] And then another one this is from
[00:22:11] I believe he works at Airtable.
[00:22:12] He's a developer. Yeah.
[00:22:14] Talking or is on the
[00:22:15] design team, talking about
[00:22:18] the design aspect of Airtable
[00:22:21] and how it kind of all fits together,
[00:22:24] like a lego piece
[00:22:25] and how it's evolved.
[00:22:27] So kind of, the analogy he shares is
[00:22:29] when you start with legos
[00:22:31] you just have the blocks.
[00:22:32] But then over time they evolved into more,
[00:22:36] you know, pre built mini,
[00:22:39] you know,
[00:22:40] figures and towns and things like that
[00:22:44] and gets complex like this
[00:22:46] and so kind of the
[00:22:47] evolution of Airtable as
[00:22:49] you started with simple blocks
[00:22:50] and now with like the interface,
[00:22:52] you've got more pre built
[00:22:54] tools that you can use. So
[00:22:56] good article talking about
[00:22:59] the evolution of the
[00:23:00] the ui of Airtable.
[00:23:04] So any other any other comments,
[00:23:07] anything stand out this weekend
[00:23:09] in the Airtable world?
[00:23:14] Just the response to interfaces,
[00:23:18] I think that basically yeah,
[00:23:21] that's been the overwhelming
[00:23:23] majority I think.
[00:23:24] Yeah, yeah, for sure. So
[00:23:27] all right with that we're gonna move on.
[00:23:30] We're going to do a quick spotlight on
[00:23:32] our primary sponsor On2Air,
[00:23:34] which is an all in one toolkit to run your
[00:23:37] business on Airtable.
[00:23:38] It's a suite of apps
[00:23:39] that do a variety of different
[00:23:41] things help you on the front end,
[00:23:43] interacting with your data to the back end
[00:23:46] of
[00:23:48] of backing up your data,
[00:23:50] doing performing automation.
[00:23:53] So check out on2air.com
[00:23:55] for all the tools
[00:23:57] in today's spotlight, I'm gonna bring in
[00:24:00] the new screen here
[00:24:03] and we are very close to
[00:24:06] pushing a new release of
[00:24:09] are On2Air Amplify app
[00:24:11] which is somewhat competitive
[00:24:14] to interfaces but
[00:24:15] actually does many different things.
[00:24:17] It doesn't try to solve
[00:24:19] the same thing that
[00:24:20] interface does,
[00:24:21] but it is in the marketplace
[00:24:23] and now our next release that
[00:24:25] should be coming out any day now,
[00:24:27] tomorrow or Thursday.
[00:24:29] I wanted to give a sneak peek
[00:24:31] in what's coming.
[00:24:32] We now have the ability
[00:24:33] to have grid views.
[00:24:35] So you can actually
[00:24:36] create layouts
[00:24:38] that are on top of each other.
[00:24:40] We used to just support columns
[00:24:42] and if I can get this to drag down below.
[00:24:45] There we go. You can now get on top of
[00:24:48] each other,
[00:24:49] you can create lots of
[00:24:51] different grids and
[00:24:54] and do that.
[00:24:55] We have new editors,
[00:24:57] we have an updated markdown editor
[00:24:59] that's a pretty nice way
[00:25:01] to interact with your markdown data.
[00:25:04] We have text editor now
[00:25:06] we also have our Google editors
[00:25:08] to interact with your
[00:25:09] Google docs and in our next spotlight
[00:25:13] we'll showcase some of our other
[00:25:16] features that will be releasing, So
[00:25:18] be ready for that.
[00:25:20] Check out On2Air Amplify,
[00:25:22] there are some game changing.
[00:25:23] I'm going to tease that for
[00:25:25] the next add segment later
[00:25:27] in the show of some of
[00:25:28] the cool stuff that has never
[00:25:30] been able to be done before in Airtable.
[00:25:33] And we'll be introducing that
[00:25:35] with this new release coming out
[00:25:38] So check out On2Air Amplify
[00:25:40] in the Airtable marketplace.
[00:25:44] All right, our next segment,
[00:25:45] we're going to A Case for Interface.
[00:25:47] We're going to dive deep
[00:25:49] into the interface
[00:25:50] and Kamille it's going to show us
[00:25:52] that go ahead.
[00:25:54] All right, so, I made
[00:25:56] the interface for something
[00:25:59] that I want to use
[00:26:00] eventually.
[00:26:01] So it's not something I'm currently
[00:26:03] using in practice at my
[00:26:05] workplace, but once there's
[00:26:07] a few things that are
[00:26:08] sort of resolved with
[00:26:09] Interface Designer,
[00:26:10] I'm pretty sure I'm going
[00:26:11] to be using this in practice.
[00:26:13] So
[00:26:13] we're currently just
[00:26:15] sort of looking at the
[00:26:17] overview page for my interface,
[00:26:19] it has three sort of pages within it
[00:26:23] and I am just going to kind
[00:26:25] of go over what I have built.
[00:26:28] And then as I'm going to go,
[00:26:30] I'm going to talk about
[00:26:31] some limitations that I
[00:26:32] ran into
[00:26:33] things that I want to change
[00:26:35] and things that I like.
[00:26:36] So it is pretty simple on the first page
[00:26:40] this is just so I can see each of
[00:26:43] my projects at a glance.
[00:26:47] so I'm using one of the pre built
[00:26:49] templates that allows
[00:26:50] you to have the record
[00:26:51] list on the left hand side
[00:26:53] and up at the top
[00:26:55] I have a filter component with a
[00:26:58] chart that goes over the
[00:27:00] remains the tasks associated
[00:27:03] with this project and how
[00:27:05] many hours we have left
[00:27:07] assigned per person.
[00:27:09] This is something we do
[00:27:11] a lot in my field where you know,
[00:27:13] everybody needs a project manager
[00:27:16] for the way that we sort of
[00:27:18] handle projects we
[00:27:19] when we signed contracts for things, we
[00:27:22] assign ourselves how many hours
[00:27:24] we think we're going to
[00:27:25] spend on each task and
[00:27:26] then to stay on budget,
[00:27:28] we keep track of how many hours
[00:27:30] we've actually spent.
[00:27:31] So this is something that our
[00:27:34] accounting system
[00:27:35] doesn't let us do easily,
[00:27:37] so I just wanted something
[00:27:39] that we could all see at a glance.
[00:27:43] so I have this sort of like
[00:27:46] overview field or overview sort of
[00:27:51] layout going on simple
[00:27:53] filters up at the top
[00:27:57] because adding
[00:27:59] records is not easy.
[00:28:01] I've done two things on this page,
[00:28:04] one is I have a
[00:28:06] simple text element that is a link
[00:28:08] to a Airtable form.
[00:28:10] So I could quickly add another project.
[00:28:13] There's only really three fields
[00:28:15] for projects, the number, the name,
[00:28:17] and then the links to all of the tasks
[00:28:19] so that's fine that I just need a
[00:28:21] simple form at it. But
[00:28:23] in a perfect world,
[00:28:25] I would be able,
[00:28:26] if I had the permissions to do so in my
[00:28:27] base to just click down here,
[00:28:29] create a new project
[00:28:30] would be nice if I could do
[00:28:31] that.
[00:28:32] And then this button here
[00:28:35] is just a link to another page within this
[00:28:39] interface.
[00:28:40] So all interfaces have unique,
[00:28:44] U.R.Ls just like the rest of
[00:28:47] Airtable.
[00:28:48] And if you look at the U. R. L.
[00:28:51] for an interface,
[00:28:52] you can
[00:28:53] start to figure out how it's built. So,
[00:28:58] I'm only sharing my tab right now
[00:29:00] so I'm going to stop sharing and share my
[00:29:02] whole
[00:29:03] thinks we could see the
[00:29:08] so we could see the U. R. L up at the top.
[00:29:12] Can you guys see stuff? Okay, so
[00:29:16] first part of the U. R. L.
[00:29:18] is the base id, second part of the U.R. L.
[00:29:20] Is the page that we're looking at,
[00:29:23] and then the third parts are depending
[00:29:25] on how many record pickers you have
[00:29:28] is how you start to pre fill things. So,
[00:29:32] you know, each
[00:29:34] element has its own id
[00:29:36] and it doesn't follow
[00:29:38] as far as I could tell,
[00:29:40] it doesn't follow a predictable
[00:29:42] pattern of what it is,
[00:29:43] but once you figure out the
[00:29:44] different pieces of this U.R.L
[00:29:46] you could probably figure it out
[00:29:48] the first one present is
[00:29:49] going to be the first one, I believe,
[00:29:51] that has been added.
[00:29:54] It's either the first one added
[00:29:56] to the page
[00:29:56] or it is the first one vertically
[00:29:58] and left most,
[00:29:59] I can't tell which of it is.
[00:30:01] It's a little, you know
[00:30:02] you have to sort of play around
[00:30:04] and figure out which of these
[00:30:05] record ids is the
[00:30:06] one that you want
[00:30:07] at some point
[00:30:08] I figured it out and
[00:30:09] was able to make a pre filled
[00:30:11] U. R. L.
[00:30:13] and then add it to my base
[00:30:15] and that's how that
[00:30:16] previous button worked.
[00:30:18] So I could jump straight to
[00:30:20] what this project is and then
[00:30:22] it's sort of sub page.
[00:30:24] So simple fields to edit
[00:30:26] what the project or what the
[00:30:28] task for this project is.
[00:30:30] And if I wanted to switch
[00:30:32] the project I would go down
[00:30:33] here and do that.
[00:30:36] and I could switch between
[00:30:38] the major tasks like this
[00:30:39] and then sub tasks I have
[00:30:41] linked here and then from there
[00:30:44] I can click on each of these
[00:30:47] two sub tasks to say how many hours I have
[00:30:51] planned for each person
[00:30:53] working on this task.
[00:30:54] This is the way that
[00:30:56] we have to set up our sort of
[00:31:00] project management
[00:31:02] bases where we need
[00:31:06] at least one junction table to say
[00:31:08] Kamille should only spend four hours on
[00:31:11] task 1.1 and then on task 2.2
[00:31:14] she should work 30 hours
[00:31:16] and then the amount of hours remaining.
[00:31:19] From there, I haven't figured out
[00:31:23] the best way to transition to the my tasks
[00:31:26] one, but
[00:31:28] this is making use of one of my
[00:31:31] favorite sort of features in
[00:31:33] interfaces that isn't
[00:31:35] necessarily present in
[00:31:36] dashboards is stacked filtering.
[00:31:40] So
[00:31:43] I'm going to edit this
[00:31:44] so we can kind of see what's going on.
[00:31:46] I have a filter component
[00:31:48] up at the top
[00:31:49] where if I wanted to say right now,
[00:31:51] it's showing me every single
[00:31:53] task that's assigned to me.
[00:31:57] and if I wanted to filter that
[00:32:00] further by project,
[00:32:01] I've heard some people say
[00:32:03] that using the filter component
[00:32:06] if you change you can add
[00:32:11] I add in this collaborator thing,
[00:32:13] right? You could say by Kamille and then
[00:32:16] whoever you're sharing
[00:32:18] this interface with,
[00:32:19] you know, they could turn that filter off.
[00:32:21] That's why I like that
[00:32:23] interfaces have stacked
[00:32:25] filters where that's not
[00:32:27] in here, it's not selectable
[00:32:29] and editable at all.
[00:32:30] But the component itself,
[00:32:32] each of these
[00:32:37] These two this chart
[00:32:38] and this grid have their own filter
[00:32:41] where collaborator
[00:32:42] is
[00:32:44] current user
[00:32:45] and then it's also connected
[00:32:47] to this filter component at the top.
[00:32:49] So if they can't edit
[00:32:52] the interface itself,
[00:32:54] you have to be a creator,
[00:32:56] I believe to edit the interface,
[00:32:58] then
[00:32:59] you know,
[00:33:00] you're able to hide the fact
[00:33:02] that you're only showing people
[00:33:04] a certain amount of
[00:33:05] information but still giving them
[00:33:07] the amount of information
[00:33:09] that they want to
[00:33:09] filter up at the top
[00:33:11] that's similar to
[00:33:13] if you share a view and the view
[00:33:15] already has a filter I think
[00:33:18] maybe.
[00:33:19] Yeah, yeah, except for in this case
[00:33:22] you can still get back directly into the
[00:33:25] base.
[00:33:26] That is true.
[00:33:27] So there's two separate
[00:33:29] things that were
[00:33:31] if I'm in,
[00:33:33] you know, let me exit out of here
[00:33:34] because I didn't make any really changes.
[00:33:35] So if we're looking at an interface
[00:33:38] you could always go back into the base by
[00:33:40] doing this
[00:33:42] and now we're in the base
[00:33:45] and
[00:33:47] sort of the
[00:33:49] going in between
[00:33:50] one record and all of its sub records
[00:33:53] affecting all of those
[00:33:54] components at once.
[00:33:56] Alli on our show has demonstrated
[00:33:58] how you could do similar
[00:34:00] functionality like this
[00:34:02] before where if you have
[00:34:04] a simple checkbox
[00:34:06] that say dashboard,
[00:34:08] you're saying only highlight this
[00:34:11] record in the dashboard
[00:34:12] and then all of my tasks
[00:34:14] who are linked to this record,
[00:34:16] have a look up field
[00:34:18] that say only show me records in
[00:34:22] records that have that
[00:34:24] dashboard in the look up field
[00:34:25] selected so
[00:34:27] you would end up, you know,
[00:34:28] roughly similar,
[00:34:29] You have different apps available
[00:34:31] to you because you know,
[00:34:32] they were built for dashboards
[00:34:35] and not for interfaces.
[00:34:36] changing that check mark is less
[00:34:42] fun.
[00:34:44] I've added a script
[00:34:46] that lets you do this which is,
[00:34:49] you know,
[00:34:50] it's quick but it's also silly.
[00:34:54] No, no one I work with
[00:34:55] is going to want to do that.
[00:34:57] It's just the fact of the matter.
[00:35:02] And none of these really
[00:35:04] talk to each other
[00:35:05] so they can't, I can't have
[00:35:07] you know, if I wanted to
[00:35:09] get in here
[00:35:10] and say have this chart really
[00:35:13] connected to what this is showing,
[00:35:15] I can't
[00:35:16] it's just their insular
[00:35:18] and so there it's it's a different sort of
[00:35:21] thing.
[00:35:22] For the most part,
[00:35:24] if you're already making use
[00:35:26] of Airtable's dashboard
[00:35:27] features, you're probably fine
[00:35:29] to not transition over
[00:35:31] into interfaces yet unless
[00:35:33] there's a piece of interfaces
[00:35:34] that you've seen that you want to show.
[00:35:37] So
[00:35:39] also
[00:35:41] if you wanted to share a dashboard,
[00:35:43] you also have to share the whole base.
[00:35:45] That's that's not a thing
[00:35:46] that's limited to just interfaces that,
[00:35:48] you know,
[00:35:50] even if you went with this setup,
[00:35:51] if you wanted to share this,
[00:35:52] you have to share
[00:35:54] the whole base as well.
[00:35:57] Right. Underneath it so
[00:35:58] either people can see
[00:36:00] all your data or they don't,
[00:36:02] I was really excited.
[00:36:04] I mean I was like, oh,
[00:36:05] like that whole air hack
[00:36:06] that I had, you know,
[00:36:07] demoed before. I was like, oh,
[00:36:09] this could totally replace that
[00:36:11] and like make it
[00:36:12] so much cooler
[00:36:13] and easier to use
[00:36:14] but I'm still going to stick
[00:36:15] with my Air hack
[00:36:16] version just because it's
[00:36:17] so limited in what I can display. Yeah,
[00:36:20] once there's more elements
[00:36:22] in an interface, I think it'll be,
[00:36:24] you know, the suitable replacement
[00:36:26] for it at the moment. I mean,
[00:36:28] if you like, I was showing the,
[00:36:30] I think that was matrix or pivot table.
[00:36:32] If you rely on the pivot table app
[00:36:35] to kind of summarize your data,
[00:36:37] there is no pivot table
[00:36:39] element here yet, so,
[00:36:41] and I can't even say yet
[00:36:42] I don't know if they're going to make that
[00:36:43] transition over.
[00:36:44] So if you're reliant on
[00:36:45] certain specific things from the
[00:36:47] dashboard, you're probably
[00:36:49] safe to just remain in dashboard if you
[00:36:52] aren't and if you're building something
[00:36:56] you know, from scratch,
[00:36:58] test it out to see if you can
[00:36:59] do what you want to do
[00:37:01] because I could do most of
[00:37:02] what I want to do
[00:37:04] this isn't linked to a record,
[00:37:07] this grid element,
[00:37:08] which is why I can add records
[00:37:10] to it and also delete records from it. So
[00:37:14] if I'm only planning my hours for a task,
[00:37:17] then I'm fine and I could use this but
[00:37:20] I want to also be able to do that
[00:37:23] for projects overall. So
[00:37:26] there's, I think that's the only thing
[00:37:29] stopping me from using
[00:37:33] this interface and by that,
[00:37:35] I mean I'm using it, I'm not
[00:37:37] using it for my other
[00:37:39] co workers yet
[00:37:40] because they're not gonna want to
[00:37:43] I know how to make records in Airtable.
[00:37:46] The whole point of this is to
[00:37:48] make it so
[00:37:49] it's an easier interface
[00:37:51] to interact with stuff
[00:37:53] and if they still have to go
[00:37:55] into the base to add records,
[00:37:57] then that's, you know,
[00:37:58] kind of defeating the
[00:37:59] purpose of me building this specifically.
[00:38:02] So
[00:38:04] yeah, I totally agree. Yeah.
[00:38:07] When adding and editing records from
[00:38:10] the list sort of component
[00:38:13] is made available
[00:38:15] I think that's the one thing
[00:38:17] that it's missing from my perspective,
[00:38:19] there's a bunch of other stuff missing
[00:38:21] from other use cases
[00:38:23] that people would find useful, but for me,
[00:38:26] they're not
[00:38:28] needed
[00:38:29] for this for this project,
[00:38:31] right.
[00:38:33] I think I'm also,
[00:38:34] one thing that really
[00:38:36] bothers me so far is like,
[00:38:38] I mean
[00:38:39] forget about like,
[00:38:40] like dragging things around the screen,
[00:38:41] I feel like it's
[00:38:42] sometimes pretty glitchy
[00:38:43] and I've actually had things
[00:38:45] disappear on me a couple
[00:38:45] of times.
[00:38:46] Just like gone poof.
[00:38:48] But like I really wish because
[00:38:50] when you set up from like
[00:38:52] a blank
[00:38:53] template, if you don't use a template
[00:38:55] rather you just start with a blank page,
[00:38:56] you can't get this view
[00:38:58] that you're looking at right now. Yes,
[00:38:59] this component here record list
[00:39:02] is only available if you choose the record
[00:39:05] list template.
[00:39:09] I don't know why.
[00:39:10] Yeah,
[00:39:11] I don't get it. I really,
[00:39:12] it would be helpful if you could just,
[00:39:14] you know,
[00:39:15] add it to a section
[00:39:17] and I just get so confused
[00:39:19] about how they segment these
[00:39:20] blocks off, like
[00:39:22] I drag it somewhere
[00:39:23] like sometimes I just can't put
[00:39:25] the block there
[00:39:27] at all
[00:39:28] or the element rather
[00:39:29] I don't know if I've been
[00:39:31] stopped yet from putting
[00:39:32] something somewhere
[00:39:33] and I haven't had something
[00:39:35] disappear on me.
[00:39:36] But I you know I believe
[00:39:38] that it happened
[00:39:40] like I'm pretty I mean I'm everywhere
[00:39:43] I'm intending to drag it is allowing me to
[00:39:46] I don't like that I can't right align
[00:39:48] things like if I put my
[00:39:50] mouse over here
[00:39:51] it will align everything to the left.
[00:39:54] I think that's a design choice
[00:39:56] but I want to make that choice for myself.
[00:39:58] Yes. You know
[00:40:00] exactly.
[00:40:01] Yeah there's definitely a few things just
[00:40:04] design wise or like layout wise
[00:40:06] that bother me. But
[00:40:08] other than that I'm happy
[00:40:09] with how it generally looks
[00:40:11] pretty slick and pretty
[00:40:12] nice. You've done a nice job Kamille,
[00:40:14] this looks great. I think that's sort of
[00:40:16] general direction
[00:40:19] of what I can reasonably infer. So
[00:40:24] you know we all have
[00:40:25] our wish lists of what
[00:40:27] can be added or what should be added. And
[00:40:30] you know one thing is like
[00:40:32] oh connecting multiple bases.
[00:40:33] I don't think Airtable
[00:40:35] ever said that.
[00:40:36] I think that's something we all
[00:40:37] sort of just came up with
[00:40:39] because the U.R. L. Includes the base id
[00:40:42] which suggests that that's
[00:40:43] not where they're going.
[00:40:45] So reasonably inferring
[00:40:48] from what I see before me
[00:40:52] is you know fine
[00:40:56] missing a few
[00:40:58] from a functional standpoint
[00:41:01] If I have the permissions
[00:41:03] to edit or add records,
[00:41:05] I should be able to add records easily
[00:41:07] and I can't yet. Also a button component.
[00:41:10] I think those are my two sort of things,
[00:41:12] like you could add a text component
[00:41:14] that has a link in it, but I want it
[00:41:16] formatted as a button,
[00:41:17] that's pretty simple.
[00:41:19] Right.
[00:41:20] Or like the buttons not working like
[00:41:23] a button.
[00:41:24] Well that would make sense
[00:41:26] to me because the button,
[00:41:29] if the button activates an app
[00:41:32] or opens a dashboard
[00:41:34] dashboards don't exist here.
[00:41:36] So there's nothing for it to open
[00:41:40] that one makes sense to me.
[00:41:41] You would have to,
[00:41:42] you would have to add in all of
[00:41:44] the apps
[00:41:45] in order for this
[00:41:46] or it would just open up in a new tab.
[00:41:48] So there's two ways you
[00:41:49] can do it. Opening up in a new tab
[00:41:51] I think is the easiest.
[00:41:53] And I think for,
[00:41:55] I don't know half the people
[00:41:57] that would be sufficient,
[00:41:58] but if you want it like
[00:41:59] available in the sidebar you would
[00:42:01] performance hits.
[00:42:03] Yeah, it just, it bothers me,
[00:42:05] I mean I think I'm just
[00:42:07] annoyed only because
[00:42:09] I have tons of use cases
[00:42:10] where buttons to run scripts
[00:42:12] are integral to using Airtable
[00:42:14] and so if I'm trying and I really
[00:42:16] want people to get out of Airtable,
[00:42:18] I want to take the people
[00:42:20] that are using it
[00:42:21] and give them an interface to use
[00:42:23] and that I just it won't be possible
[00:42:25] if they can't click a button to
[00:42:28] do something you know other than open
[00:42:31] link.
[00:42:32] Yes
[00:42:33] so there's some functionality
[00:42:35] that cannot be replaced
[00:42:37] without you know a script
[00:42:38] or some people have automations
[00:42:41] setup to do things.
[00:42:42] And so if you're trying to add
[00:42:44] whatever that functionality
[00:42:47] is into whatever
[00:42:48] interface you build
[00:42:49] it's still not going to work
[00:42:50] because the script app is an
[00:42:51] app and no apps
[00:42:52] are available
[00:42:53] because the dashboard isn't here.
[00:42:55] So one way or another
[00:42:57] they would have to find
[00:42:59] some way to get you
[00:43:02] access to that individual
[00:43:05] piece
[00:43:06] and because it's not
[00:43:07] hooked into anything it's
[00:43:10] you know the only
[00:43:11] the quickest solution
[00:43:13] I can think of is like
[00:43:15] opening it up
[00:43:17] in just another,
[00:43:20] but even that's hard
[00:43:22] because if we look
[00:43:23] if we look at the base
[00:43:25] and we open up
[00:43:27] any particular app
[00:43:29] you can see the U. R. L.
[00:43:32] will include whichever app
[00:43:34] you have in full screen.
[00:43:36] So let's say if you're in an interface
[00:43:38] and the button that activates an app
[00:43:41] opens up in a new tab,
[00:43:44] you'll also notice that it
[00:43:46] doesn't pass in any
[00:43:47] additional information.
[00:43:48] So if your script was to say
[00:43:51] perform a certain action
[00:43:53] on a particular record,
[00:43:54] no app is designed to do that
[00:43:57] and no app can be designed
[00:43:59] to do that because
[00:44:00] that's not a that's not a thing.
[00:44:03] So every single app
[00:44:05] would have to be rewritten.
[00:44:08] I mean what you could do,
[00:44:10] I guess like the really
[00:44:12] jankie kind of workaround
[00:44:13] would be to have a button
[00:44:14] that opens up
[00:44:15] the particular record in a particular
[00:44:17] view and like then you have
[00:44:19] the button right there to run this.
[00:44:21] Yes, that is, that is
[00:44:22] one way that you could do it.
[00:44:24] Yeah, that's a workaround.
[00:44:27] And lastly, we sort of show that the
[00:44:32] interfaces filter component
[00:44:33] allows you to filter
[00:44:35] by current user and some people
[00:44:36] were saying I want to have the same,
[00:44:38] well this doesn't have
[00:44:40] a collaborator field,
[00:44:41] I want to have the same sort of
[00:44:42] functionality
[00:44:43] in a regular view,
[00:44:45] you know, it doesn't say current user.
[00:44:48] That doesn't make sense
[00:44:50] for views
[00:44:51] and this is the hill I'm going to die on.
[00:44:55] It would be great
[00:44:57] until you realize how much Airtable
[00:45:00] relies on what is in a
[00:45:02] view to control the entire thing.
[00:45:06] So any script
[00:45:07] or any automation or any,
[00:45:10] anything based in the api
[00:45:12] that relies on what is in a view
[00:45:15] would vary wildly by who's looking at the
[00:45:18] base and there'd be no records in a view,
[00:45:21] if no one was looking at the base at
[00:45:23] that particular time.
[00:45:25] The only thing I could think of
[00:45:28] which would be changing views
[00:45:30] or view based
[00:45:31] filter types as we know them,
[00:45:33] is to have regular filters like this
[00:45:35] and then have a visibility filter
[00:45:37] that is separate from that on top of it
[00:45:40] and in the visibility things,
[00:45:42] they only show the
[00:45:43] current user so it's not affecting
[00:45:46] what is in the view per se
[00:45:48] and only showing you what you want to see.
[00:45:51] I think there's a
[00:45:53] distinction that would have to be
[00:45:55] made to copy over that functionality into
[00:45:58] regular views.
[00:45:59] And the reason why interfaces
[00:46:02] has that ability in the first place
[00:46:04] is because
[00:46:04] these filters do not affect
[00:46:07] what's in the view,
[00:46:08] it's purely a visibility thing.
[00:46:12] It's in this
[00:46:14] the instant you try and add it to views,
[00:46:18] it would break more things than it
[00:46:20] would solve, it really would.
[00:46:24] I agree.
[00:46:25] Very good.
[00:46:27] Thank you Kamille, that was awesome.
[00:46:29] More insight we're learning every day on
[00:46:32] what's possible in
[00:46:33] the world of interfaces.
[00:46:35] So that's good.
[00:46:36] We'll definitely continue
[00:46:38] that discussion in future weeks.
[00:46:40] So we're gonna move
[00:46:40] on, we have a special guest with us.
[00:46:43] I'm gonna bring Drew in and
[00:46:45] move him up so we can see him.
[00:46:48] Drew welcome. How are you?
[00:46:49] Thanks Great,
[00:46:50] thanks for having me everybody,
[00:46:52] yep. Glad to have you on our show.
[00:46:55] So you're a new face
[00:46:57] for at least the BuiltOnAir community.
[00:47:00] So we'd love to learn more about you.
[00:47:02] We'd love to learn
[00:47:03] kind of your history
[00:47:05] what you're up to
[00:47:06] and how you came across Airtable
[00:47:08] and
[00:47:09] how that's kind of impacted
[00:47:11] your work life.
[00:47:12] Yeah, absolutely, so Drew Dillon,
[00:47:14] longtime Product manager,
[00:47:16] Product leader tech
[00:47:17] startups out here in the Bay Area.
[00:47:20] You know, kind of, I was thinking about
[00:47:24] what my like no code history was
[00:47:26] and I was like,
[00:47:27] probably like geo cities was
[00:47:29] the first thing that I would classify
[00:47:30] as no code, MySpace,
[00:47:32] so that's gonna date
[00:47:33] myself a little there.
[00:47:35] and then, yeah,
[00:47:36] I've mostly worked in startups.
[00:47:37] So I've always had kind of an
[00:47:38] engineering team of people
[00:47:40] that could go build things quickly,
[00:47:41] but of course there's always that
[00:47:43] that middle priority of like,
[00:47:45] stuff that I want to get done,
[00:47:46] that the engineering team is too busy
[00:47:48] to work on and things that we need to just
[00:47:50] kind of deliver.
[00:47:51] And that ends up being a lot
[00:47:53] on the operations side on
[00:47:54] kind of the back office stuff,
[00:47:57] less user facing.
[00:47:59] And then, you know,
[00:48:00] most recently I've been
[00:48:02] working on a company called Burb.
[00:48:03] Burb is really, the way we think
[00:48:05] about it is like a no code
[00:48:07] app for course and
[00:48:08] community creators.
[00:48:09] So if you run a course,
[00:48:11] you run a community,
[00:48:11] you know, there's just a lot
[00:48:13] of different components to that.
[00:48:15] And we started,
[00:48:16] I think building in a very specific
[00:48:19] direction of enablement and
[00:48:20] automation.
[00:48:21] What we kept finding as
[00:48:22] we were working with more and more course
[00:48:24] creators is inevitably, you know,
[00:48:26] when you get to a
[00:48:28] certain level at a low level,
[00:48:29] when you're first starting out,
[00:48:31] you got 10 students,
[00:48:32] it's easy enough to like
[00:48:33] download CSVs and upload it
[00:48:35] over there and copy this
[00:48:36] email address over here
[00:48:37] and that kind of thing.
[00:48:39] But when you start to scale
[00:48:41] to teaching, you know, 50, 100, 200
[00:48:43] students at a time that just doesn't work.
[00:48:45] And it's that point that they start
[00:48:47] bringing in
[00:48:48] and we found kind of 50 different
[00:48:50] implementations of the same kind
[00:48:52] of Airtable template
[00:48:54] where they'd all built their
[00:48:56] own ops stack on Airtable.
[00:48:58] They all had kind of like,
[00:48:59] You know, each one of them
[00:49:00] had sort of interesting components
[00:49:02] about ways that
[00:49:02] they operated their business,
[00:49:03] but it became pretty obvious
[00:49:05] to us because we're
[00:49:05] working with 20 plus these
[00:49:06] individuals that there was actually
[00:49:08] a better way and
[00:49:09] we could actually start to pull
[00:49:10] all the best of all these
[00:49:11] components together
[00:49:12] and deliver a kind of a template
[00:49:13] that would help everybody.
[00:49:14] And you know,
[00:49:15] we're just big believers
[00:49:17] and building in public and open
[00:49:18] source, so we decided
[00:49:19] we're just gonna share that
[00:49:20] template out for everybody,
[00:49:21] let everybody use it
[00:49:22] and kind of walk everybody through
[00:49:24] how it works and why it
[00:49:25] works that way and
[00:49:26] just share it with more folks.
[00:49:28] Cool.
[00:49:29] And have you been in the
[00:49:31] education space for a while?
[00:49:32] Yeah, it's you know,
[00:49:34] I think we we
[00:49:35] started thinking about community
[00:49:38] initially, and my co founder
[00:49:41] Danielle is actually
[00:49:44] she was, she actually
[00:49:46] was an Etsy seller,
[00:49:47] one of the first Etsy sellers who got
[00:49:49] really, really successful.
[00:49:51] She was a Goldsmith in Detroit.
[00:49:53] Later got pulled in
[00:49:53] and hired by Etsy's employee
[00:49:55] number 12 and built out the
[00:49:58] basically an education team
[00:49:59] that then launched all these
[00:50:01] educational programs through community
[00:50:03] and then myself,
[00:50:04] I was a product manager at yammer,
[00:50:05] so I always think about
[00:50:06] everything in terms of like social,
[00:50:08] how you communicate,
[00:50:09] how people work together
[00:50:10] to get things done.
[00:50:11] So this is always kind of like
[00:50:13] you know the mash up
[00:50:15] of community and education
[00:50:16] kind of all together.
[00:50:18] Yeah, I remember Yammer
[00:50:19] and I wasn't at a company that used it,
[00:50:22] but definitely familiar
[00:50:24] kind of the pre slacked days,
[00:50:26] yeah, I'm pretty sure USC
[00:50:28] uses Yammer
[00:50:29] and I've never actually looked at it
[00:50:31] at some point
[00:50:32] I should, yeah,
[00:50:33] there was a time,
[00:50:35] especially after we got
[00:50:36] bought by Microsoft,
[00:50:37] like the
[00:50:38] of course at yammer
[00:50:39] engagement was like live or die,
[00:50:41] you need to like have
[00:50:42] people care about the site
[00:50:43] in order for us to succeed as a business,
[00:50:45] but once you get into Microsoft
[00:50:47] is very much about like license sales,
[00:50:49] there's a lot let's focus on whether
[00:50:51] or not people actually care about and
[00:50:52] use the product of that. Yeah,
[00:50:55] very cool. And where are you based at?
[00:50:57] I'm in Berkeley California.
[00:50:59] Yeah, everyone I talked to was
[00:51:02] in Texas
[00:51:03] and no one's in California anymore.
[00:51:05] We luckily had moved into
[00:51:07] the burbs before the pandemic
[00:51:09] so I could just stay in
[00:51:11] the burbs.
[00:51:12] Very nice.
[00:51:13] And how long has Burb been around?
[00:51:17] Almost exactly a year.
[00:51:19] Yeah, like 13 months
[00:51:20] and so yeah, initial phases were
[00:51:22] very much research based,
[00:51:23] what are we doing,
[00:51:25] meet a lot of these folks,
[00:51:26] see what their problems are
[00:51:27] and yeah that's where we
[00:51:29] kind of kept stumbling
[00:51:30] across sort of the same Airtable and
[00:51:32] implementations over and over again.
[00:51:34] And then the same challenge
[00:51:36] which is like who maintains it,
[00:51:38] you know if they get really successful,
[00:51:40] they've paid somebody on Upwork to come
[00:51:41] in and build them one but like
[00:51:43] then they wanted to make
[00:51:44] a minor tweak to it,
[00:51:45] they just didn't necessarily have
[00:51:45] the skills even though
[00:51:47] it's like change the thing
[00:51:48] that they wanted around
[00:51:48] whatever. However,
[00:51:49] the course was evolving.
[00:51:51] Nice. Cool.
[00:51:52] Well we are excited to see
[00:51:55] what you have for us so if you
[00:51:58] want to start sharing your screen
[00:52:01] before we get to that
[00:52:02] we are going to we're
[00:52:04] gonna sneak in real quick and do a
[00:52:08] deep an ad for our
[00:52:10] primary sponsor On2Air.
[00:52:12] So I kind of teased this at the
[00:52:14] beginning and one thing
[00:52:16] that will be launching
[00:52:18] with our new version of On2Air
[00:52:25] shoot
[00:52:27] I deleted
[00:52:30] now. Here we go.
[00:52:32] Okay. Our new thing that
[00:52:34] we're adding to On2Air amplify
[00:52:37] is permissions, so the
[00:52:39] ability to so we call our views layouts.
[00:52:43] So within a layout you have the
[00:52:46] ability to
[00:52:47] my browser is being very slow
[00:52:51] to determine who can see a view,
[00:52:54] so you can lock it down.
[00:52:57] So if I go into edit a view,
[00:53:01] this is gonna be painful,
[00:53:05] right
[00:53:06] browsers being slow
[00:53:07] so you can set up permissions
[00:53:09] at the view level.
[00:53:09] So you can say it's visible
[00:53:12] to everyone
[00:53:13] or to based off of a role, or it's for
[00:53:16] specific users
[00:53:18] or you can also say these people
[00:53:21] cannot see it, anybody else can.
[00:53:23] So you can set up visibility
[00:53:25] based off of user
[00:53:26] or based off of their role or by
[00:53:28] default layout is visible to everyone
[00:53:31] you can also set up permissions
[00:53:33] around who can create new records,
[00:53:35] who can edit records,
[00:53:37] who can delete records,
[00:53:39] similar permissions on per user or
[00:53:42] per role basis.
[00:53:43] So that's the ability to set up
[00:53:46] permissions around the ability to
[00:53:49] manage layouts and records within there.
[00:53:53] And then the other permission
[00:53:55] that we have
[00:53:56] that is unique is the ability to set
[00:53:59] up filtered records.
[00:54:00] So what that means is
[00:54:02] you can go to every table and you can
[00:54:04] set up a field
[00:54:06] and have some kind of
[00:54:08] way that says for these users
[00:54:11] that record has to have a value
[00:54:14] in this field equal to this
[00:54:16] in order for them to
[00:54:17] see it.
[00:54:18] Or you can say
[00:54:20] you can set it up based off of
[00:54:24] a collaboration field.
[00:54:25] So you can specify a collaborator
[00:54:28] field and say as long
[00:54:29] as the current logged in user
[00:54:32] is in this collaboration field,
[00:54:35] that would be the easiest
[00:54:36] because you don't have to go
[00:54:38] to every user and set
[00:54:38] up a permission
[00:54:40] of what records they can see.
[00:54:42] You can just say you can just lock it
[00:54:45] based off of collaborator field
[00:54:46] and do that.
[00:54:47] Or you can set it up off of a select field
[00:54:51] and say this user can
[00:54:52] only see records
[00:54:53] with this selection
[00:54:55] set or the multiple
[00:54:57] multiple select,
[00:54:59] as long as it has this one value. So
[00:55:02] or it could be based off
[00:55:03] of a text field
[00:55:04] and you can set the text field,
[00:55:06] you can set up,
[00:55:07] it has to be an exact match of that value,
[00:55:09] or if you don't have
[00:55:10] an exact match,
[00:55:11] it could be
[00:55:12] as long as that text is in there.
[00:55:14] You can make a case sensitive
[00:55:17] and you can also say
[00:55:19] these users can see this
[00:55:20] when there is a match
[00:55:22] or when there's no match.
[00:55:24] So you can kind of turn it on or
[00:55:26] off based off of the value that you set.
[00:55:29] And then you can also
[00:55:30] set up a catch all
[00:55:31] for any users that aren't configured.
[00:55:33] Need to have this value to see it So
[00:55:37] very powerful way
[00:55:39] to set up which records,
[00:55:41] users can interact with within the
[00:55:43] app.
[00:55:43] This obviously doesn't impact
[00:55:45] what they can see over on the left.
[00:55:47] So it's not intended to be a way
[00:55:50] to hide data from users,
[00:55:52] but more make it to
[00:55:53] where
[00:55:54] if they're only working with
[00:55:56] specific records that are tied to them,
[00:55:58] they won't need,
[00:55:59] they won't see them,
[00:56:01] they won't show up when they're searching
[00:56:02] for other records within the table,
[00:56:05] it will automatically filter them out.
[00:56:08] So extremely powerful,
[00:56:10] role based, user based permissions
[00:56:12] on the ability to
[00:56:14] interact with records
[00:56:15] and layouts within the
[00:56:17] On2Air Amplify app. So
[00:56:19] very powerful coming
[00:56:21] any day now this week
[00:56:23] to the marketplace,
[00:56:25] the latest version with that
[00:56:27] level of permission.
[00:56:28] So we're very excited
[00:56:30] for that and hope that you check it out
[00:56:33] with that, we'll finish up
[00:56:35] learning about the Burb app
[00:56:40] and how that works with Airtable.
[00:56:42] So Drew, I'll share your screen and then
[00:56:47] bring you back in, there you are.
[00:56:50] I snuck out there for a second,
[00:56:52] I got a new laptop.
[00:56:53] So my permissions are all
[00:56:54] messed up for display.
[00:56:56] Yeah, so I thought I'd start here
[00:56:58] with kind of like an overview of sort of
[00:57:00] the landscape of where course
[00:57:02] and community folks live and of course,
[00:57:04] you know, I know the BuiltOnAir
[00:57:06] community of course lives in some of this
[00:57:09] as well, where you're applying
[00:57:11] and getting in access
[00:57:12] to the slack channel.
[00:57:13] So often where it starts, you know,
[00:57:15] there's an application form,
[00:57:16] I want to join the community,
[00:57:18] I want to join the course
[00:57:20] that'll live in web flow
[00:57:21] or Airtable square space
[00:57:22] is just a variety of apps
[00:57:24] people use kind of as the
[00:57:25] front end
[00:57:27] if there's a membership community
[00:57:29] or a course then next,
[00:57:30] they usually go to some
[00:57:31] sort of purchasing
[00:57:33] thrive card or teachable.
[00:57:35] Sometimes being access access to a
[00:57:37] private community is a tier on Patreon,
[00:57:39] a lot of different purchasing options
[00:57:41] there.
[00:57:42] No, it's after you complete those two,
[00:57:44] that you get access
[00:57:45] to the communication app
[00:57:46] most commonly we work with
[00:57:49] slack, circle, and discord
[00:57:52] and then your course
[00:57:53] coordinating communication
[00:57:54] kind of all across the way
[00:57:55] through some sort of email marketing app
[00:57:58] convert hit mail chimp
[00:58:00] et cetera.
[00:58:00] And then once you have
[00:58:02] access to all of these things,
[00:58:03] then you put them in the
[00:58:04] learning management platform
[00:58:05] that contains all of your
[00:58:06] course materials
[00:58:07] for teaching a course
[00:58:08] and then often you'll have some
[00:58:10] form of events monthly, weekly, even
[00:58:14] a couple times a week in some cases
[00:58:16] and so, you know, that's a,
[00:58:18] it's a big stack, even, you know,
[00:58:19] if you're operating a 10 person
[00:58:21] cohort based course, that's,
[00:58:22] it's a lot of work,
[00:58:24] even just copying and pasting
[00:58:25] and we heard most commonly,
[00:58:27] you know, the biggest question
[00:58:29] that creators here is
[00:58:30] like what's the zoom link,
[00:58:32] you know, what's that
[00:58:33] I figure out where the zoom is,
[00:58:35] the event that I need to go to
[00:58:36] and so as they get more
[00:58:38] advanced they'll end up
[00:58:39] start pulling it together with Zapier
[00:58:41] Airtable for certain parts of automation
[00:58:43] and then like I said they'll,
[00:58:45] you know the really advanced folks get to
[00:58:48] you know apps and data
[00:58:50] kind of all built into one big Airtable.
[00:58:55] So with that said
[00:58:56] so what we decided to do
[00:58:58] is really build out,
[00:58:59] you know, kind of that canonical
[00:59:00] template are best practices
[00:59:02] as we learned along
[00:59:02] with all the folks
[00:59:03] that we've been working with.
[00:59:06] And it I'll walk you
[00:59:08] through the template itself.
[00:59:10] So first as the student roster,
[00:59:12] this is where folks come in when they first
[00:59:14] purchased when they first admitted
[00:59:17] to the to the community.
[00:59:20] So we've built up here
[00:59:21] just a really simple form
[00:59:22] but a lot of times what
[00:59:23] actually happens here is
[00:59:24] that this is driven by a purchase event,
[00:59:26] so somebody will go and pay
[00:59:28] for the community,
[00:59:29] they'll pay for the course,
[00:59:30] then they get added to the roster.
[00:59:32] The next thing you want
[00:59:34] to do is on board them.
[00:59:37] So kind of all the different pieces
[00:59:39] of on boarding, we'll walk through these
[00:59:40] in a minute, just you know
[00:59:42] who they are
[00:59:43] you know populate sort of a member
[00:59:45] directory, It's a best practice
[00:59:47] to understand and share
[00:59:49] who's in your community,
[00:59:50] who else is in your core,
[00:59:51] see if they've got connections
[00:59:52] in other ways of kind
[00:59:53] of you know, adding additional value,
[00:59:55] an additional
[00:59:56] connection between the
[00:59:58] members of the,
[00:59:58] of the course or community.
[01:00:03] We've already pre set up
[01:00:04] some cohorts here,
[01:00:06] so the idea there is your,
[01:00:07] if you're teaching a cohort based course,
[01:00:09] they're time based and there's also a
[01:00:10] certain number of folks
[01:00:11] that are going to be in them,
[01:00:13] so this will allow us to
[01:00:14] assign people to a cohort
[01:00:15] and we've got some automations
[01:00:17] that actually driven off
[01:00:17] of that as well
[01:00:20] and then relatedly
[01:00:21] accountability groups.
[01:00:23] This is also something that's super
[01:00:24] powerful in both courses
[01:00:26] and communities. We find
[01:00:29] people want to know each other
[01:00:30] and they want to know each
[01:00:31] other in smaller group
[01:00:32] settings. So giving people
[01:00:34] who have common goals,
[01:00:36] common expectations and
[01:00:37] needs for being there,
[01:00:39] you know, a group
[01:00:39] that they can catch up with on a
[01:00:41] regular basis
[01:00:42] is a great way of just kind of
[01:00:44] boosting utilization interest and
[01:00:45] kind of value
[01:00:46] through the community
[01:00:48] or in of course,
[01:00:50] and of course you as the course
[01:00:51] creator won't actually know
[01:00:52] that those things are
[01:00:53] happening and people are really
[01:00:54] getting value out of it.
[01:00:55] So we built basically a
[01:00:56] form where they can check in
[01:00:58] and talk about their goals,
[01:01:00] you know, how they're,
[01:01:01] how they're tracking against their goals,
[01:01:04] what else do you have any assignments
[01:01:07] oddly a lot of learning management
[01:01:09] platforms don't have the ability
[01:01:11] to upload assignments,
[01:01:12] We heard from a lot of
[01:01:12] people like this is
[01:01:14] we found at least two or three people
[01:01:16] that actually only had Airtable just to
[01:01:18] have a place to upload assignments
[01:01:20] so that they could, you know,
[01:01:21] submit their assignments week by week
[01:01:23] and then lastly, like I mentioned events
[01:01:27] and then all of these
[01:01:28] will pull back together into a task list
[01:01:31] that's actually broken down
[01:01:33] kind of week by week.
[01:01:34] So what the course creator
[01:01:35] needs to do,
[01:01:36] what they need to know,
[01:01:37] kind of week by week
[01:01:38] based on all those
[01:01:39] pieces.
[01:01:41] So if I were to
[01:01:43] to clarify my understanding,
[01:01:45] so what they're actually
[01:01:47] buying from you is this
[01:01:48] actual Airtable base as a template?
[01:01:51] So the template is totally free
[01:01:53] of what we do, is then we kind of,
[01:01:55] we'll show you this in zaps
[01:01:57] in a second,
[01:01:57] but we go and automate all the rest
[01:01:59] of these pieces.
[01:02:00] So as you add somebody to a cohort,
[01:02:01] add them to the right slack
[01:02:02] channel
[01:02:03] message them,
[01:02:04] let them know where they are,
[01:02:06] remind them as you have them to
[01:02:07] accountability group,
[01:02:08] add them to the right slack channel
[01:02:10] message into that
[01:02:10] slack channel
[01:02:11] share out these forms,
[01:02:13] just kind of remind them.
[01:02:14] So we're really the operations
[01:02:15] and the measurement side
[01:02:17] of this and this is
[01:02:17] really the operations
[01:02:19] and the view of all the course
[01:02:22] components as you put them
[01:02:23] together.
[01:02:26] yeah, that's interesting.
[01:02:28] I haven't seen a company, you know like
[01:02:31] working, I thought a lot about this,
[01:02:33] there's definitely some
[01:02:35] limitations on Airtable side,
[01:02:37] as far as sharing
[01:02:38] these bases
[01:02:43] when you share the base
[01:02:44] so you do have scripts
[01:02:46] or automation is built into Airtable
[01:02:48] or everything is outside like in Zapier?
[01:02:51] So you have a lot of missions.
[01:02:52] Yes, it's a little bit of both
[01:02:54] and we could
[01:02:54] actually walk through
[01:02:55] some of how this will work.
[01:02:58] So I've got a
[01:02:59] I lost it when I filled all this in
[01:03:04] so I've got SAM card set up here
[01:03:08] which will dummy up our purchasing flow,
[01:03:16] There is a number of test for dues.
[01:03:21] and that won't work in real life
[01:03:23] just so people know
[01:03:24] of your stripe account set on
[01:03:26] tests and you're SAM card
[01:03:27] accounts it on test
[01:03:32] and so as this purchase
[01:03:34] goes through what we then have
[01:03:35] is a zap right now and
[01:03:37] this this will be replaced by Burb
[01:03:40] that then we'll just
[01:03:42] run it to make sure it happens,
[01:03:46] maybe details or
[01:03:58] to make it around last night,
[01:03:59] maybe there's none.
[01:04:09] Well let's see if it populates.
[01:04:12] Yeah,
[01:04:14] so it went ahead and populated
[01:04:16] that registered
[01:04:18] table so that first roster
[01:04:20] so what we've got here
[01:04:22] now is the user is
[01:04:23] registered, they haven't actually
[01:04:25] been added to a cohort yet.
[01:04:26] The next piece that will do
[01:04:28] is actually add them
[01:04:29] to a cohort when we do that,
[01:04:30] that will fire
[01:04:32] this automation in Airtable.
[01:04:35] So when students registered,
[01:04:37] when they're added to a cohort
[01:04:38] And it sends them an email
[01:04:40] and that email has the
[01:04:41] onboarding form in it
[01:04:44] So go ahead and drew to cohort one
[01:04:53] we should send our
[01:04:55] email.
[01:05:02] yep. So now I get the onboarding form,
[01:05:06] Another kind of common thing
[01:05:08] that happens because all these systems are
[01:05:10] disconnected, there's no way of like
[01:05:12] associating the member record.
[01:05:14] So something that's really nice
[01:05:15] about them centralizing
[01:05:17] it all on Airtable is
[01:05:17] rather than having
[01:05:18] the member record be like
[01:05:19] basically attached by email
[01:05:21] address where people
[01:05:22] can either accidentally type
[01:05:22] the wrong thing or you know,
[01:05:24] if you have multiple
[01:05:26] email addresses is a big
[01:05:27] challenge that comes up,
[01:05:28] we can just create a selector there.
[01:05:45] It's very important
[01:05:46] at a really nice profile photo.
[01:05:48] Yeah.
[01:06:07] So we
[01:06:08] so if they buy this
[01:06:14] your team will then come in,
[01:06:16] set it all up for them,
[01:06:17] set up all the automation
[01:06:19] and the zap,
[01:06:19] that's essentially the service
[01:06:21] that you're providing.
[01:06:22] Yeah, they could have the templates
[01:06:24] free so you can get in there,
[01:06:25] start using, if you want to build zaps
[01:06:27] against it, like we're doing right now,
[01:06:29] they can go ahead and do that
[01:06:31] then if what you'll see is like the more
[01:06:35] you want to add to it,
[01:06:36] the kind of longer
[01:06:37] your list of zaps will get,
[01:06:38] So what we're able to do
[01:06:40] then is go and plug in, make it really,
[01:06:42] really easy to connect all these
[01:06:44] systems up in a more turnkey
[01:06:45] sort of way and
[01:06:46] then also measure
[01:06:47] and show you kind of your funnel
[01:06:49] as people are moving through
[01:06:49] each one of these steps
[01:06:51] and then the level of engagement
[01:06:52] are people completing
[01:06:53] the course
[01:06:53] are they getting what
[01:06:54] they want out of the course,
[01:06:55] et cetera.
[01:06:55] Yeah,
[01:06:56] I just think it's cool to show
[01:06:58] the power of, you know,
[01:07:00] this is where like that
[01:07:01] no code buzzword comes
[01:07:03] into play is you're actually
[01:07:05] building a business all on
[01:07:06] these platforms that, you know,
[01:07:09] you didn't necessarily build
[01:07:10] any of the platforms
[01:07:12] but you're still providing
[01:07:13] value in a service by getting
[01:07:15] them all to work together
[01:07:17] and bringing all the
[01:07:18] pieces together.
[01:07:20] Yeah, enables us to really
[01:07:21] rapidly prototype these things,
[01:07:23] some of this functionality,
[01:07:24] I think we'll eventually exist in Burb,
[01:07:26] but a lot of it won't,
[01:07:27] I don't think we'll go
[01:07:28] that far down the end,
[01:07:29] like down the course path.
[01:07:30] So I think we'll always
[01:07:32] want to inter operate with
[01:07:33] Airtable and folks that use Airtable,
[01:07:36] it does things like building
[01:07:38] a student directory
[01:07:40] which you can then embed
[01:07:41] super interested in trying out
[01:07:43] interfaces more
[01:07:44] as we get further along with the
[01:07:46] template,
[01:07:48] it helps students track their
[01:07:49] progress whether they've been assigned to
[01:07:51] accountability group.
[01:07:52] So similarly, once I add some
[01:07:54] drew here to an accountability group
[01:07:58] that will actually
[01:08:00] then sends a form for the
[01:08:02] accountability group,
[01:08:03] just the same way that we saw
[01:08:05] that before
[01:08:07] for tracking,
[01:08:07] and then also could send them
[01:08:09] like an introduction everybody else in
[01:08:10] the accountability group.
[01:08:12] And then one last thing
[01:08:15] there was kind of the ability to
[01:08:24] synchronize
[01:08:27] events.
[01:08:34] And so similarly,
[01:08:35] what we'll do here,
[01:08:36] we'll just go and create a simple event,
[01:08:53] in a couple seconds
[01:08:54] that actually populate
[01:08:56] the event list as well.
[01:09:01] So you can then share it
[01:09:03] similarly with the
[01:09:04] with all the students in the
[01:09:05] course, so just a way of like
[01:09:07] really centralizing,
[01:09:08] we call it course ops in a
[01:09:09] box, and we'll also be releasing
[01:09:11] community ops in a box,
[01:09:12] or just a way of like
[01:09:13] getting visualization across
[01:09:14] all the different operations.
[01:09:16] We'll help you
[01:09:16] automate all of these things,
[01:09:18] tie all those pieces together,
[01:09:19] and this will be a kind of
[01:09:20] your review of what's going on
[01:09:22] any kind of quick success story,
[01:09:24] How is how is this
[01:09:26] being used out in the wild?
[01:09:28] Yeah, we've got probably 5-10
[01:09:31] implementations of it right now,
[01:09:35] I think there's we support anything from
[01:09:38] entrepreneurship through like
[01:09:41] specific niche entrepreneurs,
[01:09:43] as well as various creator businesses.
[01:09:47] So folks, there's
[01:09:50] a million kind of businesses
[01:09:52] built around one that we support out of
[01:09:54] Australia is
[01:09:58] basically the idea is helping
[01:10:00] musicians become marketers
[01:10:02] and think of themselves
[01:10:03] as a business
[01:10:04] and how to get distribution
[01:10:06] for their music
[01:10:08] and the really cool
[01:10:11] you know, kind of
[01:10:13] challenge there is that as your creator,
[01:10:15] you're an artist, you're creating music,
[01:10:16] you don't necessarily think
[01:10:18] of the business side,
[01:10:20] how do I get to the next level?
[01:10:21] So this course helps them
[01:10:23] break down like the individual steps,
[01:10:25] seven different steps of
[01:10:26] seven different types
[01:10:27] of gatekeeper to get your music
[01:10:28] on the radio
[01:10:29] and the right Spotify playlists
[01:10:31] get to the right producers
[01:10:33] and that course it's pretty intensive,
[01:10:35] it's a two month cohort based course and
[01:10:38] they launch a new cohort every month.
[01:10:40] So without something like an
[01:10:41] operational template,
[01:10:42] to like visualize all this stuff
[01:10:43] together. It gets pretty crazy,
[01:10:45] pretty fast.
[01:10:46] Nice.
[01:10:47] That's awesome.
[01:10:48] And now you've got a new tool
[01:10:51] in interface to introduce to your
[01:10:53] community
[01:10:53] and see how that
[01:10:55] plays with your product.
[01:10:56] Yeah, and we'd love to yeah,
[01:10:58] we'd love to push it up
[01:10:59] to the resources page on
[01:10:59] BuiltOnAir too.
[01:11:00] So we'll give you a little preview there,
[01:11:02] we'll launch this a
[01:11:03] little bit after thanksgiving but
[01:11:04] we'll give the community a preview
[01:11:07] cool
[01:11:08] and where can people
[01:11:10] find out more about it?
[01:11:11] Yeah. For now you
[01:11:12] can go to burb.co
[01:11:14] and look under the resources tab and
[01:11:16] then yeah, we'll push it up
[01:11:18] to the resources page
[01:11:19] and BuiltOnAir and then
[01:11:20] we'll do probably our full drop
[01:11:23] the first week of December through product
[01:11:26] hunt and then you can sign up
[01:11:28] for our wait list on the website
[01:11:30] to get notified when that happens,
[01:11:32] awesome.
[01:11:34] That's very cool to see
[01:11:36] businesses being built
[01:11:37] entirely on Airtable
[01:11:39] and and how that plays out.
[01:11:40] So very cool.
[01:11:41] Thank you Drew for coming on the show
[01:11:43] today and showcasing,
[01:11:45] we're glad to meet you
[01:11:47] and excited to see what Burb
[01:11:49] does in the future
[01:11:50] and the community
[01:11:51] and products that you guys work on.
[01:11:54] So
[01:11:55] thanks for coming on
[01:11:56] Awesome, nice meeting all of you
[01:11:58] and thanks all BuiltOnAir
[01:11:59] community members,
[01:11:59] yep. And that concludes today's episode.
[01:12:03] So we've got two more episodes before
[01:12:05] the end of the year
[01:12:06] before we'll take December off.
[01:12:08] So join us next Tuesday.
[01:12:09] Until then we are excited to see
[01:12:12] what you build OnAir take care.
[01:12:14] Bye guys.