7/26/2022 – BuiltOnAir Live Podcast Full Show – S11-E12
Duration: 56 minutes
To get all the latest videos and demonstrations from the BuiltOnAir Podcast, subscribe and get notified on our Youtube channel here and our newsletter/community here.
FULL EPISODE VIDEO
Watch the full video of the show. See below for segment details.
FULL EPISODE AUDIO
Listen to the full Audio podcast for this episode here. Or add to your favorite podcast player
Listen On: Apple | Overcast | Spotify
The BuiltOnAir Podcast is Sponsored by On2Air – Integrations and App extensions to run your business operations in Airtable.
Start a FREE 14 Day Trial of On2Air Now
In This Episode
Welcome to the BuiltOnAir Podcast, the live show. The BuiltOnAir Podcast is a live weekly show highlighting everything happening in the Airtable world.
Check us out at BuiltOnAir.com. Join our community, join our Slack Channel, and meet your fellow Airtable fans.
Todays Hosts
Alli Alosa – Hi there! I’m Alli 🙂 I’m a fine artist turned “techie” with a passion for organization and automation. I’m also proud to be a Community Leader in the Airtable forum, and a co-host of the BuiltOnAir podcast. My favorite part about being an Airtable consultant and developer is that I get to talk with people from all sorts of industries, and each project is an opportunity to learn how a business works.
Kamille Parks – I am an Airtable Community Forums Leader and the developer behind the custom Airtable app “Scheduler”, one of the winning projects in the Airtable Custom Blocks Contest now widely available on the Marketplace. I focus on building simple scripts, automations, and custom apps for Airtable that streamline data entry and everyday workflows.
Dan Fellars – I am the Founder of Openside, On2Air, and BuiltOnAir. I love automation and software. When not coding the next feature of On2Air, I love spending time with my wife and kids and golfing.
Show Segments
Round The Bases – 00:03:32 –
Meet the Creators – 00:18:53 –
Meet Chris Zantis.
Chris Zantis is a Registered Architect in the UK (ARB) and Cyprus (ETEK). He is a graduate of the Department of Architecture of the University of Cyprus and holds an MA in Enterpreneurship from Goldsmiths University of London. He has worked in several award-winning practices in London, participating in the design and delivery of a wide range of structures and spaces, such as Private Residences, Hotels, Skyscrapers, Commercial/Office Spaces, Manufacturing Facilities, Shopping Centres and Retail.Since 2019, he has repatriated to Cyprus after several years working in London and is currently working as an Architect in Limassol. His current interest is the induction of innovative design technologies in the analysis, composition and organisation of Building Information.He discovered Airtable while working for back in 2017 and immediately fell in love with it. Since then he’s been using it to build bases that are either targeted to support Design Operations, or as a tool to organise and analyse Building Data, Project Budgets, and Client Reporting.
Base Showcase – 00:29:32 –
We dive into a full working base that will Chris will showcase some bases he uses in his Architectural Practice
A Case for Interface – 00:49:54 –
Explore Interfaces with “Google Drive Interface”.
Kamille will showcase an interface to interact with her Google Drive files..
Full Segment Details

Segment: Round The Bases
Start Time: 00:03:32
Roundup of what’s happening in the Airtable communities – Airtable, BuiltOnAir, Reddit, Facebook, YouTube, and Twitter.

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

Segment: Base Showcase
Start Time: 00:29:32
Airtable for Architecture
We dive into a full working base that will Chris will showcase some bases he uses in his Architectural Practice

