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

Duration: 56 minutes

Be Sure to Subscribe to the podcast!

To get all the latest videos and demonstrations from the BuiltOnAir Podcast, subscribe and get notified on our Youtube channel here and our newsletter/community here.

FULL EPISODE VIDEO

Watch the full video of the show. See below for segment details.

FULL EPISODE AUDIO

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

Listen On: Apple | Overcast | Spotify


The BuiltOnAir Podcast is Sponsored by On2Air – Integrations and App extensions to run your business operations in Airtable.

In This Episode

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

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

Todays Hosts

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

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

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

Show Segments

Round The Bases – 00: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.