7/26/2022 – BuiltOnAir Live Podcast Full Show – S11-E12

Duration: 56 minutes

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.

Start a FREE 14 Day Trial of On2Air Now


In This Episode

Welcome to the BuiltOnAir Podcast, the live show.  The BuiltOnAir Podcast is a live weekly show highlighting everything happening in the Airtable world.

Check us out at BuiltOnAir.com. Join our community, join our Slack Channel, and meet your fellow Airtable fans.

Todays Hosts

Alli Alosa – Hi there! I’m Alli 🙂 I’m a fine artist turned “techie” with a passion for organization and automation. I’m also proud to be a Community Leader in the Airtable forum, and a co-host of the BuiltOnAir podcast. My favorite part about being an Airtable consultant and developer is that I get to talk with people from all sorts of industries, and each project is an opportunity to learn how a business works.

Kamille Parks – I am an Airtable Community Forums Leader and the developer behind the custom Airtable app “Scheduler”, one of the winning projects in the Airtable Custom Blocks Contest now widely available on the Marketplace. I focus on building simple scripts, automations, and custom apps for Airtable that streamline data entry and everyday workflows.

Dan Fellars – I am the Founder of Openside, On2Air, and BuiltOnAir. I love automation and software. When not coding the next feature of On2Air, I love spending time with my wife and kids and golfing.

Show Segments

Round The Bases – 00:03:32 –

Meet the Creators – 00:18:53 –

Meet Chris Zantis.

Chris Zantis is a Registered Architect in the UK (ARB) and Cyprus (ETEK). He is a graduate of the Department of Architecture of the University of Cyprus and holds an MA in Enterpreneurship from Goldsmiths University of London. He has worked in several award-winning practices in London, participating in the design and delivery of a wide range of structures and spaces, such as Private Residences, Hotels, Skyscrapers, Commercial/Office Spaces, Manufacturing Facilities, Shopping Centres and Retail.Since 2019, he has repatriated to Cyprus after several years working in London and is currently working as an Architect in Limassol. His current interest is the induction of innovative design technologies in the analysis, composition and organisation of Building Information.He discovered Airtable while working for back in 2017 and immediately fell in love with it. Since then he’s been using it to build bases that are either targeted to support Design Operations, or as a tool to organise and analyse Building Data, Project Budgets, and Client Reporting.

Base Showcase – 00:29:32 –

We dive into a full working base that will Chris will showcase some bases he uses in his Architectural Practice

A Case for Interface – 00:49:54 –

Explore Interfaces with “Google Drive Interface”.

Kamille will showcase an interface to interact with her Google Drive files..

Full Segment Details

Segment: Round The Bases

Start Time: 00:03:32

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

Segment: Meet the Creators

Start Time: 00:18:53

Chris Zantis – Chris Zantis is a Registered Architect in the UK (ARB) and Cyprus (ETEK). He is a graduate of the Department of Architecture of the University of Cyprus and holds an MA in Enterpreneurship from Goldsmiths University of London. He has worked in several award-winning practices in London, participating in the design and delivery of a wide range of structures and spaces, such as Private Residences, Hotels, Skyscrapers, Commercial/Office Spaces, Manufacturing Facilities, Shopping Centres and Retail.

Meet Chris Zantis.

Chris Zantis is a Registered Architect in the UK (ARB) and Cyprus (ETEK). He is a graduate of the Department of Architecture of the University of Cyprus and holds an MA in Enterpreneurship from Goldsmiths University of London. He has worked in several award-winning practices in London, participating in the design and delivery of a wide range of structures and spaces, such as Private Residences, Hotels, Skyscrapers, Commercial/Office Spaces, Manufacturing Facilities, Shopping Centres and Retail.Since 2019, he has repatriated to Cyprus after several years working in London and is currently working as an Architect in Limassol. His current interest is the induction of innovative design technologies in the analysis, composition and organisation of Building Information.He discovered Airtable while working for back in 2017 and immediately fell in love with it. Since then he’s been using it to build bases that are either targeted to support Design Operations, or as a tool to organise and analyse Building Data, Project Budgets, and Client Reporting.

Segment: Base Showcase

Start Time: 00:29:32

Airtable for Architecture

We dive into a full working base that will Chris will showcase some bases he uses in his Architectural Practice

Segment: A Case for Interface

Start Time: 00:49:54

Google Drive Interface

Explore Interfaces with “Google Drive Interface”.

Kamille will showcase an interface to interact with her Google Drive files..

Full Transcription

The full transcription for the show can be found here:

1
00:00:01,540 --> 00:00:04,640
Welcome to the BuiltOnAir podcast.

2 00:00:04,840 —> 00:00:07,010 We are live for season 11,

3 00:00:07,010 —> 00:00:08,226 episode 12.

4 00:00:08,425 —> 00:00:10,924 Last show of season 11.

5 00:00:11,124 —> 00:00:13,640 It’s good to be with you.

6 00:00:13,640 —> 00:00:15,296 We’ve got a full show with us

7 00:00:15,496 —> 00:00:16,302 as you can see,

8 00:00:16,502 —> 00:00:17,808 we’ve got a full house today

9 00:00:17,940 —> 00:00:19,636 myself. Kamille and Alli

10 00:00:19,836 —> 00:00:21,262 the regulars with us.

11 00:00:21,462 —> 00:00:23,028 Welcome back. Welcome Alli,

12 00:00:23,340 —> 00:00:25,095 been a couple of weeks without you.

13 00:00:25,295 —> 00:00:26,295 Good to have you back.

14 00:00:26,830 —> 00:00:27,198 Glad to be back

15 00:00:28,040 —> 00:00:30,449 and we’ve got a special guest with us.

16 00:00:30,649 —> 00:00:32,288 Chris Zantis, welcome Chris,

17 00:00:32,740 —> 00:00:34,144 Thank you. Nice to be here.

18 00:00:34,344 —> 00:00:35,565 Good to have you with us.

19 00:00:35,765 —> 00:00:36,640 We’ll learn more about

20 00:00:36,640 —> 00:00:39,370 Chris and his story later in the show.

21 00:00:39,570 —> 00:00:42,100 So always good to have people with us.

22 00:00:42,100 —> 00:00:43,161 I’m gonna give us

23 00:00:43,361 —> 00:00:44,908 a little bit more room here,

24 00:00:45,540 —> 00:00:47,126 get rid of the branding

25 00:00:47,326 —> 00:00:49,505 that we can see everyone’s faces.

26 00:00:49,705 —> 00:00:50,705 There we go.

27 00:00:50,940 —> 00:00:53,995 And as always the BuiltOnAir podcast

28 00:00:54,195 —> 00:00:57,390 is an hour long show where we go through

29 00:00:57,390 —> 00:00:58,593 a couple different segments.

30 00:00:58,793 —> 00:00:59,583 I’ll walk us through

31 00:00:59,783 —> 00:01:00,570 what we’re gonna be doing

32 00:01:00,570 —> 00:01:00,938 today.

33 00:01:01,138 —> 00:01:02,582 We always start with our

34 00:01:02,782 —> 00:01:05,110 Round the Bases where we talk about what’s

35 00:01:05,110 —> 00:01:06,866 going on, keep you up to date

36 00:01:07,066 —> 00:01:09,408 in the Airtable communities and what’s new

37 00:01:09,440 —> 00:01:11,706 and then we will do a spotlight

38 00:01:11,906 —> 00:01:13,898 on our primary sponsor On2Air.

39 00:01:14,140 —> 00:01:16,204 Then we will learn about Chris

40 00:01:16,404 —> 00:01:17,261 and his story

41 00:01:17,461 —> 00:01:19,370 and how he found Airtable and

42 00:01:19,370 —> 00:01:20,914 then Chris will be doing

43 00:01:21,114 —> 00:01:21,793 a deep dive

44 00:01:21,993 —> 00:01:24,260 on some of his bases that he’s built and

45 00:01:24,260 —> 00:01:26,981 uses in his architecture firm

46 00:01:27,181 —> 00:01:29,191 and then a quick shout

47 00:01:29,391 —> 00:01:31,110 out to our BuiltOnAir

48 00:01:31,110 —> 00:01:31,908 community

49 00:01:32,140 —> 00:01:34,362 and then finally we will end

50 00:01:34,562 —> 00:01:35,560 with showcase

51 00:01:35,760 —> 00:01:38,170 A Case for Interface with Kamille,

52 00:01:38,170 —> 00:01:40,726 learning about how to integrate

53 00:01:40,926 —> 00:01:43,083 with google drive documents

54 00:01:43,283 —> 00:01:44,520 and that will wrap

55 00:01:44,520 —> 00:01:47,148 up our show and our season.

56 00:01:47,348 —> 00:01:50,750 So let’s start with Round the Bases,

57 00:01:50,750 —> 00:01:52,444 so not much going on

58 00:01:52,644 —> 00:01:55,408 a little bit quieter. Last week was

59 00:01:55,440 —> 00:01:58,052 jam packed with product announcements.

60 00:01:58,252 —> 00:02:00,940 This week will be a little bit lighter.

61 00:02:00,940 —> 00:02:02,228 I didn’t have as much to

62 00:02:02,428 —> 00:02:03,396 to share this week,

63 00:02:03,596 —> 00:02:05,180 but that’s good because we’ve got a

64 00:02:05,180 —> 00:02:06,905 lot of stuff to get to.

65 00:02:07,105 —> 00:02:09,680 So there were a couple announcements.

66 00:02:09,680 —> 00:02:11,741 New features, not big ones,

67 00:02:11,941 —> 00:02:13,263 these were kind of

68 00:02:13,463 —> 00:02:15,100 like hidden in the

69 00:02:15,100 —> 00:02:16,508 comment sections.

70 00:02:17,540 —> 00:02:18,034 So this

71 00:02:18,234 —> 00:02:21,038 did we talk about this last time Kamille?

72 00:02:21,238 —> 00:02:22,200 I can’t remember.

73 00:02:22,200 —> 00:02:24,417 No because it wasn’t there yet,

74 00:02:24,617 —> 00:02:27,420 I don’t think. So they in the new field

75 00:02:27,420 —> 00:02:28,915 manager before you could

76 00:02:29,115 —> 00:02:30,190 see the field type

77 00:02:30,390 —> 00:02:32,280 and description and permissions and

78 00:02:32,280 —> 00:02:33,815 stuff. And since then

79 00:02:34,015 —> 00:02:37,298 they have added in a column for field I.D.

80 00:02:37,440 —> 00:02:38,108 Which

81 00:02:38,140 —> 00:02:40,348 I was very happy about because

82 00:02:40,470 —> 00:02:42,340 it’s easy to get the field ids

83 00:02:42,540 —> 00:02:44,398 from a table if you’re scripting.

84 00:02:44,740 —> 00:02:45,436 And if you,

85 00:02:45,636 —> 00:02:47,464 I think you go through the api

86 00:02:47,664 —> 00:02:49,170 documentation for your base,

87 00:02:49,170 —> 00:02:50,518 you could also see it.

88 00:02:50,718 —> 00:02:52,070 But for the lay person,

89 00:02:52,270 —> 00:02:54,010 if you just want to get the field

90 00:02:54,010 —> 00:02:57,408 ID It was so difficult

91 00:02:57,740 —> 00:02:59,440 figure out what field was which

92 00:02:59,640 —> 00:03:01,030 like we can see your URL

93 00:03:01,030 —> 00:03:03,113 Right now and we can easily find

94 00:03:03,313 —> 00:03:04,204 the base ID

95 00:03:04,404 —> 00:03:05,272 The table ID

96 00:03:05,472 —> 00:03:06,314 the view ID

97 00:03:06,514 —> 00:03:07,666 and the record ID

98 00:03:07,866 —> 00:03:09,740 if you had a record expanded but you

99 00:03:09,740 —> 00:03:12,808 can’t see field IDs anywhere else

100 00:03:13,140 —> 00:03:14,614 except for you can now see it

101 00:03:14,814 —> 00:03:16,133 in the managed fields thing.

102 00:03:16,333 —> 00:03:17,140 That’s nice.

103 00:03:17,340 —> 00:03:19,351 Yeah I’m showing this here,

104 00:03:19,551 —> 00:03:21,138 I saw other people would

105 00:03:22,140 —> 00:03:22,712 use it.

106 00:03:22,912 —> 00:03:25,105 You could like find it in a

107 00:03:25,305 —> 00:03:28,190 well I guess that was for broken ones.

108 00:03:28,190 —> 00:03:29,062 I thought there was

109 00:03:29,262 —> 00:03:30,122 there was like a way

110 00:03:30,322 —> 00:03:31,540 where you could like fake it in a

111 00:03:31,540 —> 00:03:32,964 formula to like figure out

112 00:03:33,164 —> 00:03:34,990 what the field ID was or something.

113 00:03:34,990 —> 00:03:36,798 But

114 00:03:37,240 —> 00:03:39,735 so yeah this is much easier to use.

115 00:03:39,935 —> 00:03:42,730 Very very useful. Yeah I had a script that

116 00:03:42,730 —> 00:03:44,184 would generate all the fields

117 00:03:44,384 —> 00:03:45,040 and everything

118 00:03:45,240 —> 00:03:46,540 that I had before and don’t need

119 00:03:46,540 —> 00:03:48,298 that anymore.

120 00:03:49,840 —> 00:03:51,119 So that is a cool feature

121 00:03:51,319 —> 00:03:52,284 but it wasn’t really

122 00:03:52,484 —> 00:03:53,780 yeah it was just kind of hidden

123 00:03:53,780 —> 00:03:55,955 in the existing thread.

124 00:03:56,155 —> 00:03:59,760 Talking about the new based navigation.

125 00:03:59,760 —> 00:04:01,331 So that is very useful

126 00:04:01,531 —> 00:04:02,287 and if it’s

127 00:04:02,487 —> 00:04:04,830 if you don’t see it there’s a toggle.

128 00:04:04,830 —> 00:04:07,308 I didn’t realize this at first. But

129 00:04:07,640 —> 00:04:09,341 back in the managed fields

130 00:04:09,541 —> 00:04:12,480 right here, this icon right here this is

131 00:04:12,480 —> 00:04:14,964 actually a button that you can press

132 00:04:15,164 —> 00:04:17,310 to determine which fields you want

133 00:04:17,310 —> 00:04:18,098 displayed.

134 00:04:18,540 —> 00:04:19,911 And so that’s useful so

135 00:04:20,111 —> 00:04:21,423 if you’re not seeing it

136 00:04:21,623 —> 00:04:23,190 then you might need to check it

137 00:04:23,190 —> 00:04:25,518 in here to make sure it displays

138 00:04:25,530 —> 00:04:28,398 but I think it displays by default.

139 00:04:29,040 —> 00:04:29,926 I think so too.

140 00:04:30,126 —> 00:04:31,713 I think one other thing that

141 00:04:31,913 —> 00:04:33,470 I’ve seen a couple of people

142 00:04:33,470 —> 00:04:35,309 discover and like be surprised about

143 00:04:35,509 —> 00:04:37,250 is if you actually click on one of the

144 00:04:37,250 —> 00:04:40,008 column headers you can sort by that column

145 00:04:40,840 —> 00:04:41,908 not the field ID

146 00:04:42,250 —> 00:04:42,968 apparently not the field ID

147 00:04:43,520 —> 00:04:47,808 I mean you’d never need to. Right,

148 00:04:48,340 —> 00:04:49,598 field type

149 00:04:50,360 —> 00:04:52,788 the most relevant. Yeah.

150 00:04:54,040 —> 00:04:55,175 Right. Yeah you can’t see a

151 00:04:55,375 —> 00:04:56,543 situation where you’d actually

152 00:04:56,743 —> 00:04:57,360 want to sort by field

153 00:04:57,360 —> 00:04:58,108 ID

154 00:04:58,540 —> 00:04:59,808 Yeah. Yeah

155 00:05:00,440 —> 00:05:03,017 that’s funny. Or the dependency you can

156 00:05:03,217 —> 00:05:05,000 so you can see which ones have

157 00:05:05,000 —> 00:05:05,978 dependencies

158 00:05:07,110 —> 00:05:09,208 so it doesn’t even sort by value

159 00:05:10,740 —> 00:05:13,123 like your most dependent

160 00:05:13,323 —> 00:05:15,308 field basically. Yeah.

161 00:05:16,540 —> 00:05:18,262 Yeah cool. So yeah

162 00:05:18,462 —> 00:05:20,152 definitely useful.

163 00:05:20,352 —> 00:05:21,834 Check that out.

164 00:05:22,034 —> 00:05:23,908 There was one more

165 00:05:23,940 —> 00:05:25,765 So this is also another one

166 00:05:25,965 —> 00:05:26,937 that was hidden