Segment: A Case for Interface
Start Time: 00:49:54
Google Drive Interface
Explore Interfaces with “Google Drive Interface”.
Kamille will showcase an interface to interact with her Google Drive files..
Full Transcription
The full transcription for the show can be found here:
1 00:00:01,540 --> 00:00:04,640 Welcome to the BuiltOnAir podcast.2 00:00:04,840 —> 00:00:07,010 We are live for season 11,
3 00:00:07,010 —> 00:00:08,226 episode 12.
4 00:00:08,425 —> 00:00:10,924 Last show of season 11.
5 00:00:11,124 —> 00:00:13,640 It’s good to be with you.
6 00:00:13,640 —> 00:00:15,296 We’ve got a full show with us
7 00:00:15,496 —> 00:00:16,302 as you can see,
8 00:00:16,502 —> 00:00:17,808 we’ve got a full house today
9 00:00:17,940 —> 00:00:19,636 myself. Kamille and Alli
10 00:00:19,836 —> 00:00:21,262 the regulars with us.
11 00:00:21,462 —> 00:00:23,028 Welcome back. Welcome Alli,
12 00:00:23,340 —> 00:00:25,095 been a couple of weeks without you.
13 00:00:25,295 —> 00:00:26,295 Good to have you back.
14 00:00:26,830 —> 00:00:27,198 Glad to be back
15 00:00:28,040 —> 00:00:30,449 and we’ve got a special guest with us.
16 00:00:30,649 —> 00:00:32,288 Chris Zantis, welcome Chris,
17 00:00:32,740 —> 00:00:34,144 Thank you. Nice to be here.
18 00:00:34,344 —> 00:00:35,565 Good to have you with us.
19 00:00:35,765 —> 00:00:36,640 We’ll learn more about
20 00:00:36,640 —> 00:00:39,370 Chris and his story later in the show.
21 00:00:39,570 —> 00:00:42,100 So always good to have people with us.
22 00:00:42,100 —> 00:00:43,161 I’m gonna give us
23 00:00:43,361 —> 00:00:44,908 a little bit more room here,
24 00:00:45,540 —> 00:00:47,126 get rid of the branding
25 00:00:47,326 —> 00:00:49,505 that we can see everyone’s faces.
26 00:00:49,705 —> 00:00:50,705 There we go.
27 00:00:50,940 —> 00:00:53,995 And as always the BuiltOnAir podcast
28 00:00:54,195 —> 00:00:57,390 is an hour long show where we go through
29 00:00:57,390 —> 00:00:58,593 a couple different segments.
30 00:00:58,793 —> 00:00:59,583 I’ll walk us through
31 00:00:59,783 —> 00:01:00,570 what we’re gonna be doing
32 00:01:00,570 —> 00:01:00,938 today.
33 00:01:01,138 —> 00:01:02,582 We always start with our
34 00:01:02,782 —> 00:01:05,110 Round the Bases where we talk about what’s
35 00:01:05,110 —> 00:01:06,866 going on, keep you up to date
36 00:01:07,066 —> 00:01:09,408 in the Airtable communities and what’s new
37 00:01:09,440 —> 00:01:11,706 and then we will do a spotlight
38 00:01:11,906 —> 00:01:13,898 on our primary sponsor On2Air.
39 00:01:14,140 —> 00:01:16,204 Then we will learn about Chris
40 00:01:16,404 —> 00:01:17,261 and his story
41 00:01:17,461 —> 00:01:19,370 and how he found Airtable and
42 00:01:19,370 —> 00:01:20,914 then Chris will be doing
43 00:01:21,114 —> 00:01:21,793 a deep dive
44 00:01:21,993 —> 00:01:24,260 on some of his bases that he’s built and
45 00:01:24,260 —> 00:01:26,981 uses in his architecture firm
46 00:01:27,181 —> 00:01:29,191 and then a quick shout
47 00:01:29,391 —> 00:01:31,110 out to our BuiltOnAir
48 00:01:31,110 —> 00:01:31,908 community
49 00:01:32,140 —> 00:01:34,362 and then finally we will end
50 00:01:34,562 —> 00:01:35,560 with showcase
51 00:01:35,760 —> 00:01:38,170 A Case for Interface with Kamille,
52 00:01:38,170 —> 00:01:40,726 learning about how to integrate
53 00:01:40,926 —> 00:01:43,083 with google drive documents
54 00:01:43,283 —> 00:01:44,520 and that will wrap
55 00:01:44,520 —> 00:01:47,148 up our show and our season.
56 00:01:47,348 —> 00:01:50,750 So let’s start with Round the Bases,
57 00:01:50,750 —> 00:01:52,444 so not much going on
58 00:01:52,644 —> 00:01:55,408 a little bit quieter. Last week was
59 00:01:55,440 —> 00:01:58,052 jam packed with product announcements.
60 00:01:58,252 —> 00:02:00,940 This week will be a little bit lighter.
61 00:02:00,940 —> 00:02:02,228 I didn’t have as much to
62 00:02:02,428 —> 00:02:03,396 to share this week,
63 00:02:03,596 —> 00:02:05,180 but that’s good because we’ve got a
64 00:02:05,180 —> 00:02:06,905 lot of stuff to get to.
65 00:02:07,105 —> 00:02:09,680 So there were a couple announcements.
66 00:02:09,680 —> 00:02:11,741 New features, not big ones,
67 00:02:11,941 —> 00:02:13,263 these were kind of
68 00:02:13,463 —> 00:02:15,100 like hidden in the
69 00:02:15,100 —> 00:02:16,508 comment sections.
70 00:02:17,540 —> 00:02:18,034 So this
71 00:02:18,234 —> 00:02:21,038 did we talk about this last time Kamille?
72 00:02:21,238 —> 00:02:22,200 I can’t remember.
73 00:02:22,200 —> 00:02:24,417 No because it wasn’t there yet,
74 00:02:24,617 —> 00:02:27,420 I don’t think. So they in the new field
75 00:02:27,420 —> 00:02:28,915 manager before you could
76 00:02:29,115 —> 00:02:30,190 see the field type
77 00:02:30,390 —> 00:02:32,280 and description and permissions and
78 00:02:32,280 —> 00:02:33,815 stuff. And since then
79 00:02:34,015 —> 00:02:37,298 they have added in a column for field I.D.
80 00:02:37,440 —> 00:02:38,108 Which
81 00:02:38,140 —> 00:02:40,348 I was very happy about because
82 00:02:40,470 —> 00:02:42,340 it’s easy to get the field ids
83 00:02:42,540 —> 00:02:44,398 from a table if you’re scripting.
84 00:02:44,740 —> 00:02:45,436 And if you,
85 00:02:45,636 —> 00:02:47,464 I think you go through the api
86 00:02:47,664 —> 00:02:49,170 documentation for your base,
87 00:02:49,170 —> 00:02:50,518 you could also see it.
88 00:02:50,718 —> 00:02:52,070 But for the lay person,
89 00:02:52,270 —> 00:02:54,010 if you just want to get the field
90 00:02:54,010 —> 00:02:57,408 ID It was so difficult
91 00:02:57,740 —> 00:02:59,440 figure out what field was which
92 00:02:59,640 —> 00:03:01,030 like we can see your URL
93 00:03:01,030 —> 00:03:03,113 Right now and we can easily find
94 00:03:03,313 —> 00:03:04,204 the base ID
95 00:03:04,404 —> 00:03:05,272 The table ID
96 00:03:05,472 —> 00:03:06,314 the view ID
97 00:03:06,514 —> 00:03:07,666 and the record ID
98 00:03:07,866 —> 00:03:09,740 if you had a record expanded but you
99 00:03:09,740 —> 00:03:12,808 can’t see field IDs anywhere else
100 00:03:13,140 —> 00:03:14,614 except for you can now see it
101 00:03:14,814 —> 00:03:16,133 in the managed fields thing.
102 00:03:16,333 —> 00:03:17,140 That’s nice.
103 00:03:17,340 —> 00:03:19,351 Yeah I’m showing this here,
104 00:03:19,551 —> 00:03:21,138 I saw other people would
105 00:03:22,140 —> 00:03:22,712 use it.
106 00:03:22,912 —> 00:03:25,105 You could like find it in a
107 00:03:25,305 —> 00:03:28,190 well I guess that was for broken ones.
108 00:03:28,190 —> 00:03:29,062 I thought there was
109 00:03:29,262 —> 00:03:30,122 there was like a way
110 00:03:30,322 —> 00:03:31,540 where you could like fake it in a
111 00:03:31,540 —> 00:03:32,964 formula to like figure out
112 00:03:33,164 —> 00:03:34,990 what the field ID was or something.
113 00:03:34,990 —> 00:03:36,798 But
114 00:03:37,240 —> 00:03:39,735 so yeah this is much easier to use.
115 00:03:39,935 —> 00:03:42,730 Very very useful. Yeah I had a script that
116 00:03:42,730 —> 00:03:44,184 would generate all the fields
117 00:03:44,384 —> 00:03:45,040 and everything
118 00:03:45,240 —> 00:03:46,540 that I had before and don’t need
119 00:03:46,540 —> 00:03:48,298 that anymore.
120 00:03:49,840 —> 00:03:51,119 So that is a cool feature
121 00:03:51,319 —> 00:03:52,284 but it wasn’t really
122 00:03:52,484 —> 00:03:53,780 yeah it was just kind of hidden
123 00:03:53,780 —> 00:03:55,955 in the existing thread.
124 00:03:56,155 —> 00:03:59,760 Talking about the new based navigation.
125 00:03:59,760 —> 00:04:01,331 So that is very useful
126 00:04:01,531 —> 00:04:02,287 and if it’s
127 00:04:02,487 —> 00:04:04,830 if you don’t see it there’s a toggle.
128 00:04:04,830 —> 00:04:07,308 I didn’t realize this at first. But
129 00:04:07,640 —> 00:04:09,341 back in the managed fields
130 00:04:09,541 —> 00:04:12,480 right here, this icon right here this is
131 00:04:12,480 —> 00:04:14,964 actually a button that you can press
132 00:04:15,164 —> 00:04:17,310 to determine which fields you want
133 00:04:17,310 —> 00:04:18,098 displayed.
134 00:04:18,540 —> 00:04:19,911 And so that’s useful so
135 00:04:20,111 —> 00:04:21,423 if you’re not seeing it
136 00:04:21,623 —> 00:04:23,190 then you might need to check it
137 00:04:23,190 —> 00:04:25,518 in here to make sure it displays
138 00:04:25,530 —> 00:04:28,398 but I think it displays by default.
139 00:04:29,040 —> 00:04:29,926 I think so too.
140 00:04:30,126 —> 00:04:31,713 I think one other thing that
141 00:04:31,913 —> 00:04:33,470 I’ve seen a couple of people
142 00:04:33,470 —> 00:04:35,309 discover and like be surprised about
143 00:04:35,509 —> 00:04:37,250 is if you actually click on one of the
144 00:04:37,250 —> 00:04:40,008 column headers you can sort by that column
145 00:04:40,840 —> 00:04:41,908 not the field ID
146 00:04:42,250 —> 00:04:42,968 apparently not the field ID
147 00:04:43,520 —> 00:04:47,808 I mean you’d never need to. Right,
148 00:04:48,340 —> 00:04:49,598 field type
149 00:04:50,360 —> 00:04:52,788 the most relevant. Yeah.
150 00:04:54,040 —> 00:04:55,175 Right. Yeah you can’t see a
151 00:04:55,375 —> 00:04:56,543 situation where you’d actually
152 00:04:56,743 —> 00:04:57,360 want to sort by field
153 00:04:57,360 —> 00:04:58,108 ID
154 00:04:58,540 —> 00:04:59,808 Yeah. Yeah
155 00:05:00,440 —> 00:05:03,017 that’s funny. Or the dependency you can
156 00:05:03,217 —> 00:05:05,000 so you can see which ones have
157 00:05:05,000 —> 00:05:05,978 dependencies
158 00:05:07,110 —> 00:05:09,208 so it doesn’t even sort by value
159 00:05:10,740 —> 00:05:13,123 like your most dependent
160 00:05:13,323 —> 00:05:15,308 field basically. Yeah.
161 00:05:16,540 —> 00:05:18,262 Yeah cool. So yeah
162 00:05:18,462 —> 00:05:20,152 definitely useful.
163 00:05:20,352 —> 00:05:21,834 Check that out.
164 00:05:22,034 —> 00:05:23,908 There was one more
165 00:05:23,940 —> 00:05:25,765 So this is also another one
166 00:05:25,965 —> 00:05:26,937 that was hidden
167 00:05:27,137 —> 00:05:29,010 at the bottom of another thread.
168 00:05:29,010 —> 00:05:31,091 I think there’s another thread
169 00:05:31,291 —> 00:05:32,756 that talks about this.
170 00:05:32,956 —> 00:05:34,420 So now if you’re using
171 00:05:34,420 —> 00:05:35,939 URL Parameters
172 00:05:36,139 —> 00:05:37,698 in your Airtable forms
173 00:05:38,040 —> 00:05:40,948 before you had to use pre fill
174 00:05:41,148 —> 00:05:44,340 underscore and then the field name.
175 00:05:44,340 —> 00:05:48,198 But now you can use the field ID
176 00:05:48,540 —> 00:05:49,888 Which is useful.
177 00:05:51,140 —> 00:05:52,283 That’s super useful.
178 00:05:52,483 —> 00:05:54,398 That means if you want to change your
179 00:05:54,940 —> 00:05:56,269 field names you don’t have to
180 00:05:56,469 —> 00:05:58,148 worry about finding all the formulas that
181 00:05:58,280 —> 00:05:58,620 reference
182 00:05:58,820 —> 00:06:00,303 it because it’s not like it’s referencing,
183 00:06:00,503 —> 00:06:01,150 well it probably is also
184 00:06:01,150 —> 00:06:02,998 referencing the field itself but
185 00:06:03,940 —> 00:06:05,761 like if the field name is typed out
186 00:06:05,961 —> 00:06:07,030 and then you delete it
187 00:06:07,230 —> 00:06:08,050 then you’re not gonna
188 00:06:08,050 —> 00:06:10,438 know that it’s broken if that makes sense
189 00:06:13,040 —> 00:06:15,084 And you know you might have spaces
190 00:06:15,284 —> 00:06:16,309 in your field name
191 00:06:16,509 —> 00:06:17,790 you have to go and make it
192 00:06:17,790 —> 00:06:20,108 so it’s encoded
193 00:06:20,440 —> 00:06:21,986 all that kind of stuff
194 00:06:22,186 —> 00:06:24,563 and you know this isn’t necessarily
195 00:06:24,763 —> 00:06:25,990 fool proof but if you
196 00:06:25,990 —> 00:06:28,024 wanted to discourage people
197 00:06:28,224 —> 00:06:30,553 from changing a pre filled value
198 00:06:30,753 —> 00:06:31,790 if you can see in
199 00:06:31,790 —> 00:06:32,508 the
200 00:06:33,240 —> 00:06:34,522 URL of the former
201 00:06:34,722 —> 00:06:36,408 just given that says like
202 00:06:36,740 —> 00:06:40,598 you know pricing tier, Ultra or whatever,
203 00:06:41,040 —> 00:06:42,270 someone could see that
204 00:06:42,470 —> 00:06:43,748 and go well I don’t want
205 00:06:43,948 —> 00:06:45,400 I don’t want my pricing tier to
206 00:06:45,400 —> 00:06:46,887 be Ultra. I want it to be
207 00:06:47,087 —> 00:06:48,040 you know minimal.
208 00:06:48,240 —> 00:06:50,134 If they’re just seeing
209 00:06:50,334 —> 00:06:52,675 random field ID Equals Ultra
210 00:06:52,875 —> 00:06:54,180 you’re going to be
211 00:06:54,180 —> 00:06:56,814 less likely to you know suss out exactly
212 00:06:57,014 —> 00:06:59,250 what information you’re trying to put
213 00:06:59,250 —> 00:06:59,708 in there.
214 00:07:00,040 —> 00:07:00,498 Yeah.
215 00:07:01,140 —> 00:07:02,513 Do you still have to
216 00:07:02,713 —> 00:07:04,235 put pre fill underscore
217 00:07:04,435 —> 00:07:06,220 in front of it if you’re using
218 00:07:06,220 —> 00:07:06,624 field ID?
219 00:07:06,824 —> 00:07:07,460 Probably.
220 00:07:07,660 —> 00:07:10,908 Yeah. Yeah I haven’t actually tested that.
221 00:07:11,540 —> 00:07:13,242 Well I guess they’re saying
222 00:07:13,442 —> 00:07:15,577 they will update the article soon
223 00:07:15,777 —> 00:07:16,330 so it might not
224 00:07:16,330 —> 00:07:17,198 be updated.
225 00:07:19,740 —> 00:07:22,308 I think you still have to do it to get the
226 00:07:22,940 —> 00:07:26,498 query parameter to register.
227 00:07:28,140 —> 00:07:28,688 Yeah
228 00:07:32,240 —> 00:07:33,538 it looks like
229 00:07:34,340 —> 00:07:35,414 it’s actually a good article.
230 00:07:35,614 —> 00:07:36,414 I haven’t seen this one.
231 00:07:36,614 —> 00:07:37,080 It’s actually pretty
232 00:07:37,080 —> 00:07:37,808 detailed.
233 00:07:38,330 —> 00:07:39,508 That’s super helpful.
234 00:07:41,140 —> 00:07:42,748 Yeah it looks like they don’t
235 00:07:44,640 —> 00:07:47,786 They’ve even got a shout out to
236 00:07:47,986 —> 00:07:49,308 Kuovonne’s app.
237 00:07:51,240 —> 00:07:52,098 That’s nice.
238 00:07:52,940 —> 00:07:54,594 So yeah it doesn’t say yet
239 00:07:54,794 —> 00:07:56,325 but I’m assuming yeah
240 00:07:56,525 —> 00:07:58,730 you still say pre fill underscore
241 00:07:58,730 —> 00:07:59,621 and then the
242 00:07:59,821 —> 00:08:01,913 we have a comment from Justin
243 00:08:02,113 —> 00:08:04,150 that clarifies that it is still
244 00:08:04,150 —> 00:08:06,608 necessary. Thank you Justin
245 00:08:08,640 —> 00:08:10,427 cool so yeah that’s useful
246 00:08:10,627 —> 00:08:12,071 like you all mentioned
247 00:08:12,271 —> 00:08:13,450 to lock it in and you
248 00:08:13,450 —> 00:08:16,022 don’t have to especially if you’re
249 00:08:16,222 —> 00:08:19,200 sharing your form out in the world and
250 00:08:19,200 —> 00:08:21,154 linking to it from different websites.
251 00:08:21,354 —> 00:08:23,210 If you ever change your field names then
252 00:08:23,210 —> 00:08:24,736 you can’t, it’s hard to go back
253 00:08:24,936 —> 00:08:26,508 and find all the places where that’s
254 00:08:26,770 —> 00:08:27,291 linked to
255 00:08:27,491 —> 00:08:29,606 so you don’t have to worry about that.
256 00:08:29,806 —> 00:08:30,998 So useful in that regard.
257 00:08:32,840 —> 00:08:33,878 Alright last one
258 00:08:34,078 —> 00:08:36,539 this comes from our BuiltOnAir community,
259 00:08:36,539 —> 00:08:37,714 a fun little game
260 00:08:37,914 —> 00:08:40,121 so start thinking so Hannah poses
261 00:08:40,321 —> 00:08:41,860 the question how would you
262 00:08:41,860 —> 00:08:44,708 describe Airtable in three words?
263 00:08:44,840 —> 00:08:46,427 So there’s some good commentary.
264 00:08:46,627 —> 00:08:47,319 I’ll read these
265 00:08:47,519 —> 00:08:48,610 while you’re all thinking of
266 00:08:48,610 —> 00:08:50,437 how you would describe it.
267 00:08:50,637 —> 00:08:53,108 People said organize everything easily
268 00:08:53,240 —> 00:08:55,738 spreadsheets become databases.
269 00:08:56,140 —> 00:08:59,006 Rebecca is not able to share her
270 00:08:59,206 —> 00:09:02,410 three words. Might not be appropriate.
271 00:09:02,410 —> 00:09:04,796 Powerful, always evolving.
272 00:09:04,996 —> 00:09:07,678 Supercharge your spreadsheets.
273 00:09:07,878 —> 00:09:09,108 No loco database
274 00:09:09,540 —> 00:09:10,778 data gone wild
275 00:09:10,978 —> 00:09:14,138 from Justin joining us. Data your way.
276 00:09:14,160 —> 00:09:16,208 Red, yellow, blue
277 00:09:16,540 —> 00:09:20,508 Bill French is very literal
278 00:09:21,040 —> 00:09:23,597 expanded my career.
279 00:09:23,797 —> 00:09:26,318 That’s kind of cool
280 00:09:26,518 —> 00:09:28,308 legos but work.
281 00:09:28,840 —> 00:09:31,285 Yeah Foundation to functions.
282 00:09:31,485 —> 00:09:33,308 The last one from Leona.
283 00:09:34,180 —> 00:09:35,198 Any others?
284 00:09:38,040 —> 00:09:39,949 I’m not a tagline person.
285 00:09:40,149 —> 00:09:41,728 I’m a long protracted
286 00:09:41,928 —> 00:09:43,308 metaphor kind of gal.
287 00:09:43,640 —> 00:09:46,693 It’s like all your base are
288 00:09:46,893 —> 00:09:50,990 belong to us. Yeah. Base belong us.
289 00:09:50,990 —> 00:09:52,926 There you go.
290 00:09:53,126 —> 00:09:56,648 BuiltOnAir. There you go.
291 00:09:58,740 —> 00:10:00,308 Yeah
292 00:10:00,640 —> 00:10:01,835 kind of fun game.
293 00:10:02,035 —> 00:10:03,051 We usually yeah
294 00:10:03,251 —> 00:10:05,490 Hannah’s good about posting some fun
295 00:10:05,490 —> 00:10:08,245 activities in the BuiltOnAir community
296 00:10:08,445 —> 00:10:10,420 always enjoy participation.
297 00:10:10,420 —> 00:10:11,625 So fun way to
298 00:10:11,825 —> 00:10:12,785 to wrap up
299 00:10:12,985 —> 00:10:13,919 any other,
300 00:10:14,119 —> 00:10:16,910 was there anything I missed this
301 00:10:16,910 —> 00:10:18,511 week? Anything else interesting
302 00:10:18,711 —> 00:10:20,008 happening in the communities?
303 00:10:20,540 —> 00:10:22,298 Not that I recall
304 00:10:25,440 —> 00:10:27,397 side notes, I saw that they
305 00:10:27,597 —> 00:10:29,498 extended the deadline for the
306 00:10:30,020 —> 00:10:31,808 Interface competition.
307 00:10:34,020 —> 00:10:34,828 I didn’t know that
308 00:10:35,350 —> 00:10:37,208 it was it was hidden in the comments.
309 00:10:37,540 —> 00:10:39,064 Yeah, when they
310 00:10:39,264 —> 00:10:41,908 when they announced the form
311 00:10:42,340 —> 00:10:43,556 element or page type
312 00:10:43,756 —> 00:10:45,271 or whatever for Interfaces
313 00:10:45,471 —> 00:10:46,960 extended the deadline because
314 00:10:46,960 —> 00:10:47,619 it’s you know,
315 00:10:47,819 —> 00:10:49,205 obviously something that people
316 00:10:49,405 —> 00:10:50,680 would probably want to include in
317 00:10:50,680 —> 00:10:53,608 their competition entry.
318 00:10:54,040 —> 00:10:55,457 Yeah, that’s a good
319 00:10:55,658 —> 00:10:57,901 Also if anybody is planning to,
320 00:10:58,101 —> 00:10:59,710 there actually is a group
321 00:10:59,710 —> 00:11:01,848 somewhere in the BuiltOnAir community
322 00:11:02,048 —> 00:11:04,160 of people that are gonna help each other
323 00:11:04,160 —> 00:11:04,932 review. So
324 00:11:05,132 —> 00:11:07,393 if you’re looking for feedback
325 00:11:07,593 —> 00:11:10,030 on yours before submitting, check
326 00:11:10,030 —> 00:11:12,536 out in the slack community for BuiltOnAir,
327 00:11:12,736 —> 00:11:13,908 there’s people that are
328 00:11:14,340 —> 00:11:17,508 helping each other out with that. So
329 00:11:17,940 —> 00:11:20,461 the other thing I was gonna mention also
330 00:11:20,661 —> 00:11:22,540 I saw there’s a lot of discussion
331 00:11:22,540 —> 00:11:26,005 about what’s included in the Interface,
332 00:11:26,205 —> 00:11:28,670 like what’s being judged?
333 00:11:28,670 —> 00:11:30,357 You know, especially like
334 00:11:30,558 —> 00:11:32,581 what if you’re using automations
335 00:11:32,781 —> 00:11:33,530 as part of your
336 00:11:33,530 —> 00:11:35,208 Interface? It sounds like
337 00:11:35,940 —> 00:11:38,038 they will incorporate
338 00:11:38,190 —> 00:11:41,052 automations as part of their evaluation
339 00:11:41,252 —> 00:11:44,060 for your Interface. There wasn’t a lot
340 00:11:44,060 —> 00:11:45,154 of clarification,
341 00:11:45,354 —> 00:11:47,598 more questions than clarification, but
342 00:11:47,940 —> 00:11:49,718 yeah, it’s
343 00:11:50,940 —> 00:11:54,198 from my reading of that thread, it
344 00:11:54,830 —> 00:11:56,386 someone pointed out.
345 00:11:56,586 —> 00:11:58,211 I think it was Kuovonne,
346 00:11:58,411 —> 00:11:59,498 that before, if you
347 00:12:00,140 —> 00:12:03,374 added a base to the Airtable universe,
348 00:12:03,574 —> 00:12:06,098 automations didn’t carry over.
349 00:12:06,440 —> 00:12:07,228 And
350 00:12:07,270 —> 00:12:09,115 she was asking well if the Interfaces
351 00:12:09,315 —> 00:12:11,010 that we’re submitting are dependent on
352 00:12:11,010 —> 00:12:12,684 automations, how does that work?
353 00:12:12,884 —> 00:12:14,109 And then some time passed
354 00:12:14,309 —> 00:12:15,090 and then Jordan came
355 00:12:15,090 —> 00:12:15,998 in and said
356 00:12:16,440 —> 00:12:18,692 automations will be there.
357 00:12:18,892 —> 00:12:20,913 So I haven’t tested this
358 00:12:21,113 —> 00:12:22,850 myself but it sounds to
359 00:12:22,850 —> 00:12:24,961 me like that has been fixed
360 00:12:25,161 —> 00:12:28,400 for the universe that they now carry over
361 00:12:28,400 —> 00:12:29,842 automations, I think
362 00:12:30,043 —> 00:12:32,071 either that or they obviously
363 00:12:32,271 —> 00:12:34,170 have a way where they can pull
364 00:12:34,170 —> 00:12:35,708 in the automations
365 00:12:35,740 —> 00:12:37,082 or duplicate the base
366 00:12:37,282 —> 00:12:39,309 because when you duplicate a base
367 00:12:39,509 —> 00:12:40,598 it does include them.
368 00:12:40,740 —> 00:12:42,654 Yeah so they might just
369 00:12:42,854 —> 00:12:44,545 have a back end where
370 00:12:44,745 —> 00:12:46,398 they duplicate the base
371 00:12:47,340 —> 00:12:48,206 Hopefully because yeah
372 00:12:48,406 —> 00:12:49,406 that is a really good point.
373 00:12:51,840 —> 00:12:53,692 One other thing I saw this week,
374 00:12:53,892 —> 00:12:55,199 I don’t know if you guys
375 00:12:55,399 —> 00:12:56,180 maybe pulled it up
376 00:12:56,180 —> 00:12:58,088 last week or when it was released
377 00:12:58,288 —> 00:12:59,598 but an Airtable employee
378 00:12:59,798 —> 00:13:00,690 on linkedin shared a
379 00:13:00,690 —> 00:13:01,838 super super cute
380 00:13:02,038 —> 00:13:04,548 new commercial with like little kids
381 00:13:04,748 —> 00:13:06,360 pretending to be directors
382 00:13:06,360 —> 00:13:07,495 of like a movie.
383 00:13:07,695 —> 00:13:08,863 It’s really cute.
384 00:13:09,063 —> 00:13:11,750 Like I would highly recommend watching it.
385 00:13:11,750 —> 00:13:12,814 I don’t know if it’s worth
386 00:13:13,014 —> 00:13:13,550 pulling it up now,
387 00:13:13,750 —> 00:13:14,910 it’s pretty long but definitely go
388 00:13:14,910 —> 00:13:16,008 check that out. It’s
389 00:13:16,340 —> 00:13:17,108 really funny.
390 00:13:17,440 —> 00:13:19,660 I think if it’s the one I’m thinking of
391 00:13:19,860 —> 00:13:21,710 there’s one that’s been around for a
392 00:13:21,710 —> 00:13:23,181 couple of years,
393 00:13:23,381 —> 00:13:26,398 was it like outside like in a yard?
394 00:13:26,840 —> 00:13:28,103 I’m not sure if it was,
395 00:13:28,303 —> 00:13:30,410 if it’s a couple of years old then my bad,
396 00:13:30,410 —> 00:13:31,947 but I don’t know, I saw it.
397 00:13:32,147 —> 00:13:33,940 I thought it was really cute. Yeah,
398 00:13:33,940 —> 00:13:35,897 maybe. I don’t know.
399 00:13:36,097 —> 00:13:39,908 Okay, we’ll look for that and share that.
400 00:13:40,340 —> 00:13:43,796 Very good. So that concludes
401 00:13:43,996 —> 00:13:46,360 our Round the Bases
402 00:13:46,560 —> 00:13:49,720 next quick plug for On2Air,
403 00:13:49,720 —> 00:13:51,098 our primary sponsor.
404 00:13:51,440 —> 00:13:52,219 Jan just
405 00:13:52,419 —> 00:13:55,663 Jan mentions he doesn’t think it’s
406 00:13:55,863 —> 00:13:57,380 it’s new. Yeah,
407 00:13:57,380 —> 00:13:58,445 so there was one
408 00:13:58,645 —> 00:14:00,376 early in Airtable about that,
409 00:14:00,576 —> 00:14:02,200 so, but still worth checking
410 00:14:02,200 —> 00:14:03,808 out if you haven’t seen it.
411 00:14:04,740 —> 00:14:06,655 So On2Air’s an all in one toolkit
412 00:14:06,855 —> 00:14:08,570 to run your business on Airtable.
413 00:14:08,570 —> 00:14:10,066 It’s a suite of apps
414 00:14:10,266 —> 00:14:11,282 and extensions
415 00:14:11,482 —> 00:14:14,330 that enable businesses to really take full
416 00:14:14,330 —> 00:14:15,912 advantage of Airtable.
417 00:14:16,112 —> 00:14:17,518 We provide a lot of
418 00:14:17,718 —> 00:14:19,220 different things. Today,
419 00:14:19,220 —> 00:14:21,772 I’m continuing with our highlight
420 00:14:21,972 —> 00:14:23,386 of our soon to come
421 00:14:23,586 —> 00:14:25,098 soon to release in beta
422 00:14:25,240 —> 00:14:27,401 standalone forms product.
423 00:14:27,601 —> 00:14:30,293 So we have a forms integration
424 00:14:30,493 —> 00:14:31,550 with jot form,
425 00:14:31,550 —> 00:14:33,322 a third party form solution.
426 00:14:33,522 —> 00:14:34,605 We’ve been working
427 00:14:34,805 —> 00:14:36,170 for months on a standalone
428 00:14:36,170 —> 00:14:38,949 version that will be a game changer
429 00:14:39,149 —> 00:14:41,490 for your Airtable form solution.
430 00:14:41,490 —> 00:14:43,146 This is hopefully
431 00:14:43,346 —> 00:14:46,403 we will be live at least in beta
432 00:14:46,603 —> 00:14:48,600 before we come back for
433 00:14:48,600 —> 00:14:49,498 next season.
434 00:14:49,740 —> 00:14:51,960 That’s our goal is to launch in August,
435 00:14:52,160 —> 00:14:54,180 there’s always a lot of last things to,
436 00:14:54,180 —> 00:14:55,727 to wrap up before then,
437 00:14:55,927 —> 00:14:57,484 but we’re getting close.
438 00:14:57,684 —> 00:14:59,560 So I just wanted to showcase.
439 00:14:59,560 —> 00:15:01,515 So with this form solution
440 00:15:01,715 —> 00:15:03,678 you’ll be able to determine
441 00:15:03,878 —> 00:15:05,350 how you want to use it.
442 00:15:05,350 —> 00:15:07,168 You can use it just for
443 00:15:07,368 —> 00:15:08,749 creating new records
444 00:15:08,949 —> 00:15:10,990 or just for updating existing
445 00:15:10,990 —> 00:15:11,708 records.
446 00:15:11,740 —> 00:15:14,208 Or be able to use the same form
447 00:15:14,408 —> 00:15:16,102 for either or creating
448 00:15:16,302 —> 00:15:17,950 a new record or updating
449 00:15:17,950 —> 00:15:19,465 an existing record
450 00:15:19,665 —> 00:15:22,365 in the database in the table.
451 00:15:22,565 —> 00:15:24,600 And once you select that
452 00:15:24,600 —> 00:15:25,898 it will determine
453 00:15:26,098 —> 00:15:28,798 it will have the configuration for it.
454 00:15:28,940 —> 00:15:31,396 And one of the cool features
455 00:15:31,596 —> 00:15:35,430 that we’ve been experimenting with is the
456 00:15:35,430 —> 00:15:37,861 ability to default your values
457 00:15:38,061 —> 00:15:40,494 based off of an existing record
458 00:15:40,694 —> 00:15:41,750 in the database.
459 00:15:41,750 —> 00:15:42,947 So you can specify
460 00:15:43,147 —> 00:15:45,334 when you’re creating a new record,
461 00:15:45,534 —> 00:15:47,070 you can specify a record ID
462 00:15:47,070 —> 00:15:49,579 to use as the default values
463 00:15:49,779 —> 00:15:51,908 to insert into a new form.
464 00:15:52,340 —> 00:15:54,819 Or you can even dynamically
465 00:15:55,019 —> 00:15:57,940 do that where you can pass in a URL
466 00:15:57,940 —> 00:16:00,068 parameter with the record ID
467 00:16:00,268 —> 00:16:03,260 Of the record that you want to use as your
468 00:16:03,260 —> 00:16:04,577 default values.
469 00:16:04,777 —> 00:16:07,298 So that’s an option as well.
470 00:16:07,340 —> 00:16:09,966 Or if you’re updating an existing record
471 00:16:10,166 —> 00:16:12,330 you can specify how you want to find
472 00:16:12,330 —> 00:16:15,081 that record that you want to update.
473 00:16:15,281 —> 00:16:17,908 The default would be to just pass the
474 00:16:18,240 —> 00:16:20,304 the record ID As a parameter
475 00:16:20,504 —> 00:16:22,804 in the URL Like slash record ID
476 00:16:23,004 —> 00:16:24,232 in the form URL
477 00:16:24,432 —> 00:16:27,180 or you can match on a URL Parameter.
478 00:16:27,180 —> 00:16:28,736 So if you have some other
479 00:16:28,936 —> 00:16:31,100 unique identify rare to find a record,
480 00:16:31,100 —> 00:16:33,614 you can specify what field
481 00:16:33,814 —> 00:16:36,998 to match it with the URL Parameter.
482 00:16:37,240 —> 00:16:39,159 And so very advanced ways
483 00:16:39,359 —> 00:16:41,288 to update existing records
484 00:16:41,488 —> 00:16:42,920 or create new records.
485 00:16:42,920 —> 00:16:44,991 Just one small feature that
486 00:16:45,191 —> 00:16:46,822 that will be available
487 00:16:47,022 —> 00:16:48,750 in the form solution along
488 00:16:48,750 —> 00:16:49,777 with many others.
489 00:16:49,977 —> 00:16:51,366 Some we’ve already shown
490 00:16:51,566 —> 00:16:53,160 many that we haven’t shown yet.
491 00:16:53,160 —> 00:16:54,542 So very excited to
492 00:16:54,742 —> 00:16:56,754 this has been a lot of work
493 00:16:56,954 —> 00:16:58,840 and very excited to get this
494 00:16:58,840 —> 00:17:00,708 out there live and get people using it.
495 00:17:00,840 —> 00:17:02,160 So coming soon.
496 00:17:02,360 —> 00:17:04,718 Hopefully this month in August.
497 00:17:07,339 —> 00:17:09,252 All right let’s move on
498 00:17:09,452 —> 00:17:11,067 to meet the creators
499 00:17:11,267 —> 00:17:13,328 and our friend Chris with us
500 00:17:13,690 —> 00:17:16,358 Alli, you wanna learn about Chris?
501 00:17:16,380 —> 00:17:18,070 Absolutely. And my neighbor
502 00:17:18,270 —> 00:17:20,184 decided right now is a good time
503 00:17:20,384 —> 00:17:21,200 to go use the saw
504 00:17:21,200 —> 00:17:22,538 in his driveway. So
505 00:17:22,599 —> 00:17:25,948 I apologize if you can hear that.
506 00:17:26,849 —> 00:17:27,598 Good.
507 00:17:27,839 —> 00:17:30,284 Excellent Chris. Welcome.
508 00:17:30,484 —> 00:17:33,708 Very great to have you on the show.
509 00:17:34,640 —> 00:17:35,448 Thank you.
510 00:17:35,460 —> 00:17:37,048 Thank you very much.
511 00:17:37,170 —> 00:17:40,508 Super exciting. So you are an architect?
512 00:17:40,940 —> 00:17:43,030 Yes. Not data, not software
513 00:17:43,230 —> 00:17:46,280 actual buildings. Right, actual buildings.
514 00:17:46,280 —> 00:17:47,308 So that’s actually
515 00:17:47,508 —> 00:17:48,735 an interesting crossover.
516 00:17:48,935 —> 00:17:50,520 So are you building your
517 00:17:50,520 —> 00:17:51,090 bases too?
518 00:17:51,290 —> 00:17:52,381 Like are you the one
519 00:17:52,581 —> 00:17:54,398 that’s the one building the database?
520 00:17:54,740 —> 00:17:55,508 Yes.
521 00:17:57,160 —> 00:17:57,278 I’m
522 00:17:57,540 —> 00:18:00,208 gonna throw in before
523 00:18:00,540 —> 00:18:01,629 we get too far in.
524 00:18:01,829 —> 00:18:03,224 I mentioned all the time
525 00:18:03,424 —> 00:18:05,200 that I’m actually an urban planner
526 00:18:05,200 —> 00:18:07,193 and I work at an architecture firm,
527 00:18:07,393 —> 00:18:07,959 on the mug
528 00:18:08,159 —> 00:18:09,830 I’ve been drinking from literally
529 00:18:09,830 —> 00:18:13,508 says architecture. First word in there.
530 00:18:14,340 —> 00:18:16,848 That’s the theme of the day.
531 00:18:17,740 —> 00:18:19,613 That’s perfect. Well excellent.
532 00:18:19,813 —> 00:18:22,030 How did you get started? And how did you
533 00:18:22,030 —> 00:18:23,908 discover Airtable along the way?
534 00:18:24,540 —> 00:18:25,098 Well,
535 00:18:25,540 —> 00:18:27,921 in a different timeline,
536 00:18:28,121 —> 00:18:31,913 I was going to go into computer science
537 00:18:32,113 —> 00:18:33,080 and software
538 00:18:33,080 —> 00:18:33,598 developing,
539 00:18:34,240 —> 00:18:36,094 But my dad managed to get me
540 00:18:36,294 —> 00:18:38,835 a salary job at an architecture practice
541 00:18:39,035 —> 00:18:39,470 when I was
542 00:18:39,470 —> 00:18:42,045 like 15 and I caught the bug,
543 00:18:42,245 —> 00:18:43,725 so there you go,
544 00:18:43,925 —> 00:18:46,130 so I still have the coding
545 00:18:46,130 —> 00:18:47,863 skills but don’t use them
546 00:18:48,063 —> 00:18:50,220 far from like scripting in design
547 00:18:50,220 —> 00:18:53,098 software. Now,
548 00:18:53,440 —> 00:18:59,268 fast forward to 2017. I was working in
549 00:18:59,310 —> 00:19:01,733 the works European Division,
550 00:19:01,933 —> 00:19:04,445 so we’re doing the buildings
551 00:19:04,645 —> 00:19:06,060 here in Europe and
552 00:19:06,060 —> 00:19:08,825 we did have already set up
553 00:19:09,025 —> 00:19:11,908 a number of bases in Airtable
554 00:19:12,140 —> 00:19:13,110 and we were required
555 00:19:13,310 —> 00:19:14,178 to use them as part of
556 00:19:14,340 —> 00:19:14,808 work,
557 00:19:15,440 —> 00:19:17,825 and then I’m like, oh wow,
558 00:19:18,025 —> 00:19:20,709 there’s so much potential here
559 00:19:20,909 —> 00:19:22,320 to utilize this in
560 00:19:22,320 —> 00:19:24,308 ways that we’re actually not using it.
561 00:19:24,840 —> 00:19:25,561 So yeah,
562 00:19:25,761 —> 00:19:28,718 that’s where it kind of started and
563 00:19:29,040 —> 00:19:30,140 it was super useful
564 00:19:30,340 —> 00:19:32,108 when I started using it to kind of
565 00:19:32,840 —> 00:19:35,318 data mine our buildings.
566 00:19:35,740 —> 00:19:38,676 So using that in a way where
567 00:19:38,876 —> 00:19:42,660 it wasn’t kind of intended to be used.
568 00:19:42,660 —> 00:19:45,706 So yeah, it was super interesting
569 00:19:45,906 —> 00:19:48,290 and then I moved back
570 00:19:48,290 —> 00:19:50,508 I just never stopped using it.
571 00:19:51,740 —> 00:19:53,108 Excellent. Yeah, it’s funny,
572 00:19:53,308 —> 00:19:54,360 I think a lot of people
573 00:19:54,560 —> 00:19:55,550 kind of start out using it
574 00:19:55,550 —> 00:19:57,116 just because it is so flexible,
575 00:19:57,316 —> 00:19:58,357 you can use it however
576 00:19:58,557 —> 00:19:59,540 you want and like there’s
577 00:19:59,540 —> 00:20:01,722 really like no right way to do it.
578 00:20:01,922 —> 00:20:04,290 If it’s gonna work for you then it works
579 00:20:04,290 —> 00:20:05,899 right? That’s what I love about it.
580 00:20:06,099 —> 00:20:07,099 It’s super flexible.
581 00:20:07,840 —> 00:20:08,388 Yeah.
582 00:20:08,940 —> 00:20:10,242 So what kind of projects
583 00:20:10,442 —> 00:20:11,598 are you using it for now?
584 00:20:12,740 —> 00:20:14,498 So we’ve got like
585 00:20:15,140 —> 00:20:16,018 I keep coming up with
586 00:20:16,218 —> 00:20:17,075 different applications
587 00:20:17,275 —> 00:20:18,400 like we can use it for this we can
588 00:20:18,400 —> 00:20:19,001 use it for this,
589 00:20:19,201 —> 00:20:19,967 we can use it for this
590 00:20:20,167 —> 00:20:21,290 like we can use it for our operations,
591 00:20:21,290 —> 00:20:23,682 we can use it for projects.
592 00:20:23,882 —> 00:20:25,264 So for budgeting
593 00:20:25,464 —> 00:20:28,200 and taking quantities directly off
594 00:20:28,200 —> 00:20:30,247 of software and stuff like that.
595 00:20:30,447 —> 00:20:31,666 We use it to kind of
596 00:20:31,866 —> 00:20:33,190 like benchmark our briefs
597 00:20:33,190 —> 00:20:34,598 from the clients to make sure like
598 00:20:34,640 —> 00:20:35,908 are we actually
599 00:20:35,940 —> 00:20:38,552 designing too brief and things like that?
600 00:20:38,752 —> 00:20:40,910 I’ve got something to show and we can
601 00:20:40,910 —> 00:20:43,094 go through it in a bit.
602 00:20:43,294 —> 00:20:46,608 But generally speaking it’s more of a
603 00:20:47,040 —> 00:20:49,797 hey like we’ve got a problem,
604 00:20:49,997 —> 00:20:51,318 a design problem
605 00:20:51,640 —> 00:20:53,896 but it requires us to validate data.
606 00:20:54,096 —> 00:20:55,096 How do we do it?
607 00:20:55,340 —> 00:20:56,937 So it’s usually sometimes
608 00:20:57,137 —> 00:20:59,108 it’s something that’s more kind of
609 00:21:00,040 —> 00:21:02,098 holistic so you can
610 00:21:02,540 —> 00:21:04,255 use it for a lot of things
611 00:21:04,455 —> 00:21:06,039 or is sometimes it’s like
612 00:21:06,239 —> 00:21:07,750 a very very specific way to
613 00:21:07,750 —> 00:21:09,603 look one base for one thing
614 00:21:09,803 —> 00:21:10,986 and it just solves
615 00:21:11,186 —> 00:21:12,760 one specific problem and it
616 00:21:12,760 —> 00:21:13,717 doesn’t necessarily mean
617 00:21:13,917 —> 00:21:14,833 that you can translate it
618 00:21:15,033 —> 00:21:15,750 to another project but at
619 00:21:15,750 —> 00:21:16,898 least it takes a lot of
620 00:21:17,240 —> 00:21:21,418 reporting or work off of our hands.
621 00:21:22,040 —> 00:21:23,038 Absolutely.
622 00:21:23,640 —> 00:21:24,942 That’s super interesting.
623 00:21:25,142 —> 00:21:26,020 I’m excited to see
624 00:21:26,220 —> 00:21:27,338 what you’ve got to show us.
625 00:21:28,040 —> 00:21:30,008 I’m I was curious
626 00:21:30,760 —> 00:21:31,905 if you can share
627 00:21:32,105 —> 00:21:33,908 how we work used Airtable?
628 00:21:34,540 —> 00:21:40,708 N. D. A. But
629 00:21:41,040 —> 00:21:44,237 yeah I’m not sure they still use it.
630 00:21:44,437 —> 00:21:47,790 They were using it back in the day
631 00:21:47,790 —> 00:21:49,349 But we used it more
632 00:21:49,549 —> 00:21:51,318 for internal operations.
633 00:21:51,640 —> 00:21:54,268 It was more reporting internal operations,
634 00:21:54,640 —> 00:21:55,538 getting
635 00:21:55,580 —> 00:21:57,228 things through gates. So like
636 00:21:58,240 —> 00:22:00,201 when you get through approval gates
637 00:22:00,401 —> 00:22:01,716 and then you kind of like
638 00:22:01,916 —> 00:22:02,610 pass it on to the
639 00:22:02,610 —> 00:22:03,291 next department.
640 00:22:03,491 —> 00:22:04,600 So when it was going through
641 00:22:04,800 —> 00:22:05,590 real estate and they were
642 00:22:05,590 —> 00:22:07,122 assessing a potential property
643 00:22:07,322 —> 00:22:08,398 and then you kind of like
644 00:22:08,740 —> 00:22:10,004 get it over and like
645 00:22:10,204 —> 00:22:11,648 push it to the design team
646 00:22:12,140 —> 00:22:14,129 so you kind of like use the same data
647 00:22:14,329 —> 00:22:16,280 but pass it on to different stakeholders
648 00:22:16,280 —> 00:22:17,008 along the way.
649 00:22:17,940 —> 00:22:19,208 So yeah.
650 00:22:20,340 —> 00:22:21,248 Very nice.
651 00:22:21,840 —> 00:22:24,941 What about maybe question for Kamille
652 00:22:25,141 —> 00:22:28,210 or Chris like, how pop do you know other
653 00:22:28,210 —> 00:22:29,752 architecture related firms
654 00:22:29,952 —> 00:22:32,420 that use Airtable? Is it known within that
655 00:22:32,420 —> 00:22:34,998 industry or you guys are just outliers?
656 00:22:35,340 —> 00:22:37,998 I don’t think it’s a
657 00:22:38,840 —> 00:22:39,848 popular
658 00:22:39,950 —> 00:22:42,608 tool I guess in our field.
659 00:22:47,040 —> 00:22:48,438 Not for us either.
660 00:22:48,638 —> 00:22:49,993 Like we’ve used it
661 00:22:50,193 —> 00:22:52,630 like we’ve instigated using it with
662 00:22:52,630 —> 00:22:56,058 clients to get and give them access
663 00:22:56,258 —> 00:23:00,270 to their dashboards or specific views so
664 00:23:00,270 —> 00:23:02,188 they can kind of like keep up
665 00:23:02,388 —> 00:23:04,030 to date with their permits
666 00:23:04,230 —> 00:23:05,230 and tracking it and
667 00:23:05,230 —> 00:23:06,218 stuff like that. But
668 00:23:06,340 —> 00:23:08,398 I’ve been
669 00:23:09,520 —> 00:23:11,032 I’ve been pushing it a lot
670 00:23:11,232 —> 00:23:12,718 and it hasn’t been picking up
671 00:23:13,140 —> 00:23:13,998 for some reason
672 00:23:14,340 —> 00:23:16,643 but not a lot of architects
673 00:23:16,843 —> 00:23:18,008 are big on data.
674 00:23:18,340 —> 00:23:22,818 Well I think that’s interesting because
675 00:23:23,840 —> 00:23:25,455 I’ve been seeing more and more,
676 00:23:25,655 —> 00:23:26,825 we were talking about it
677 00:23:27,025 —> 00:23:27,800 literally yesterday.
678 00:23:29,810 —> 00:23:32,578 The idea of parametric design which is
679 00:23:33,040 —> 00:23:37,108 using data to help you generate
680 00:23:37,640 —> 00:23:40,336 different design schemes really quickly.
681 00:23:40,536 —> 00:23:42,830 So you feed it a bunch of parameters.
682 00:23:42,830 —> 00:23:45,236 A program will spit out a couple
683 00:23:45,436 —> 00:23:48,018 of different building shapes and then
684 00:23:48,050 —> 00:23:49,065 the architects
685 00:23:49,265 —> 00:23:51,166 will take that building shape
686 00:23:51,366 —> 00:23:53,008 that you know best fits
687 00:23:53,340 —> 00:23:54,431 what they want
688 00:23:54,631 —> 00:23:55,618 and then like
689 00:23:55,818 —> 00:23:57,620 start to like carve out
690 00:23:57,820 —> 00:23:59,108 even more it’s like
691 00:23:59,640 —> 00:24:02,574 a good comparison might be 3D printing
692 00:24:02,774 —> 00:24:05,200 where the printer will print out a
693 00:24:05,200 —> 00:24:06,305 lot of what you need to do,
694 00:24:06,505 —> 00:24:07,519 but you still need to go in
695 00:24:07,719 —> 00:24:08,270 and sand it and then
696 00:24:08,270 —> 00:24:09,498 paint it afterward.
697 00:24:09,840 —> 00:24:10,508 And
698 00:24:11,140 —> 00:24:13,710 I don’t think Airtable is necessarily
699 00:24:13,910 —> 00:24:16,350 a good fit for the world of parametric
700 00:24:16,350 —> 00:24:18,898 design. But I do see more and more people
701 00:24:19,240 —> 00:24:20,825 trying to think through how
702 00:24:21,025 —> 00:24:21,863 can we use data
703 00:24:22,063 —> 00:24:23,818 to help with the process of design.
704 00:24:24,240 —> 00:24:26,313 Yeah. Well it’s picking up,
705 00:24:26,513 —> 00:24:28,446 it’s picking up a lot more
706 00:24:28,646 —> 00:24:30,230 for urban design because
707 00:24:30,230 —> 00:24:31,098 you
708 00:24:31,840 —> 00:24:33,699 you do get a lot of more,
709 00:24:33,899 —> 00:24:35,554 there’s a lot more data
710 00:24:35,754 —> 00:24:37,640 readily available online that
711 00:24:37,640 —> 00:24:38,374 you can use
712 00:24:38,574 —> 00:24:39,800 from the government
713 00:24:39,999 —> 00:24:42,510 now for like building design unless you’re
714 00:24:42,510 —> 00:24:44,597 generating your own data
715 00:24:44,797 —> 00:24:45,811 is very hard
716 00:24:46,011 —> 00:24:48,598 to get proper benchmarks for that
717 00:24:49,140 —> 00:24:50,548 unfortunately.
718 00:24:50,690 —> 00:24:52,608 But in terms of
719 00:24:53,440 —> 00:24:56,998 generative design, we do
720 00:24:57,430 —> 00:24:59,508 we do parametric design in the office.
721 00:25:00,060 —> 00:25:01,608 And we
722 00:25:02,040 —> 00:25:04,178 we also use rivet. So
723 00:25:04,340 —> 00:25:05,108 for
724 00:25:05,940 —> 00:25:07,463 people who don’t know
725 00:25:07,663 —> 00:25:09,127 rivet is the software
726 00:25:09,327 —> 00:25:10,870 that allows you to design
727 00:25:10,870 —> 00:25:11,718 buildings
728 00:25:12,240 —> 00:25:13,979 with objects rather than geometry.
729 00:25:14,179 —> 00:25:15,324 So like a door is a door
730 00:25:15,524 —> 00:25:16,230 and it has metadata
731 00:25:16,230 —> 00:25:17,178 attached to it.
732 00:25:17,420 —> 00:25:18,818 So it carries the
733 00:25:19,240 —> 00:25:20,752 dimensions of the door,
734 00:25:20,952 —> 00:25:22,161 price of the door,
735 00:25:22,361 —> 00:25:24,040 manufacturer, specifications,
736 00:25:24,040 —> 00:25:27,833 all of that goes with the object.
737 00:25:28,033 —> 00:25:32,890 So that data can be transformed into like
738 00:25:32,890 —> 00:25:35,045 you can export schedules of this data
739 00:25:35,245 —> 00:25:37,200 from the software directly to CSP for
740 00:25:37,200 —> 00:25:38,508 example, so
741 00:25:38,640 —> 00:25:40,728 getting the data out of the software and
742 00:25:41,040 —> 00:25:42,417 putting it somewhere where you
743 00:25:42,617 —> 00:25:43,840 can actually do things with it.
744 00:25:43,840 —> 00:25:46,684 Like Airtable, super useful.
745 00:25:46,884 —> 00:25:49,216 Like I love doing it.
746 00:25:49,416 —> 00:25:51,660 And also the other way
747 00:25:51,660 —> 00:25:52,626 around. So we
748 00:25:52,826 —> 00:25:55,141 like I’ve used it in cases where
749 00:25:55,341 —> 00:25:57,310 I have the data in Airtable and
750 00:25:57,310 —> 00:26:01,308 had to export it to link it into
751 00:26:01,440 —> 00:26:02,468 into the software.
752 00:26:02,600 —> 00:26:04,328 So things like
753 00:26:05,740 —> 00:26:07,408 like what spaces,
754 00:26:07,940 —> 00:26:10,070 what kind of like space take up
755 00:26:10,270 —> 00:26:11,849 does each function take?
756 00:26:12,049 —> 00:26:13,230 And then like plotted
757 00:26:13,230 —> 00:26:15,718 out into Airtable like as a dummy
758 00:26:16,240 —> 00:26:17,451 environment sandbox
759 00:26:17,651 —> 00:26:19,938 and then just push it into the software
760 00:26:20,070 —> 00:26:20,998 so it
761 00:26:21,440 —> 00:26:22,620 it can integrate
762 00:26:22,820 —> 00:26:25,348 not directly so you always need to go
763 00:26:25,390 —> 00:26:27,529 to work flow around it.
764 00:26:27,729 —> 00:26:30,268 But I have used it both ways
765 00:26:30,468 —> 00:26:31,900 so it can work,
766 00:26:31,900 —> 00:26:32,383 it just
767 00:26:32,583 —> 00:26:35,008 it doesn’t lend itself too much to it.
768 00:26:35,940 —> 00:26:37,998 So have you with any of
769 00:26:38,440 —> 00:26:40,793 the above that was just mentioned,
770 00:26:40,993 —> 00:26:43,630 would you be able to use the like 3D
771 00:26:43,630 —> 00:26:46,332 renderer extension that Airtable has
772 00:26:46,532 —> 00:26:48,808 because it’s so rare to find like
773 00:26:49,040 —> 00:26:51,290 something that would use that extension
774 00:26:51,490 —> 00:26:53,310 and I’ve always wanted to see it in
775 00:26:53,310 —> 00:26:55,240 action. I think we had someone on
776 00:26:55,440 —> 00:26:56,823 the show a few weeks ago.
777 00:26:57,023 —> 00:26:57,930 We did and you could
778 00:26:57,930 —> 00:27:00,583 but the process you would need to take,
779 00:27:00,783 —> 00:27:01,808 I think to get the
780 00:27:02,040 —> 00:27:04,207 info that we typically work with
781 00:27:04,407 —> 00:27:06,170 from an architect standpoint.
782 00:27:06,170 —> 00:27:07,711 I don’t want to speak for you Chris
783 00:27:07,911 —> 00:27:09,560 but from an architect standpoint there’s a
784 00:27:09,560 —> 00:27:11,005 lot more detailed geometry
785 00:27:11,205 —> 00:27:12,313 that you have to work
786 00:27:12,513 —> 00:27:13,950 with and from an urban planning
787 00:27:13,950 —> 00:27:16,176 standpoint. All of my geometry is simple,
788 00:27:16,376 —> 00:27:18,130 but I’m looking at a whole city at a
789 00:27:18,130 —> 00:27:18,708 time
790 00:27:18,740 —> 00:27:20,750 and I don’t want to deal
791 00:27:20,950 —> 00:27:22,508 with that in Airtable
792 00:27:23,740 —> 00:27:24,612 no shade to Airtable
793 00:27:24,812 —> 00:27:26,277 but that’s not what they’re made for
794 00:27:26,477 —> 00:27:27,010 and I would rather
795 00:27:27,010 —> 00:27:27,908 just use a,
796 00:27:28,340 —> 00:27:30,722 You know, 3D viewer that is sort of built
797 00:27:30,922 —> 00:27:32,058 to handle that level of
798 00:27:32,090 —> 00:27:34,208 detail or that level of scale.
799 00:27:34,540 —> 00:27:34,978 Right,
800 00:27:36,640 —> 00:27:37,218 Cool,
801 00:27:37,640 —> 00:27:40,654 awesome. Well we are glad
802 00:27:40,854 —> 00:27:45,718 you could join us all the way from Cyprus.
803 00:27:46,140 —> 00:27:47,108 Yeah, that’s so cool.
804 00:27:47,790 —> 00:27:49,398 Go back here
805 00:27:49,710 —> 00:27:51,008 and now
806 00:27:51,340 —> 00:27:53,450 Chris is going to share with us
807 00:27:53,650 —> 00:27:54,760 some of his bases
808 00:27:54,960 —> 00:27:56,718 that he uses in the real world
809 00:27:57,240 —> 00:27:59,898 and we’re gonna share your screen here.
810 00:28:01,150 —> 00:28:03,008 There you go. Take it away.
811 00:28:03,540 —> 00:28:05,249 Alright, perfect. So
812 00:28:05,449 —> 00:28:07,619 I’m gonna go through a few
813 00:28:07,819 —> 00:28:10,290 bases slash Interfaces that kind
814 00:28:10,290 —> 00:28:11,661 of use case scenarios
815 00:28:11,861 —> 00:28:13,098 that we use it for.
816 00:28:14,440 —> 00:28:17,658 It’s not using any automations,
817 00:28:17,858 —> 00:28:19,179 no scripting,
818 00:28:19,379 —> 00:28:22,330 no bells and whistles but it
819 00:28:22,330 —> 00:28:23,285 does the job
820 00:28:23,485 —> 00:28:26,325 with the base Airtable functionality
821 00:28:26,525 —> 00:28:28,218 so we try to do our best
822 00:28:28,540 —> 00:28:32,069 now just to highlight the data here,
823 00:28:32,269 —> 00:28:35,500 a lot of it is dummy data because I
824 00:28:35,500 —> 00:28:38,350 can’t actually share the real data
825 00:28:38,550 —> 00:28:41,200 but so I’m gonna go through a few.
826 00:28:41,200 —> 00:28:42,842 Use case scenarios,
827 00:28:43,042 —> 00:28:45,401 use case scenario number one
828 00:28:45,601 —> 00:28:47,508 is using the data from
829 00:28:47,950 —> 00:28:49,348 the design software,
830 00:28:49,520 —> 00:28:51,258 getting quantities out of
831 00:28:51,458 —> 00:28:52,718 the software and then
832 00:28:53,240 —> 00:28:55,673 how we deal with those quantities
833 00:28:55,873 —> 00:28:57,590 for budgeting the project.
834 00:28:57,590 —> 00:29:00,239 The other one is more kind of like
835 00:29:00,439 —> 00:29:02,810 how do we make sure that we’re
836 00:29:02,810 —> 00:29:03,998 designing to brief
837 00:29:04,540 —> 00:29:07,108 and
838 00:29:07,440 —> 00:29:08,974 tracking permits
839 00:29:09,174 —> 00:29:11,468 and optimizing budgets. So
840 00:29:11,540 —> 00:29:14,408 I’m gonna start off with our kind of
841 00:29:16,440 —> 00:29:17,977 the project budgeting side
842 00:29:18,177 —> 00:29:18,679 of things
843 00:29:18,879 —> 00:29:20,520 but we also use it for tendering.
844 00:29:20,520 —> 00:29:22,866 So if we have a look at
845 00:29:23,066 —> 00:29:25,008 the base behind this.
846 00:29:25,340 —> 00:29:29,498 So what we have here is, alright
847 00:29:29,840 —> 00:29:32,175 so we’ve got so there’s a
848 00:29:32,375 —> 00:29:33,922 basically a table
849 00:29:34,122 —> 00:29:36,470 that deals with the quantity
850 00:29:36,470 —> 00:29:40,018 takeoffs. So we’ve got these organized
851 00:29:40,218 —> 00:29:43,660 in categories. So every category of the
852 00:29:43,660 —> 00:29:45,219 building process from
853 00:29:45,419 —> 00:29:47,001 preliminary excavations,
854 00:29:47,201 —> 00:29:48,890 demolitions all the way to
855 00:29:48,890 —> 00:29:50,498 artwork.
856 00:29:50,640 —> 00:29:52,221 We’re like we’re covered in
857 00:29:52,421 —> 00:29:53,270 these categories
858 00:29:53,470 —> 00:29:55,398 and then what we do, we go and
859 00:29:55,740 —> 00:29:57,909 get every single aspect of the building
860 00:29:58,109 —> 00:29:59,300 mapped out in quantities.
861 00:29:59,300 —> 00:30:01,508 So partitions for meeting rooms,
862 00:30:02,140 —> 00:30:04,035 there. Cutting the floor boxes
863 00:30:04,235 —> 00:30:05,930 to get the power distribution,
864 00:30:05,930 —> 00:30:06,995 it’s there.
865 00:30:07,195 —> 00:30:10,547 Things like ceiling mounted racks
866 00:30:10,747 —> 00:30:13,290 all the way to like meeting
867 00:30:13,290 —> 00:30:15,019 room chairs and boardroom chairs,
868 00:30:15,219 —> 00:30:17,220 everything’s in there. And we we basically
869 00:30:17,220 —> 00:30:18,757 break them down by level
870 00:30:18,957 —> 00:30:19,694 and by zone.
871 00:30:19,894 —> 00:30:22,150 So like level four meeting room has four
872 00:30:22,150 —> 00:30:23,218 meeting room chairs
873 00:30:23,440 —> 00:30:25,398 and there’s a budget assigned to that.
874 00:30:25,660 —> 00:30:26,928 Now
875 00:30:27,340 —> 00:30:30,044 after we do these kind of takeoffs
876 00:30:30,244 —> 00:30:32,510 and migrate them into Airtable,
877 00:30:32,510 —> 00:30:34,509 then we try to go out to tenders
878 00:30:34,709 —> 00:30:36,508 because the idea is that we want
879 00:30:36,940 —> 00:30:39,178 to be unbiased towards
880 00:30:39,480 —> 00:30:40,578 the tenders
881 00:30:40,740 —> 00:30:42,208 or the potential suppliers.
882 00:30:42,540 —> 00:30:45,408 So what we do is kind of like a report
883 00:30:46,140 —> 00:30:48,108 the different tenders to the clients.
884 00:30:48,740 —> 00:30:52,682 So we basically go on every single item
885 00:30:52,882 —> 00:30:55,108 in the quantities table.
886 00:30:55,440 —> 00:30:57,992 And we put like for example this
887 00:30:58,192 —> 00:30:59,512 two seater sofa,
888 00:30:59,712 —> 00:31:01,740 approximate dimensions from
889 00:31:01,740 —> 00:31:03,308 the design is this.
890 00:31:03,508 —> 00:31:06,242 And then we’ve got three different
891 00:31:06,442 —> 00:31:07,930 options for that with
892 00:31:07,930 —> 00:31:09,044 their associated pictures
893 00:31:09,244 —> 00:31:10,572 and we kind of like do an export
894 00:31:10,772 —> 00:31:11,360 of this and send it
895 00:31:11,360 —> 00:31:12,218 to the client.
896 00:31:12,440 —> 00:31:14,379 So for this item in the quantities,
897 00:31:14,579 —> 00:31:16,318 you’ve got three different options,
898 00:31:16,340 —> 00:31:17,583 which one do you want?
899 00:31:17,783 —> 00:31:19,122 So it basically goes into
900 00:31:19,322 —> 00:31:20,408 the quantities table and
901 00:31:21,140 —> 00:31:23,725 starts multiplying by unit price.
902 00:31:23,925 —> 00:31:26,310 If there’s a percentage waste,
903 00:31:26,310 —> 00:31:27,169 if you’ve got tiles
904 00:31:27,369 —> 00:31:28,376 and you’re cutting tiles
905 00:31:28,576 —> 00:31:29,340 and you’ve got wastage,
906 00:31:29,340 —> 00:31:31,696 it also has a parameter in there for that.
907 00:31:31,896 —> 00:31:33,098 And if you have discounts
908 00:31:33,540 —> 00:31:36,142 and then we basically just report,
909 00:31:36,342 —> 00:31:39,280 you know what the unit price is that this
910 00:31:39,280 —> 00:31:40,971 much times the quantity that it pulls
911 00:31:41,171 —> 00:31:42,480 from the other table. This is the
912 00:31:42,480 —> 00:31:43,508 estimated cost
913 00:31:44,040 —> 00:31:46,958 across the project for this specific item
914 00:31:46,960 —> 00:31:48,503 and then if you have it
915 00:31:48,703 —> 00:31:50,718 you’ve got different statuses. So
916 00:31:51,140 —> 00:31:52,598 we’re using the same
917 00:31:52,940 —> 00:31:54,908 tables to track deliveries as well.
918 00:31:55,540 —> 00:31:56,278 So
919 00:31:56,440 —> 00:31:57,858 if you have a short listed
920 00:31:58,058 —> 00:31:59,548 if you haven’t selected ordered
921 00:31:59,940 —> 00:32:01,402 confirmed delivery dates
922 00:32:01,602 —> 00:32:02,724 delivered, installed,
923 00:32:02,924 —> 00:32:03,900 rejected, and damaged.
924 00:32:03,900 —> 00:32:04,718 So
925 00:32:05,040 —> 00:32:07,218 if things are
926 00:32:08,540 —> 00:32:11,305 if we were tracking the deliveries
927 00:32:11,505 —> 00:32:13,500 but also the overdue items.
928 00:32:13,500 —> 00:32:16,591 So that’s how we go around with it.
929 00:32:16,791 —> 00:32:20,300 But if for example anything that is at bit
930 00:32:20,300 —> 00:32:20,818 mode
931 00:32:21,240 —> 00:32:23,343 doesn’t pull so we’ve got
932 00:32:23,543 —> 00:32:25,179 it doesn’t pull into
933 00:32:25,379 —> 00:32:27,550 this table the quantity table
934 00:32:27,550 —> 00:32:30,411 because in here this estimated cost
935 00:32:30,611 —> 00:32:32,428 is basically rolling up
936 00:32:32,628 —> 00:32:34,008 the information from
937 00:32:34,340 —> 00:32:36,056 the tender table where
938 00:32:36,256 —> 00:32:38,708 the status is not been rejected.
939 00:32:39,840 —> 00:32:41,421 Right? So if it’s at Bit mode
940 00:32:41,621 —> 00:32:42,593 or if it’s rejected
941 00:32:42,793 —> 00:32:43,820 it doesn’t aggregate the
942 00:32:43,820 —> 00:32:46,297 values. If it changes into anything else
943 00:32:46,497 —> 00:32:48,340 it means it’s already part of the
944 00:32:48,340 —> 00:32:50,278 opposition process of procurement
945 00:32:50,478 —> 00:32:52,098 and it adds it into the budget.
946 00:32:52,840 —> 00:32:53,947 So that’s kind of like
947 00:32:54,147 —> 00:32:55,608 what’s going on in the background
948 00:32:56,240 —> 00:32:58,475 of the base which can make
949 00:32:58,675 —> 00:33:00,434 this make more sense.
950 00:33:00,634 —> 00:33:03,030 So basically everything that we
951 00:33:03,030 —> 00:33:04,811 put into the base aggregate
952 00:33:05,011 —> 00:33:06,019 in terms of cost
953 00:33:06,219 —> 00:33:07,910 and then the client can have a
954 00:33:07,910 —> 00:33:09,076 dashboard and see
955 00:33:09,276 —> 00:33:11,818 exactly what this cost breaks down into.
956 00:33:11,940 —> 00:33:13,903 So we’ve got the different categories
957 00:33:14,103 —> 00:33:15,920 from more constructions or the minimum
958 00:33:15,920 —> 00:33:16,818 systems
959 00:33:16,840 —> 00:33:19,178 floor coverings I. T. Systems all of these
960 00:33:19,540 —> 00:33:21,160 for this project specifically
961 00:33:21,360 —> 00:33:22,361 because it has done
962 00:33:22,561 —> 00:33:23,730 an interior fit out for an
963 00:33:23,730 —> 00:33:24,791 office space.
964 00:33:24,991 —> 00:33:28,218 So there’s no building work done to it,
965 00:33:28,540 —> 00:33:29,438 construction wise.
966 00:33:29,840 —> 00:33:31,270 So you see the breakdown
967 00:33:31,470 —> 00:33:33,002 of the different categories
968 00:33:33,202 —> 00:33:34,250 and what the estimated
969 00:33:34,250 —> 00:33:35,268 cost for each is.
970 00:33:35,468 —> 00:33:36,387 So that’s great.
971 00:33:36,587 —> 00:33:38,168 And if you scroll further down
972 00:33:38,368 —> 00:33:38,800 you actually
973 00:33:38,800 —> 00:33:39,218 have
974 00:33:39,740 —> 00:33:41,461 a breakdown of the quantities
975 00:33:41,661 —> 00:33:42,504 and the budget.
976 00:33:42,704 —> 00:33:44,190 So they still get kind of like
977 00:33:44,190 —> 00:33:46,942 more data oriented breakdown of this
978 00:33:47,142 —> 00:33:50,230 if they really want to see it summarized
979 00:33:50,230 —> 00:33:51,819 but they also have like a
980 00:33:52,019 —> 00:33:53,218 high level overview of
981 00:33:53,540 —> 00:33:56,127 what the budget is for the project.
982 00:33:56,327 —> 00:33:59,380 So where you see if it’s been selected
983 00:33:59,380 —> 00:34:02,124 so place partitions create it’s selected.
984 00:34:02,324 —> 00:34:04,600 It’s there anything that’s zero value
985 00:34:04,600 —> 00:34:05,971 means there’s no supplier,
986 00:34:06,171 —> 00:34:07,310 nothing selected for it
987 00:34:07,510 —> 00:34:08,449 and they need to make a
988 00:34:08,449 —> 00:34:08,799 decision
989 00:34:08,999 —> 00:34:10,508 essentially that’s what it’s there for.
990 00:34:10,840 —> 00:34:12,598 So if it’s empty means guys
991 00:34:12,940 —> 00:34:14,651 we’ve got tenders for this
992 00:34:14,851 —> 00:34:17,679 we’ve allowed for it but you have made a
993 00:34:17,679 —> 00:34:19,313 decision so if you want this
994 00:34:19,513 —> 00:34:21,343 project budget to reflect reality
995 00:34:21,543 —> 00:34:22,230 you need to fill
996 00:34:22,230 —> 00:34:22,608 it in.
997 00:34:24,139 —> 00:34:26,108 Even though we’re doing the filling in
998 00:34:26,440 —> 00:34:28,148 aspect of it which is
999 00:34:28,520 —> 00:34:29,008 kind of
1000 00:34:29,440 —> 00:34:31,037 the bottleneck but
1001 00:34:31,237 —> 00:34:34,408 at least it keeps us on top of things.
1002 00:34:34,739 —> 00:34:35,508 Now
1003 00:34:35,940 —> 00:34:38,044 we do have are kind of like
1004 00:34:38,244 —> 00:34:39,671 internal Interfaces
1005 00:34:39,871 —> 00:34:41,550 to help us deal with like
1006 00:34:41,550 —> 00:34:42,733 reviewing these items.
1007 00:34:42,933 —> 00:34:44,005 So if we go furniture
1008 00:34:44,205 —> 00:34:45,690 and we’re going between different
1009 00:34:45,690 —> 00:34:47,299 options different types of
1010 00:34:47,499 —> 00:34:48,796 furniture that we have
1011 00:34:48,996 —> 00:34:50,330 and we’re seeing different
1012 00:34:50,330 —> 00:34:52,446 options for the same item. Right?
1013 00:34:52,646 —> 00:34:53,439 So this is from
1014 00:34:53,639 —> 00:34:54,379 the same supplier
1015 00:34:54,579 —> 00:34:55,968 but two options for the same item,
1016 00:34:56,168 —> 00:34:56,949 so we can decide all you
1017 00:34:56,949 —> 00:34:57,308 want,
1018 00:34:57,440 —> 00:34:59,838 we want that. So let’s go and select it
1019 00:35:00,050 —> 00:35:01,662 like we’ve selected that.
1020 00:35:01,862 —> 00:35:03,918 So now if we go back to the budget,
1021 00:35:03,950 —> 00:35:04,898 it’s already changed.
1022 00:35:05,440 —> 00:35:06,018 Right?
1023 00:35:06,840 —> 00:35:08,543 So that’s one use case scenario
1024 00:35:08,743 —> 00:35:09,723 that we use it for.
1025 00:35:09,923 —> 00:35:10,960 Super useful for smaller
1026 00:35:10,960 —> 00:35:12,483 projects and bigger projects,
1027 00:35:12,682 —> 00:35:13,809 you’ve got a specialist
1028 00:35:14,009 —> 00:35:14,740 that deals with the
1029 00:35:14,740 —> 00:35:15,549 quantities. So
1030 00:35:15,749 —> 00:35:17,639 we don’t want to kind of double up
1031 00:35:17,839 —> 00:35:19,250 on the work but for a smaller
1032 00:35:19,250 —> 00:35:20,208 project like this,
1033 00:35:20,540 —> 00:35:21,098 that’s great.
1034 00:35:21,440 —> 00:35:26,518 Now let me go here. So
1035 00:35:27,140 —> 00:35:28,103 because we’re getting
1036 00:35:28,303 —> 00:35:29,506 we’re dealing with buildings
1037 00:35:29,706 —> 00:35:30,580 and we need to go through
1038 00:35:30,580 —> 00:35:32,535 kind of jumping through hoops
1039 00:35:32,735 —> 00:35:34,091 with the authorities.
1040 00:35:34,291 —> 00:35:35,770 A lot of the work we do is
1041 00:35:35,770 —> 00:35:38,088 based on getting permit approvals
1042 00:35:38,288 —> 00:35:40,898 from the local and national authorities.
1043 00:35:41,240 —> 00:35:44,430 So basically for any building
1044 00:35:44,630 —> 00:35:48,086 that’s in potential construction
1045 00:35:48,286 —> 00:35:49,490 that’s over a
1046 00:35:49,490 —> 00:35:50,308 certain size,
1047 00:35:50,640 —> 00:35:52,608 you need to go through
1048 00:35:53,440 —> 00:35:55,337 authorized an authorization process
1049 00:35:55,537 —> 00:35:56,800 with different departments.
1050 00:35:56,800 —> 00:35:57,637 So you need to go to
1051 00:35:57,837 —> 00:35:58,559 the Energy Department,
1052 00:35:58,759 —> 00:35:59,990 you need to go to the Department of
1053 00:35:59,990 —> 00:36:02,412 Environment to make sure that
1054 00:36:02,612 —> 00:36:06,170 your are you taking all the sustainability
1055 00:36:06,170 —> 00:36:08,464 issues, are you making sure
1056 00:36:08,664 —> 00:36:11,098 that you’re not creating any
1057 00:36:11,230 —> 00:36:12,608 issues with the local flora
1058 00:36:12,808 —> 00:36:13,730 and fauna and so on.
1059 00:36:13,930 —> 00:36:16,588 So part of that is actually tracking it,
1060 00:36:16,930 —> 00:36:19,349 Creating dashboards to support it.
1061 00:36:19,549 —> 00:36:19,958 Right?
1062 00:36:20,158 —> 00:36:22,480 So basically this is a dashboard that
1063 00:36:22,480 —> 00:36:23,506 deals with that.
1064 00:36:23,706 —> 00:36:26,390 It’s basically just a reporting dashboard,
1065 00:36:26,390 —> 00:36:28,121 we know what’s going on in the
1066 00:36:28,321 —> 00:36:29,359 background anyways,
1067 00:36:29,559 —> 00:36:30,890 but for clients to see where
1068 00:36:30,890 —> 00:36:32,934 we are. So this is what we do.
1069 00:36:33,134 —> 00:36:35,218 So like there’s 12 consultations
1070 00:36:35,418 —> 00:36:36,000 that we were
1071 00:36:36,000 —> 00:36:36,912 requested to do with
1072 00:36:37,112 —> 00:36:38,098 the different departments.
1073 00:36:38,230 —> 00:36:40,012 There’s 10 of them complete.
1074 00:36:40,212 —> 00:36:41,975 That’s the average percentage
1075 00:36:42,175 —> 00:36:43,130 completion based on
1076 00:36:43,130 —> 00:36:44,247 the values.
1077 00:36:44,447 —> 00:36:48,208 And then what we have here is basically
1078 00:36:48,730 —> 00:36:50,178 responsibility
1079 00:36:50,220 —> 00:36:51,798 for this by
1080 00:36:52,130 —> 00:36:53,708 the different disciplines
1081 00:36:54,030 —> 00:36:55,698 and then basically
1082 00:36:56,030 —> 00:36:57,215 it’s the same data
1083 00:36:57,415 —> 00:36:58,988 just grouped differently.
1084 00:36:59,188 —> 00:37:00,310 So this is basically,
1085 00:37:00,310 —> 00:37:02,638 you know what executive architects
1086 00:37:02,838 —> 00:37:04,410 which is us in this case
1087 00:37:04,610 —> 00:37:05,720 and we’re seeing,
1088 00:37:05,720 —> 00:37:07,898 you know what, we’ve got
1089 00:37:08,230 —> 00:37:10,296 one record that’s pending approval
1090 00:37:10,496 —> 00:37:11,998 and one that’s under review.
1091 00:37:12,730 —> 00:37:14,788 So we can check that
1092 00:37:15,530 —> 00:37:17,473 that has environmental engineer
1093 00:37:17,673 —> 00:37:19,524 has one record pending approval
1094 00:37:19,724 —> 00:37:20,420 and the rest is
1095 00:37:20,420 —> 00:37:22,343 like changes requested,
1096 00:37:22,543 —> 00:37:23,194 approved
1097 00:37:23,394 —> 00:37:26,940 so different disciplines having
1098 00:37:26,940 —> 00:37:28,566 to deal with different departments.
1099 00:37:28,766 —> 00:37:30,470 And then here is basically just that it’s
1100 00:37:30,470 —> 00:37:32,888 more of a color coded version of
1101 00:37:33,230 —> 00:37:34,375 the different departments.
1102 00:37:34,575 —> 00:37:36,180 So you’ve got the antiquities Department,
1103 00:37:36,180 —> 00:37:37,654 Civil Aviation Authority,
1104 00:37:37,854 —> 00:37:39,090 Electricity Authority.
1105 00:37:39,290 —> 00:37:40,720 So it’s just color coding the
1106 00:37:40,720 —> 00:37:41,708 status of each.
1107 00:37:43,130 —> 00:37:45,485 And if you go further down again,
1108 00:37:45,685 —> 00:37:48,340 this is something that like I like to do
1109 00:37:48,340 —> 00:37:50,123 typically because this is kind of like
1110 00:37:50,323 —> 00:37:52,000 the overview and this is the data if you
1111 00:37:52,000 —> 00:37:53,288 really want to go into detail,
1112 00:37:53,830 —> 00:37:56,197 right? Because of transparency,
1113 00:37:56,397 —> 00:37:59,098 like we want people to be able to see,
1114 00:37:59,530 —> 00:38:00,523 hey, you know what,
1115 00:38:00,723 —> 00:38:02,409 this is kind of the, the overview,
1116 00:38:02,609 —> 00:38:03,450 but if you want to go
1117 00:38:03,450 —> 00:38:05,578 into data and see the details or you know,
1118 00:38:05,778 —> 00:38:06,490 what was approved?
1119 00:38:06,490 —> 00:38:07,151 You know what
1120 00:38:07,351 —> 00:38:08,557 these specific conditions
1121 00:38:08,757 —> 00:38:10,100 are currently under negotiation.
1122 00:38:10,100 —> 00:38:11,491 So there’s a lot,
1123 00:38:11,691 —> 00:38:14,108 there’s more data and summary of
1124 00:38:14,140 —> 00:38:15,727 the different decisions in there
1125 00:38:15,927 —> 00:38:17,710 if they want to get into the new degree,
1126 00:38:17,710 —> 00:38:18,588 the details, but
1127 00:38:18,720 —> 00:38:20,312 if not the dashboard is usually
1128 00:38:20,512 —> 00:38:21,648 more than enough for them.
1129 00:38:22,110 —> 00:38:24,658 I really like the chart on the right, I,
1130 00:38:24,858 —> 00:38:27,078 for some reason, I’ve never thought of
1131 00:38:27,520 —> 00:38:29,634 doing it that way when you have
1132 00:38:29,834 —> 00:38:31,076 a sequential series
1133 00:38:31,276 —> 00:38:32,840 of things that you need and
1134 00:38:32,840 —> 00:38:34,778 each of those sequential things
1135 00:38:34,978 —> 00:38:36,528 has a status and I don’t know
1136 00:38:36,530 —> 00:38:38,579 if it’s exactly the same where
1137 00:38:38,779 —> 00:38:41,310 you are but with our permitting process,
1138 00:38:41,310 —> 00:38:43,498 sometimes you have to get,
1139 00:38:43,720 —> 00:38:44,053 you know,
1140 00:38:44,253 —> 00:38:45,570 you have to go to the building department
1141 00:38:45,770 —> 00:38:46,550 before you go to the energy
1142 00:38:46,550 —> 00:38:48,628 Department or vice versa. So there’s,
1143 00:38:48,820 —> 00:38:51,321 you know, things happen in an order
1144 00:38:51,521 —> 00:38:54,180 and I know with charts you can change or
1145 00:38:54,180 —> 00:38:55,378 control rather,
1146 00:38:55,820 —> 00:38:58,216 you know which stack appears where
1147 00:38:58,416 —> 00:39:00,260 and seeing color coded. Okay.
1148 00:39:00,260 —> 00:39:02,153 This is gonna go from light tan
1149 00:39:02,353 —> 00:39:03,625 to dark orange to blue
1150 00:39:03,825 —> 00:39:04,840 and that’s how I know
1151 00:39:04,840 —> 00:39:06,147 that that column is done.
1152 00:39:06,347 —> 00:39:07,233 Then the next one
1153 00:39:07,433 —> 00:39:08,760 I could see where it is in that
1154 00:39:08,760 —> 00:39:09,650 process. Just by
1155 00:39:09,850 —> 00:39:11,209 looking at the color coding.
1156 00:39:11,409 —> 00:39:12,409 I just really like
1157 00:39:12,620 —> 00:39:14,279 seeing, they’re all the same height
1158 00:39:14,479 —> 00:39:16,270 obviously because there’s one approval one
1159 00:39:16,270 —> 00:39:16,738 record.
1160 00:39:18,820 —> 00:39:20,648 So you’re just using a number of records
1161 00:39:20,848 —> 00:39:22,110 versus like aggregating a field,
1162 00:39:22,110 —> 00:39:23,723 having a field summary.
1163 00:39:23,923 —> 00:39:25,272 So that’s why it is,
1164 00:39:25,472 —> 00:39:27,160 there’s no sequence to them
1165 00:39:27,160 —> 00:39:29,019 the way the permitting process
1166 00:39:29,219 —> 00:39:31,498 happens here gets you going in parallel.
1167 00:39:31,820 —> 00:39:32,544 But the
1168 00:39:32,744 —> 00:39:36,578 but I get what you mean, like you could
1169 00:39:36,920 —> 00:39:39,800 potentially number the department’s,
1170 00:39:40,000 —> 00:39:41,880 so if you have a sequence,
1171 00:39:41,880 —> 00:39:44,090 you can put a number on the
1172 00:39:44,290 —> 00:39:45,322 formula field
1173 00:39:45,522 —> 00:39:48,100 to like give them a sequence so you
1174 00:39:48,100 —> 00:39:49,871 can sort by department
1175 00:39:50,071 —> 00:39:51,168 and then yeah,
1176 00:39:51,368 —> 00:39:54,380 just have like a volume bar and then it’s
1177 00:39:54,380 —> 00:39:55,296 basically because
1178 00:39:55,496 —> 00:39:56,698 it becomes a progress bar.
1179 00:39:56,820 —> 00:39:57,798 Right?
1180 00:39:58,320 —> 00:39:59,999 Yeah, I’ve done that in one
1181 00:40:00,199 —> 00:40:01,990 Interface with a bunch of tasks.
1182 00:40:01,990 —> 00:40:02,859 Like it’s not,
1183 00:40:03,059 —> 00:40:04,615 it’s not as pretty as this
1184 00:40:04,815 —> 00:40:06,710 because there’s way too many tasks.
1185 00:40:06,710 —> 00:40:08,041 I thought it looked better
1186 00:40:08,241 —> 00:40:08,860 than having like
1187 00:40:09,060 —> 00:40:10,660 the grid because it just took up too
1188 00:40:10,660 —> 00:40:12,900 much space. It looks very nice,
1189 00:40:13,100 —> 00:40:14,778 but yours looks way better
1190 00:40:15,110 —> 00:40:17,873 and you’re also using the non default
1191 00:40:18,073 —> 00:40:20,860 color scheme. I think it’s it was lost a
1192 00:40:20,860 —> 00:40:22,551 while ago that I don’t think
1193 00:40:22,751 —> 00:40:24,356 we’ve ever really mentioned,
1194 00:40:24,556 —> 00:40:25,330 but you have more
1195 00:40:25,330 —> 00:40:27,642 color options and Interfaces.
1196 00:40:27,842 —> 00:40:28,765 Yes, you do.
1197 00:40:28,965 —> 00:40:31,150 And like it’s a shame
1198 00:40:31,150 —> 00:40:34,288 because the it doesn’t give you control
1199 00:40:34,710 —> 00:40:36,116 of the color scheme.
1200 00:40:36,316 —> 00:40:37,797 Yeah, you can’t get it
1201 00:40:37,997 —> 00:40:39,210 exactly how you want,
1202 00:40:39,210 —> 00:40:40,503 but you don’t have to use
1203 00:40:40,703 —> 00:40:41,970 the default Airtable color
1204 00:40:42,170 —> 00:40:43,090 scheme that’s in like a
1205 00:40:43,090 —> 00:40:45,298 single select fields, for instance,
1206 00:40:45,498 —> 00:40:46,634 like I’ve got like,
1207 00:40:46,834 —> 00:40:48,010 like whenever I go into
1208 00:40:48,010 —> 00:40:49,579 edit mode and look at these
1209 00:40:49,779 —> 00:40:50,288 color schemes.
1210 00:40:50,410 —> 00:40:51,356 I’m like, okay,
1211 00:40:51,556 —> 00:40:52,578 tableau extended
1212 00:40:52,778 —> 00:40:53,568 science book.
1213 00:40:53,768 —> 00:40:55,390 Like I love science book but
1214 00:40:55,390 —> 00:40:56,068 it’s not useful
1215 00:40:56,310 —> 00:40:58,988 like there’s almost no
1216 00:40:59,370 —> 00:41:00,291 it’s too close.
1217 00:41:00,491 —> 00:41:02,553 And then like the one I really like
1218 00:41:02,753 —> 00:41:03,850 is the city lights one
1219 00:41:03,850 —> 00:41:05,385 because it’s always funky
1220 00:41:05,585 —> 00:41:07,406 but like you can’t control like
1221 00:41:07,606 —> 00:41:08,640 I want a proved to be
1222 00:41:08,640 —> 00:41:11,054 like a greenish color, right?
1223 00:41:11,254 —> 00:41:13,844 But you can’t control what color
1224 00:41:14,044 —> 00:41:15,300 from your palates.
1225 00:41:15,300 —> 00:41:15,878 Does what.
1226 00:41:16,110 —> 00:41:17,118 Yeah,
1227 00:41:17,410 —> 00:41:19,248 it would be great if you could have like
1228 00:41:19,540 —> 00:41:20,488 in your
1229 00:41:20,810 —> 00:41:23,308 status or like single select fields
1230 00:41:23,508 —> 00:41:26,020 or multi select fields to kind of like
1231 00:41:26,020 —> 00:41:28,173 assign one color to each
1232 00:41:28,373 —> 00:41:29,878 different status or
1233 00:41:30,310 —> 00:41:32,783 it would be great but it’s not there yet,
1234 00:41:32,983 —> 00:41:34,110 which is okay I guess.
1235 00:41:36,560 —> 00:41:37,378 What else do we have?
1236 00:41:37,910 —> 00:41:40,378 Oh this this one’s interesting. Alright so
1237 00:41:40,710 —> 00:41:44,452 another use that we typically use it for
1238 00:41:44,652 —> 00:41:47,540 when you have a brief from the
1239 00:41:47,540 —> 00:41:50,519 client. So this is a condition where
1240 00:41:50,719 —> 00:41:53,830 you’ve got a brief where you’ve got like
1241 00:41:53,830 —> 00:41:56,568 this is a done your hotel projects.
1242 00:41:56,768 —> 00:41:58,368 So data is not actually
1243 00:41:58,710 —> 00:41:59,182 real but
1244 00:41:59,382 —> 00:42:00,634 it’s basically saying,
1245 00:42:00,834 —> 00:42:01,743 oh you know what,
1246 00:42:01,943 —> 00:42:03,080 we’ve got specific number
1247 00:42:03,080 —> 00:42:05,129 of guest rooms and they need to be
1248 00:42:05,329 —> 00:42:06,411 this specific size.
1249 00:42:06,611 —> 00:42:07,720 And are you hitting the
1250 00:42:07,720 —> 00:42:08,205 targets?
1251 00:42:08,405 —> 00:42:10,162 How much space are you taking?
1252 00:42:10,362 —> 00:42:12,270 Because then we can use this data to
1253 00:42:12,270 —> 00:42:13,811 actually budget the project
1254 00:42:14,011 —> 00:42:15,361 or pass the data onwards
1255 00:42:15,561 —> 00:42:16,550 to make sure that it’s
1256 00:42:16,550 —> 00:42:17,778 actually feasible to be built.
1257 00:42:18,300 —> 00:42:20,882 So we’re basically breaking down
1258 00:42:21,082 —> 00:42:24,190 if I go, let’s see, can I go do I have it
1259 00:42:24,190 —> 00:42:27,858 below? Not here, maybe here, Yes. So
1260 00:42:28,700 —> 00:42:30,868 here what we’re doing, we’re looking at,
1261 00:42:31,300 —> 00:42:33,387 for example, guest rooms and suites,
1262 00:42:33,587 —> 00:42:34,720 king, guest room, king,
1263 00:42:34,720 —> 00:42:36,130 twin guest room,
1264 00:42:36,330 —> 00:42:38,658 deluxe, queen deluxe, king.
1265 00:42:38,858 —> 00:42:41,330 And you’ve got the target area,
1266 00:42:41,330 —> 00:42:43,191 the occupancy, the proposed area
1267 00:42:43,391 —> 00:42:44,324 and the occupancy
1268 00:42:44,524 —> 00:42:45,750 and what the deviation is.
1269 00:42:45,750 —> 00:42:46,930 So if you’ve gotten minus
1270 00:42:47,130 —> 00:42:48,316 in any field that means
1271 00:42:48,516 —> 00:42:49,290 you’re not hitting your
1272 00:42:49,290 —> 00:42:49,858 targets,
1273 00:42:50,900 —> 00:42:51,368 right?
1274 00:42:51,700 —> 00:42:53,526 So you’ve got a deviation
1275 00:42:53,726 —> 00:42:54,848 in terms of area
1276 00:42:55,048 —> 00:42:56,740 and a deviation in terms of
1277 00:42:56,740 —> 00:42:57,584 occupancy,
1278 00:42:57,784 —> 00:43:00,677 that you can basically just review.
1279 00:43:00,877 —> 00:43:03,240 So we do it for every aspect of
1280 00:43:03,240 —> 00:43:03,778 the building.
1281 00:43:04,100 —> 00:43:06,617 And this is a big building,
1282 00:43:06,817 —> 00:43:08,668 so we’re talking about
1283 00:43:10,100 —> 00:43:12,128 70,000 m2
1284 00:43:12,130 —> 00:43:15,368 in terms of building volume, so
1285 00:43:15,800 —> 00:43:18,444 knowing where the bulk of your space is
1286 00:43:18,644 —> 00:43:20,410 allocated is super important.
1287 00:43:20,410 —> 00:43:22,203 So we can tell from here,
1288 00:43:22,403 —> 00:43:23,509 for example that
1289 00:43:23,709 —> 00:43:25,860 you know what the guest rooms were
1290 00:43:25,860 —> 00:43:28,940 like 14,670 and we’ve managed to
1291 00:43:29,140 —> 00:43:31,058 get it down to 10,900.
1292 00:43:31,500 —> 00:43:33,390 So like in terms of optimizing
1293 00:43:33,590 —> 00:43:35,658 the budget and making sure that your
1294 00:43:36,100 —> 00:43:38,493 following your brief, it’s good.
1295 00:43:38,693 —> 00:43:40,960 What I haven’t been able to like,
1296 00:43:40,960 —> 00:43:42,252 this is one of my pet peeves
1297 00:43:42,452 —> 00:43:43,094 with Airtable,
1298 00:43:43,294 —> 00:43:44,560 you can’t customize the scale of
1299 00:43:44,560 —> 00:43:45,118 this.
1300 00:43:46,800 —> 00:43:48,375 Yeah, and it really bugs me
1301 00:43:48,575 —> 00:43:49,953 because it would be great
1302 00:43:50,153 —> 00:43:51,000 if I could see that
1303 00:43:51,000 —> 00:43:51,875 one’s there and you know
1304 00:43:52,075 —> 00:43:53,075 what the other ones over here,
1305 00:43:53,400 —> 00:43:53,715 right?
1306 00:43:53,915 —> 00:43:55,657 Or if I could get these side by side,
1307 00:43:55,857 —> 00:43:57,350 like one field here and the other
1308 00:43:57,350 —> 00:43:59,058 one, like directly adjacent to it,
1309 00:43:59,400 —> 00:44:01,682 which kind of like Excel,
1310 00:44:01,882 —> 00:44:04,968 Excel was so helpful in these cases.
1311 00:44:07,190 —> 00:44:08,612 Well, Chris we’ve got
1312 00:44:08,812 —> 00:44:09,726 we’ll wrap up,
1313 00:44:09,926 —> 00:44:12,270 we’ve got a question from Jan from the
1314 00:44:12,270 —> 00:44:13,417 community asking
1315 00:44:13,617 —> 00:44:14,990 how do you share the
1316 00:44:15,190 —> 00:44:16,570 dashboard with clients?
1317 00:44:16,570 —> 00:44:19,158 Do you give them access to the base?
1318 00:44:19,358 —> 00:44:21,458 And then also to explain F two f
1319 00:44:22,290 —> 00:44:26,236 Yes, well, a lot of it is face to face,
1320 00:44:26,436 —> 00:44:29,980 we don’t share, so if we get a client
1321 00:44:29,980 —> 00:44:32,958 into another table would be
1322 00:44:33,490 —> 00:44:35,637 if we are able to sync the data
1323 00:44:35,837 —> 00:44:38,130 and kind of like isolate it, then yes,
1324 00:44:38,130 —> 00:44:40,073 if they are on Airtable, we could
1325 00:44:40,273 —> 00:44:42,310 we don’t typically usually we have our
1326 00:44:42,310 —> 00:44:42,995 weekly calls
1327 00:44:43,195 —> 00:44:44,775 and we’ll go through dashboard
1328 00:44:44,975 —> 00:44:46,250 show them and go through it.
1329 00:44:46,250 —> 00:44:48,468 So it is more a lot of it is face to face.
1330 00:44:48,690 —> 00:44:50,851 We’ve shared views in the past,
1331 00:44:51,051 —> 00:44:53,708 we don’t share the dashboards themselves.
1332 00:44:53,990 —> 00:44:55,999 But we share snapshots
1333 00:44:56,199 —> 00:44:57,806 of the dashboards,
1334 00:44:58,006 —> 00:45:00,930 which is kind of like a workaround.
1335 00:45:00,930 —> 00:45:02,667 So we basically just
1336 00:45:02,867 —> 00:45:05,156 if we wanted to share this,
1337 00:45:05,356 —> 00:45:07,530 we could basically just do a
1338 00:45:07,530 —> 00:45:09,070 full page screenshots,
1339 00:45:09,270 —> 00:45:11,503 which is that so screen capturing
1340 00:45:11,703 —> 00:45:13,060 process and then we can
1341 00:45:13,060 —> 00:45:14,158 just share this.
1342 00:45:14,390 —> 00:45:17,494 So that’s the way around it.
1343 00:45:17,694 —> 00:45:19,268 So it’s a static
1344 00:45:19,890 —> 00:45:20,940 piece of information
1345 00:45:21,140 —> 00:45:22,236 at that point in time.
1346 00:45:22,436 —> 00:45:23,880 If they want to go through it,
1347 00:45:23,880 —> 00:45:24,873 we have our calls
1348 00:45:25,073 —> 00:45:26,920 and we can we can do like a quick
1349 00:45:27,120 —> 00:45:28,320 15 minute session just to
1350 00:45:28,320 —> 00:45:29,101 walk through it
1351 00:45:29,301 —> 00:45:30,592 if they have any questions
1352 00:45:30,792 —> 00:45:32,380 but yeah typically we won’t add them
1353 00:45:32,380 —> 00:45:35,058 to the bases if the bases have
1354 00:45:35,590 —> 00:45:36,558 too much data.
1355 00:45:38,490 —> 00:45:39,324 Very cool.
1356 00:45:39,524 —> 00:45:41,493 That’s awesome stuff Chris
1357 00:45:41,693 —> 00:45:44,820 thank you so much for sharing with us and
1358 00:45:44,820 —> 00:45:46,515 giving insight into how
1359 00:45:46,715 —> 00:45:48,841 real companies use Airtable,
1360 00:45:49,041 —> 00:45:49,980 what’s been the
1361 00:45:49,980 —> 00:45:51,472 impression of the team
1362 00:45:51,672 —> 00:45:54,048 as they’ve been interacting with this?
1363 00:45:56,390 —> 00:45:57,918 Well it’s
1364 00:45:58,590 —> 00:45:59,317 it’s picking up,
1365 00:45:59,517 —> 00:46:00,591 they see the value in it,
1366 00:46:00,791 —> 00:46:02,180 they’re like it would be difficult to
1367 00:46:02,180 —> 00:46:03,259 not look at it
1368 00:46:03,459 —> 00:46:05,648 and not see the value in it.
1369 00:46:06,180 —> 00:46:08,138 I think that the real challenge
1370 00:46:08,338 —> 00:46:09,338 is actually getting
1371 00:46:10,180 —> 00:46:12,049 getting people to start inputting
1372 00:46:12,249 —> 00:46:13,249 the data and being
1373 00:46:13,460 —> 00:46:15,838 like interested in putting the data, so
1374 00:46:16,180 —> 00:46:17,512 it’s not part of your
1375 00:46:17,712 —> 00:46:18,908 normal job description
1376 00:46:19,480 —> 00:46:21,538 right? So it
1377 00:46:22,980 —> 00:46:24,958 getting people into the mindset of
1378 00:46:25,158 —> 00:46:27,110 oh you know what, I’ve got this data,
1379 00:46:27,110 —> 00:46:29,958 how can I make better use of it?
1380 00:46:30,280 —> 00:46:32,105 Because we usually get data
1381 00:46:32,305 —> 00:46:33,925 from the work that we do,
1382 00:46:34,125 —> 00:46:35,350 like whether it’s like
1383 00:46:35,350 —> 00:46:37,423 floor areas and floor plan
1384 00:46:37,623 —> 00:46:41,010 or like quantities that we have to review.
1385 00:46:41,010 —> 00:46:43,788 Like schedules of doors and windows,
1386 00:46:43,988 —> 00:46:46,720 which is really who really cares about
1387 00:46:46,720 —> 00:46:47,248 that but
1388 00:46:47,480 —> 00:46:49,089 in terms of like itemizing
1389 00:46:49,289 —> 00:46:51,378 the data and being able to review it,
1390 00:46:51,480 —> 00:46:52,376 it’s super useful
1391 00:46:52,576 —> 00:46:53,321 and grouping it
1392 00:46:53,521 —> 00:46:54,960 and having it organized by types.
1393 00:46:54,960 —> 00:46:56,937 Like I’ve done it in the past
1394 00:46:57,137 —> 00:46:58,704 and like I can’t imagine
1395 00:46:58,904 —> 00:47:00,140 not doing it. Like I’ve
1396 00:47:00,140 —> 00:47:01,134 had to do it with
1397 00:47:01,334 —> 00:47:02,654 pivot tables in excel once
1398 00:47:02,854 —> 00:47:04,540 and I wanted to pull my hair out.
1399 00:47:04,540 —> 00:47:07,458 And I did it twice in one year
1400 00:47:07,780 —> 00:47:09,931 so doing in Airtable was
1401 00:47:10,131 —> 00:47:13,248 obviously a better solution but yeah.
1402 00:47:14,080 —> 00:47:17,058 Cool. Yeah that’s always the issue is
1403 00:47:17,258 —> 00:47:18,810 it’s only as good as
1404 00:47:19,010 —> 00:47:20,518 the data that’s in it.
1405 00:47:20,540 —> 00:47:23,558 Sorry I’ve got I’ve got a small visitor
1406 00:47:24,280 —> 00:47:26,248 Welcome
1407 00:47:28,170 —> 00:47:29,028 Junior.
1408 00:47:31,080 —> 00:47:31,548 All right,
1409 00:47:33,910 —> 00:47:35,197 alright, very good.
1410 00:47:35,397 —> 00:47:36,312 We’ll move on.
1411 00:47:36,512 —> 00:47:38,990 Thank you Chris for sharing that with us.
1412 00:47:38,990 —> 00:47:41,744 Final plug for our BuiltOnAir community,
1413 00:47:41,944 —> 00:47:44,360 join us. Amazing people like Chris and
1414 00:47:44,360 —> 00:47:46,258 many other we have thousands of
1415 00:47:46,680 —> 00:47:48,321 people in our slack community.
1416 00:47:48,521 —> 00:47:50,400 We’d love to have you join us as well.
1417 00:47:50,400 —> 00:47:52,098 builtonair.com/join.
1418 00:47:52,298 —> 00:47:54,390 Get in the slack community.
1419 00:47:54,390 —> 00:47:56,459 Subscribe to the newsletter.
1420 00:47:56,659 —> 00:47:58,441 Get up to date on all the
1421 00:47:58,641 —> 00:48:00,080 new happenings when the
1422 00:48:00,080 —> 00:48:01,581 podcast is released
1423 00:48:01,781 —> 00:48:03,549 and all that fun stuff.
1424 00:48:03,749 —> 00:48:06,240 So we’d love to have you join us if
1425 00:48:06,240 —> 00:48:08,048 you’re not already in our community,
1426 00:48:08,660 —> 00:48:11,080 we will wrap up with Kamille
1427 00:48:11,280 —> 00:48:14,538 walking through some Google drive stuff.
1428 00:48:15,370 —> 00:48:16,548 There you go.
1429 00:48:16,870 —> 00:48:17,938 Is my screen up?
1430 00:48:18,570 —> 00:48:19,538 Yep. Okay.
1431 00:48:20,270 —> 00:48:21,938 So I
1432 00:48:22,570 —> 00:48:24,966 am again one of the very few
1433 00:48:25,166 —> 00:48:28,560 people that will be affected by Airtable’s
1434 00:48:28,560 —> 00:48:31,828 move away from permanent attachment links,
1435 00:48:33,170 —> 00:48:34,568 you know, being reliable
1436 00:48:34,768 —> 00:48:36,009 outside of Airtable
1437 00:48:36,209 —> 00:48:37,641 if you’re using the API to
1438 00:48:37,841 —> 00:48:39,034 grab a static link
1439 00:48:39,234 —> 00:48:40,612 to an attachment image.
1440 00:48:40,812 —> 00:48:42,110 It’s not gonna work after
1441 00:48:42,110 —> 00:48:42,838 November.
1442 00:48:43,370 —> 00:48:46,748 And because the way my old website was,
1443 00:48:47,570 —> 00:48:48,749 you know, set up,
1444 00:48:48,949 —> 00:48:51,038 I was storing all of my images in
1445 00:48:51,370 —> 00:48:53,268 Airtable’s attachment fields
1446 00:48:53,400 —> 00:48:55,638 and pulling those static
1447 00:48:56,170 —> 00:48:58,297 URLs to display them on my website.
1448 00:48:58,497 —> 00:49:00,120 Well I have to think through a
1449 00:49:00,120 —> 00:49:02,115 different way of organizing
1450 00:49:02,315 —> 00:49:02,886 my stuff
1451 00:49:03,086 —> 00:49:04,124 and I remembered
1452 00:49:04,324 —> 00:49:05,810 that I basically store all
1453 00:49:05,810 —> 00:49:08,448 of my files on Google drive anyway
1454 00:49:08,870 —> 00:49:11,361 so I have been going through
1455 00:49:11,561 —> 00:49:13,987 the process of transitioning
1456 00:49:14,187 —> 00:49:15,720 my methodology to
1457 00:49:15,720 —> 00:49:17,638 keeping all of my stuff on
1458 00:49:18,070 —> 00:49:19,135 Google drive
1459 00:49:19,335 —> 00:49:22,113 and associating each of my files
1460 00:49:22,313 —> 00:49:24,370 with the relevant project.
1461 00:49:24,370 —> 00:49:25,815 So my file structure
1462 00:49:26,015 —> 00:49:27,833 for Google drive is set up
1463 00:49:28,033 —> 00:49:29,790 where I have a portfolio top
1464 00:49:29,790 —> 00:49:30,628 level folder,
1465 00:49:31,070 —> 00:49:33,007 and Airtable’s reading that folder
1466 00:49:33,207 —> 00:49:34,120 and pulling it in
1467 00:49:34,320 —> 00:49:35,570 through their native Google
1468 00:49:35,570 —> 00:49:37,159 drive integration sync
1469 00:49:37,359 —> 00:49:39,169 which is very very helpful
1470 00:49:39,369 —> 00:49:40,770 and I’m just gonna talk
1471 00:49:40,770 —> 00:49:42,604 through a couple of things
1472 00:49:42,804 —> 00:49:44,294 that I’ve done to help
1473 00:49:44,494 —> 00:49:45,920 the process along and my
1474 00:49:45,920 —> 00:49:48,338 Interface that I used to control which
1475 00:49:48,690 —> 00:49:51,248 images will eventually appear on my site.
1476 00:49:51,370 —> 00:49:52,138 So
1477 00:49:52,570 —> 00:49:55,373 when you sync into Airtable
1478 00:49:55,573 —> 00:49:58,280 you get A URL, or not a URL
1479 00:49:58,280 —> 00:50:00,928 a file path of the top level folder
1480 00:50:01,330 —> 00:50:02,750 that you’ve selected to sync.
1481 00:50:02,950 —> 00:50:04,368 And then all of the sub folders
1482 00:50:04,568 —> 00:50:05,100 leading into the
1483 00:50:05,100 —> 00:50:05,978 actual file.
1484 00:50:06,660 —> 00:50:09,055 I’m using a combination of
1485 00:50:09,255 —> 00:50:11,538 find and Rejex to pull out
1486 00:50:11,960 —> 00:50:13,414 pieces of information.
1487 00:50:13,614 —> 00:50:16,190 So I have a very regulated file structure.
1488 00:50:16,190 —> 00:50:19,130 I put everything by the project type.
1489 00:50:19,330 —> 00:50:20,994 It’s either urban planning
1490 00:50:21,194 —> 00:50:22,019 or it’s Airtable
1491 00:50:22,219 —> 00:50:24,339 or its graphic design or something.
1492 00:50:24,539 —> 00:50:26,520 That’s the first sub folder and then
1493 00:50:26,520 —> 00:50:27,858 the second sub folder
1494 00:50:28,058 —> 00:50:30,019 is going to be the project name.
1495 00:50:30,219 —> 00:50:31,490 And then from there it’s
1496 00:50:31,490 —> 00:50:32,633 a free for all because
1497 00:50:32,833 —> 00:50:33,860 for planning projects
1498 00:50:34,060 —> 00:50:35,230 I have way more attachments.
1499 00:50:35,230 —> 00:50:36,361 Some of them are images.
1500 00:50:36,561 —> 00:50:37,487 Some of them are pdf.
1501 00:50:37,687 —> 00:50:38,810 Some of them are working files
1502 00:50:38,810 —> 00:50:40,738 like illustrator or sketch up.
1503 00:50:41,160 —> 00:50:42,449 For Airtable projects,
1504 00:50:42,649 —> 00:50:43,976 it’s only gonna be images
1505 00:50:44,176 —> 00:50:45,250 and there’s not gonna be
1506 00:50:45,250 —> 00:50:46,818 those sub folders. So
1507 00:50:47,960 —> 00:50:49,198 my last
1508 00:50:50,160 —> 00:50:51,950 formula field is a little bit
1509 00:50:52,150 —> 00:50:53,000 more complicated
1510 00:50:53,200 —> 00:50:55,328 to get what the name of the project is.
1511 00:50:55,760 —> 00:50:57,426 I’m not going to explain this
1512 00:50:57,626 —> 00:50:59,840 in detail because this would take forever.
1513 00:50:59,840 —> 00:51:02,094 But essentially I’m saying
1514 00:51:02,294 —> 00:51:04,915 if it’s urban planning project,
1515 00:51:05,115 —> 00:51:06,690 it probably has a sub
1516 00:51:06,690 —> 00:51:08,981 folder that I have to parse out
1517 00:51:09,181 —> 00:51:10,238 and get just what
1518 00:51:10,560 —> 00:51:12,298 the name of the project is.
1519 00:51:12,450 —> 00:51:13,188 If it’s
1520 00:51:13,560 —> 00:51:14,758 a Airtable project,
1521 00:51:14,958 —> 00:51:17,266 it probably doesn’t have a sub folder.
1522 00:51:17,466 —> 00:51:18,480 And it’s more simple
1523 00:51:18,480 —> 00:51:19,818 to get that the project name is.
1524 00:51:20,460 —> 00:51:21,583 So at the end of the day
1525 00:51:21,783 —> 00:51:22,745 I have a formula field
1526 00:51:22,945 —> 00:51:23,970 that just spits out what the
1527 00:51:23,970 —> 00:51:26,738 name of the project is based on the
1528 00:51:27,060 —> 00:51:29,211 one of the folders in the file path.
1529 00:51:29,411 —> 00:51:31,600 And then I have a simple automation that
1530 00:51:31,600 —> 00:51:33,872 will take that and copy and paste it
1531 00:51:34,072 —> 00:51:35,828 into the link to project field.
1532 00:51:36,360 —> 00:51:37,278 And that’s what happens.
1533 00:51:38,460 —> 00:51:40,827 Then if we take a look at my
1534 00:51:41,027 —> 00:51:42,588 demo website again,
1535 00:51:42,788 —> 00:51:44,970 I was building this in Glide.
1536 00:51:44,970 —> 00:51:47,092 It hasn’t really gone live yet.
1537 00:51:47,292 —> 00:51:49,064 But I’m either going to use
1538 00:51:49,264 —> 00:51:50,310 this thing or use a
1539 00:51:50,310 —> 00:51:51,762 very, very similar process
1540 00:51:51,962 —> 00:51:53,828 to what I’m showing here. And you can
1541 00:51:54,260 —> 00:51:55,943 see that I have one image
1542 00:51:56,143 —> 00:51:57,242 that will show up
1543 00:51:57,442 —> 00:51:59,310 when you’re looking at a grid of
1544 00:51:59,310 —> 00:52:00,556 all of my projects.
1545 00:52:00,756 —> 00:52:01,893 And again it will,
1546 00:52:02,093 —> 00:52:04,230 it’ll appear here. But if I look at a
1547 00:52:04,230 —> 00:52:05,820 gallery of images,
1548 00:52:06,020 —> 00:52:07,911 I have a lot of images
1549 00:52:08,111 —> 00:52:10,060 that are also associated.
1550 00:52:10,060 —> 00:52:12,218 So the way I accomplished that
1551 00:52:12,640 —> 00:52:15,618 in my setup is to have a column for
1552 00:52:16,050 —> 00:52:18,085 a check box that should this
1553 00:52:18,285 —> 00:52:20,032 image appear on the site?
1554 00:52:20,232 —> 00:52:21,500 And is this image the
1555 00:52:21,500 —> 00:52:22,428 cover image?
1556 00:52:22,950 —> 00:52:24,963 And the easiest way to go through
1557 00:52:25,163 —> 00:52:27,280 all of my files is to look at it in an
1558 00:52:27,280 —> 00:52:28,728 Interface. So
1559 00:52:29,150 —> 00:52:31,429 it’s a fairly simple setup.
1560 00:52:31,629 —> 00:52:33,919 I have a list of my projects
1561 00:52:34,119 —> 00:52:35,228 off to the left.
1562 00:52:35,750 —> 00:52:37,523 And then in the center view,
1563 00:52:37,723 —> 00:52:38,806 I just have simply
1564 00:52:39,006 —> 00:52:40,310 all I need to know is the
1565 00:52:40,310 —> 00:52:41,576 name of the project.
1566 00:52:41,776 —> 00:52:44,108 And then I have a bunch of number fields
1567 00:52:44,730 —> 00:52:46,928 to help me see
1568 00:52:47,450 —> 00:52:49,394 whether or not I think I have
1569 00:52:49,594 —> 00:52:51,009 enough images that are
1570 00:52:51,209 —> 00:52:52,680 marked as published and
1571 00:52:52,680 —> 00:52:54,794 whether or not I have a cover photo.
1572 00:52:54,994 —> 00:52:57,260 So I’ve gone in and unchecked one of these
1573 00:52:57,260 —> 00:52:59,228 boxes just so that you could see.
1574 00:52:59,550 —> 00:53:01,571 That’s what the use case is.
1575 00:53:01,771 —> 00:53:03,641 I only need one cover image
1576 00:53:03,841 —> 00:53:04,841 and it’s that one
1577 00:53:05,550 —> 00:53:07,009 and having this up at the top
1578 00:53:07,209 —> 00:53:08,820 just lets me know at a quick glance,
1579 00:53:08,820 —> 00:53:10,441 oh I forgot to fill this one in.
1580 00:53:10,641 —> 00:53:11,808 Let me go back and do that.
1581 00:53:12,450 —> 00:53:14,518 But with this layout
1582 00:53:14,718 —> 00:53:18,163 I’m able to look at the thumbnail.
1583 00:53:18,363 —> 00:53:19,480 Obviously the
1584 00:53:19,480 —> 00:53:21,649 thumbnails pulled in from the sync
1585 00:53:21,849 —> 00:53:24,010 are very small versions of the image.
1586 00:53:24,010 —> 00:53:25,604 So it’s I can’t really
1587 00:53:25,804 —> 00:53:27,343 see it in all its glory,
1588 00:53:27,543 —> 00:53:29,400 but if I wanted to view it in
1589 00:53:29,400 —> 00:53:31,355 full I could click the button
1590 00:53:31,555 —> 00:53:34,118 that comes along with the integration and
1591 00:53:34,350 —> 00:53:36,048 view the image
1592 00:53:36,130 —> 00:53:36,728 you know
1593 00:53:37,450 —> 00:53:37,818 it
1594 00:53:38,250 —> 00:53:40,258 larger in case I have very similar
1595 00:53:40,458 —> 00:53:41,238 looking images
1596 00:53:41,438 —> 00:53:42,798 and I need to pick which one
1597 00:53:42,900 —> 00:53:44,808 is the one I have that button there.
1598 00:53:45,250 —> 00:53:46,457 I also have the name
1599 00:53:46,657 —> 00:53:47,807 of the file in there.
1600 00:53:48,007 —> 00:53:49,560 I’ve been considering whether or
1601 00:53:49,560 —> 00:53:51,670 not to add another column
1602 00:53:51,870 —> 00:53:54,118 for caption because sometimes
1603 00:53:54,450 —> 00:53:56,204 you know the name of the image.
1604 00:53:56,404 —> 00:53:57,475 If I haven’t gone in
1605 00:53:57,675 —> 00:53:58,920 and renamed something might
1606 00:53:58,920 —> 00:54:00,631 not be what I want to show as
1607 00:54:00,831 —> 00:54:02,289 the caption on my website.
1608 00:54:02,489 —> 00:54:03,580 So that may be the next
1609 00:54:03,580 —> 00:54:05,905 step for me in my file manager Interface.
1610 00:54:06,105 —> 00:54:08,060 Just adding a quick little column that
1611 00:54:08,060 —> 00:54:10,167 says caption and then telling
1612 00:54:10,367 —> 00:54:11,447 Glide to pull in
1613 00:54:11,647 —> 00:54:13,608 that field versus the file name.
1614 00:54:14,140 —> 00:54:15,947 And then of course my two
1615 00:54:16,147 —> 00:54:18,229 check boxes for whether or not
1616 00:54:18,429 —> 00:54:19,200 I want this to
1617 00:54:19,200 —> 00:54:20,218 appear on the site
1618 00:54:20,910 —> 00:54:22,047 and I have it grouped.
1619 00:54:22,247 —> 00:54:23,908 So here are the ones that I’ve said
1620 00:54:24,340 —> 00:54:26,747 I want to keep them in my Google drive
1621 00:54:26,947 —> 00:54:29,030 so I always have access to them but I
1622 00:54:29,030 —> 00:54:31,343 don’t necessarily need them on my website.
1623 00:54:31,543 —> 00:54:33,380 I wanted to make sure that all of the
1624 00:54:33,380 —> 00:54:35,398 good ones, the ones that are really gonna,
1625 00:54:35,940 —> 00:54:37,357 you know, pull people’s attention
1626 00:54:37,557 —> 00:54:38,688 are the ones that get published
1627 00:54:38,760 —> 00:54:41,598 and having it in an Interface means I can
1628 00:54:42,540 —> 00:54:46,008 focus in on the information I want to see
1629 00:54:46,340 —> 00:54:47,432 very, very quickly
1630 00:54:47,632 —> 00:54:49,141 and then switch in between
1631 00:54:49,341 —> 00:54:50,708 projects also very quickly.
1632 00:54:51,040 —> 00:54:52,995 So that’s pretty much it
1633 00:54:53,195 —> 00:54:55,520 for how I’ve laid everything out.
1634 00:54:55,720 —> 00:54:56,750 I showed the other
1635 00:54:56,750 —> 00:54:59,030 part of this Interface before,
1636 00:54:59,230 —> 00:55:00,986 which shows each project
1637 00:55:01,186 —> 00:55:02,450 and then information
1638 00:55:02,450 —> 00:55:04,002 about each one that allows me
1639 00:55:04,202 —> 00:55:05,608 to edit things really quickly.
1640 00:55:06,440 —> 00:55:08,964 But the file manager I think
1641 00:55:09,164 —> 00:55:10,829 is probably the one
1642 00:55:11,029 —> 00:55:13,020 I’m going to use the most
1643 00:55:13,020 —> 00:55:13,808 because
1644 00:55:14,440 —> 00:55:16,305 I might add as the project goes on,
1645 00:55:16,505 —> 00:55:18,490 I might make a new graphic that I want to
1646 00:55:18,490 —> 00:55:19,746 appear on the website
1647 00:55:19,946 —> 00:55:22,018 and I want to be able to review things
1648 00:55:22,640 —> 00:55:24,798 fast enough and make sure that
1649 00:55:24,998 —> 00:55:25,897 I have enough
1650 00:55:26,097 —> 00:55:28,108 that’s displayed on the website.
1651 00:55:30,340 —> 00:55:30,898 That’s it.
1652 00:55:32,440 —> 00:55:33,058 That’s cool.
1653 00:55:34,540 —> 00:55:36,031 I do think, I mean, I think
1654 00:55:36,231 —> 00:55:38,130 we’re just gonna see more and more of,
1655 00:55:38,130 —> 00:55:39,894 you know, Airtable’s the back end
1656 00:55:40,094 —> 00:55:42,140 and then some maybe something else for the
1657 00:55:42,140 —> 00:55:43,027 front end.
1658 00:55:43,227 —> 00:55:45,216 But this just showcases
1659 00:55:45,416 —> 00:55:47,638 how useful that scenario is,
1660 00:55:50,340 —> 00:55:53,598 awesome. Thank you Kamille.
1661 00:55:54,340 —> 00:55:55,038 Cool.
1662 00:55:55,130 —> 00:55:57,876 That wraps up our show for today.
1663 00:55:58,076 —> 00:56:01,288 Any final parts before we end our season?
1664 00:56:05,150 —> 00:56:06,367 I’m bummed we’re at the end
1665 00:56:06,567 —> 00:56:07,567 of the season.
1666 00:56:11,730 —> 00:56:13,211 Maybe actually take a vacation.
1667 00:56:13,411 —> 00:56:15,170 I don’t know, I haven’t done this summer.
1668 00:56:15,170 —> 00:56:15,738 I need to,
1669 00:56:17,830 —> 00:56:19,708 we’re going to stay here
1670 00:56:19,908 —> 00:56:21,898 and we’re gonna work nonstop
1671 00:56:22,230 —> 00:56:24,212 so that we have just the
1672 00:56:24,412 —> 00:56:26,608 coolest looking Interfaces.
1673 00:56:27,530 —> 00:56:30,128 That’s probably in the reality.
1674 00:56:32,130 —> 00:56:33,511 Okay. So for the previous
1675 00:56:33,711 —> 00:56:35,076 competitions that Airtable
1676 00:56:35,276 —> 00:56:36,440 has done the scripting one
1677 00:56:36,440 —> 00:56:37,698 and the
1678 00:56:38,130 —> 00:56:39,252 Custom Blocks one,
1679 00:56:39,452 —> 00:56:41,251 the entries were like publicly
1680 00:56:41,451 —> 00:56:42,930 accessible in like a gallery
1681 00:56:42,930 —> 00:56:43,805 kind of thing.
1682 00:56:44,005 —> 00:56:45,152 Are the Interfaces,
1683 00:56:45,352 —> 00:56:46,441 do we know if those
1684 00:56:46,641 —> 00:56:47,930 are going to be available?
1685 00:56:47,930 —> 00:56:50,508 I ask because we have a full month
1686 00:56:51,140 —> 00:56:52,579 sort of that we’re going
1687 00:56:52,779 —> 00:56:53,779 to be off and then
1688 00:56:54,030 —> 00:56:55,285 I think by the time
1689 00:56:55,485 —> 00:56:57,204 we come back with season 12
1690 00:56:57,404 —> 00:56:59,050 we might be able to do like a
1691 00:56:59,050 —> 00:57:00,710 just a review and looking through
1692 00:57:00,910 —> 00:57:02,270 some of the submissions. Maybe?
1693 00:57:02,270 —> 00:57:02,798 I don’t know.
1694 00:57:03,230 —> 00:57:05,342 I think a lot of people are sharing them
1695 00:57:05,542 —> 00:57:07,190 on the actual post in the community
1696 00:57:07,190 —> 00:57:07,738 because
1697 00:57:08,070 —> 00:57:09,831 I think Kuovonne had asked that question
1698 00:57:10,031 —> 00:57:11,020 to Jordan and she was like,
1699 00:57:11,020 —> 00:57:13,278 oh, I’d love if you just post it here too
1700 00:57:13,350 —> 00:57:14,869 hopefully we’ll have a
1701 00:57:15,069 —> 00:57:16,388 nice repository there.
1702 00:57:17,830 —> 00:57:20,520 Yeah. I’m curious to see what other people
1703 00:57:20,720 —> 00:57:22,890 do because I have I think a handful
1704 00:57:22,890 —> 00:57:25,706 of Interfaces that I personally use
1705 00:57:25,906 —> 00:57:27,798 myself that I’ve built and
1706 00:57:29,030 —> 00:57:30,522 I, the way I design things,
1707 00:57:30,722 —> 00:57:31,921 a lot of my stuff looks
1708 00:57:32,121 —> 00:57:33,120 similar because I have,
1709 00:57:33,120 —> 00:57:34,846 I’m very particular about the way
1710 00:57:35,046 —> 00:57:36,123 I want stuff laid out.
1711 00:57:36,323 —> 00:57:37,200 And so I am curious to
1712 00:57:37,200 —> 00:57:38,588 see how other people
1713 00:57:39,430 —> 00:57:40,545 set their stuff up.
1714 00:57:40,745 —> 00:57:42,261 Even if I have a completely
1715 00:57:42,461 —> 00:57:43,890 different use case like Chris
1716 00:57:43,890 —> 00:57:45,269 was showing with the way
1717 00:57:45,469 —> 00:57:46,730 you’ve done your chart.
1718 00:57:46,930 —> 00:57:48,430 It’s so simple and yet it never
1719 00:57:48,430 —> 00:57:50,009 occurred to me to
1720 00:57:50,209 —> 00:57:52,888 use a chart in that way. And so
1721 00:57:53,330 —> 00:57:57,603 now I want to see everybody’s stuff.
1722 00:57:57,803 —> 00:57:59,028 I’m excited.
1723 00:57:59,080 —> 00:58:00,618 We should just have like an
1724 00:58:00,818 —> 00:58:02,498 Interface share day or something.
1725 00:58:02,830 —> 00:58:04,096 Yeah, yeah, for sure.
1726 00:58:04,296 —> 00:58:05,438 We’ll go through it.
1727 00:58:05,638 —> 00:58:06,750 So cool. I’m gonna end,
1728 00:58:06,750 —> 00:58:08,086 I’m gonna end the show
1729 00:58:08,286 —> 00:58:09,784 and thankful for everybody
1730 00:58:09,984 —> 00:58:10,820 that participated,
1731 00:58:10,820 —> 00:58:12,909 we will be back with you in September.
1732 00:58:13,109 —> 00:58:14,109 Take care, everyone.
1733 00:58:15,130 —> 00:58:17,098 Thank you. Bye.
Share: