7/26/2022 – BuiltOnAir Live Podcast Full Show – S11-E12
Duration: 56 minutes
Be Sure to Subscribe to the podcast!
To get all the latest videos and demonstrations from the BuiltOnAir Podcast, subscribe and get notified on our Youtube channel here and our newsletter/community here.
FULL EPISODE VIDEO
Watch the full video of the show. See below for segment details.
The BuiltOnAir Podcast is Sponsored by On2Air – Integrations and App extensions to run your business operations in Airtable.
In This Episode
Welcome to the BuiltOnAir Podcast, the live show. The BuiltOnAir Podcast is a live weekly show highlighting everything happening in the Airtable world.
Check us out at BuiltOnAir.com. Join our community, join our Slack Channel, and meet your fellow Airtable fans.
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.