167 00:05:27,137 —> 00:05:29,010 at the bottom of another thread.

168 00:05:29,010 —> 00:05:31,091 I think there’s another thread

169 00:05:31,291 —> 00:05:32,756 that talks about this.

170 00:05:32,956 —> 00:05:34,420 So now if you’re using

171 00:05:34,420 —> 00:05:35,939 URL Parameters

172 00:05:36,139 —> 00:05:37,698 in your Airtable forms

173 00:05:38,040 —> 00:05:40,948 before you had to use pre fill

174 00:05:41,148 —> 00:05:44,340 underscore and then the field name.

175 00:05:44,340 —> 00:05:48,198 But now you can use the field ID

176 00:05:48,540 —> 00:05:49,888 Which is useful.

177 00:05:51,140 —> 00:05:52,283 That’s super useful.

178 00:05:52,483 —> 00:05:54,398 That means if you want to change your

179 00:05:54,940 —> 00:05:56,269 field names you don’t have to

180 00:05:56,469 —> 00:05:58,148 worry about finding all the formulas that

181 00:05:58,280 —> 00:05:58,620 reference

182 00:05:58,820 —> 00:06:00,303 it because it’s not like it’s referencing,

183 00:06:00,503 —> 00:06:01,150 well it probably is also

184 00:06:01,150 —> 00:06:02,998 referencing the field itself but

185 00:06:03,940 —> 00:06:05,761 like if the field name is typed out

186 00:06:05,961 —> 00:06:07,030 and then you delete it

187 00:06:07,230 —> 00:06:08,050 then you’re not gonna

188 00:06:08,050 —> 00:06:10,438 know that it’s broken if that makes sense

189 00:06:13,040 —> 00:06:15,084 And you know you might have spaces

190 00:06:15,284 —> 00:06:16,309 in your field name

191 00:06:16,509 —> 00:06:17,790 you have to go and make it

192 00:06:17,790 —> 00:06:20,108 so it’s encoded

193 00:06:20,440 —> 00:06:21,986 all that kind of stuff

194 00:06:22,186 —> 00:06:24,563 and you know this isn’t necessarily

195 00:06:24,763 —> 00:06:25,990 fool proof but if you

196 00:06:25,990 —> 00:06:28,024 wanted to discourage people

197 00:06:28,224 —> 00:06:30,553 from changing a pre filled value

198 00:06:30,753 —> 00:06:31,790 if you can see in

199 00:06:31,790 —> 00:06:32,508 the

200 00:06:33,240 —> 00:06:34,522 URL of the former

201 00:06:34,722 —> 00:06:36,408 just given that says like

202 00:06:36,740 —> 00:06:40,598 you know pricing tier, Ultra or whatever,

203 00:06:41,040 —> 00:06:42,270 someone could see that

204 00:06:42,470 —> 00:06:43,748 and go well I don’t want

205 00:06:43,948 —> 00:06:45,400 I don’t want my pricing tier to

206 00:06:45,400 —> 00:06:46,887 be Ultra. I want it to be

207 00:06:47,087 —> 00:06:48,040 you know minimal.

208 00:06:48,240 —> 00:06:50,134 If they’re just seeing

209 00:06:50,334 —> 00:06:52,675 random field ID Equals Ultra

210 00:06:52,875 —> 00:06:54,180 you’re going to be

211 00:06:54,180 —> 00:06:56,814 less likely to you know suss out exactly

212 00:06:57,014 —> 00:06:59,250 what information you’re trying to put

213 00:06:59,250 —> 00:06:59,708 in there.

214 00:07:00,040 —> 00:07:00,498 Yeah.

215 00:07:01,140 —> 00:07:02,513 Do you still have to

216 00:07:02,713 —> 00:07:04,235 put pre fill underscore

217 00:07:04,435 —> 00:07:06,220 in front of it if you’re using

218 00:07:06,220 —> 00:07:06,624 field ID?

219 00:07:06,824 —> 00:07:07,460 Probably.

220 00:07:07,660 —> 00:07:10,908 Yeah. Yeah I haven’t actually tested that.

221 00:07:11,540 —> 00:07:13,242 Well I guess they’re saying

222 00:07:13,442 —> 00:07:15,577 they will update the article soon

223 00:07:15,777 —> 00:07:16,330 so it might not

224 00:07:16,330 —> 00:07:17,198 be updated.

225 00:07:19,740 —> 00:07:22,308 I think you still have to do it to get the

226 00:07:22,940 —> 00:07:26,498 query parameter to register.

227 00:07:28,140 —> 00:07:28,688 Yeah

228 00:07:32,240 —> 00:07:33,538 it looks like

229 00:07:34,340 —> 00:07:35,414 it’s actually a good article.

230 00:07:35,614 —> 00:07:36,414 I haven’t seen this one.

231 00:07:36,614 —> 00:07:37,080 It’s actually pretty

232 00:07:37,080 —> 00:07:37,808 detailed.

233 00:07:38,330 —> 00:07:39,508 That’s super helpful.

234 00:07:41,140 —> 00:07:42,748 Yeah it looks like they don’t

235 00:07:44,640 —> 00:07:47,786 They’ve even got a shout out to

236 00:07:47,986 —> 00:07:49,308 Kuovonne’s app.

237 00:07:51,240 —> 00:07:52,098 That’s nice.

238 00:07:52,940 —> 00:07:54,594 So yeah it doesn’t say yet

239 00:07:54,794 —> 00:07:56,325 but I’m assuming yeah

240 00:07:56,525 —> 00:07:58,730 you still say pre fill underscore

241 00:07:58,730 —> 00:07:59,621 and then the

242 00:07:59,821 —> 00:08:01,913 we have a comment from Justin

243 00:08:02,113 —> 00:08:04,150 that clarifies that it is still

244 00:08:04,150 —> 00:08:06,608 necessary. Thank you Justin

245 00:08:08,640 —> 00:08:10,427 cool so yeah that’s useful

246 00:08:10,627 —> 00:08:12,071 like you all mentioned

247 00:08:12,271 —> 00:08:13,450 to lock it in and you

248 00:08:13,450 —> 00:08:16,022 don’t have to especially if you’re

249 00:08:16,222 —> 00:08:19,200 sharing your form out in the world and

250 00:08:19,200 —> 00:08:21,154 linking to it from different websites.

251 00:08:21,354 —> 00:08:23,210 If you ever change your field names then

252 00:08:23,210 —> 00:08:24,736 you can’t, it’s hard to go back

253 00:08:24,936 —> 00:08:26,508 and find all the places where that’s

254 00:08:26,770 —> 00:08:27,291 linked to

255 00:08:27,491 —> 00:08:29,606 so you don’t have to worry about that.

256 00:08:29,806 —> 00:08:30,998 So useful in that regard.

257 00:08:32,840 —> 00:08:33,878 Alright last one

258 00:08:34,078 —> 00:08:36,539 this comes from our BuiltOnAir community,

259 00:08:36,539 —> 00:08:37,714 a fun little game

260 00:08:37,914 —> 00:08:40,121 so start thinking so Hannah poses

261 00:08:40,321 —> 00:08:41,860 the question how would you

262 00:08:41,860 —> 00:08:44,708 describe Airtable in three words?

263 00:08:44,840 —> 00:08:46,427 So there’s some good commentary.

264 00:08:46,627 —> 00:08:47,319 I’ll read these

265 00:08:47,519 —> 00:08:48,610 while you’re all thinking of

266 00:08:48,610 —> 00:08:50,437 how you would describe it.

267 00:08:50,637 —> 00:08:53,108 People said organize everything easily

268 00:08:53,240 —> 00:08:55,738 spreadsheets become databases.

269 00:08:56,140 —> 00:08:59,006 Rebecca is not able to share her

270 00:08:59,206 —> 00:09:02,410 three words. Might not be appropriate.

271 00:09:02,410 —> 00:09:04,796 Powerful, always evolving.

272 00:09:04,996 —> 00:09:07,678 Supercharge your spreadsheets.

273 00:09:07,878 —> 00:09:09,108 No loco database

274 00:09:09,540 —> 00:09:10,778 data gone wild

275 00:09:10,978 —> 00:09:14,138 from Justin joining us. Data your way.

276 00:09:14,160 —> 00:09:16,208 Red, yellow, blue

277 00:09:16,540 —> 00:09:20,508 Bill French is very literal

278 00:09:21,040 —> 00:09:23,597 expanded my career.

279 00:09:23,797 —> 00:09:26,318 That’s kind of cool

280 00:09:26,518 —> 00:09:28,308 legos but work.

281 00:09:28,840 —> 00:09:31,285 Yeah Foundation to functions.

282 00:09:31,485 —> 00:09:33,308 The last one from Leona.

283 00:09:34,180 —> 00:09:35,198 Any others?

284 00:09:38,040 —> 00:09:39,949 I’m not a tagline person.

285 00:09:40,149 —> 00:09:41,728 I’m a long protracted

286 00:09:41,928 —> 00:09:43,308 metaphor kind of gal.

287 00:09:43,640 —> 00:09:46,693 It’s like all your base are

288 00:09:46,893 —> 00:09:50,990 belong to us. Yeah. Base belong us.

289 00:09:50,990 —> 00:09:52,926 There you go.

290 00:09:53,126 —> 00:09:56,648 BuiltOnAir. There you go.

291 00:09:58,740 —> 00:10:00,308 Yeah

292 00:10:00,640 —> 00:10:01,835 kind of fun game.

293 00:10:02,035 —> 00:10:03,051 We usually yeah

294 00:10:03,251 —> 00:10:05,490 Hannah’s good about posting some fun

295 00:10:05,490 —> 00:10:08,245 activities in the BuiltOnAir community

296 00:10:08,445 —> 00:10:10,420 always enjoy participation.

297 00:10:10,420 —> 00:10:11,625 So fun way to

298 00:10:11,825 —> 00:10:12,785 to wrap up

299 00:10:12,985 —> 00:10:13,919 any other,

300 00:10:14,119 —> 00:10:16,910 was there anything I missed this

301 00:10:16,910 —> 00:10:18,511 week? Anything else interesting

302 00:10:18,711 —> 00:10:20,008 happening in the communities?

303 00:10:20,540 —> 00:10:22,298 Not that I recall

304 00:10:25,440 —> 00:10:27,397 side notes, I saw that they

305 00:10:27,597 —> 00:10:29,498 extended the deadline for the

306 00:10:30,020 —> 00:10:31,808 Interface competition.

307 00:10:34,020 —> 00:10:34,828 I didn’t know that

308 00:10:35,350 —> 00:10:37,208 it was it was hidden in the comments.

309 00:10:37,540 —> 00:10:39,064 Yeah, when they

310 00:10:39,264 —> 00:10:41,908 when they announced the form

311 00:10:42,340 —> 00:10:43,556 element or page type

312 00:10:43,756 —> 00:10:45,271 or whatever for Interfaces

313 00:10:45,471 —> 00:10:46,960 extended the deadline because

314 00:10:46,960 —> 00:10:47,619 it’s you know,

315 00:10:47,819 —> 00:10:49,205 obviously something that people

316 00:10:49,405 —> 00:10:50,680 would probably want to include in

317 00:10:50,680 —> 00:10:53,608 their competition entry.

318 00:10:54,040 —> 00:10:55,457 Yeah, that’s a good

319 00:10:55,658 —> 00:10:57,901 Also if anybody is planning to,

320 00:10:58,101 —> 00:10:59,710 there actually is a group

321 00:10:59,710 —> 00:11:01,848 somewhere in the BuiltOnAir community

322 00:11:02,048 —> 00:11:04,160 of people that are gonna help each other

323 00:11:04,160 —> 00:11:04,932 review. So

324 00:11:05,132 —> 00:11:07,393 if you’re looking for feedback

325 00:11:07,593 —> 00:11:10,030 on yours before submitting, check

326 00:11:10,030 —> 00:11:12,536 out in the slack community for BuiltOnAir,

327 00:11:12,736 —> 00:11:13,908 there’s people that are

328 00:11:14,340 —> 00:11:17,508 helping each other out with that. So

329 00:11:17,940 —> 00:11:20,461 the other thing I was gonna mention also

330 00:11:20,661 —> 00:11:22,540 I saw there’s a lot of discussion

331 00:11:22,540 —> 00:11:26,005 about what’s included in the Interface,

332 00:11:26,205 —> 00:11:28,670 like what’s being judged?

333 00:11:28,670 —> 00:11:30,357 You know, especially like

334 00:11:30,558 —> 00:11:32,581 what if you’re using automations

335 00:11:32,781 —> 00:11:33,530 as part of your

336 00:11:33,530 —> 00:11:35,208 Interface? It sounds like

337 00:11:35,940 —> 00:11:38,038 they will incorporate

338 00:11:38,190 —> 00:11:41,052 automations as part of their evaluation

339 00:11:41,252 —> 00:11:44,060 for your Interface. There wasn’t a lot

340 00:11:44,060 —> 00:11:45,154 of clarification,

341 00:11:45,354 —> 00:11:47,598 more questions than clarification, but

342 00:11:47,940 —> 00:11:49,718 yeah, it’s

343 00:11:50,940 —> 00:11:54,198 from my reading of that thread, it

344 00:11:54,830 —> 00:11:56,386 someone pointed out.

345 00:11:56,586 —> 00:11:58,211 I think it was Kuovonne,

346 00:11:58,411 —> 00:11:59,498 that before, if you

347 00:12:00,140 —> 00:12:03,374 added a base to the Airtable universe,

348 00:12:03,574 —> 00:12:06,098 automations didn’t carry over.

349 00:12:06,440 —> 00:12:07,228 And

350 00:12:07,270 —> 00:12:09,115 she was asking well if the Interfaces

351 00:12:09,315 —> 00:12:11,010 that we’re submitting are dependent on

352 00:12:11,010 —> 00:12:12,684 automations, how does that work?

353 00:12:12,884 —> 00:12:14,109 And then some time passed

354 00:12:14,309 —> 00:12:15,090 and then Jordan came

355 00:12:15,090 —> 00:12:15,998 in and said

356 00:12:16,440 —> 00:12:18,692 automations will be there.

357 00:12:18,892 —> 00:12:20,913 So I haven’t tested this

358 00:12:21,113 —> 00:12:22,850 myself but it sounds to

359 00:12:22,850 —> 00:12:24,961 me like that has been fixed

360 00:12:25,161 —> 00:12:28,400 for the universe that they now carry over

361 00:12:28,400 —> 00:12:29,842 automations, I think

362 00:12:30,043 —> 00:12:32,071 either that or they obviously

363 00:12:32,271 —> 00:12:34,170 have a way where they can pull

364 00:12:34,170 —> 00:12:35,708 in the automations

365 00:12:35,740 —> 00:12:37,082 or duplicate the base

366 00:12:37,282 —> 00:12:39,309 because when you duplicate a base

367 00:12:39,509 —> 00:12:40,598 it does include them.

368 00:12:40,740 —> 00:12:42,654 Yeah so they might just

369 00:12:42,854 —> 00:12:44,545 have a back end where

370 00:12:44,745 —> 00:12:46,398 they duplicate the base

371 00:12:47,340 —> 00:12:48,206 Hopefully because yeah

372 00:12:48,406 —> 00:12:49,406 that is a really good point.

373 00:12:51,840 —> 00:12:53,692 One other thing I saw this week,

374 00:12:53,892 —> 00:12:55,199 I don’t know if you guys

375 00:12:55,399 —> 00:12:56,180 maybe pulled it up

376 00:12:56,180 —> 00:12:58,088 last week or when it was released

377 00:12:58,288 —> 00:12:59,598 but an Airtable employee

378 00:12:59,798 —> 00:13:00,690 on linkedin shared a

379 00:13:00,690 —> 00:13:01,838 super super cute

380 00:13:02,038 —> 00:13:04,548 new commercial with like little kids

381 00:13:04,748 —> 00:13:06,360 pretending to be directors

382 00:13:06,360 —> 00:13:07,495 of like a movie.

383 00:13:07,695 —> 00:13:08,863 It’s really cute.

384 00:13:09,063 —> 00:13:11,750 Like I would highly recommend watching it.

385 00:13:11,750 —> 00:13:12,814 I don’t know if it’s worth

386 00:13:13,014 —> 00:13:13,550 pulling it up now,

387 00:13:13,750 —> 00:13:14,910 it’s pretty long but definitely go

388 00:13:14,910 —> 00:13:16,008 check that out. It’s

389 00:13:16,340 —> 00:13:17,108 really funny.

390 00:13:17,440 —> 00:13:19,660 I think if it’s the one I’m thinking of

391 00:13:19,860 —> 00:13:21,710 there’s one that’s been around for a

392 00:13:21,710 —> 00:13:23,181 couple of years,

393 00:13:23,381 —> 00:13:26,398 was it like outside like in a yard?

394 00:13:26,840 —> 00:13:28,103 I’m not sure if it was,

395 00:13:28,303 —> 00:13:30,410 if it’s a couple of years old then my bad,

396 00:13:30,410 —> 00:13:31,947 but I don’t know, I saw it.

397 00:13:32,147 —> 00:13:33,940 I thought it was really cute. Yeah,

398 00:13:33,940 —> 00:13:35,897 maybe. I don’t know.

399 00:13:36,097 —> 00:13:39,908 Okay, we’ll look for that and share that.

400 00:13:40,340 —> 00:13:43,796 Very good. So that concludes

401 00:13:43,996 —> 00:13:46,360 our Round the Bases

402 00:13:46,560 —> 00:13:49,720 next quick plug for On2Air,

403 00:13:49,720 —> 00:13:51,098 our primary sponsor.

404 00:13:51,440 —> 00:13:52,219 Jan just

405 00:13:52,419 —> 00:13:55,663 Jan mentions he doesn’t think it’s

406 00:13:55,863 —> 00:13:57,380 it’s new. Yeah,

407 00:13:57,380 —> 00:13:58,445 so there was one

408 00:13:58,645 —> 00:14:00,376 early in Airtable about that,

409 00:14:00,576 —> 00:14:02,200 so, but still worth checking

410 00:14:02,200 —> 00:14:03,808 out if you haven’t seen it.

411 00:14:04,740 —> 00:14:06,655 So On2Air’s an all in one toolkit

412 00:14:06,855 —> 00:14:08,570 to run your business on Airtable.

413 00:14:08,570 —> 00:14:10,066 It’s a suite of apps

414 00:14:10,266 —> 00:14:11,282 and extensions

415 00:14:11,482 —> 00:14:14,330 that enable businesses to really take full

416 00:14:14,330 —> 00:14:15,912 advantage of Airtable.

417 00:14:16,112 —> 00:14:17,518 We provide a lot of

418 00:14:17,718 —> 00:14:19,220 different things. Today,

419 00:14:19,220 —> 00:14:21,772 I’m continuing with our highlight

420 00:14:21,972 —> 00:14:23,386 of our soon to come

421 00:14:23,586 —> 00:14:25,098 soon to release in beta

422 00:14:25,240 —> 00:14:27,401 standalone forms product.

423 00:14:27,601 —> 00:14:30,293 So we have a forms integration

424 00:14:30,493 —> 00:14:31,550 with jot form,

425 00:14:31,550 —> 00:14:33,322 a third party form solution.

426 00:14:33,522 —> 00:14:34,605 We’ve been working

427 00:14:34,805 —> 00:14:36,170 for months on a standalone

428 00:14:36,170 —> 00:14:38,949 version that will be a game changer

429 00:14:39,149 —> 00:14:41,490 for your Airtable form solution.

430 00:14:41,490 —> 00:14:43,146 This is hopefully

431 00:14:43,346 —> 00:14:46,403 we will be live at least in beta

432 00:14:46,603 —> 00:14:48,600 before we come back for

433 00:14:48,600 —> 00:14:49,498 next season.

434 00:14:49,740 —> 00:14:51,960 That’s our goal is to launch in August,

435 00:14:52,160 —> 00:14:54,180 there’s always a lot of last things to,

436 00:14:54,180 —> 00:14:55,727 to wrap up before then,

437 00:14:55,927 —> 00:14:57,484 but we’re getting close.

438 00:14:57,684 —> 00:14:59,560 So I just wanted to showcase.

439 00:14:59,560 —> 00:15:01,515 So with this form solution

440 00:15:01,715 —> 00:15:03,678 you’ll be able to determine

441 00:15:03,878 —> 00:15:05,350 how you want to use it.

442 00:15:05,350 —> 00:15:07,168 You can use it just for

443 00:15:07,368 —> 00:15:08,749 creating new records

444 00:15:08,949 —> 00:15:10,990 or just for updating existing

445 00:15:10,990 —> 00:15:11,708 records.

446 00:15:11,740 —> 00:15:14,208 Or be able to use the same form

447 00:15:14,408 —> 00:15:16,102 for either or creating

448 00:15:16,302 —> 00:15:17,950 a new record or updating

449 00:15:17,950 —> 00:15:19,465 an existing record

450 00:15:19,665 —> 00:15:22,365 in the database in the table.

451 00:15:22,565 —> 00:15:24,600 And once you select that

452 00:15:24,600 —> 00:15:25,898 it will determine

453 00:15:26,098 —> 00:15:28,798 it will have the configuration for it.

454 00:15:28,940 —> 00:15:31,396 And one of the cool features

455 00:15:31,596 —> 00:15:35,430 that we’ve been experimenting with is the

456 00:15:35,430 —> 00:15:37,861 ability to default your values

457 00:15:38,061 —> 00:15:40,494 based off of an existing record

458 00:15:40,694 —> 00:15:41,750 in the database.

459 00:15:41,750 —> 00:15:42,947 So you can specify

460 00:15:43,147 —> 00:15:45,334 when you’re creating a new record,

461 00:15:45,534 —> 00:15:47,070 you can specify a record ID

462 00:15:47,070 —> 00:15:49,579 to use as the default values

463 00:15:49,779 —> 00:15:51,908 to insert into a new form.

464 00:15:52,340 —> 00:15:54,819 Or you can even dynamically

465 00:15:55,019 —> 00:15:57,940 do that where you can pass in a URL

466 00:15:57,940 —> 00:16:00,068 parameter with the record ID

467 00:16:00,268 —> 00:16:03,260 Of the record that you want to use as your

468 00:16:03,260 —> 00:16:04,577 default values.

469 00:16:04,777 —> 00:16:07,298 So that’s an option as well.

470 00:16:07,340 —> 00:16:09,966 Or if you’re updating an existing record

471 00:16:10,166 —> 00:16:12,330 you can specify how you want to find

472 00:16:12,330 —> 00:16:15,081 that record that you want to update.

473 00:16:15,281 —> 00:16:17,908 The default would be to just pass the

474 00:16:18,240 —> 00:16:20,304 the record ID As a parameter

475 00:16:20,504 —> 00:16:22,804 in the URL Like slash record ID

476 00:16:23,004 —> 00:16:24,232 in the form URL

477 00:16:24,432 —> 00:16:27,180 or you can match on a URL Parameter.

478 00:16:27,180 —> 00:16:28,736 So if you have some other

479 00:16:28,936 —> 00:16:31,100 unique identify rare to find a record,

480 00:16:31,100 —> 00:16:33,614 you can specify what field

481 00:16:33,814 —> 00:16:36,998 to match it with the URL Parameter.

482 00:16:37,240 —> 00:16:39,159 And so very advanced ways

483 00:16:39,359 —> 00:16:41,288 to update existing records

484 00:16:41,488 —> 00:16:42,920 or create new records.

485 00:16:42,920 —> 00:16:44,991 Just one small feature that

486 00:16:45,191 —> 00:16:46,822 that will be available

487 00:16:47,022 —> 00:16:48,750 in the form solution along

488 00:16:48,750 —> 00:16:49,777 with many others.

489 00:16:49,977 —> 00:16:51,366 Some we’ve already shown

490 00:16:51,566 —> 00:16:53,160 many that we haven’t shown yet.

491 00:16:53,160 —> 00:16:54,542 So very excited to

492 00:16:54,742 —> 00:16:56,754 this has been a lot of work

493 00:16:56,954 —> 00:16:58,840 and very excited to get this

494 00:16:58,840 —> 00:17:00,708 out there live and get people using it.

495 00:17:00,840 —> 00:17:02,160 So coming soon.

496 00:17:02,360 —> 00:17:04,718 Hopefully this month in August.

497 00:17:07,339 —> 00:17:09,252 All right let’s move on

498 00:17:09,452 —> 00:17:11,067 to meet the creators

499 00:17:11,267 —> 00:17:13,328 and our friend Chris with us

500 00:17:13,690 —> 00:17:16,358 Alli, you wanna learn about Chris?

501 00:17:16,380 —> 00:17:18,070 Absolutely. And my neighbor

502 00:17:18,270 —> 00:17:20,184 decided right now is a good time

503 00:17:20,384 —> 00:17:21,200 to go use the saw

504 00:17:21,200 —> 00:17:22,538 in his driveway. So

505 00:17:22,599 —> 00:17:25,948 I apologize if you can hear that.

506 00:17:26,849 —> 00:17:27,598 Good.

507 00:17:27,839 —> 00:17:30,284 Excellent Chris. Welcome.

508 00:17:30,484 —> 00:17:33,708 Very great to have you on the show.

509 00:17:34,640 —> 00:17:35,448 Thank you.

510 00:17:35,460 —> 00:17:37,048 Thank you very much.

511 00:17:37,170 —> 00:17:40,508 Super exciting. So you are an architect?

512 00:17:40,940 —> 00:17:43,030 Yes. Not data, not software

513 00:17:43,230 —> 00:17:46,280 actual buildings. Right, actual buildings.

514 00:17:46,280 —> 00:17:47,308 So that’s actually

515 00:17:47,508 —> 00:17:48,735 an interesting crossover.

516 00:17:48,935 —> 00:17:50,520 So are you building your

517 00:17:50,520 —> 00:17:51,090 bases too?

518 00:17:51,290 —> 00:17:52,381 Like are you the one

519 00:17:52,581 —> 00:17:54,398 that’s the one building the database?

520 00:17:54,740 —> 00:17:55,508 Yes.

521 00:17:57,160 —> 00:17:57,278 I’m

522 00:17:57,540 —> 00:18:00,208 gonna throw in before

523 00:18:00,540 —> 00:18:01,629 we get too far in.

524 00:18:01,829 —> 00:18:03,224 I mentioned all the time

525 00:18:03,424 —> 00:18:05,200 that I’m actually an urban planner

526 00:18:05,200 —> 00:18:07,193 and I work at an architecture firm,

527 00:18:07,393 —> 00:18:07,959 on the mug

528 00:18:08,159 —> 00:18:09,830 I’ve been drinking from literally

529 00:18:09,830 —> 00:18:13,508 says architecture. First word in there.

530 00:18:14,340 —> 00:18:16,848 That’s the theme of the day.

531 00:18:17,740 —> 00:18:19,613 That’s perfect. Well excellent.

532 00:18:19,813 —> 00:18:22,030 How did you get started? And how did you

533 00:18:22,030 —> 00:18:23,908 discover Airtable along the way?

534 00:18:24,540 —> 00:18:25,098 Well,

535 00:18:25,540 —> 00:18:27,921 in a different timeline,

536 00:18:28,121 —> 00:18:31,913 I was going to go into computer science

537 00:18:32,113 —> 00:18:33,080 and software

538 00:18:33,080 —> 00:18:33,598 developing,

539 00:18:34,240 —> 00:18:36,094 But my dad managed to get me

540 00:18:36,294 —> 00:18:38,835 a salary job at an architecture practice

541 00:18:39,035 —> 00:18:39,470 when I was

542 00:18:39,470 —> 00:18:42,045 like 15 and I caught the bug,

543 00:18:42,245 —> 00:18:43,725 so there you go,

544 00:18:43,925 —> 00:18:46,130 so I still have the coding

545 00:18:46,130 —> 00:18:47,863 skills but don’t use them

546 00:18:48,063 —> 00:18:50,220 far from like scripting in design

547 00:18:50,220 —> 00:18:53,098 software. Now,

548 00:18:53,440 —> 00:18:59,268 fast forward to 2017. I was working in

549 00:18:59,310 —> 00:19:01,733 the works European Division,

550 00:19:01,933 —> 00:19:04,445 so we’re doing the buildings

551 00:19:04,645 —> 00:19:06,060 here in Europe and

552 00:19:06,060 —> 00:19:08,825 we did have already set up

553 00:19:09,025 —> 00:19:11,908 a number of bases in Airtable

554 00:19:12,140 —> 00:19:13,110 and we were required

555 00:19:13,310 —> 00:19:14,178 to use them as part of

556 00:19:14,340 —> 00:19:14,808 work,

557 00:19:15,440 —> 00:19:17,825 and then I’m like, oh wow,

558 00:19:18,025 —> 00:19:20,709 there’s so much potential here

559 00:19:20,909 —> 00:19:22,320 to utilize this in

560 00:19:22,320 —> 00:19:24,308 ways that we’re actually not using it.

561 00:19:24,840 —> 00:19:25,561 So yeah,

562 00:19:25,761 —> 00:19:28,718 that’s where it kind of started and

563 00:19:29,040 —> 00:19:30,140 it was super useful

564 00:19:30,340 —> 00:19:32,108 when I started using it to kind of

565 00:19:32,840 —> 00:19:35,318 data mine our buildings.

566 00:19:35,740 —> 00:19:38,676 So using that in a way where

567 00:19:38,876 —> 00:19:42,660 it wasn’t kind of intended to be used.

568 00:19:42,660 —> 00:19:45,706 So yeah, it was super interesting

569 00:19:45,906 —> 00:19:48,290 and then I moved back

570 00:19:48,290 —> 00:19:50,508 I just never stopped using it.

571 00:19:51,740 —> 00:19:53,108 Excellent. Yeah, it’s funny,

572 00:19:53,308 —> 00:19:54,360 I think a lot of people

573 00:19:54,560 —> 00:19:55,550 kind of start out using it

574 00:19:55,550 —> 00:19:57,116 just because it is so flexible,

575 00:19:57,316 —> 00:19:58,357 you can use it however

576 00:19:58,557 —> 00:19:59,540 you want and like there’s

577 00:19:59,540 —> 00:20:01,722 really like no right way to do it.

578 00:20:01,922 —> 00:20:04,290 If it’s gonna work for you then it works

579 00:20:04,290 —> 00:20:05,899 right? That’s what I love about it.

580 00:20:06,099 —> 00:20:07,099 It’s super flexible.

581 00:20:07,840 —> 00:20:08,388 Yeah.

582 00:20:08,940 —> 00:20:10,242 So what kind of projects

583 00:20:10,442 —> 00:20:11,598 are you using it for now?

584 00:20:12,740 —> 00:20:14,498 So we’ve got like

585 00:20:15,140 —> 00:20:16,018 I keep coming up with

586 00:20:16,218 —> 00:20:17,075 different applications

587 00:20:17,275 —> 00:20:18,400 like we can use it for this we can

588 00:20:18,400 —> 00:20:19,001 use it for this,

589 00:20:19,201 —> 00:20:19,967 we can use it for this

590 00:20:20,167 —> 00:20:21,290 like we can use it for our operations,

591 00:20:21,290 —> 00:20:23,682 we can use it for projects.

592 00:20:23,882 —> 00:20:25,264 So for budgeting

593 00:20:25,464 —> 00:20:28,200 and taking quantities directly off

594 00:20:28,200 —> 00:20:30,247 of software and stuff like that.

595 00:20:30,447 —> 00:20:31,666 We use it to kind of

596 00:20:31,866 —> 00:20:33,190 like benchmark our briefs

597 00:20:33,190 —> 00:20:34,598 from the clients to make sure like

598 00:20:34,640 —> 00:20:35,908 are we actually

599 00:20:35,940 —> 00:20:38,552 designing too brief and things like that?

600 00:20:38,752 —> 00:20:40,910 I’ve got something to show and we can

601 00:20:40,910 —> 00:20:43,094 go through it in a bit.

602 00:20:43,294 —> 00:20:46,608 But generally speaking it’s more of a

603 00:20:47,040 —> 00:20:49,797 hey like we’ve got a problem,

604 00:20:49,997 —> 00:20:51,318 a design problem

605 00:20:51,640 —> 00:20:53,896 but it requires us to validate data.

606 00:20:54,096 —> 00:20:55,096 How do we do it?

607 00:20:55,340 —> 00:20:56,937 So it’s usually sometimes

608 00:20:57,137 —> 00:20:59,108 it’s something that’s more kind of

609 00:21:00,040 —> 00:21:02,098 holistic so you can

610 00:21:02,540 —> 00:21:04,255 use it for a lot of things

611 00:21:04,455 —> 00:21:06,039 or is sometimes it’s like

612 00:21:06,239 —> 00:21:07,750 a very very specific way to

613 00:21:07,750 —> 00:21:09,603 look one base for one thing

614 00:21:09,803 —> 00:21:10,986 and it just solves

615 00:21:11,186 —> 00:21:12,760 one specific problem and it

616 00:21:12,760 —> 00:21:13,717 doesn’t necessarily mean

617 00:21:13,917 —> 00:21:14,833 that you can translate it

618 00:21:15,033 —> 00:21:15,750 to another project but at

619 00:21:15,750 —> 00:21:16,898 least it takes a lot of

620 00:21:17,240 —> 00:21:21,418 reporting or work off of our hands.

621 00:21:22,040 —> 00:21:23,038 Absolutely.

622 00:21:23,640 —> 00:21:24,942 That’s super interesting.

623 00:21:25,142 —> 00:21:26,020 I’m excited to see

624 00:21:26,220 —> 00:21:27,338 what you’ve got to show us.

625 00:21:28,040 —> 00:21:30,008 I’m I was curious

626 00:21:30,760 —> 00:21:31,905 if you can share

627 00:21:32,105 —> 00:21:33,908 how we work used Airtable?

628 00:21:34,540 —> 00:21:40,708 N. D. A. But

629 00:21:41,040 —> 00:21:44,237 yeah I’m not sure they still use it.

630 00:21:44,437 —> 00:21:47,790 They were using it back in the day

631 00:21:47,790 —> 00:21:49,349 But we used it more

632 00:21:49,549 —> 00:21:51,318 for internal operations.

633 00:21:51,640 —> 00:21:54,268 It was more reporting internal operations,

634 00:21:54,640 —> 00:21:55,538 getting

635 00:21:55,580 —> 00:21:57,228 things through gates. So like

636 00:21:58,240 —> 00:22:00,201 when you get through approval gates

637 00:22:00,401 —> 00:22:01,716 and then you kind of like

638 00:22:01,916 —> 00:22:02,610 pass it on to the

639 00:22:02,610 —> 00:22:03,291 next department.

640 00:22:03,491 —> 00:22:04,600 So when it was going through

641 00:22:04,800 —> 00:22:05,590 real estate and they were

642 00:22:05,590 —> 00:22:07,122 assessing a potential property

643 00:22:07,322 —> 00:22:08,398 and then you kind of like

644 00:22:08,740 —> 00:22:10,004 get it over and like

645 00:22:10,204 —> 00:22:11,648 push it to the design team

646 00:22:12,140 —> 00:22:14,129 so you kind of like use the same data

647 00:22:14,329 —> 00:22:16,280 but pass it on to different stakeholders

648 00:22:16,280 —> 00:22:17,008 along the way.

649 00:22:17,940 —> 00:22:19,208 So yeah.

650 00:22:20,340 —> 00:22:21,248 Very nice.

651 00:22:21,840 —> 00:22:24,941 What about maybe question for Kamille

652 00:22:25,141 —> 00:22:28,210 or Chris like, how pop do you know other

653 00:22:28,210 —> 00:22:29,752 architecture related firms

654 00:22:29,952 —> 00:22:32,420 that use Airtable? Is it known within that

655 00:22:32,420 —> 00:22:34,998 industry or you guys are just outliers?

656 00:22:35,340 —> 00:22:37,998 I don’t think it’s a

657 00:22:38,840 —> 00:22:39,848 popular

658 00:22:39,950 —> 00:22:42,608 tool I guess in our field.

659 00:22:47,040 —> 00:22:48,438 Not for us either.

660 00:22:48,638 —> 00:22:49,993 Like we’ve used it

661 00:22:50,193 —> 00:22:52,630 like we’ve instigated using it with

662 00:22:52,630 —> 00:22:56,058 clients to get and give them access

663 00:22:56,258 —> 00:23:00,270 to their dashboards or specific views so

664 00:23:00,270 —> 00:23:02,188 they can kind of like keep up

665 00:23:02,388 —> 00:23:04,030 to date with their permits

666 00:23:04,230 —> 00:23:05,230 and tracking it and

667 00:23:05,230 —> 00:23:06,218 stuff like that. But

668 00:23:06,340 —> 00:23:08,398 I’ve been

669 00:23:09,520 —> 00:23:11,032 I’ve been pushing it a lot

670 00:23:11,232 —> 00:23:12,718 and it hasn’t been picking up

671 00:23:13,140 —> 00:23:13,998 for some reason

672 00:23:14,340 —> 00:23:16,643 but not a lot of architects

673 00:23:16,843 —> 00:23:18,008 are big on data.

674 00:23:18,340 —> 00:23:22,818 Well I think that’s interesting because

675 00:23:23,840 —> 00:23:25,455 I’ve been seeing more and more,

676 00:23:25,655 —> 00:23:26,825 we were talking about it

677 00:23:27,025 —> 00:23:27,800 literally yesterday.

678 00:23:29,810 —> 00:23:32,578 The idea of parametric design which is

679 00:23:33,040 —> 00:23:37,108 using data to help you generate

680 00:23:37,640 —> 00:23:40,336 different design schemes really quickly.

681 00:23:40,536 —> 00:23:42,830 So you feed it a bunch of parameters.

682 00:23:42,830 —> 00:23:45,236 A program will spit out a couple

683 00:23:45,436 —> 00:23:48,018 of different building shapes and then

684 00:23:48,050 —> 00:23:49,065 the architects

685 00:23:49,265 —> 00:23:51,166 will take that building shape

686 00:23:51,366 —> 00:23:53,008 that you know best fits

687 00:23:53,340 —> 00:23:54,431 what they want

688 00:23:54,631 —> 00:23:55,618 and then like

689 00:23:55,818 —> 00:23:57,620 start to like carve out

690 00:23:57,820 —> 00:23:59,108 even more it’s like

691 00:23:59,640 —> 00:24:02,574 a good comparison might be 3D printing

692 00:24:02,774 —> 00:24:05,200 where the printer will print out a

693 00:24:05,200 —> 00:24:06,305 lot of what you need to do,

694 00:24:06,505 —> 00:24:07,519 but you still need to go in

695 00:24:07,719 —> 00:24:08,270 and sand it and then

696 00:24:08,270 —> 00:24:09,498 paint it afterward.

697 00:24:09,840 —> 00:24:10,508 And

698 00:24:11,140 —> 00:24:13,710 I don’t think Airtable is necessarily

699 00:24:13,910 —> 00:24:16,350 a good fit for the world of parametric

700 00:24:16,350 —> 00:24:18,898 design. But I do see more and more people

701 00:24:19,240 —> 00:24:20,825 trying to think through how

702 00:24:21,025 —> 00:24:21,863 can we use data

703 00:24:22,063 —> 00:24:23,818 to help with the process of design.

704 00:24:24,240 —> 00:24:26,313 Yeah. Well it’s picking up,

705 00:24:26,513 —> 00:24:28,446 it’s picking up a lot more

706 00:24:28,646 —> 00:24:30,230 for urban design because

707 00:24:30,230 —> 00:24:31,098 you

708 00:24:31,840 —> 00:24:33,699 you do get a lot of more,

709 00:24:33,899 —> 00:24:35,554 there’s a lot more data

710 00:24:35,754 —> 00:24:37,640 readily available online that

711 00:24:37,640 —> 00:24:38,374 you can use

712 00:24:38,574 —> 00:24:39,800 from the government

713 00:24:39,999 —> 00:24:42,510 now for like building design unless you’re

714 00:24:42,510 —> 00:24:44,597 generating your own data

715 00:24:44,797 —> 00:24:45,811 is very hard

716 00:24:46,011 —> 00:24:48,598 to get proper benchmarks for that

717 00:24:49,140 —> 00:24:50,548 unfortunately.

718 00:24:50,690 —> 00:24:52,608 But in terms of

719 00:24:53,440 —> 00:24:56,998 generative design, we do

720 00:24:57,430 —> 00:24:59,508 we do parametric design in the office.

721 00:25:00,060 —> 00:25:01,608 And we

722 00:25:02,040 —> 00:25:04,178 we also use rivet. So

723 00:25:04,340 —> 00:25:05,108 for

724 00:25:05,940 —> 00:25:07,463 people who don’t know

725 00:25:07,663 —> 00:25:09,127 rivet is the software

726 00:25:09,327 —> 00:25:10,870 that allows you to design

727 00:25:10,870 —> 00:25:11,718 buildings

728 00:25:12,240 —> 00:25:13,979 with objects rather than geometry.

729 00:25:14,179 —> 00:25:15,324 So like a door is a door

730 00:25:15,524 —> 00:25:16,230 and it has metadata

731 00:25:16,230 —> 00:25:17,178 attached to it.

732 00:25:17,420 —> 00:25:18,818 So it carries the

733 00:25:19,240 —> 00:25:20,752 dimensions of the door,

734 00:25:20,952 —> 00:25:22,161 price of the door,

735 00:25:22,361 —> 00:25:24,040 manufacturer, specifications,

736 00:25:24,040 —> 00:25:27,833 all of that goes with the object.

737 00:25:28,033 —> 00:25:32,890 So that data can be transformed into like

738 00:25:32,890 —> 00:25:35,045 you can export schedules of this data

739 00:25:35,245 —> 00:25:37,200 from the software directly to CSP for

740 00:25:37,200 —> 00:25:38,508 example, so

741 00:25:38,640 —> 00:25:40,728 getting the data out of the software and

742 00:25:41,040 —> 00:25:42,417 putting it somewhere where you

743 00:25:42,617 —> 00:25:43,840 can actually do things with it.

744 00:25:43,840 —> 00:25:46,684 Like Airtable, super useful.

745 00:25:46,884 —> 00:25:49,216 Like I love doing it.

746 00:25:49,416 —> 00:25:51,660 And also the other way

747 00:25:51,660 —> 00:25:52,626 around. So we

748 00:25:52,826 —> 00:25:55,141 like I’ve used it in cases where

749 00:25:55,341 —> 00:25:57,310 I have the data in Airtable and

750 00:25:57,310 —> 00:26:01,308 had to export it to link it into

751 00:26:01,440 —> 00:26:02,468 into the software.

752 00:26:02,600 —> 00:26:04,328 So things like

753 00:26:05,740 —> 00:26:07,408 like what spaces,

754 00:26:07,940 —> 00:26:10,070 what kind of like space take up

755 00:26:10,270 —> 00:26:11,849 does each function take?

756 00:26:12,049 —> 00:26:13,230 And then like plotted

757 00:26:13,230 —> 00:26:15,718 out into Airtable like as a dummy

758 00:26:16,240 —> 00:26:17,451 environment sandbox

759 00:26:17,651 —> 00:26:19,938 and then just push it into the software

760 00:26:20,070 —> 00:26:20,998 so it

761 00:26:21,440 —> 00:26:22,620 it can integrate

762 00:26:22,820 —> 00:26:25,348 not directly so you always need to go

763 00:26:25,390 —> 00:26:27,529 to work flow around it.

764 00:26:27,729 —> 00:26:30,268 But I have used it both ways

765 00:26:30,468 —> 00:26:31,900 so it can work,

766 00:26:31,900 —> 00:26:32,383 it just

767 00:26:32,583 —> 00:26:35,008 it doesn’t lend itself too much to it.

768 00:26:35,940 —> 00:26:37,998 So have you with any of

769 00:26:38,440 —> 00:26:40,793 the above that was just mentioned,

770 00:26:40,993 —> 00:26:43,630 would you be able to use the like 3D

771 00:26:43,630 —> 00:26:46,332 renderer extension that Airtable has

772 00:26:46,532 —> 00:26:48,808 because it’s so rare to find like

773 00:26:49,040 —> 00:26:51,290 something that would use that extension

774 00:26:51,490 —> 00:26:53,310 and I’ve always wanted to see it in

775 00:26:53,310 —> 00:26:55,240 action. I think we had someone on

776 00:26:55,440 —> 00:26:56,823 the show a few weeks ago.

777 00:26:57,023 —> 00:26:57,930 We did and you could

778 00:26:57,930 —> 00:27:00,583 but the process you would need to take,

779 00:27:00,783 —> 00:27:01,808 I think to get the

780 00:27:02,040 —> 00:27:04,207 info that we typically work with

781 00:27:04,407 —> 00:27:06,170 from an architect standpoint.

782 00:27:06,170 —> 00:27:07,711 I don’t want to speak for you Chris

783 00:27:07,911 —> 00:27:09,560 but from an architect standpoint there’s a

784 00:27:09,560 —> 00:27:11,005 lot more detailed geometry

785 00:27:11,205 —> 00:27:12,313 that you have to work

786 00:27:12,513 —> 00:27:13,950 with and from an urban planning

787 00:27:13,950 —> 00:27:16,176 standpoint. All of my geometry is simple,

788 00:27:16,376 —> 00:27:18,130 but I’m looking at a whole city at a

789 00:27:18,130 —> 00:27:18,708 time

790 00:27:18,740 —> 00:27:20,750 and I don’t want to deal

791 00:27:20,950 —> 00:27:22,508 with that in Airtable

792 00:27:23,740 —> 00:27:24,612 no shade to Airtable

793 00:27:24,812 —> 00:27:26,277 but that’s not what they’re made for

794 00:27:26,477 —> 00:27:27,010 and I would rather

795 00:27:27,010 —> 00:27:27,908 just use a,

796 00:27:28,340 —> 00:27:30,722 You know, 3D viewer that is sort of built

797 00:27:30,922 —> 00:27:32,058 to handle that level of

798 00:27:32,090 —> 00:27:34,208 detail or that level of scale.

799 00:27:34,540 —> 00:27:34,978 Right,

800 00:27:36,640 —> 00:27:37,218 Cool,

801 00:27:37,640 —> 00:27:40,654 awesome. Well we are glad

802 00:27:40,854 —> 00:27:45,718 you could join us all the way from Cyprus.

803 00:27:46,140 —> 00:27:47,108 Yeah, that’s so cool.

804 00:27:47,790 —> 00:27:49,398 Go back here

805 00:27:49,710 —> 00:27:51,008 and now

806 00:27:51,340 —> 00:27:53,450 Chris is going to share with us

807 00:27:53,650 —> 00:27:54,760 some of his bases

808 00:27:54,960 —> 00:27:56,718 that he uses in the real world

809 00:27:57,240 —> 00:27:59,898 and we’re gonna share your screen here.

810 00:28:01,150 —> 00:28:03,008 There you go. Take it away.

811 00:28:03,540 —> 00:28:05,249 Alright, perfect. So

812 00:28:05,449 —> 00:28:07,619 I’m gonna go through a few

813 00:28:07,819 —> 00:28:10,290 bases slash Interfaces that kind

814 00:28:10,290 —> 00:28:11,661 of use case scenarios

815 00:28:11,861 —> 00:28:13,098 that we use it for.

816 00:28:14,440 —> 00:28:17,658 It’s not using any automations,

817 00:28:17,858 —> 00:28:19,179 no scripting,

818 00:28:19,379 —> 00:28:22,330 no bells and whistles but it

819 00:28:22,330 —> 00:28:23,285 does the job

820 00:28:23,485 —> 00:28:26,325 with the base Airtable functionality

821 00:28:26,525 —> 00:28:28,218 so we try to do our best

822 00:28:28,540 —> 00:28:32,069 now just to highlight the data here,

823 00:28:32,269 —> 00:28:35,500 a lot of it is dummy data because I

824 00:28:35,500 —> 00:28:38,350 can’t actually share the real data

825 00:28:38,550 —> 00:28:41,200 but so I’m gonna go through a few.

826 00:28:41,200 —> 00:28:42,842 Use case scenarios,

827 00:28:43,042 —> 00:28:45,401 use case scenario number one

828 00:28:45,601 —> 00:28:47,508 is using the data from

829 00:28:47,950 —> 00:28:49,348 the design software,

830 00:28:49,520 —> 00:28:51,258 getting quantities out of

831 00:28:51,458 —> 00:28:52,718 the software and then

832 00:28:53,240 —> 00:28:55,673 how we deal with those quantities

833 00:28:55,873 —> 00:28:57,590 for budgeting the project.

834 00:28:57,590 —> 00:29:00,239 The other one is more kind of like

835 00:29:00,439 —> 00:29:02,810 how do we make sure that we’re

836 00:29:02,810 —> 00:29:03,998 designing to brief

837 00:29:04,540 —> 00:29:07,108 and

838 00:29:07,440 —> 00:29:08,974 tracking permits

839 00:29:09,174 —> 00:29:11,468 and optimizing budgets. So

840 00:29:11,540 —> 00:29:14,408 I’m gonna start off with our kind of

841 00:29:16,440 —> 00:29:17,977 the project budgeting side

842 00:29:18,177 —> 00:29:18,679 of things

843 00:29:18,879 —> 00:29:20,520 but we also use it for tendering.

844 00:29:20,520 —> 00:29:22,866 So if we have a look at

845 00:29:23,066 —> 00:29:25,008 the base behind this.

846 00:29:25,340 —> 00:29:29,498 So what we have here is, alright

847 00:29:29,840 —> 00:29:32,175 so we’ve got so there’s a

848 00:29:32,375 —> 00:29:33,922 basically a table

849 00:29:34,122 —> 00:29:36,470 that deals with the quantity

850 00:29:36,470 —> 00:29:40,018 takeoffs. So we’ve got these organized

851 00:29:40,218 —> 00:29:43,660 in categories. So every category of the

852 00:29:43,660 —> 00:29:45,219 building process from

853 00:29:45,419 —> 00:29:47,001 preliminary excavations,

854 00:29:47,201 —> 00:29:48,890 demolitions all the way to

855 00:29:48,890 —> 00:29:50,498 artwork.

856 00:29:50,640 —> 00:29:52,221 We’re like we’re covered in

857 00:29:52,421 —> 00:29:53,270 these categories

858 00:29:53,470 —> 00:29:55,398 and then what we do, we go and

859 00:29:55,740 —> 00:29:57,909 get every single aspect of the building

860 00:29:58,109 —> 00:29:59,300 mapped out in quantities.

861 00:29:59,300 —> 00:30:01,508 So partitions for meeting rooms,

862 00:30:02,140 —> 00:30:04,035 there. Cutting the floor boxes

863 00:30:04,235 —> 00:30:05,930 to get the power distribution,

864 00:30:05,930 —> 00:30:06,995 it’s there.

865 00:30:07,195 —> 00:30:10,547 Things like ceiling mounted racks

866 00:30:10,747 —> 00:30:13,290 all the way to like meeting

867 00:30:13,290 —> 00:30:15,019 room chairs and boardroom chairs,

868 00:30:15,219 —> 00:30:17,220 everything’s in there. And we we basically

869 00:30:17,220 —> 00:30:18,757 break them down by level

870 00:30:18,957 —> 00:30:19,694 and by zone.

871 00:30:19,894 —> 00:30:22,150 So like level four meeting room has four

872 00:30:22,150 —> 00:30:23,218 meeting room chairs

873 00:30:23,440 —> 00:30:25,398 and there’s a budget assigned to that.

874 00:30:25,660 —> 00:30:26,928 Now

875 00:30:27,340 —> 00:30:30,044 after we do these kind of takeoffs

876 00:30:30,244 —> 00:30:32,510 and migrate them into Airtable,

877 00:30:32,510 —> 00:30:34,509 then we try to go out to tenders

878 00:30:34,709 —> 00:30:36,508 because the idea is that we want

879 00:30:36,940 —> 00:30:39,178 to be unbiased towards

880 00:30:39,480 —> 00:30:40,578 the tenders

881 00:30:40,740 —> 00:30:42,208 or the potential suppliers.

882 00:30:42,540 —> 00:30:45,408 So what we do is kind of like a report

883 00:30:46,140 —> 00:30:48,108 the different tenders to the clients.

884 00:30:48,740 —> 00:30:52,682 So we basically go on every single item

885 00:30:52,882 —> 00:30:55,108 in the quantities table.

886 00:30:55,440 —> 00:30:57,992 And we put like for example this

887 00:30:58,192 —> 00:30:59,512 two seater sofa,

888 00:30:59,712 —> 00:31:01,740 approximate dimensions from

889 00:31:01,740 —> 00:31:03,308 the design is this.

890 00:31:03,508 —> 00:31:06,242 And then we’ve got three different

891 00:31:06,442 —> 00:31:07,930 options for that with

892 00:31:07,930 —> 00:31:09,044 their associated pictures

893 00:31:09,244 —> 00:31:10,572 and we kind of like do an export

894 00:31:10,772 —> 00:31:11,360 of this and send it

895 00:31:11,360 —> 00:31:12,218 to the client.

896 00:31:12,440 —> 00:31:14,379 So for this item in the quantities,

897 00:31:14,579 —> 00:31:16,318 you’ve got three different options,

898 00:31:16,340 —> 00:31:17,583 which one do you want?

899 00:31:17,783 —> 00:31:19,122 So it basically goes into

900 00:31:19,322 —> 00:31:20,408 the quantities table and

901 00:31:21,140 —> 00:31:23,725 starts multiplying by unit price.

902 00:31:23,925 —> 00:31:26,310 If there’s a percentage waste,

903 00:31:26,310 —> 00:31:27,169 if you’ve got tiles

904 00:31:27,369 —> 00:31:28,376 and you’re cutting tiles

905 00:31:28,576 —> 00:31:29,340 and you’ve got wastage,

906 00:31:29,340 —> 00:31:31,696 it also has a parameter in there for that.

907 00:31:31,896 —> 00:31:33,098 And if you have discounts

908 00:31:33,540 —> 00:31:36,142 and then we basically just report,

909 00:31:36,342 —> 00:31:39,280 you know what the unit price is that this

910 00:31:39,280 —> 00:31:40,971 much times the quantity that it pulls

911 00:31:41,171 —> 00:31:42,480 from the other table. This is the

912 00:31:42,480 —> 00:31:43,508 estimated cost

913 00:31:44,040 —> 00:31:46,958 across the project for this specific item

914 00:31:46,960 —> 00:31:48,503 and then if you have it

915 00:31:48,703 —> 00:31:50,718 you’ve got different statuses. So

916 00:31:51,140 —> 00:31:52,598 we’re using the same

917 00:31:52,940 —> 00:31:54,908 tables to track deliveries as well.

918 00:31:55,540 —> 00:31:56,278 So

919 00:31:56,440 —> 00:31:57,858 if you have a short listed

920 00:31:58,058 —> 00:31:59,548 if you haven’t selected ordered

921 00:31:59,940 —> 00:32:01,402 confirmed delivery dates

922 00:32:01,602 —> 00:32:02,724 delivered, installed,

923 00:32:02,924 —> 00:32:03,900 rejected, and damaged.

924 00:32:03,900 —> 00:32:04,718 So

925 00:32:05,040 —> 00:32:07,218 if things are

926 00:32:08,540 —> 00:32:11,305 if we were tracking the deliveries

927 00:32:11,505 —> 00:32:13,500 but also the overdue items.

928 00:32:13,500 —> 00:32:16,591 So that’s how we go around with it.

929 00:32:16,791 —> 00:32:20,300 But if for example anything that is at bit

930 00:32:20,300 —> 00:32:20,818 mode

931 00:32:21,240 —> 00:32:23,343 doesn’t pull so we’ve got

932 00:32:23,543 —> 00:32:25,179 it doesn’t pull into

933 00:32:25,379 —> 00:32:27,550 this table the quantity table

934 00:32:27,550 —> 00:32:30,411 because in here this estimated cost

935 00:32:30,611 —> 00:32:32,428 is basically rolling up

936 00:32:32,628 —> 00:32:34,008 the information from

937 00:32:34,340 —> 00:32:36,056 the tender table where

938 00:32:36,256 —> 00:32:38,708 the status is not been rejected.

939 00:32:39,840 —> 00:32:41,421 Right? So if it’s at Bit mode

940 00:32:41,621 —> 00:32:42,593 or if it’s rejected

941 00:32:42,793 —> 00:32:43,820 it doesn’t aggregate the

942 00:32:43,820 —> 00:32:46,297 values. If it changes into anything else

943 00:32:46,497 —> 00:32:48,340 it means it’s already part of the

944 00:32:48,340 —> 00:32:50,278 opposition process of procurement

945 00:32:50,478 —> 00:32:52,098 and it adds it into the budget.

946 00:32:52,840 —> 00:32:53,947 So that’s kind of like

947 00:32:54,147 —> 00:32:55,608 what’s going on in the background

948 00:32:56,240 —> 00:32:58,475 of the base which can make

949 00:32:58,675 —> 00:33:00,434 this make more sense.

950 00:33:00,634 —> 00:33:03,030 So basically everything that we

951 00:33:03,030 —> 00:33:04,811 put into the base aggregate

952 00:33:05,011 —> 00:33:06,019 in terms of cost

953 00:33:06,219 —> 00:33:07,910 and then the client can have a

954 00:33:07,910 —> 00:33:09,076 dashboard and see

955 00:33:09,276 —> 00:33:11,818 exactly what this cost breaks down into.

956 00:33:11,940 —> 00:33:13,903 So we’ve got the different categories

957 00:33:14,103 —> 00:33:15,920 from more constructions or the minimum

958 00:33:15,920 —> 00:33:16,818 systems

959 00:33:16,840 —> 00:33:19,178 floor coverings I. T. Systems all of these

960 00:33:19,540 —> 00:33:21,160 for this project specifically

961 00:33:21,360 —> 00:33:22,361 because it has done

962 00:33:22,561 —> 00:33:23,730 an interior fit out for an

963 00:33:23,730 —> 00:33:24,791 office space.

964 00:33:24,991 —> 00:33:28,218 So there’s no building work done to it,

965 00:33:28,540 —> 00:33:29,438 construction wise.

966 00:33:29,840 —> 00:33:31,270 So you see the breakdown

967 00:33:31,470 —> 00:33:33,002 of the different categories

968 00:33:33,202 —> 00:33:34,250 and what the estimated

969 00:33:34,250 —> 00:33:35,268 cost for each is.

970 00:33:35,468 —> 00:33:36,387 So that’s great.

971 00:33:36,587 —> 00:33:38,168 And if you scroll further down

972 00:33:38,368 —> 00:33:38,800 you actually

973 00:33:38,800 —> 00:33:39,218 have

974 00:33:39,740 —> 00:33:41,461 a breakdown of the quantities

975 00:33:41,661 —> 00:33:42,504 and the budget.

976 00:33:42,704 —> 00:33:44,190 So they still get kind of like

977 00:33:44,190 —> 00:33:46,942 more data oriented breakdown of this

978 00:33:47,142 —> 00:33:50,230 if they really want to see it summarized

979 00:33:50,230 —> 00:33:51,819 but they also have like a

980 00:33:52,019 —> 00:33:53,218 high level overview of

981 00:33:53,540 —> 00:33:56,127 what the budget is for the project.

982 00:33:56,327 —> 00:33:59,380 So where you see if it’s been selected

983 00:33:59,380 —> 00:34:02,124 so place partitions create it’s selected.

984 00:34:02,324 —> 00:34:04,600 It’s there anything that’s zero value

985 00:34:04,600 —> 00:34:05,971 means there’s no supplier,

986 00:34:06,171 —> 00:34:07,310 nothing selected for it

987 00:34:07,510 —> 00:34:08,449 and they need to make a

988 00:34:08,449 —> 00:34:08,799 decision

989 00:34:08,999 —> 00:34:10,508 essentially that’s what it’s there for.

990 00:34:10,840 —> 00:34:12,598 So if it’s empty means guys

991 00:34:12,940 —> 00:34:14,651 we’ve got tenders for this

992 00:34:14,851 —> 00:34:17,679 we’ve allowed for it but you have made a

993 00:34:17,679 —> 00:34:19,313 decision so if you want this

994 00:34:19,513 —> 00:34:21,343 project budget to reflect reality

995 00:34:21,543 —> 00:34:22,230 you need to fill

996 00:34:22,230 —> 00:34:22,608 it in.

997 00:34:24,139 —> 00:34:26,108 Even though we’re doing the filling in

998 00:34:26,440 —> 00:34:28,148 aspect of it which is

999 00:34:28,520 —> 00:34:29,008 kind of

1000 00:34:29,440 —> 00:34:31,037 the bottleneck but

1001 00:34:31,237 —> 00:34:34,408 at least it keeps us on top of things.

1002 00:34:34,739 —> 00:34:35,508 Now

1003 00:34:35,940 —> 00:34:38,044 we do have are kind of like

1004 00:34:38,244 —> 00:34:39,671 internal Interfaces

1005 00:34:39,871 —> 00:34:41,550 to help us deal with like

1006 00:34:41,550 —> 00:34:42,733 reviewing these items.

1007 00:34:42,933 —> 00:34:44,005 So if we go furniture

1008 00:34:44,205 —> 00:34:45,690 and we’re going between different

1009 00:34:45,690 —> 00:34:47,299 options different types of

1010 00:34:47,499 —> 00:34:48,796 furniture that we have

1011 00:34:48,996 —> 00:34:50,330 and we’re seeing different

1012 00:34:50,330 —> 00:34:52,446 options for the same item. Right?

1013 00:34:52,646 —> 00:34:53,439 So this is from

1014 00:34:53,639 —> 00:34:54,379 the same supplier

1015 00:34:54,579 —> 00:34:55,968 but two options for the same item,

1016 00:34:56,168 —> 00:34:56,949 so we can decide all you

1017 00:34:56,949 —> 00:34:57,308 want,

1018 00:34:57,440 —> 00:34:59,838 we want that. So let’s go and select it

1019 00:35:00,050 —> 00:35:01,662 like we’ve selected that.

1020 00:35:01,862 —> 00:35:03,918 So now if we go back to the budget,

1021 00:35:03,950 —> 00:35:04,898 it’s already changed.

1022 00:35:05,440 —> 00:35:06,018 Right?

1023 00:35:06,840 —> 00:35:08,543 So that’s one use case scenario

1024 00:35:08,743 —> 00:35:09,723 that we use it for.

1025 00:35:09,923 —> 00:35:10,960 Super useful for smaller

1026 00:35:10,960 —> 00:35:12,483 projects and bigger projects,

1027 00:35:12,682 —> 00:35:13,809 you’ve got a specialist

1028 00:35:14,009 —> 00:35:14,740 that deals with the

1029 00:35:14,740 —> 00:35:15,549 quantities. So

1030 00:35:15,749 —> 00:35:17,639 we don’t want to kind of double up

1031 00:35:17,839 —> 00:35:19,250 on the work but for a smaller

1032 00:35:19,250 —> 00:35:20,208 project like this,

1033 00:35:20,540 —> 00:35:21,098 that’s great.

1034 00:35:21,440 —> 00:35:26,518 Now let me go here. So

1035 00:35:27,140 —> 00:35:28,103 because we’re getting

1036 00:35:28,303 —> 00:35:29,506 we’re dealing with buildings

1037 00:35:29,706 —> 00:35:30,580 and we need to go through

1038 00:35:30,580 —> 00:35:32,535 kind of jumping through hoops

1039 00:35:32,735 —> 00:35:34,091 with the authorities.

1040 00:35:34,291 —> 00:35:35,770 A lot of the work we do is

1041 00:35:35,770 —> 00:35:38,088 based on getting permit approvals

1042 00:35:38,288 —> 00:35:40,898 from the local and national authorities.

1043 00:35:41,240 —> 00:35:44,430 So basically for any building

1044 00:35:44,630 —> 00:35:48,086 that’s in potential construction

1045 00:35:48,286 —> 00:35:49,490 that’s over a

1046 00:35:49,490 —> 00:35:50,308 certain size,

1047 00:35:50,640 —> 00:35:52,608 you need to go through

1048 00:35:53,440 —> 00:35:55,337 authorized an authorization process

1049 00:35:55,537 —> 00:35:56,800 with different departments.

1050 00:35:56,800 —> 00:35:57,637 So you need to go to

1051 00:35:57,837 —> 00:35:58,559 the Energy Department,

1052 00:35:58,759 —> 00:35:59,990 you need to go to the Department of

1053 00:35:59,990 —> 00:36:02,412 Environment to make sure that

1054 00:36:02,612 —> 00:36:06,170 your are you taking all the sustainability

1055 00:36:06,170 —> 00:36:08,464 issues, are you making sure

1056 00:36:08,664 —> 00:36:11,098 that you’re not creating any

1057 00:36:11,230 —> 00:36:12,608 issues with the local flora

1058 00:36:12,808 —> 00:36:13,730 and fauna and so on.

1059 00:36:13,930 —> 00:36:16,588 So part of that is actually tracking it,

1060 00:36:16,930 —> 00:36:19,349 Creating dashboards to support it.

1061 00:36:19,549 —> 00:36:19,958 Right?

1062 00:36:20,158 —> 00:36:22,480 So basically this is a dashboard that

1063 00:36:22,480 —> 00:36:23,506 deals with that.

1064 00:36:23,706 —> 00:36:26,390 It’s basically just a reporting dashboard,

1065 00:36:26,390 —> 00:36:28,121 we know what’s going on in the

1066 00:36:28,321 —> 00:36:29,359 background anyways,

1067 00:36:29,559 —> 00:36:30,890 but for clients to see where

1068 00:36:30,890 —> 00:36:32,934 we are. So this is what we do.

1069 00:36:33,134 —> 00:36:35,218 So like there’s 12 consultations

1070 00:36:35,418 —> 00:36:36,000 that we were

1071 00:36:36,000 —> 00:36:36,912 requested to do with

1072 00:36:37,112 —> 00:36:38,098 the different departments.

1073 00:36:38,230 —> 00:36:40,012 There’s 10 of them complete.

1074 00:36:40,212 —> 00:36:41,975 That’s the average percentage

1075 00:36:42,175 —> 00:36:43,130 completion based on

1076 00:36:43,130 —> 00:36:44,247 the values.

1077 00:36:44,447 —> 00:36:48,208 And then what we have here is basically

1078 00:36:48,730 —> 00:36:50,178 responsibility

1079 00:36:50,220 —> 00:36:51,798 for this by

1080 00:36:52,130 —> 00:36:53,708 the different disciplines

1081 00:36:54,030 —> 00:36:55,698 and then basically

1082 00:36:56,030 —> 00:36:57,215 it’s the same data

1083 00:36:57,415 —> 00:36:58,988 just grouped differently.

1084 00:36:59,188 —> 00:37:00,310 So this is basically,

1085 00:37:00,310 —> 00:37:02,638 you know what executive architects

1086 00:37:02,838 —> 00:37:04,410 which is us in this case

1087 00:37:04,610 —> 00:37:05,720 and we’re seeing,

1088 00:37:05,720 —> 00:37:07,898 you know what, we’ve got

1089 00:37:08,230 —> 00:37:10,296 one record that’s pending approval

1090 00:37:10,496 —> 00:37:11,998 and one that’s under review.

1091 00:37:12,730 —> 00:37:14,788 So we can check that

1092 00:37:15,530 —> 00:37:17,473 that has environmental engineer

1093 00:37:17,673 —> 00:37:19,524 has one record pending approval

1094 00:37:19,724 —> 00:37:20,420 and the rest is

1095 00:37:20,420 —> 00:37:22,343 like changes requested,

1096 00:37:22,543 —> 00:37:23,194 approved

1097 00:37:23,394 —> 00:37:26,940 so different disciplines having

1098 00:37:26,940 —> 00:37:28,566 to deal with different departments.

1099 00:37:28,766 —> 00:37:30,470 And then here is basically just that it’s

1100 00:37:30,470 —> 00:37:32,888 more of a color coded version of

1101 00:37:33,230 —> 00:37:34,375 the different departments.

1102 00:37:34,575 —> 00:37:36,180 So you’ve got the antiquities Department,

1103 00:37:36,180 —> 00:37:37,654 Civil Aviation Authority,

1104 00:37:37,854 —> 00:37:39,090 Electricity Authority.

1105 00:37:39,290 —> 00:37:40,720 So it’s just color coding the

1106 00:37:40,720 —> 00:37:41,708 status of each.

1107 00:37:43,130 —> 00:37:45,485 And if you go further down again,

1108 00:37:45,685 —> 00:37:48,340 this is something that like I like to do

1109 00:37:48,340 —> 00:37:50,123 typically because this is kind of like

1110 00:37:50,323 —> 00:37:52,000 the overview and this is the data if you

1111 00:37:52,000 —> 00:37:53,288 really want to go into detail,

1112 00:37:53,830 —> 00:37:56,197 right? Because of transparency,

1113 00:37:56,397 —> 00:37:59,098 like we want people to be able to see,

1114 00:37:59,530 —> 00:38:00,523 hey, you know what,

1115 00:38:00,723 —> 00:38:02,409 this is kind of the, the overview,

1116 00:38:02,609 —> 00:38:03,450 but if you want to go

1117 00:38:03,450 —> 00:38:05,578 into data and see the details or you know,

1118 00:38:05,778 —> 00:38:06,490 what was approved?

1119 00:38:06,490 —> 00:38:07,151 You know what

1120 00:38:07,351 —> 00:38:08,557 these specific conditions

1121 00:38:08,757 —> 00:38:10,100 are currently under negotiation.

1122 00:38:10,100 —> 00:38:11,491 So there’s a lot,

1123 00:38:11,691 —> 00:38:14,108 there’s more data and summary of

1124 00:38:14,140 —> 00:38:15,727 the different decisions in there

1125 00:38:15,927 —> 00:38:17,710 if they want to get into the new degree,

1126 00:38:17,710 —> 00:38:18,588 the details, but

1127 00:38:18,720 —> 00:38:20,312 if not the dashboard is usually

1128 00:38:20,512 —> 00:38:21,648 more than enough for them.

1129 00:38:22,110 —> 00:38:24,658 I really like the chart on the right, I,

1130 00:38:24,858 —> 00:38:27,078 for some reason, I’ve never thought of

1131 00:38:27,520 —> 00:38:29,634 doing it that way when you have

1132 00:38:29,834 —> 00:38:31,076 a sequential series

1133 00:38:31,276 —> 00:38:32,840 of things that you need and

1134 00:38:32,840 —> 00:38:34,778 each of those sequential things

1135 00:38:34,978 —> 00:38:36,528 has a status and I don’t know

1136 00:38:36,530 —> 00:38:38,579 if it’s exactly the same where

1137 00:38:38,779 —> 00:38:41,310 you are but with our permitting process,

1138 00:38:41,310 —> 00:38:43,498 sometimes you have to get,

1139 00:38:43,720 —> 00:38:44,053 you know,

1140 00:38:44,253 —> 00:38:45,570 you have to go to the building department

1141 00:38:45,770 —> 00:38:46,550 before you go to the energy

1142 00:38:46,550 —> 00:38:48,628 Department or vice versa. So there’s,

1143 00:38:48,820 —> 00:38:51,321 you know, things happen in an order

1144 00:38:51,521 —> 00:38:54,180 and I know with charts you can change or

1145 00:38:54,180 —> 00:38:55,378 control rather,

1146 00:38:55,820 —> 00:38:58,216 you know which stack appears where

1147 00:38:58,416 —> 00:39:00,260 and seeing color coded. Okay.

1148 00:39:00,260 —> 00:39:02,153 This is gonna go from light tan

1149 00:39:02,353 —> 00:39:03,625 to dark orange to blue

1150 00:39:03,825 —> 00:39:04,840 and that’s how I know

1151 00:39:04,840 —> 00:39:06,147 that that column is done.

1152 00:39:06,347 —> 00:39:07,233 Then the next one

1153 00:39:07,433 —> 00:39:08,760 I could see where it is in that

1154 00:39:08,760 —> 00:39:09,650 process. Just by

1155 00:39:09,850 —> 00:39:11,209 looking at the color coding.

1156 00:39:11,409 —> 00:39:12,409 I just really like

1157 00:39:12,620 —> 00:39:14,279 seeing, they’re all the same height

1158 00:39:14,479 —> 00:39:16,270 obviously because there’s one approval one

1159 00:39:16,270 —> 00:39:16,738 record.

1160 00:39:18,820 —> 00:39:20,648 So you’re just using a number of records

1161 00:39:20,848 —> 00:39:22,110 versus like aggregating a field,

1162 00:39:22,110 —> 00:39:23,723 having a field summary.

1163 00:39:23,923 —> 00:39:25,272 So that’s why it is,

1164 00:39:25,472 —> 00:39:27,160 there’s no sequence to them

1165 00:39:27,160 —> 00:39:29,019 the way the permitting process

1166 00:39:29,219 —> 00:39:31,498 happens here gets you going in parallel.

1167 00:39:31,820 —> 00:39:32,544 But the

1168 00:39:32,744 —> 00:39:36,578 but I get what you mean, like you could

1169 00:39:36,920 —> 00:39:39,800 potentially number the department’s,

1170 00:39:40,000 —> 00:39:41,880 so if you have a sequence,

1171 00:39:41,880 —> 00:39:44,090 you can put a number on the

1172 00:39:44,290 —> 00:39:45,322 formula field

1173 00:39:45,522 —> 00:39:48,100 to like give them a sequence so you

1174 00:39:48,100 —> 00:39:49,871 can sort by department

1175 00:39:50,071 —> 00:39:51,168 and then yeah,

1176 00:39:51,368 —> 00:39:54,380 just have like a volume bar and then it’s

1177 00:39:54,380 —> 00:39:55,296 basically because

1178 00:39:55,496 —> 00:39:56,698 it becomes a progress bar.

1179 00:39:56,820 —> 00:39:57,798 Right?

1180 00:39:58,320 —> 00:39:59,999 Yeah, I’ve done that in one

1181 00:40:00,199 —> 00:40:01,990 Interface with a bunch of tasks.

1182 00:40:01,990 —> 00:40:02,859 Like it’s not,

1183 00:40:03,059 —> 00:40:04,615 it’s not as pretty as this

1184 00:40:04,815 —> 00:40:06,710 because there’s way too many tasks.

1185 00:40:06,710 —> 00:40:08,041 I thought it looked better

1186 00:40:08,241 —> 00:40:08,860 than having like

1187 00:40:09,060 —> 00:40:10,660 the grid because it just took up too

1188 00:40:10,660 —> 00:40:12,900 much space. It looks very nice,

1189 00:40:13,100 —> 00:40:14,778 but yours looks way better

1190 00:40:15,110 —> 00:40:17,873 and you’re also using the non default

1191 00:40:18,073 —> 00:40:20,860 color scheme. I think it’s it was lost a

1192 00:40:20,860 —> 00:40:22,551 while ago that I don’t think

1193 00:40:22,751 —> 00:40:24,356 we’ve ever really mentioned,

1194 00:40:24,556 —> 00:40:25,330 but you have more

1195 00:40:25,330 —> 00:40:27,642 color options and Interfaces.

1196 00:40:27,842 —> 00:40:28,765 Yes, you do.

1197 00:40:28,965 —> 00:40:31,150 And like it’s a shame

1198 00:40:31,150 —> 00:40:34,288 because the it doesn’t give you control

1199 00:40:34,710 —> 00:40:36,116 of the color scheme.

1200 00:40:36,316 —> 00:40:37,797 Yeah, you can’t get it

1201 00:40:37,997 —> 00:40:39,210 exactly how you want,

1202 00:40:39,210 —> 00:40:40,503 but you don’t have to use

1203 00:40:40,703 —> 00:40:41,970 the default Airtable color

1204 00:40:42,170 —> 00:40:43,090 scheme that’s in like a

1205 00:40:43,090 —> 00:40:45,298 single select fields, for instance,

1206 00:40:45,498 —> 00:40:46,634 like I’ve got like,

1207 00:40:46,834 —> 00:40:48,010 like whenever I go into

1208 00:40:48,010 —> 00:40:49,579 edit mode and look at these

1209 00:40:49,779 —> 00:40:50,288 color schemes.

1210 00:40:50,410 —> 00:40:51,356 I’m like, okay,

1211 00:40:51,556 —> 00:40:52,578 tableau extended

1212 00:40:52,778 —> 00:40:53,568 science book.

1213 00:40:53,768 —> 00:40:55,390 Like I love science book but

1214 00:40:55,390 —> 00:40:56,068 it’s not useful

1215 00:40:56,310 —> 00:40:58,988 like there’s almost no

1216 00:40:59,370 —> 00:41:00,291 it’s too close.

1217 00:41:00,491 —> 00:41:02,553 And then like the one I really like

1218 00:41:02,753 —> 00:41:03,850 is the city lights one

1219 00:41:03,850 —> 00:41:05,385 because it’s always funky

1220 00:41:05,585 —> 00:41:07,406 but like you can’t control like

1221 00:41:07,606 —> 00:41:08,640 I want a proved to be

1222 00:41:08,640 —> 00:41:11,054 like a greenish color, right?

1223 00:41:11,254 —> 00:41:13,844 But you can’t control what color

1224 00:41:14,044 —> 00:41:15,300 from your palates.

1225 00:41:15,300 —> 00:41:15,878 Does what.

1226 00:41:16,110 —> 00:41:17,118 Yeah,

1227 00:41:17,410 —> 00:41:19,248 it would be great if you could have like

1228 00:41:19,540 —> 00:41:20,488 in your

1229 00:41:20,810 —> 00:41:23,308 status or like single select fields

1230 00:41:23,508 —> 00:41:26,020 or multi select fields to kind of like

1231 00:41:26,020 —> 00:41:28,173 assign one color to each

1232 00:41:28,373 —> 00:41:29,878 different status or

1233 00:41:30,310 —> 00:41:32,783 it would be great but it’s not there yet,

1234 00:41:32,983 —> 00:41:34,110 which is okay I guess.

1235 00:41:36,560 —> 00:41:37,378 What else do we have?

1236 00:41:37,910 —> 00:41:40,378 Oh this this one’s interesting. Alright so

1237 00:41:40,710 —> 00:41:44,452 another use that we typically use it for

1238 00:41:44,652 —> 00:41:47,540 when you have a brief from the

1239 00:41:47,540 —> 00:41:50,519 client. So this is a condition where

1240 00:41:50,719 —> 00:41:53,830 you’ve got a brief where you’ve got like

1241 00:41:53,830 —> 00:41:56,568 this is a done your hotel projects.

1242 00:41:56,768 —> 00:41:58,368 So data is not actually

1243 00:41:58,710 —> 00:41:59,182 real but

1244 00:41:59,382 —> 00:42:00,634 it’s basically saying,

1245 00:42:00,834 —> 00:42:01,743 oh you know what,

1246 00:42:01,943 —> 00:42:03,080 we’ve got specific number

1247 00:42:03,080 —> 00:42:05,129 of guest rooms and they need to be

1248 00:42:05,329 —> 00:42:06,411 this specific size.

1249 00:42:06,611 —> 00:42:07,720 And are you hitting the

1250 00:42:07,720 —> 00:42:08,205 targets?

1251 00:42:08,405 —> 00:42:10,162 How much space are you taking?

1252 00:42:10,362 —> 00:42:12,270 Because then we can use this data to

1253 00:42:12,270 —> 00:42:13,811 actually budget the project

1254 00:42:14,011 —> 00:42:15,361 or pass the data onwards

1255 00:42:15,561 —> 00:42:16,550 to make sure that it’s

1256 00:42:16,550 —> 00:42:17,778 actually feasible to be built.

1257 00:42:18,300 —> 00:42:20,882 So we’re basically breaking down

1258 00:42:21,082 —> 00:42:24,190 if I go, let’s see, can I go do I have it

1259 00:42:24,190 —> 00:42:27,858 below? Not here, maybe here, Yes. So

1260 00:42:28,700 —> 00:42:30,868 here what we’re doing, we’re looking at,

1261 00:42:31,300 —> 00:42:33,387 for example, guest rooms and suites,

1262 00:42:33,587 —> 00:42:34,720 king, guest room, king,

1263 00:42:34,720 —> 00:42:36,130 twin guest room,

1264 00:42:36,330 —> 00:42:38,658 deluxe, queen deluxe, king.

1265 00:42:38,858 —> 00:42:41,330 And you’ve got the target area,

1266 00:42:41,330 —> 00:42:43,191 the occupancy, the proposed area

1267 00:42:43,391 —> 00:42:44,324 and the occupancy

1268 00:42:44,524 —> 00:42:45,750 and what the deviation is.

1269 00:42:45,750 —> 00:42:46,930 So if you’ve gotten minus

1270 00:42:47,130 —> 00:42:48,316 in any field that means

1271 00:42:48,516 —> 00:42:49,290 you’re not hitting your

1272 00:42:49,290 —> 00:42:49,858 targets,

1273 00:42:50,900 —> 00:42:51,368 right?

1274 00:42:51,700 —> 00:42:53,526 So you’ve got a deviation

1275 00:42:53,726 —> 00:42:54,848 in terms of area

1276 00:42:55,048 —> 00:42:56,740 and a deviation in terms of

1277 00:42:56,740 —> 00:42:57,584 occupancy,

1278 00:42:57,784 —> 00:43:00,677 that you can basically just review.

1279 00:43:00,877 —> 00:43:03,240 So we do it for every aspect of

1280 00:43:03,240 —> 00:43:03,778 the building.

1281 00:43:04,100 —> 00:43:06,617 And this is a big building,

1282 00:43:06,817 —> 00:43:08,668 so we’re talking about

1283 00:43:10,100 —> 00:43:12,128 70,000 m2

1284 00:43:12,130 —> 00:43:15,368 in terms of building volume, so

1285 00:43:15,800 —> 00:43:18,444 knowing where the bulk of your space is

1286 00:43:18,644 —> 00:43:20,410 allocated is super important.

1287 00:43:20,410 —> 00:43:22,203 So we can tell from here,

1288 00:43:22,403 —> 00:43:23,509 for example that

1289 00:43:23,709 —> 00:43:25,860 you know what the guest rooms were

1290 00:43:25,860 —> 00:43:28,940 like 14,670 and we’ve managed to

1291 00:43:29,140 —> 00:43:31,058 get it down to 10,900.

1292 00:43:31,500 —> 00:43:33,390 So like in terms of optimizing

1293 00:43:33,590 —> 00:43:35,658 the budget and making sure that your

1294 00:43:36,100 —> 00:43:38,493 following your brief, it’s good.

1295 00:43:38,693 —> 00:43:40,960 What I haven’t been able to like,

1296 00:43:40,960 —> 00:43:42,252 this is one of my pet peeves

1297 00:43:42,452 —> 00:43:43,094 with Airtable,

1298 00:43:43,294 —> 00:43:44,560 you can’t customize the scale of

1299 00:43:44,560 —> 00:43:45,118 this.

1300 00:43:46,800 —> 00:43:48,375 Yeah, and it really bugs me

1301 00:43:48,575 —> 00:43:49,953 because it would be great

1302 00:43:50,153 —> 00:43:51,000 if I could see that

1303 00:43:51,000 —> 00:43:51,875 one’s there and you know

1304 00:43:52,075 —> 00:43:53,075 what the other ones over here,

1305 00:43:53,400 —> 00:43:53,715 right?

1306 00:43:53,915 —> 00:43:55,657 Or if I could get these side by side,

1307 00:43:55,857 —> 00:43:57,350 like one field here and the other

1308 00:43:57,350 —> 00:43:59,058 one, like directly adjacent to it,

1309 00:43:59,400 —> 00:44:01,682 which kind of like Excel,

1310 00:44:01,882 —> 00:44:04,968 Excel was so helpful in these cases.

1311 00:44:07,190 —> 00:44:08,612 Well, Chris we’ve got

1312 00:44:08,812 —> 00:44:09,726 we’ll wrap up,

1313 00:44:09,926 —> 00:44:12,270 we’ve got a question from Jan from the

1314 00:44:12,270 —> 00:44:13,417 community asking

1315 00:44:13,617 —> 00:44:14,990 how do you share the

1316 00:44:15,190 —> 00:44:16,570 dashboard with clients?

1317 00:44:16,570 —> 00:44:19,158 Do you give them access to the base?

1318 00:44:19,358 —> 00:44:21,458 And then also to explain F two f

1319 00:44:22,290 —> 00:44:26,236 Yes, well, a lot of it is face to face,

1320 00:44:26,436 —> 00:44:29,980 we don’t share, so if we get a client

1321 00:44:29,980 —> 00:44:32,958 into another table would be

1322 00:44:33,490 —> 00:44:35,637 if we are able to sync the data

1323 00:44:35,837 —> 00:44:38,130 and kind of like isolate it, then yes,

1324 00:44:38,130 —> 00:44:40,073 if they are on Airtable, we could

1325 00:44:40,273 —> 00:44:42,310 we don’t typically usually we have our

1326 00:44:42,310 —> 00:44:42,995 weekly calls

1327 00:44:43,195 —> 00:44:44,775 and we’ll go through dashboard

1328 00:44:44,975 —> 00:44:46,250 show them and go through it.

1329 00:44:46,250 —> 00:44:48,468 So it is more a lot of it is face to face.

1330 00:44:48,690 —> 00:44:50,851 We’ve shared views in the past,

1331 00:44:51,051 —> 00:44:53,708 we don’t share the dashboards themselves.

1332 00:44:53,990 —> 00:44:55,999 But we share snapshots

1333 00:44:56,199 —> 00:44:57,806 of the dashboards,

1334 00:44:58,006 —> 00:45:00,930 which is kind of like a workaround.

1335 00:45:00,930 —> 00:45:02,667 So we basically just

1336 00:45:02,867 —> 00:45:05,156 if we wanted to share this,

1337 00:45:05,356 —> 00:45:07,530 we could basically just do a

1338 00:45:07,530 —> 00:45:09,070 full page screenshots,

1339 00:45:09,270 —> 00:45:11,503 which is that so screen capturing

1340 00:45:11,703 —> 00:45:13,060 process and then we can

1341 00:45:13,060 —> 00:45:14,158 just share this.

1342 00:45:14,390 —> 00:45:17,494 So that’s the way around it.

1343 00:45:17,694 —> 00:45:19,268 So it’s a static

1344 00:45:19,890 —> 00:45:20,940 piece of information

1345 00:45:21,140 —> 00:45:22,236 at that point in time.

1346 00:45:22,436 —> 00:45:23,880 If they want to go through it,

1347 00:45:23,880 —> 00:45:24,873 we have our calls

1348 00:45:25,073 —> 00:45:26,920 and we can we can do like a quick

1349 00:45:27,120 —> 00:45:28,320 15 minute session just to

1350 00:45:28,320 —> 00:45:29,101 walk through it

1351 00:45:29,301 —> 00:45:30,592 if they have any questions

1352 00:45:30,792 —> 00:45:32,380 but yeah typically we won’t add them

1353 00:45:32,380 —> 00:45:35,058 to the bases if the bases have

1354 00:45:35,590 —> 00:45:36,558 too much data.

1355 00:45:38,490 —> 00:45:39,324 Very cool.

1356 00:45:39,524 —> 00:45:41,493 That’s awesome stuff Chris

1357 00:45:41,693 —> 00:45:44,820 thank you so much for sharing with us and

1358 00:45:44,820 —> 00:45:46,515 giving insight into how

1359 00:45:46,715 —> 00:45:48,841 real companies use Airtable,

1360 00:45:49,041 —> 00:45:49,980 what’s been the

1361 00:45:49,980 —> 00:45:51,472 impression of the team

1362 00:45:51,672 —> 00:45:54,048 as they’ve been interacting with this?

1363 00:45:56,390 —> 00:45:57,918 Well it’s

1364 00:45:58,590 —> 00:45:59,317 it’s picking up,

1365 00:45:59,517 —> 00:46:00,591 they see the value in it,

1366 00:46:00,791 —> 00:46:02,180 they’re like it would be difficult to

1367 00:46:02,180 —> 00:46:03,259 not look at it

1368 00:46:03,459 —> 00:46:05,648 and not see the value in it.

1369 00:46:06,180 —> 00:46:08,138 I think that the real challenge

1370 00:46:08,338 —> 00:46:09,338 is actually getting

1371 00:46:10,180 —> 00:46:12,049 getting people to start inputting

1372 00:46:12,249 —> 00:46:13,249 the data and being

1373 00:46:13,460 —> 00:46:15,838 like interested in putting the data, so

1374 00:46:16,180 —> 00:46:17,512 it’s not part of your

1375 00:46:17,712 —> 00:46:18,908 normal job description

1376 00:46:19,480 —> 00:46:21,538 right? So it

1377 00:46:22,980 —> 00:46:24,958 getting people into the mindset of

1378 00:46:25,158 —> 00:46:27,110 oh you know what, I’ve got this data,

1379 00:46:27,110 —> 00:46:29,958 how can I make better use of it?

1380 00:46:30,280 —> 00:46:32,105 Because we usually get data

1381 00:46:32,305 —> 00:46:33,925 from the work that we do,

1382 00:46:34,125 —> 00:46:35,350 like whether it’s like

1383 00:46:35,350 —> 00:46:37,423 floor areas and floor plan

1384 00:46:37,623 —> 00:46:41,010 or like quantities that we have to review.

1385 00:46:41,010 —> 00:46:43,788 Like schedules of doors and windows,

1386 00:46:43,988 —> 00:46:46,720 which is really who really cares about

1387 00:46:46,720 —> 00:46:47,248 that but

1388 00:46:47,480 —> 00:46:49,089 in terms of like itemizing

1389 00:46:49,289 —> 00:46:51,378 the data and being able to review it,

1390 00:46:51,480 —> 00:46:52,376 it’s super useful

1391 00:46:52,576 —> 00:46:53,321 and grouping it

1392 00:46:53,521 —> 00:46:54,960 and having it organized by types.

1393 00:46:54,960 —> 00:46:56,937 Like I’ve done it in the past

1394 00:46:57,137 —> 00:46:58,704 and like I can’t imagine

1395 00:46:58,904 —> 00:47:00,140 not doing it. Like I’ve

1396 00:47:00,140 —> 00:47:01,134 had to do it with

1397 00:47:01,334 —> 00:47:02,654 pivot tables in excel once

1398 00:47:02,854 —> 00:47:04,540 and I wanted to pull my hair out.

1399 00:47:04,540 —> 00:47:07,458 And I did it twice in one year

1400 00:47:07,780 —> 00:47:09,931 so doing in Airtable was

1401 00:47:10,131 —> 00:47:13,248 obviously a better solution but yeah.

1402 00:47:14,080 —> 00:47:17,058 Cool. Yeah that’s always the issue is

1403 00:47:17,258 —> 00:47:18,810 it’s only as good as

1404 00:47:19,010 —> 00:47:20,518 the data that’s in it.

1405 00:47:20,540 —> 00:47:23,558 Sorry I’ve got I’ve got a small visitor

1406 00:47:24,280 —> 00:47:26,248 Welcome

1407 00:47:28,170 —> 00:47:29,028 Junior.

1408 00:47:31,080 —> 00:47:31,548 All right,

1409 00:47:33,910 —> 00:47:35,197 alright, very good.

1410 00:47:35,397 —> 00:47:36,312 We’ll move on.

1411 00:47:36,512 —> 00:47:38,990 Thank you Chris for sharing that with us.

1412 00:47:38,990 —> 00:47:41,744 Final plug for our BuiltOnAir community,

1413 00:47:41,944 —> 00:47:44,360 join us. Amazing people like Chris and

1414 00:47:44,360 —> 00:47:46,258 many other we have thousands of

1415 00:47:46,680 —> 00:47:48,321 people in our slack community.

1416 00:47:48,521 —> 00:47:50,400 We’d love to have you join us as well.

1417 00:47:50,400 —> 00:47:52,098 builtonair.com/join.

1418 00:47:52,298 —> 00:47:54,390 Get in the slack community.

1419 00:47:54,390 —> 00:47:56,459 Subscribe to the newsletter.

1420 00:47:56,659 —> 00:47:58,441 Get up to date on all the

1421 00:47:58,641 —> 00:48:00,080 new happenings when the

1422 00:48:00,080 —> 00:48:01,581 podcast is released

1423 00:48:01,781 —> 00:48:03,549 and all that fun stuff.

1424 00:48:03,749 —> 00:48:06,240 So we’d love to have you join us if

1425 00:48:06,240 —> 00:48:08,048 you’re not already in our community,

1426 00:48:08,660 —> 00:48:11,080 we will wrap up with Kamille

1427 00:48:11,280 —> 00:48:14,538 walking through some Google drive stuff.

1428 00:48:15,370 —> 00:48:16,548 There you go.

1429 00:48:16,870 —> 00:48:17,938 Is my screen up?

1430 00:48:18,570 —> 00:48:19,538 Yep. Okay.

1431 00:48:20,270 —> 00:48:21,938 So I

1432 00:48:22,570 —> 00:48:24,966 am again one of the very few

1433 00:48:25,166 —> 00:48:28,560 people that will be affected by Airtable’s

1434 00:48:28,560 —> 00:48:31,828 move away from permanent attachment links,

1435 00:48:33,170 —> 00:48:34,568 you know, being reliable

1436 00:48:34,768 —> 00:48:36,009 outside of Airtable

1437 00:48:36,209 —> 00:48:37,641 if you’re using the API to

1438 00:48:37,841 —> 00:48:39,034 grab a static link

1439 00:48:39,234 —> 00:48:40,612 to an attachment image.

1440 00:48:40,812 —> 00:48:42,110 It’s not gonna work after

1441 00:48:42,110 —> 00:48:42,838 November.

1442 00:48:43,370 —> 00:48:46,748 And because the way my old website was,

1443 00:48:47,570 —> 00:48:48,749 you know, set up,

1444 00:48:48,949 —> 00:48:51,038 I was storing all of my images in

1445 00:48:51,370 —> 00:48:53,268 Airtable’s attachment fields

1446 00:48:53,400 —> 00:48:55,638 and pulling those static

1447 00:48:56,170 —> 00:48:58,297 URLs to display them on my website.

1448 00:48:58,497 —> 00:49:00,120 Well I have to think through a

1449 00:49:00,120 —> 00:49:02,115 different way of organizing

1450 00:49:02,315 —> 00:49:02,886 my stuff

1451 00:49:03,086 —> 00:49:04,124 and I remembered

1452 00:49:04,324 —> 00:49:05,810 that I basically store all

1453 00:49:05,810 —> 00:49:08,448 of my files on Google drive anyway

1454 00:49:08,870 —> 00:49:11,361 so I have been going through

1455 00:49:11,561 —> 00:49:13,987 the process of transitioning

1456 00:49:14,187 —> 00:49:15,720 my methodology to

1457 00:49:15,720 —> 00:49:17,638 keeping all of my stuff on

1458 00:49:18,070 —> 00:49:19,135 Google drive

1459 00:49:19,335 —> 00:49:22,113 and associating each of my files

1460 00:49:22,313 —> 00:49:24,370 with the relevant project.

1461 00:49:24,370 —> 00:49:25,815 So my file structure

1462 00:49:26,015 —> 00:49:27,833 for Google drive is set up

1463 00:49:28,033 —> 00:49:29,790 where I have a portfolio top

1464 00:49:29,790 —> 00:49:30,628 level folder,

1465 00:49:31,070 —> 00:49:33,007 and Airtable’s reading that folder

1466 00:49:33,207 —> 00:49:34,120 and pulling it in

1467 00:49:34,320 —> 00:49:35,570 through their native Google

1468 00:49:35,570 —> 00:49:37,159 drive integration sync

1469 00:49:37,359 —> 00:49:39,169 which is very very helpful

1470 00:49:39,369 —> 00:49:40,770 and I’m just gonna talk

1471 00:49:40,770 —> 00:49:42,604 through a couple of things

1472 00:49:42,804 —> 00:49:44,294 that I’ve done to help

1473 00:49:44,494 —> 00:49:45,920 the process along and my

1474 00:49:45,920 —> 00:49:48,338 Interface that I used to control which

1475 00:49:48,690 —> 00:49:51,248 images will eventually appear on my site.

1476 00:49:51,370 —> 00:49:52,138 So

1477 00:49:52,570 —> 00:49:55,373 when you sync into Airtable

1478 00:49:55,573 —> 00:49:58,280 you get A URL, or not a URL

1479 00:49:58,280 —> 00:50:00,928 a file path of the top level folder

1480 00:50:01,330 —> 00:50:02,750 that you’ve selected to sync.

1481 00:50:02,950 —> 00:50:04,368 And then all of the sub folders

1482 00:50:04,568 —> 00:50:05,100 leading into the

1483 00:50:05,100 —> 00:50:05,978 actual file.

1484 00:50:06,660 —> 00:50:09,055 I’m using a combination of

1485 00:50:09,255 —> 00:50:11,538 find and Rejex to pull out

1486 00:50:11,960 —> 00:50:13,414 pieces of information.

1487 00:50:13,614 —> 00:50:16,190 So I have a very regulated file structure.

1488 00:50:16,190 —> 00:50:19,130 I put everything by the project type.

1489 00:50:19,330 —> 00:50:20,994 It’s either urban planning

1490 00:50:21,194 —> 00:50:22,019 or it’s Airtable

1491 00:50:22,219 —> 00:50:24,339 or its graphic design or something.

1492 00:50:24,539 —> 00:50:26,520 That’s the first sub folder and then

1493 00:50:26,520 —> 00:50:27,858 the second sub folder

1494 00:50:28,058 —> 00:50:30,019 is going to be the project name.

1495 00:50:30,219 —> 00:50:31,490 And then from there it’s

1496 00:50:31,490 —> 00:50:32,633 a free for all because

1497 00:50:32,833 —> 00:50:33,860 for planning projects

1498 00:50:34,060 —> 00:50:35,230 I have way more attachments.

1499 00:50:35,230 —> 00:50:36,361 Some of them are images.

1500 00:50:36,561 —> 00:50:37,487 Some of them are pdf.

1501 00:50:37,687 —> 00:50:38,810 Some of them are working files

1502 00:50:38,810 —> 00:50:40,738 like illustrator or sketch up.

1503 00:50:41,160 —> 00:50:42,449 For Airtable projects,

1504 00:50:42,649 —> 00:50:43,976 it’s only gonna be images

1505 00:50:44,176 —> 00:50:45,250 and there’s not gonna be

1506 00:50:45,250 —> 00:50:46,818 those sub folders. So

1507 00:50:47,960 —> 00:50:49,198 my last

1508 00:50:50,160 —> 00:50:51,950 formula field is a little bit

1509 00:50:52,150 —> 00:50:53,000 more complicated

1510 00:50:53,200 —> 00:50:55,328 to get what the name of the project is.

1511 00:50:55,760 —> 00:50:57,426 I’m not going to explain this

1512 00:50:57,626 —> 00:50:59,840 in detail because this would take forever.

1513 00:50:59,840 —> 00:51:02,094 But essentially I’m saying

1514 00:51:02,294 —> 00:51:04,915 if it’s urban planning project,

1515 00:51:05,115 —> 00:51:06,690 it probably has a sub

1516 00:51:06,690 —> 00:51:08,981 folder that I have to parse out

1517 00:51:09,181 —> 00:51:10,238 and get just what

1518 00:51:10,560 —> 00:51:12,298 the name of the project is.

1519 00:51:12,450 —> 00:51:13,188 If it’s

1520 00:51:13,560 —> 00:51:14,758 a Airtable project,

1521 00:51:14,958 —> 00:51:17,266 it probably doesn’t have a sub folder.

1522 00:51:17,466 —> 00:51:18,480 And it’s more simple

1523 00:51:18,480 —> 00:51:19,818 to get that the project name is.

1524 00:51:20,460 —> 00:51:21,583 So at the end of the day

1525 00:51:21,783 —> 00:51:22,745 I have a formula field

1526 00:51:22,945 —> 00:51:23,970 that just spits out what the

1527 00:51:23,970 —> 00:51:26,738 name of the project is based on the

1528 00:51:27,060 —> 00:51:29,211 one of the folders in the file path.

1529 00:51:29,411 —> 00:51:31,600 And then I have a simple automation that

1530 00:51:31,600 —> 00:51:33,872 will take that and copy and paste it

1531 00:51:34,072 —> 00:51:35,828 into the link to project field.

1532 00:51:36,360 —> 00:51:37,278 And that’s what happens.

1533 00:51:38,460 —> 00:51:40,827 Then if we take a look at my

1534 00:51:41,027 —> 00:51:42,588 demo website again,

1535 00:51:42,788 —> 00:51:44,970 I was building this in Glide.

1536 00:51:44,970 —> 00:51:47,092 It hasn’t really gone live yet.

1537 00:51:47,292 —> 00:51:49,064 But I’m either going to use

1538 00:51:49,264 —> 00:51:50,310 this thing or use a

1539 00:51:50,310 —> 00:51:51,762 very, very similar process

1540 00:51:51,962 —> 00:51:53,828 to what I’m showing here. And you can

1541 00:51:54,260 —> 00:51:55,943 see that I have one image

1542 00:51:56,143 —> 00:51:57,242 that will show up

1543 00:51:57,442 —> 00:51:59,310 when you’re looking at a grid of

1544 00:51:59,310 —> 00:52:00,556 all of my projects.

1545 00:52:00,756 —> 00:52:01,893 And again it will,

1546 00:52:02,093 —> 00:52:04,230 it’ll appear here. But if I look at a

1547 00:52:04,230 —> 00:52:05,820 gallery of images,

1548 00:52:06,020 —> 00:52:07,911 I have a lot of images

1549 00:52:08,111 —> 00:52:10,060 that are also associated.

1550 00:52:10,060 —> 00:52:12,218 So the way I accomplished that

1551 00:52:12,640 —> 00:52:15,618 in my setup is to have a column for

1552 00:52:16,050 —> 00:52:18,085 a check box that should this

1553 00:52:18,285 —> 00:52:20,032 image appear on the site?

1554 00:52:20,232 —> 00:52:21,500 And is this image the

1555 00:52:21,500 —> 00:52:22,428 cover image?

1556 00:52:22,950 —> 00:52:24,963 And the easiest way to go through

1557 00:52:25,163 —> 00:52:27,280 all of my files is to look at it in an

1558 00:52:27,280 —> 00:52:28,728 Interface. So

1559 00:52:29,150 —> 00:52:31,429 it’s a fairly simple setup.

1560 00:52:31,629 —> 00:52:33,919 I have a list of my projects

1561 00:52:34,119 —> 00:52:35,228 off to the left.

1562 00:52:35,750 —> 00:52:37,523 And then in the center view,

1563 00:52:37,723 —> 00:52:38,806 I just have simply

1564 00:52:39,006 —> 00:52:40,310 all I need to know is the

1565 00:52:40,310 —> 00:52:41,576 name of the project.

1566 00:52:41,776 —> 00:52:44,108 And then I have a bunch of number fields

1567 00:52:44,730 —> 00:52:46,928 to help me see

1568 00:52:47,450 —> 00:52:49,394 whether or not I think I have

1569 00:52:49,594 —> 00:52:51,009 enough images that are

1570 00:52:51,209 —> 00:52:52,680 marked as published and

1571 00:52:52,680 —> 00:52:54,794 whether or not I have a cover photo.

1572 00:52:54,994 —> 00:52:57,260 So I’ve gone in and unchecked one of these

1573 00:52:57,260 —> 00:52:59,228 boxes just so that you could see.

1574 00:52:59,550 —> 00:53:01,571 That’s what the use case is.

1575 00:53:01,771 —> 00:53:03,641 I only need one cover image

1576 00:53:03,841 —> 00:53:04,841 and it’s that one

1577 00:53:05,550 —> 00:53:07,009 and having this up at the top

1578 00:53:07,209 —> 00:53:08,820 just lets me know at a quick glance,

1579 00:53:08,820 —> 00:53:10,441 oh I forgot to fill this one in.

1580 00:53:10,641 —> 00:53:11,808 Let me go back and do that.

1581 00:53:12,450 —> 00:53:14,518 But with this layout

1582 00:53:14,718 —> 00:53:18,163 I’m able to look at the thumbnail.

1583 00:53:18,363 —> 00:53:19,480 Obviously the

1584 00:53:19,480 —> 00:53:21,649 thumbnails pulled in from the sync

1585 00:53:21,849 —> 00:53:24,010 are very small versions of the image.

1586 00:53:24,010 —> 00:53:25,604 So it’s I can’t really

1587 00:53:25,804 —> 00:53:27,343 see it in all its glory,

1588 00:53:27,543 —> 00:53:29,400 but if I wanted to view it in

1589 00:53:29,400 —> 00:53:31,355 full I could click the button

1590 00:53:31,555 —> 00:53:34,118 that comes along with the integration and

1591 00:53:34,350 —> 00:53:36,048 view the image

1592 00:53:36,130 —> 00:53:36,728 you know

1593 00:53:37,450 —> 00:53:37,818 it

1594 00:53:38,250 —> 00:53:40,258 larger in case I have very similar

1595 00:53:40,458 —> 00:53:41,238 looking images

1596 00:53:41,438 —> 00:53:42,798 and I need to pick which one

1597 00:53:42,900 —> 00:53:44,808 is the one I have that button there.

1598 00:53:45,250 —> 00:53:46,457 I also have the name

1599 00:53:46,657 —> 00:53:47,807 of the file in there.

1600 00:53:48,007 —> 00:53:49,560 I’ve been considering whether or

1601 00:53:49,560 —> 00:53:51,670 not to add another column

1602 00:53:51,870 —> 00:53:54,118 for caption because sometimes

1603 00:53:54,450 —> 00:53:56,204 you know the name of the image.

1604 00:53:56,404 —> 00:53:57,475 If I haven’t gone in

1605 00:53:57,675 —> 00:53:58,920 and renamed something might

1606 00:53:58,920 —> 00:54:00,631 not be what I want to show as

1607 00:54:00,831 —> 00:54:02,289 the caption on my website.

1608 00:54:02,489 —> 00:54:03,580 So that may be the next

1609 00:54:03,580 —> 00:54:05,905 step for me in my file manager Interface.

1610 00:54:06,105 —> 00:54:08,060 Just adding a quick little column that

1611 00:54:08,060 —> 00:54:10,167 says caption and then telling

1612 00:54:10,367 —> 00:54:11,447 Glide to pull in

1613 00:54:11,647 —> 00:54:13,608 that field versus the file name.

1614 00:54:14,140 —> 00:54:15,947 And then of course my two

1615 00:54:16,147 —> 00:54:18,229 check boxes for whether or not

1616 00:54:18,429 —> 00:54:19,200 I want this to

1617 00:54:19,200 —> 00:54:20,218 appear on the site

1618 00:54:20,910 —> 00:54:22,047 and I have it grouped.

1619 00:54:22,247 —> 00:54:23,908 So here are the ones that I’ve said

1620 00:54:24,340 —> 00:54:26,747 I want to keep them in my Google drive

1621 00:54:26,947 —> 00:54:29,030 so I always have access to them but I

1622 00:54:29,030 —> 00:54:31,343 don’t necessarily need them on my website.

1623 00:54:31,543 —> 00:54:33,380 I wanted to make sure that all of the

1624 00:54:33,380 —> 00:54:35,398 good ones, the ones that are really gonna,

1625 00:54:35,940 —> 00:54:37,357 you know, pull people’s attention

1626 00:54:37,557 —> 00:54:38,688 are the ones that get published

1627 00:54:38,760 —> 00:54:41,598 and having it in an Interface means I can

1628 00:54:42,540 —> 00:54:46,008 focus in on the information I want to see

1629 00:54:46,340 —> 00:54:47,432 very, very quickly

1630 00:54:47,632 —> 00:54:49,141 and then switch in between

1631 00:54:49,341 —> 00:54:50,708 projects also very quickly.

1632 00:54:51,040 —> 00:54:52,995 So that’s pretty much it

1633 00:54:53,195 —> 00:54:55,520 for how I’ve laid everything out.

1634 00:54:55,720 —> 00:54:56,750 I showed the other

1635 00:54:56,750 —> 00:54:59,030 part of this Interface before,

1636 00:54:59,230 —> 00:55:00,986 which shows each project

1637 00:55:01,186 —> 00:55:02,450 and then information

1638 00:55:02,450 —> 00:55:04,002 about each one that allows me

1639 00:55:04,202 —> 00:55:05,608 to edit things really quickly.

1640 00:55:06,440 —> 00:55:08,964 But the file manager I think

1641 00:55:09,164 —> 00:55:10,829 is probably the one

1642 00:55:11,029 —> 00:55:13,020 I’m going to use the most

1643 00:55:13,020 —> 00:55:13,808 because

1644 00:55:14,440 —> 00:55:16,305 I might add as the project goes on,

1645 00:55:16,505 —> 00:55:18,490 I might make a new graphic that I want to

1646 00:55:18,490 —> 00:55:19,746 appear on the website

1647 00:55:19,946 —> 00:55:22,018 and I want to be able to review things

1648 00:55:22,640 —> 00:55:24,798 fast enough and make sure that

1649 00:55:24,998 —> 00:55:25,897 I have enough

1650 00:55:26,097 —> 00:55:28,108 that’s displayed on the website.

1651 00:55:30,340 —> 00:55:30,898 That’s it.

1652 00:55:32,440 —> 00:55:33,058 That’s cool.

1653 00:55:34,540 —> 00:55:36,031 I do think, I mean, I think

1654 00:55:36,231 —> 00:55:38,130 we’re just gonna see more and more of,

1655 00:55:38,130 —> 00:55:39,894 you know, Airtable’s the back end

1656 00:55:40,094 —> 00:55:42,140 and then some maybe something else for the

1657 00:55:42,140 —> 00:55:43,027 front end.

1658 00:55:43,227 —> 00:55:45,216 But this just showcases

1659 00:55:45,416 —> 00:55:47,638 how useful that scenario is,

1660 00:55:50,340 —> 00:55:53,598 awesome. Thank you Kamille.

1661 00:55:54,340 —> 00:55:55,038 Cool.

1662 00:55:55,130 —> 00:55:57,876 That wraps up our show for today.

1663 00:55:58,076 —> 00:56:01,288 Any final parts before we end our season?

1664 00:56:05,150 —> 00:56:06,367 I’m bummed we’re at the end

1665 00:56:06,567 —> 00:56:07,567 of the season.

1666 00:56:11,730 —> 00:56:13,211 Maybe actually take a vacation.

1667 00:56:13,411 —> 00:56:15,170 I don’t know, I haven’t done this summer.

1668 00:56:15,170 —> 00:56:15,738 I need to,

1669 00:56:17,830 —> 00:56:19,708 we’re going to stay here

1670 00:56:19,908 —> 00:56:21,898 and we’re gonna work nonstop

1671 00:56:22,230 —> 00:56:24,212 so that we have just the

1672 00:56:24,412 —> 00:56:26,608 coolest looking Interfaces.

1673 00:56:27,530 —> 00:56:30,128 That’s probably in the reality.

1674 00:56:32,130 —> 00:56:33,511 Okay. So for the previous

1675 00:56:33,711 —> 00:56:35,076 competitions that Airtable

1676 00:56:35,276 —> 00:56:36,440 has done the scripting one

1677 00:56:36,440 —> 00:56:37,698 and the

1678 00:56:38,130 —> 00:56:39,252 Custom Blocks one,

1679 00:56:39,452 —> 00:56:41,251 the entries were like publicly

1680 00:56:41,451 —> 00:56:42,930 accessible in like a gallery

1681 00:56:42,930 —> 00:56:43,805 kind of thing.

1682 00:56:44,005 —> 00:56:45,152 Are the Interfaces,

1683 00:56:45,352 —> 00:56:46,441 do we know if those

1684 00:56:46,641 —> 00:56:47,930 are going to be available?

1685 00:56:47,930 —> 00:56:50,508 I ask because we have a full month

1686 00:56:51,140 —> 00:56:52,579 sort of that we’re going

1687 00:56:52,779 —> 00:56:53,779 to be off and then

1688 00:56:54,030 —> 00:56:55,285 I think by the time

1689 00:56:55,485 —> 00:56:57,204 we come back with season 12

1690 00:56:57,404 —> 00:56:59,050 we might be able to do like a

1691 00:56:59,050 —> 00:57:00,710 just a review and looking through

1692 00:57:00,910 —> 00:57:02,270 some of the submissions. Maybe?

1693 00:57:02,270 —> 00:57:02,798 I don’t know.

1694 00:57:03,230 —> 00:57:05,342 I think a lot of people are sharing them

1695 00:57:05,542 —> 00:57:07,190 on the actual post in the community

1696 00:57:07,190 —> 00:57:07,738 because

1697 00:57:08,070 —> 00:57:09,831 I think Kuovonne had asked that question

1698 00:57:10,031 —> 00:57:11,020 to Jordan and she was like,

1699 00:57:11,020 —> 00:57:13,278 oh, I’d love if you just post it here too

1700 00:57:13,350 —> 00:57:14,869 hopefully we’ll have a

1701 00:57:15,069 —> 00:57:16,388 nice repository there.

1702 00:57:17,830 —> 00:57:20,520 Yeah. I’m curious to see what other people

1703 00:57:20,720 —> 00:57:22,890 do because I have I think a handful

1704 00:57:22,890 —> 00:57:25,706 of Interfaces that I personally use

1705 00:57:25,906 —> 00:57:27,798 myself that I’ve built and

1706 00:57:29,030 —> 00:57:30,522 I, the way I design things,

1707 00:57:30,722 —> 00:57:31,921 a lot of my stuff looks

1708 00:57:32,121 —> 00:57:33,120 similar because I have,

1709 00:57:33,120 —> 00:57:34,846 I’m very particular about the way

1710 00:57:35,046 —> 00:57:36,123 I want stuff laid out.

1711 00:57:36,323 —> 00:57:37,200 And so I am curious to

1712 00:57:37,200 —> 00:57:38,588 see how other people

1713 00:57:39,430 —> 00:57:40,545 set their stuff up.

1714 00:57:40,745 —> 00:57:42,261 Even if I have a completely

1715 00:57:42,461 —> 00:57:43,890 different use case like Chris

1716 00:57:43,890 —> 00:57:45,269 was showing with the way

1717 00:57:45,469 —> 00:57:46,730 you’ve done your chart.

1718 00:57:46,930 —> 00:57:48,430 It’s so simple and yet it never

1719 00:57:48,430 —> 00:57:50,009 occurred to me to

1720 00:57:50,209 —> 00:57:52,888 use a chart in that way. And so

1721 00:57:53,330 —> 00:57:57,603 now I want to see everybody’s stuff.

1722 00:57:57,803 —> 00:57:59,028 I’m excited.

1723 00:57:59,080 —> 00:58:00,618 We should just have like an

1724 00:58:00,818 —> 00:58:02,498 Interface share day or something.

1725 00:58:02,830 —> 00:58:04,096 Yeah, yeah, for sure.

1726 00:58:04,296 —> 00:58:05,438 We’ll go through it.

1727 00:58:05,638 —> 00:58:06,750 So cool. I’m gonna end,

1728 00:58:06,750 —> 00:58:08,086 I’m gonna end the show

1729 00:58:08,286 —> 00:58:09,784 and thankful for everybody

1730 00:58:09,984 —> 00:58:10,820 that participated,

1731 00:58:10,820 —> 00:58:12,909 we will be back with you in September.

1732 00:58:13,109 —> 00:58:14,109 Take care, everyone.

1733 00:58:15,130 —> 00:58:17,098 Thank you. Bye.

Share: