![[S13-E07] Full Podcast Summary for 02-21-2023 – RPG in Airtable from Jeremy Olgesby](https://builtonair.com/wp/../uploads/segment_image_1-92.png)
2/21/2023 – BuiltOnAir Live Podcast Full Show – S13-E07
Duration: 61 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.
Todays Hosts
Alli Alosa – Hi there! I’m Alli 🙂 I’m a fine artist turned “techie” with a passion for organization and automation. I’m also proud to be a Community Leader in the Airtable forum, and a co-host of the BuiltOnAir podcast. My favorite part about being an Airtable consultant and developer is that I get to talk with people from all sorts of industries, and each project is an opportunity to learn how a business works.
Kamille Parks – I am an Airtable Community Forums Leader and the developer behind the custom Airtable app “Scheduler”, one of the winning projects in the Airtable Custom Blocks Contest now widely available on the Marketplace. I focus on building simple scripts, automations, and custom apps for Airtable that streamline data entry and everyday workflows.
Dan Fellars – I am the Founder of Openside, On2Air, and BuiltOnAir. I love automation and software. When not coding the next feature of On2Air, I love spending time with my wife and kids and golfing.
Show Segments
Round The Bases – 00:03:22 –
Following Articles Used in this Segment:
[Airtable Community] New: Visual Refresh – Airtable Community
[Airtable Community] New: Repeating groups of actions in Automations – Airtable Community
[BuiltOnAir Community] general – BuiltOnAir – Slack
[BuiltOnAir Community] general – BuiltOnAir – Slack
[Facebook] (20+) Airtable Community | 🚨 COMMUNITY EXCLUSIVE: | Facebook
Meet the Experts – 00:24:57 –
Meet Jeremy Oglesby.
Jeremy is a software developer, and Airtable Community Leader
Base Showcase – 00:35:37 –
We dive into a full working base that will Jeremy will showcase his adventure game system built with Airtable interfaces and automations that will showcase the power of what Airtable can be used for.
Scripting Time – 00:57:51 –
Explore Scripting with “Linked Record Sorting”.
Alli will share a script to keep Linked Records sorted in a particular order..
Full Segment Details
Segment: Round The Bases
Start Time: 00:03:22
Roundup of what’s happening in the Airtable communities – Airtable, BuiltOnAir, Reddit, Facebook, YouTube, and Twitter.
Following Articles Used in this Segment:
[Airtable Community] New: Visual Refresh – Airtable Community
[Airtable Community] New: Repeating groups of actions in Automations – Airtable Community
[BuiltOnAir Community] general – BuiltOnAir – Slack
[BuiltOnAir Community] general – BuiltOnAir – Slack
[Facebook] (20+) Airtable Community | 🚨 COMMUNITY EXCLUSIVE: | Facebook
Segment: Meet the Experts
Start Time: 00:24:57
Jeremy Oglesby –
Meet Jeremy Oglesby.
Jeremy is a software developer, and Airtable Community Leader
Segment: Base Showcase
Start Time: 00:35:37
Adventure game system
We dive into a full working base that will Jeremy will showcase his adventure game system built with Airtable interfaces and automations that will showcase the power of what Airtable can be used for.
Segment: Scripting Time
Start Time: 00:57:51
Scripting Time: Linked Record Sorting
Explore Scripting with “Linked Record Sorting”.
Alli will share a script to keep Linked Records sorted in a particular order..
Full Transcription
The full transcription for the show can be found here:
[00:01:42] Welcome back to the BuiltOnAir podcast, [00:01:46] season 13, Episode seven. [00:01:48] Good to be back with you. [00:01:49] We've got a full house here myself, [00:01:51] Kamille and Alli welcome [00:01:55] and we've got a new face here, [00:01:58] I'm actually going to [00:02:00] take our banner off so we [00:02:02] can see everyone. [00:02:04] There we go, Jeremy welcome. [00:02:08] Jeremy will be with us [00:02:11] and we will be [00:02:14] his back ground and story [00:02:18] world later in the segment, [00:02:20] but I will walk through [00:02:21] what we're gonna be talking [00:02:23] about today. [00:02:24] As always, the BuiltOnAir community [00:02:27] or the podcast is an hour long show where [00:02:29] we talk about all things Airtable [00:02:32] and what is going on. And we have four [00:02:35] different segments. Our [00:02:37] first is Round the Bases [00:02:39] to get you up to date on [00:02:40] everything new happening in Airtable, [00:02:43] then a quick spotlight on On2Air our [00:02:45] primary sponsor and then [00:02:47] we'll learn about Jeremy [00:02:50] and his background and story [00:02:52] and then Jeremy is going to share [00:02:54] a cool base that he has built [00:02:56] in the adventure [00:02:57] gaming world [00:02:59] and then a quick spotlight [00:03:01] on how to join our community [00:03:02] and then finally, [00:03:03] Alli will be showing some scripting [00:03:06] and how to keep linked records towards it. [00:03:11] Okay, let's see what's going on [00:03:17] around the bases. [00:03:19] So first, let's start off big event [00:03:23] coming from the world and [00:03:26] Chris [00:03:28] and Ben at the Airtable community, [00:03:31] they announced [00:03:34] actually this is not, [00:03:37] no, no, [00:03:40] it's kind of it. [00:03:46] so they have the the announced, [00:03:52] and be at the headquarters for [00:03:57] Airtable, [00:04:01] I'm losing connection. [00:04:04] Well, well, I'll restate it just [00:04:08] so Airtable is happening. [00:04:12] Yeah, go for it, [00:04:13] I was just gonna say [00:04:15] so the Airtable conference this year [00:04:18] is going to be at the Airtable [00:04:20] Headquarters in San Francisco. [00:04:23] And this is the third year that [00:04:27] Chris Dancy has put this event on. [00:04:30] And I believe the second year [00:04:34] that Ben Green has assisted. [00:04:37] I could be wrong, [00:04:39] but last year was super fun. [00:04:41] We all went to Austin Texas [00:04:44] and we were joined [00:04:45] by some employees of Airtable [00:04:48] and this year we're going to be in the [00:04:51] headquarters. So [00:04:53] you know [00:04:54] the A. P. I call will be coming [00:04:56] from inside the house. [00:04:59] Yeah. [00:05:01] Yeah. Very exciting. [00:05:03] So there is a limit though. [00:05:05] That's the one thing. [00:05:07] Only 75 tickets because [00:05:09] it's in a limited space [00:05:11] at Airtable headquarters. [00:05:12] So get your tickets today. [00:05:18] So go to daretable.com [00:05:20] for more information. [00:05:26] Any other comments on DareTable? [00:05:29] I will do my best to attend. [00:05:31] I thought I was going originally, [00:05:33] I'm pretty sure I'm going [00:05:35] but I'll have been starting [00:05:37] a new job and so that's [00:05:38] always iffy whether or not [00:05:39] you can get the, you know [00:05:41] the hours off. [00:05:42] So the hope is that I can go [00:05:45] Alli you making it? [00:05:47] Yep. I bought my ticket this morning. [00:05:51] Nice Jeremy, is that in the plans? [00:05:54] No, unfortunately not for me this year. [00:05:59] That's a long trip out [00:06:00] there from Arkansas. [00:06:03] Yeah, that's true. [00:06:06] Cool. Well hopefully we'll meet [00:06:09] some of you all there. [00:06:10] We'll do something and [00:06:12] excited to see everybody, [00:06:14] I will be there. [00:06:16] Okay, next a few announcements [00:06:19] from Airtable, they were busy, [00:06:22] couple things got released. [00:06:25] They did release the repeating [00:06:28] groups of actions [00:06:29] in automations. So in automations [00:06:33] the ability to loop through records and [00:06:36] perform tasks on a [00:06:38] per record basis is now live [00:06:41] thoughts on that feature? [00:06:44] Have you played with it? Yes. It is, [00:06:48] it's one or the other whether [00:06:50] or not an automation can do conditional [00:06:53] actions or repeated actions. [00:06:56] You can't have both [00:06:58] a conditional group or series [00:07:00] of groups and repeating group. [00:07:03] So if you have an existing automation [00:07:05] you should be able to add repeating [00:07:07] actions to it. [00:07:08] You know, unless there's [00:07:10] already conditions in it, [00:07:11] I think that's what I've experienced. [00:07:15] It so far works as expected to me. [00:07:18] There is, I do wish you could as it's [00:07:21] looping through. [00:07:23] It will give you whatever [00:07:25] the current item in your loop is, [00:07:27] but it doesn't give the item index. [00:07:30] So if you have 50 records [00:07:32] found from a find [00:07:33] record step, it doesn't let you [00:07:35] know that you're on 30 out of 50. [00:07:37] That could be useful in a [00:07:39] lot of different ways. And so I [00:07:41] you know, I'm hoping that in [00:07:44] improvements down the line, [00:07:46] they include the loop [00:07:47] index and sorting over raise. [00:07:50] That be great. [00:07:52] Exactly. I'm also [00:07:55] it would be great. [00:07:56] It looks to me right now, [00:07:57] I haven't played around with it a [00:07:58] ton but I think it only works [00:08:01] with linked record fields [00:08:03] and look up fields. [00:08:04] It would be nice if we could [00:08:06] use like fields [00:08:08] that are inherently in array [00:08:09] that Airtable sees them [00:08:11] as but it would be great [00:08:12] to be able to use a string and [00:08:13] then tell it what the d limiter is [00:08:15] or even if you just give [00:08:17] it a number field, if I say, [00:08:20] You know, if I give something [00:08:21] five out of five stars in a rating field, [00:08:24] maybe I wanna loop for each rating. Right? [00:08:28] Yeah, that'd be interesting. [00:08:31] Yeah that's definitely you know, [00:08:33] moving in the right direction, [00:08:35] you can see them slowly eating [00:08:38] into the Zapier, make make use cases [00:08:43] so this is a big one. [00:08:44] And being able to loop through those [00:08:47] and the good part I think Kamille [00:08:49] you mentioned it does not count as like [00:08:51] additional execution limits [00:08:54] so they only count at the [00:08:56] top level execution. So every time [00:08:59] an automation is triggered [00:09:01] is how they count. [00:09:02] Your automation runs [00:09:04] nice release [00:09:08] when it's like the loops and [00:09:10] do eat away at every single. [00:09:15] Is there a limit on the number of [00:09:18] records you can query in there find? [00:09:21] Yes. So the find records step has a limit [00:09:25] of [00:09:25] 100 records which is pretty small [00:09:27] but you can use if you have a pro plan or [00:09:30] higher you can use a run a script [00:09:33] action to sort of replace [00:09:35] the functionality of [00:09:37] a find record step. [00:09:39] I do think the limit there is 8000, [00:09:44] I feel like I saw that number somewhere. [00:09:46] So there is another hard limit but it [00:09:48] is far more than 100. [00:09:52] So if you were using automations [00:09:54] to process like when [00:09:56] a record triggered and [00:09:57] you had like a simple automation [00:09:59] that did something [00:10:00] each time a record triggered [00:10:02] one way to save on your automations [00:10:04] to like change that to be like a [00:10:06] scheduled trigger and then do a look up [00:10:09] of any record that meets your criteria [00:10:12] and then pass those through this [00:10:14] and now that only counts [00:10:15] as one and you could [00:10:16] do up to [00:10:16] 100 [00:10:18] not one, so [00:10:20] save you some execution usage, [00:10:26] yep cool, it's glad to see that. [00:10:29] All right, there was another big one. [00:10:32] Sure everybody noticed this one [00:10:35] refresh of their visual layout, [00:10:38] quite a bit of changes. [00:10:41] The reaction was was mixed, [00:10:43] I'd probably say it was definitely, [00:10:46] I feel like the reaction was more [00:10:49] on the negative side [00:10:50] of people shocked from, [00:10:51] from the reaction, [00:10:53] I did see some positive [00:10:55] I'll just go through, [00:10:57] there was a couple of reactions [00:11:00] on Twitter of making it [00:11:02] to faded. Some people said [00:11:05] that if you're colorblind [00:11:07] this was a bad change. [00:11:09] There is some feedback in [00:11:12] in the BuiltOnAir community. So [00:11:16] yeah, I I pointed out that the [00:11:19] two grays on the, in the other one, [00:11:22] the screenshot from the slack, [00:11:26] the two bottom grays [00:11:28] on the right hand side to [00:11:30] me look pretty close to identical. [00:11:34] Yeah, the other ones [00:11:36] I can see a clear difference [00:11:37] in between the colors in [00:11:38] terms of saturation and you know [00:11:40] how dark each color is, but I did find the [00:11:43] grays a little funny. [00:11:48] Yeah. Initial reaction Alli? [00:11:51] I mean I noticed it was funny, [00:11:53] I had two different tabs open [00:11:55] while they were [00:11:56] pushing these updates out [00:11:58] and one of them had the new look [00:11:59] and one of them had [00:12:00] the old look and I was like, [00:12:03] whoa, what just happened. [00:12:06] I don't mind the colors so much. [00:12:09] I what I really want [00:12:11] is the ability to choose [00:12:13] these colors for any piece of an interface [00:12:16] and they seem to you like the [00:12:19] buttons you can only pick [00:12:21] from from four different [00:12:22] colors and your number elements. [00:12:25] And the yeah, I just want the same color [00:12:28] choices across the board. [00:12:30] It would be great to have [00:12:31] more control and flexibility [00:12:32] there. [00:12:33] Can you click and zoom into this image? [00:12:39] Is it is there any way to zoom [00:12:41] into the bottom right of this? [00:12:43] So what element is that because [00:12:47] it's not quite the new list one, [00:12:51] I think this is what I had seen before [00:12:52] and I was like, I wonder when they're [00:12:54] gonna release it and they released [00:12:56] the list view and that distracted me [00:12:59] but it's still not quite this [00:13:02] because it has filter sort search [00:13:05] and a button at the top of it, [00:13:07] which would certainly be nice. [00:13:09] But why is that in the branding [00:13:12] package for here's the new, [00:13:16] its colors so much they when [00:13:18] they first came out with interfaces, [00:13:20] all of their marketing materials [00:13:22] had screenshots of stuff that just wasn't [00:13:25] possible to do with interfaces. [00:13:27] And I told them I was [00:13:29] like people want this like [00:13:30] you just can't you can't do it [00:13:32] that way. I don't understand. [00:13:34] I mean hopefully they're going in [00:13:36] that direction [00:13:37] but there's, yeah or marketing [00:13:39] coming soon or something but like what [00:13:42] what is that might also just [00:13:45] be a marketer or designers, you know, [00:13:49] version of it. [00:13:50] It could be because they could [00:13:52] have just done this in sigma and [00:13:53] it has no real connection to [00:13:58] see what they're actually doing [00:14:00] in Airtable. But there's [00:14:04] like this button up here, [00:14:06] I don't I don't think that's a real icon [00:14:09] is it? Can't tell what that is. [00:14:12] Full screen. [00:14:14] Yeah, like what, [00:14:16] what is that entire thing? [00:14:17] It looks like an expanded record [00:14:19] arrows on the sides. It does. [00:14:22] Maybe maybe this is gonna [00:14:24] be the new expanded [00:14:25] record look? I know when they [00:14:28] enabled in interfaces you can [00:14:30] expand a record [00:14:31] and it goes to a new page before, [00:14:33] it would open the expanded record [00:14:35] model that we were familiar with [00:14:37] and now it opens a new page [00:14:38] and they had talked about in a webinar [00:14:40] that they will eventually [00:14:41] allow you to do both. [00:14:42] You can go to a new page [00:14:44] or you can open a model [00:14:45] and I wonder if this is the [00:14:47] model that would open. [00:14:52] Maybe. Maybe. So [00:14:54] that's cool. What what what [00:14:56] do you think of the new icons? [00:14:58] I think there's [00:15:00] there's a screenshot somewhere. [00:15:03] The change in icons, [00:15:04] they're all pretty thin now [00:15:07] I don't have more opinion [00:15:09] than that other than [00:15:10] they're they're thinner [00:15:11] and I wonder if that makes [00:15:13] them harder to see. [00:15:15] Yeah, but they're they're pretty [00:15:17] close to what they were. [00:15:18] I think the icons aren't [00:15:21] too different. [00:15:23] They're not they used to be boxed [00:15:26] more boxed. Now they're a little bit more [00:15:28] floating like the timeline [00:15:30] one looks a lot better I think [00:15:33] or the gant because it used [00:15:35] to be encapsulated in a in a box. [00:15:39] So [00:15:40] in general I'm I'm happy with it. [00:15:42] I'm not super critical on those things. [00:15:44] So I'm okay with the changes. [00:15:48] There's one thing that I saw [00:15:51] that confused me and it related to colors [00:15:55] the and this is very specific [00:15:58] but if you know, [00:15:59] if you do a whole update of your [00:16:01] design, I noticed it. [00:16:03] If you go into automations [00:16:05] and you have an automation [00:16:07] that's turned on [00:16:09] in the sidebar where it lists [00:16:11] all your automations, it's one green. [00:16:13] And then if you look at the top [00:16:15] of the automation [00:16:16] where the toggle for on or off, [00:16:17] it's a different green. Why? [00:16:20] Because it wasn't like that [00:16:23] before someone when it [00:16:26] that's a conscious change [00:16:27] or an accidental change [00:16:29] but they're communicating the [00:16:30] same idea and it's the same [00:16:32] segment of product. [00:16:34] That's funny. Why? [00:16:39] I agree. [00:16:42] Kamille's OCD it's driving her nuts there. [00:16:44] This is why they bring me in for things is [00:16:47] just to look at screenshots [00:16:49] of things very closely into nitpick. [00:16:52] Yeah. [00:16:55] Alright. Yeah definitely changes. [00:16:58] So they're they're moving forward [00:17:01] see what they have in store next. [00:17:04] Alright, let's move on. [00:17:06] This came from Twitter [00:17:08] so this is I believe works at [00:17:11] a venture capital firm [00:17:13] but must have a developer [00:17:15] background. And the cool thing is [00:17:19] is they they wrote a script [00:17:23] to [00:17:25] where you could type in [00:17:27] how you want to describe [00:17:29] the base and they send it to [00:17:31] chat. GPT, chat Gpt knows the A. P. I. [00:17:35] And the and the structure for Airtable [00:17:39] and it provides [00:17:41] and it actually will create, [00:17:44] it gets the code from chat GPT [00:17:46] on creating the tables [00:17:48] and fields that you describe [00:17:51] and then it actually [00:17:52] executes that code [00:17:55] and so it's pretty cool [00:17:57] and the cool thing is [00:17:59] is this person shares the code so [00:18:01] you can run it yourself so [00:18:04] so you basically describe, [00:18:06] you know I want a [00:18:08] wedding tape planning table [00:18:10] with wedding guests [00:18:12] vendor and budget and you [00:18:14] know it's it doesn't support [00:18:16] all the column types [00:18:18] because Airtable doesn't [00:18:19] support them but here's [00:18:20] the base so you can click on it [00:18:24] and if you want to learn the code [00:18:27] of how it works it's all there. [00:18:32] So this is this is pretty cool. [00:18:34] We might do this as [00:18:35] a segment in the future of [00:18:37] actually running this but you can [00:18:38] see the code, [00:18:39] you you do have to provide your [00:18:41] own open ai api key [00:18:43] and then it's kind of cool. [00:18:46] It runs it and executes [00:18:48] everything from from [00:18:50] the code that it gets. So [00:18:52] that's a great use case of chat GPT, [00:18:56] awesome. [00:18:58] Good stuff there. [00:19:01] Alright. Our last one comes [00:19:04] from the new table forums [00:19:06] Scott and Kuovonne and [00:19:08] and we're also a sponsor of it [00:19:10] from BuiltOnAir. So definitely an active [00:19:13] community. Check it out at tableforums.com [00:19:16] or air.tableforums.com [00:19:19] This is just kind of a show and tell [00:19:23] from Scott talking about how if you [00:19:27] have an enterprise, [00:19:28] if you're an enterprise account, [00:19:30] you can create what they [00:19:31] call service accounts that's kind [00:19:34] of like api key that's not tied to a user. [00:19:37] So you might want to [00:19:39] set it up for some kind of [00:19:41] automation or third party integration [00:19:44] but you don't want it necessarily tied to [00:19:46] a specific user because normally [00:19:49] you're api keys [00:19:50] if you're using OAuth or or [00:19:52] the new personal access tokens [00:19:54] or the legacy ones were tied to a user. [00:19:57] So any change was associated [00:19:59] with that user. [00:20:00] Now you can basically create like [00:20:02] fake users and and they have their [00:20:05] own api key that can do things. [00:20:08] So [00:20:08] it's a good reminder, [00:20:10] but it's only at the enterprise level. [00:20:12] Yeah, [00:20:13] worth checking out. [00:20:15] And then also wanted to highlight [00:20:18] Scott mentions this. [00:20:19] I don't know where they're at now, [00:20:21] but as of four days ago. So, [00:20:22] so since the launch of TableForums, [00:20:26] you can get a badge that shows that [00:20:29] you're a founding contributor. [00:20:31] So if you ask a question [00:20:33] or give an answer to a [00:20:34] question, [00:20:35] Scott will toggle that on for you [00:20:37] and then you can actually make your badge [00:20:40] be visible like a star like this. [00:20:42] It'll say founding contributor, [00:20:44] but if you want to start to show [00:20:46] next to your name [00:20:48] then you can turn that on. [00:20:49] And as a four days ago [00:20:50] there is only 10 spots left. [00:20:52] I don't know if those have [00:20:53] all been used up Scott. [00:20:54] If you're if you're watching, [00:20:56] let us know how many how [00:20:57] many spots are left [00:20:58] and so worth worth going [00:21:00] and participating in the [00:21:02] new TableForum and get [00:21:04] your founding contributor badge. [00:21:09] Alright. Anything else I missed? [00:21:11] Any any updates? [00:21:12] Any news going on in Airtable? [00:21:14] I think that's it. [00:21:17] I don't know if we [00:21:18] missed last week. [00:21:19] I don't know if you mentioned it, [00:21:20] but they did. [00:21:22] I saw they put a hard deadline, [00:21:25] which I believe is March 12 on [00:21:28] when they will actually start [00:21:30] locking down bases that are over limits. [00:21:33] So I've been getting [00:21:35] emails on that for, a while. [00:21:38] yep. So if you've been relying on them [00:21:40] never doing it, they're gonna do it soon [00:21:42] and you won't be able [00:21:44] to create new records. [00:21:47] Yeah, that is true. [00:21:49] All right, just a second here. [00:21:54] Okay, moving on. [00:21:56] We're gonna talk about [00:22:00] where my mouse go [00:22:01] On2Air, our primary sponsor. [00:22:06] So On2Air is one toolkit [00:22:09] to run your business on Airtable. [00:22:12] It's a variety of apps that help you [00:22:14] do more with your Airtable environment. [00:22:15] So if your business depends on [00:22:18] Airtable, you want to check out On2Air and [00:22:21] for today's spotlight, [00:22:23] I wanted to showcase [00:22:25] you likely got a bunch of emails. [00:22:27] Well I got a bunch of emails [00:22:30] because of a ton of Airtable accounts [00:22:33] and all of them use the A. P. I. [00:22:35] I got flooded telling me [00:22:37] the changes to the api [00:22:38] coming up. And so we got, [00:22:40] we got a few questions from [00:22:43] our clients saying, [00:22:44] hey I got this email from Airtable, [00:22:46] what does that mean? How does it impact [00:22:48] On2Air? So just want to give an update [00:22:51] on that. We now have OAuth [00:22:54] integration with our Airtable connector. [00:22:57] So if you're using On2Air [00:23:00] you can now upgrade [00:23:02] your connection to use the OAuth [00:23:04] you'll need to do that by next February. [00:23:07] So you still have time we'll still [00:23:10] support the legacy api keys [00:23:13] as long as Airtable does [00:23:15] which they've announced the [00:23:17] the beginning of February [00:23:19] of next year will be the [00:23:20] cut off. So it's real simple. [00:23:23] Go into your existing [00:23:25] Airtable connector and [00:23:27] then now you'll see there's [00:23:28] now kind of two sections [00:23:30] we still have our legacy [00:23:31] api key [00:23:32] where you can where you can enter that in. [00:23:35] But what you wanna do is go to [00:23:37] your existing connector [00:23:39] and go through the process [00:23:41] to connect it with Airtable [00:23:43] using what is called OAuth [00:23:45] which is an industry standard [00:23:47] and that will walk you through [00:23:50] authorization [00:23:50] process. So you no longer [00:23:52] have to copy and paste any keys in. [00:23:55] You just approve to give us [00:23:57] permission to contact, [00:23:59] connect with your base. [00:24:01] And so the big thing is go [00:24:03] to your existing connection [00:24:04] and upgrade that one [00:24:05] instead of creating a new one. [00:24:07] Because then that will [00:24:09] save you from having to go [00:24:10] to all of your backups or forms [00:24:13] or anything and have to [00:24:15] like re authenticate any [00:24:17] of those as long as you're [00:24:19] updating your existing connection [00:24:21] then that that's [00:24:22] the only thing that you have to do. [00:24:23] If you create a new one, [00:24:24] then you have to go to all [00:24:26] the places that were using [00:24:27] the old one and update [00:24:28] them to the new one. So [00:24:30] much easier approach to just [00:24:32] upgrade your your existing connection. [00:24:35] So excited to to have that in [00:24:38] will be you know once [00:24:40] we'll be pushing that [00:24:41] more and more and hopefully [00:24:43] if you're new to On2Air [00:24:45] just use the the OAuth so that [00:24:47] you don't have to upgrade down the road. [00:24:51] So with that [00:24:53] we're now going to [00:24:55] learn more about Jeremy and [00:24:57] Kamille is gonna walk us [00:24:59] through his story. [00:25:00] Well Jeremy, welcome back [00:25:03] to the BuiltOnAir podcast. [00:25:05] Quite some time ago [00:25:07] we had you on back when [00:25:09] we were an interview type format. [00:25:12] So for the people who [00:25:13] haven't seen that episode, [00:25:15] tell us a little bit [00:25:17] about yourself and how you [00:25:18] started to use Airtable. [00:25:21] Sure. Yeah. So I was I was working in the [00:25:24] construction industry at the time [00:25:27] working in equipment and process QA [00:25:31] so my job was to make sure that our [00:25:34] engineering firm past audits [00:25:38] which involved a lot of record keeping. [00:25:41] And the company as is the case for [00:25:43] many companies in the construction [00:25:45] industry was pretty behind [00:25:46] the times when it [00:25:47] comes to technology [00:25:48] doing pretty much everything with paper [00:25:52] records and the file cabinets were [00:25:54] growing down the hallway [00:25:56] lining the hallway [00:25:57] with file cabinets of records of [00:26:00] just equipment calibrations [00:26:04] and and training, [00:26:06] you know, training records [00:26:10] for our technicians and just all kinds [00:26:13] of stuff that we had to furnish and keep [00:26:15] for five years in order to pass audits. [00:26:18] So when I joined the department [00:26:21] being the good millennial that I am [00:26:26] I told them yeah this this is [00:26:28] not gonna work for me, [00:26:30] I'm not gonna do paper [00:26:31] records, this is crazy. [00:26:33] So I started [00:26:35] and this this actually I'm [00:26:37] a I'm a software engineer [00:26:39] now full time software [00:26:40] engineer. But [00:26:41] this kind of started my whole journey [00:26:45] into technology I think into the [00:26:47] software industry. [00:26:49] I started with just tinkering [00:26:52] in Excel as everyone does [00:26:54] right? [00:26:55] And learning some visual basic [00:26:58] for Excel, learning how to do scripting [00:27:01] and whatnot in Excel to [00:27:03] turn those into like a form [00:27:06] on one on one sheet in Excel and you know, [00:27:11] do the input in a form and then click [00:27:13] a button that triggers a script, [00:27:15] vb script and transfers all that data [00:27:18] into another sheet that acts as the [00:27:20] database. [00:27:21] And yeah ultimately from there [00:27:24] started branching out and looking at other [00:27:27] options because Excel [00:27:29] just didn't have [00:27:31] great options for for web [00:27:34] connectivity and mobile [00:27:36] mobile options for when we [00:27:38] were doing stuff out in [00:27:40] the field, you know, [00:27:41] doing inspections [00:27:42] on site inspections or truck [00:27:43] inspections out in the field. [00:27:45] So that's where [00:27:47] I stumbled across Airtable. [00:27:50] And yeah, it started started [00:27:52] building out a system for this [00:27:54] company in Airtable for tracking [00:27:56] equipment, calibration records [00:27:58] and inspection records and whatnot. [00:28:01] And ultimately from there decided [00:28:04] that I wanted to do software stuff full [00:28:07] time. [00:28:09] So that that began a whole [00:28:11] whole process of career change, mid life, [00:28:14] career change. Sure. [00:28:16] It's I think something that [00:28:19] many of us can empathize with, [00:28:21] we have one problem that annoys us [00:28:23] sufficiently that we stumble [00:28:25] across Airtable [00:28:26] and it slowly but surely [00:28:28] takes over our lives. [00:28:29] So in addition to using [00:28:31] Airtable to make your [00:28:33] job easier and more, you know, [00:28:35] less tedious, [00:28:36] you've also implemented Airtable [00:28:38] in your downtown [00:28:40] downtime for helping to [00:28:42] coordinate some of the more [00:28:44] complex games you play [00:28:46] with your family and friends. [00:28:47] Let's hear a little bit [00:28:48] about that too. [00:28:50] Yeah, sure. So that's actually [00:28:52] I went through a period of of doing some [00:28:56] consulting and whatnot [00:28:58] with with Airtable on my own, [00:29:00] but actually over the [00:29:01] last few years, most of my Airtable [00:29:05] usage has been personal. [00:29:07] So that may kind of set me [00:29:09] apart a bit from most [00:29:11] of the guests you've had [00:29:13] on the show in the past [00:29:15] where they're building out [00:29:16] business workflows and [00:29:17] whatnot. [00:29:18] Most of my stuff is pretty whimsical [00:29:21] and it's just stuff that I feel like [00:29:23] building in the moment [00:29:25] and I'm, you know, [00:29:26] continually tinkering with over the [00:29:27] years. [00:29:29] So yeah, I've built the last time [00:29:32] I was on the show with you Kamille [00:29:34] several years ago I had built [00:29:37] a database for for tracking [00:29:40] scores for one of my [00:29:42] favorite board games. [00:29:43] And I've since I've since [00:29:45] expanded that out to a couple [00:29:47] other board games. [00:29:49] So it's it kind of makes [00:29:52] a fun little hub for [00:29:55] keeping a record of all [00:29:57] our games and our scores [00:29:58] in those games [00:30:00] and kind of [00:30:01] divvying out where we got [00:30:03] our points from in those games [00:30:04] so we can kinda analyze [00:30:05] our strategy across games. [00:30:07] And I've got all my friends [00:30:09] and family in the [00:30:10] database and kind of views shared [00:30:13] out that they can look at and see their [00:30:15] statistics and [00:30:17] I don't know, kind of plan [00:30:19] for the next time we get [00:30:20] together of how they're [00:30:21] gonna approach their their gameplay [00:30:23] based on how they've done in the past. [00:30:25] It's a lot of fun. [00:30:27] Do you anticipate joining [00:30:30] some sort of tournament [00:30:32] with your team who now have [00:30:35] all of these statistics that would [00:30:37] put them in sort of, you know, [00:30:39] prepare them for [00:30:42] I think most game groups, [00:30:44] I have a game group [00:30:45] when we are not organized at all. [00:30:47] We have one person who [00:30:49] continues to win sabotage. [00:30:52] We're not entirely sure [00:30:53] why. [00:30:59] Oh look at that. Someone else [00:31:01] is doing stuff in Airtable [00:31:03] with board games. [00:31:04] That's fun. I've actually, [00:31:06] I've had a kind of a thought [00:31:08] in the back of my [00:31:09] mind for a long time to build a [00:31:12] a web service for this kind of thing [00:31:15] of scoring board games and tracking [00:31:17] there are some web services [00:31:19] out there for like tracking [00:31:21] your scores and board [00:31:22] games. But one of the things [00:31:24] that my my Airtable base [00:31:27] in particular one for [00:31:28] a game called seven wonders [00:31:31] does is that I actually provide [00:31:33] a scoring sheet in the version of a form [00:31:36] an Airtable form. [00:31:38] They get shared out. [00:31:39] That makes it easier to score the [00:31:41] game because it's actually a [00:31:43] pretty complex game to score. [00:31:45] You have to do a lot [00:31:46] of math. And so my scoring sheet [00:31:48] just makes that easier. [00:31:49] And it does all the [00:31:50] math for you. And then produces [00:31:53] all the statistics [00:31:54] and whatnot in in the [00:31:55] Airtable back end. [00:31:58] But yeah, that's kind of one [00:32:00] of those I don't know, dreams I've had is [00:32:02] building a web service for that. [00:32:05] But to your question Kamille [00:32:08] Most of the board games I play [00:32:09] are are not, not the type [00:32:11] that are necessarily [00:32:12] suited to to competitions like that. [00:32:15] I don't do, I don't know [00:32:18] like magic the gathering [00:32:20] or Pokemon. I really, [00:32:22] I'm not, I'm not up on on the [00:32:25] competitive board gaming community, so [00:32:28] not really sure what that [00:32:30] would look like, but yeah, [00:32:32] okay, just checking, just wondering. [00:32:35] Well [00:32:36] you have [00:32:37] another demo. [00:32:40] I do, yeah, [00:32:42] let's take a look at that [00:32:44] one question. [00:32:45] Maybe I had, where you get into that [00:32:47] talk a little bit about [00:32:49] you were pretty prominent [00:32:51] in the community and and [00:32:53] answering a lot of questions, [00:32:55] how did you get into that? [00:32:57] What what's been that [00:32:58] experience like [00:32:59] and just interacting [00:33:00] with people on the community? [00:33:02] Sure, yeah, [00:33:06] how did I get into it? [00:33:07] I think I had someone [00:33:09] answer a question for me, [00:33:10] I believe it was Alex Wolff, [00:33:12] actually, I can, I can quite [00:33:15] quite vividly remember [00:33:17] the first time I thought [00:33:19] like I want to do this [00:33:21] at least last time I heard [00:33:23] Yeah, yeah, so I logged into [00:33:26] the forums there [00:33:28] and honestly I think it was, [00:33:30] I think that maybe the first [00:33:32] like online forum community [00:33:34] that I ever joined in [00:33:35] my life [00:33:37] and I posted my question [00:33:38] and just wasn't sure what to expect, [00:33:41] and then someone gave me an answer [00:33:43] and Alex gave me an answer and explained [00:33:45] how to implement it, [00:33:47] and I was like oh and that was a moment, [00:33:49] both of seeing the value [00:33:51] of the community, [00:33:53] and then also like expanding my mind [00:33:56] to oh if I just think a little differently [00:33:58] about how I approach things in Airtable [00:34:00] you know, and don't don't [00:34:02] just stay within the box of, [00:34:04] you know, [00:34:06] this is this type of field, [00:34:07] it's supposed to do this, [00:34:09] but oh I can actually use [00:34:10] it to do something else that, [00:34:12] you know, that isn't [00:34:13] necessarily implied by the [00:34:14] name, and yeah that just opened [00:34:17] up a whole world for me where as I was [00:34:21] building out things for that [00:34:23] construction company [00:34:24] I was working for at the time, [00:34:26] I was just continually referencing [00:34:28] the forums to see what creative [00:34:29] things people [00:34:30] were doing to get around [00:34:31] you know, some of the shortcomings [00:34:33] Airtable has [00:34:34] and how to just do things [00:34:36] creatively and set things up creatively, [00:34:38] and then started seeing other [00:34:40] people asking questions about [00:34:44] perhaps challenges that I had [00:34:46] found a way to overcome [00:34:47] challenges that I had, [00:34:48] you know, found a solution to, [00:34:50] and so I started answering [00:34:52] those questions and [00:34:53] you know, just, it's I'm [00:34:55] I'm a problem solver at heart, [00:34:58] I'm an engineer at heart, [00:35:00] so I just find it enjoyable, [00:35:03] even in my downtime in the evening, [00:35:06] I'll come home and browse [00:35:07] through the forums [00:35:08] and see if there's any fun little [00:35:10] challenges that I can tackle, [00:35:12] you know, it's kind of like [00:35:13] my version of doing [00:35:14] the crossword puzzle or something. [00:35:16] Yeah, [00:35:18] yep. Very cool, [00:35:21] Alright, if you want to share [00:35:23] your screen, [00:35:24] but yeah, I'm sure myself and many [00:35:26] others have benefited [00:35:27] from your willingness [00:35:29] to to share with the community, [00:35:30] so thank you for that. [00:35:35] Alright, so we're gonna do our [00:35:37] Base Showcase and I will [00:35:39] share your screen go for [00:35:41] it. Cool. Yeah, [00:35:42] sorry for the super wide [00:35:45] screen format there that doesn't [00:35:47] quite fill the [00:35:49] vertical space, but [00:35:50] All right, so I have to start by [00:35:53] explaining that my wife [00:35:56] and I, we sort of [00:35:57] home school our kids [00:35:58] I say sort of because they're enrolled [00:36:01] in an online school. [00:36:02] That involves part homeschool [00:36:07] curriculum and part curriculum part [00:36:12] online classes where they [00:36:14] actually attend a class [00:36:16] at a specified time with the [00:36:18] teacher and other students online. [00:36:21] But we still track all [00:36:23] of their assignments [00:36:24] in this home school base. [00:36:26] And that's a key part of [00:36:28] our adventure game, because [00:36:30] I use the adventure game [00:36:31] to try and motivate them [00:36:32] to get their assignments done. [00:36:33] So we we we input all of their [00:36:36] assignments at the beginning of the year. [00:36:40] Not necessarily all the details [00:36:43] because you know that's that's a lot of [00:36:45] work getting hundreds [00:36:46] and hundreds of assignments [00:36:48] in here, but I've created [00:36:48] scripts that can at least [00:36:50] we can just say [00:36:52] look we know that they're going to [00:36:54] be 120 assignments for this class, [00:36:56] so at least just create [00:36:57] the records and then [00:36:58] throughout the school year [00:37:00] we can go in and fill in [00:37:01] with details as we need to. [00:37:02] But I at least have numbers [00:37:04] for how many assignments [00:37:06] each of my kids have [00:37:08] throughout the school year. [00:37:09] So that I can put a point value [00:37:12] on those or a coin value for our adventure [00:37:16] game. So they actually earn [00:37:18] their coin [00:37:19] that kind of powers our adventure game [00:37:21] by completing their school [00:37:23] assignments throughout the year. [00:37:25] So if they are staying caught up [00:37:27] then they will stay caught up [00:37:29] with kind of the [00:37:30] power level [00:37:31] that they're supposed to be at. [00:37:33] during the course of the game. [00:37:35] And if they get ahead [00:37:36] in some of their stuff [00:37:38] since some of their their work is [00:37:40] home school work, [00:37:41] they can get ahead on it, [00:37:42] then they can kind of get ahead in [00:37:43] power as well in the game. [00:37:45] So I'm not gonna go [00:37:47] too much into the home school [00:37:49] stuff because that's not the point [00:37:51] here, but it is [00:37:52] one of the bases [00:37:54] that is tied into the whole system. [00:37:58] The next base is [00:38:00] where I actually build out [00:38:03] all of the items [00:38:05] and rules for our adventure game. [00:38:10] So [00:38:12] Gosh it's hard to know [00:38:13] even where to start with this one. [00:38:17] The items are really [00:38:24] what's hard is trying to figure out [00:38:27] how much to talk about the game itself [00:38:29] versus I know that what I'm supposed [00:38:30] to be talking about is the Airtable system [00:38:32] behind it all. [00:38:34] But the items really drive kind [00:38:37] of the the character progression [00:38:39] for my kids and for their characters [00:38:41] that they are playing [00:38:43] in our adventure game. [00:38:43] So think of D and D [00:38:45] when we when we play our board [00:38:48] game our our game [00:38:49] sessions [00:38:51] We are I am acting [00:38:53] as the game master. [00:38:55] I'm telling the story of of what's [00:38:58] happening to their characters [00:39:00] and what their characters [00:39:01] are encountering as they [00:39:02] go along. [00:39:03] And then they may run into [00:39:06] encounters where they have to [00:39:08] battle bad guys are [00:39:09] monsters. And so their equipment [00:39:12] that they have equipped [00:39:14] on their characters [00:39:15] is what drives their progression [00:39:18] and and their growth [00:39:19] in power as a character [00:39:21] and their ability to tackle [00:39:23] more and more difficult challenges. [00:39:25] So I have been just going in [00:39:28] in and creating all of these items. [00:39:31] So I have tons of fields. [00:39:34] actually the majority of the fields are in [00:39:39] their hero bases but on their items [00:39:43] They have various attributes. [00:39:47] So how much will this item [00:39:50] add to their defense [00:39:51] score there with score, [00:39:53] their power score [00:39:54] or their hardiness, their their hearts. [00:39:58] How much does it cost? [00:40:00] And then what other kind [00:40:02] of effects may it have? [00:40:04] Sometimes I'll try to give it [00:40:06] fun little flavor text to that. [00:40:08] They will see when it gets sent [00:40:10] to the store. [00:40:11] And then I check this box when [00:40:12] this item is ready to be sent [00:40:14] to the store [00:40:15] and that's just a filtered view. [00:40:17] And then I've got a filtered view [00:40:19] for each of the classes, [00:40:21] the character classes [00:40:22] that they can choose for their character. [00:40:25] I also just went way overboard [00:40:28] and also made sets. So certain items can [00:40:32] belong to item sets and if they collect [00:40:35] and equip multiple items [00:40:37] in a set then they can get extra bonuses. [00:40:40] That was a fun challenge to [00:40:42] figure out how do I [00:40:44] actually detect that they are [00:40:46] equipped to have a set equipped? [00:40:49] In order to let them equip the effect for [00:40:53] having the set fully equipped or whatever. [00:40:56] In the end I just am doing kind of [00:41:00] manual manual monitoring of that and [00:41:03] you know at the beginning of our [00:41:05] sessions we check and see how you, [00:41:06] do you have any sets equipped? [00:41:08] If so then just go ahead [00:41:10] and equip you know [00:41:11] if you've got hunter's outfit [00:41:12] and you've got two pieces, [00:41:14] go ahead and equip the [00:41:15] two piece bonus. [00:41:15] If you've got three pieces, [00:41:17] go and equip the three piece bonus [00:41:18] as well. So that's kind of [00:41:20] how we handle that. [00:41:21] I've been looking for a way to [00:41:22] automate that but haven't [00:41:24] quite figured it out yet. [00:41:26] And then there's a way there [00:41:29] must be the hard part [00:41:32] is that those those things [00:41:35] exist in this base [00:41:36] but they get sync over to the base [00:41:38] where they're actually [00:41:40] equipping things on their heroes. [00:41:43] So yeah I also create all the effects that [00:41:47] can be like status effects [00:41:49] that can be applied [00:41:51] to your character during a [00:41:52] session. So if your character can [00:41:56] your character can be chilled [00:41:58] or frightened or intimidated. [00:42:01] And those apply a [00:42:03] you know some some kind of effect [00:42:05] on your character. So maybe some of them [00:42:07] are good effects their buffs. [00:42:10] And so they actually [00:42:11] increase one of your scores, [00:42:13] some of them are negative ones. [00:42:15] And so they decrease the score. [00:42:17] And then I actually [00:42:19] also figured out a way to [00:42:21] do percentage modifiers as well. [00:42:24] So when you equip a particular I say [00:42:28] equip when you apply [00:42:29] a particular effect, [00:42:31] that means adding it to your character [00:42:33] in a linked record field. [00:42:35] It will it will apply these [00:42:37] to your character, [00:42:39] right? So when you [00:42:40] when you put the distracted [00:42:43] effect on your character in [00:42:45] the interface which will [00:42:46] will get to that in a in a bit here, [00:42:48] it will take away three defense [00:42:51] from your defense score. And it will take [00:42:53] away two from your wits score. [00:42:55] And then these ones will do percentage [00:42:58] modifiers. So this will increase [00:43:01] your armor by 10% [00:43:03] and this one will decrease [00:43:05] your armor by 10%. [00:43:07] Those were all fun challenges [00:43:09] to figure out how to [00:43:10] how to get these things to [00:43:12] work. But of course I've got [00:43:14] I've got formulas that [00:43:17] that figure out how much [00:43:20] based on these static columns [00:43:23] and the percentage columns. [00:43:25] How much to actually deduct [00:43:27] from from their their [00:43:28] statistics on their characters. [00:43:32] Alright, so I also do some of my [00:43:34] my story planning and and create my [00:43:37] encounters for them here in this base. [00:43:41] But the rest is done [00:43:44] by syncing all of this information over to [00:43:48] over to a base that I've created [00:43:50] for each of my kids [00:43:52] and this is where their [00:43:54] hero lives. [00:43:55] So we sync over their school data, [00:43:58] their school year data. So their total [00:44:00] assignments for the school year, [00:44:03] how many they've completed [00:44:05] to this point And [00:44:06] this is their [00:44:07] total coin that they can earn [00:44:09] for the entire school year of our [00:44:11] gaming session. So then I can just [00:44:13] figure out how much is each assignment [00:44:15] worth and how much do [00:44:17] they have so far based on [00:44:18] how many of their assignments [00:44:20] they've completed [00:44:21] and so that kind of [00:44:22] makes up their coin purse. [00:44:24] And then I sync over all of the [00:44:28] effects that I create in my game master [00:44:31] base. [00:44:32] I sync over all of the [00:44:35] items into a store. [00:44:37] So for each of their heroes, [00:44:40] they have selected a [00:44:42] character class. So [00:44:44] my boy Brady has selected [00:44:46] a warrior and so I sync over [00:44:49] the warrior store view to him [00:44:52] so that he can only see [00:44:54] items that are usable [00:44:55] by his character class. [00:45:00] And then this hero's table [00:45:02] is where his hero lives. [00:45:04] And this is the one that [00:45:05] has a whole bunch of fields [00:45:08] that are essentially allowing him [00:45:12] to equip items by adding [00:45:15] them into a linked [00:45:16] record spot for a particular [00:45:20] item slot for his character. [00:45:23] So like the head item, [00:45:24] you know it's going to be [00:45:26] filled with a bunch of options [00:45:28] for helmets that he can wear as a warrior. [00:45:31] And this is of course limited [00:45:33] to only one record can be equipped so they [00:45:37] can only equip one item in each item slot. [00:45:42] And then I've got all the roll ups that [00:45:47] help to help me to figure out [00:45:49] how much of their coin [00:45:50] they have spent out of [00:45:51] their coin that they have earned [00:45:53] and figure out how much [00:45:54] they have left to spend. [00:45:56] Roll ups to figure out [00:45:58] how much of each stat [00:46:00] does each piece of equipment [00:46:03] give them? [00:46:04] So each [00:46:05] each piece of equipment is [00:46:07] gonna have multiple [00:46:08] roll ups for figuring out for [00:46:10] each of the four main statistics [00:46:12] that their character has. [00:46:14] How much do they [00:46:15] have in total? [00:46:17] But of course this is unwieldy [00:46:20] to work with, right? [00:46:21] This giant horizontal table. [00:46:23] So kind of the key here [00:46:25] is the automations [00:46:26] in interfaces that I've created [00:46:29] for doing this kind of stuff. [00:46:30] I'm gonna poke into [00:46:32] the automations real quick [00:46:33] first because these kind of power [00:46:35] our encounters [00:46:36] and I will [00:46:39] just kind of show that they're [00:46:41] all really simple, click a button, [00:46:43] update a record, automation, [00:46:45] there's there's nothing [00:46:47] too crazy going on here. [00:46:48] But these are essentially for [00:46:53] managing their health [00:46:54] and damage that they've taken [00:46:56] and healing that they do [00:46:58] during our encounter. [00:47:00] And then also [00:47:02] when we're done with an encounter, [00:47:05] everything gets reset [00:47:07] many times we'll have multiple [00:47:09] encounters in a session. [00:47:10] And so we kind of reset everything [00:47:13] for them in between encounters. [00:47:16] So these automations are taking care [00:47:19] of those things for us as we're as [00:47:22] we're playing the game. [00:47:24] And then in interfaces [00:47:26] have an interface with 2, 2 views. [00:47:28] So the shop view is [00:47:30] my kids are in here during [00:47:32] the week as they're earning [00:47:34] coins by completing their assignments. [00:47:36] And they're in here shopping for items. [00:47:40] So these items are all separated [00:47:43] by type. So if they know [00:47:44] who I wanna I wanna get [00:47:45] a new belt they can click here [00:47:47] and look at all the look through [00:47:49] all the options [00:47:50] they're sorted by their cost [00:47:51] and the cost is relative to their power. [00:47:54] So you know the more powerful items [00:47:57] are further down the list [00:47:59] but they also cost more [00:48:00] and they are not allowed [00:48:02] to spend over their purse limit. [00:48:05] So as they spend money [00:48:07] here [00:48:07] So let's say I unequipped [00:48:10] that belt that he has [00:48:13] currently and I equipped [00:48:15] this most expensive one instead [00:48:20] for him, [00:48:22] we'll see his his purse value go down. [00:48:28] Actually I wonder if that would [00:48:29] actually cost the same as the other one. [00:48:31] But you know if I un equip it, [00:48:33] you can see he gets credited back the [00:48:35] money there in his purse [00:48:36] and so at the beginning [00:48:37] of the session I just have to [00:48:37] check and make sure that [00:48:39] All of them are above zero [00:48:42] or 0 or more dollars. [00:48:44] They cannot be in the [00:48:46] negatives in the coin that they've spent. [00:48:49] And then as they equip these items, [00:48:52] it also affects their statistics so they [00:48:55] can kind of see in real time [00:48:57] how you know a new piece [00:48:59] of equipment is gonna [00:49:00] affect their character [00:49:02] and grow their power. [00:49:05] And then I've kind of laid this [00:49:07] out in a paper doll fashion. [00:49:09] If you're familiar with [00:49:11] kind of role playing [00:49:12] video games a lot of times [00:49:14] they'll have a little picture [00:49:15] of your character [00:49:16] and you can kind of you know [00:49:17] drag items onto your character [00:49:19] into particular slots. [00:49:21] So I've kind of tried to [00:49:22] emulate that here [00:49:23] where you've got the helmet [00:49:25] amulet and then the shoulders [00:49:26] you know everything [00:49:28] kind of is laid out to make [00:49:29] sense for you know this kind of [00:49:31] represents your character [00:49:32] what your character [00:49:33] looks like. [00:49:34] And I try to find pictures online [00:49:37] that I can use for all these [00:49:39] equipment that actually [00:49:40] takes the most work. [00:49:42] Yeah I was gonna ask a question one [00:49:44] is this a game system [00:49:46] that you designed completely [00:49:48] yourself or is it some you [00:49:49] know like open source game system? [00:49:51] And two. How many items are in here? [00:49:55] And did you find it? What? [00:49:57] This is insane. [00:50:00] Yeah. Yeah. Yeah it's my own game system. [00:50:04] Of course the ideas the ideas are [00:50:07] are just sort of an amalgam [00:50:09] of things that I've experienced. [00:50:11] You know I've played [00:50:12] a fair bit of D. And D [00:50:14] in in my time, and a good number of [00:50:17] role playing video games, [00:50:18] and so I just kind of [00:50:19] take the elements that I like [00:50:20] the most from various games [00:50:22] that I've played [00:50:23] and figured out how can I make this [00:50:26] simple enough for my kids, [00:50:28] but also engaging enough, that, you know, [00:50:30] it matters what equipment [00:50:32] you're wearing and it matters [00:50:33] what decisions you make [00:50:34] and what skills you use [00:50:35] in an encounter and whatnot. [00:50:37] So yeah, how many items? [00:50:41] 380. Almost so far and counting [00:50:47] for comparison's sake, [00:50:50] I wanted to make it just [00:50:52] a simple initiative tracker [00:50:54] because I play D and D. [00:50:56] And then I gave up [00:50:57] like I never completed it, [00:50:59] and that is one tiny portion [00:51:02] of what you've constructed here. [00:51:06] Yeah. I've got a little bit of [00:51:08] an initiative tracker, [00:51:10] I think in my in my [00:51:11] encounter part, [00:51:12] I wasn't even gonna go into that because [00:51:13] it's [00:51:14] already over, [00:51:16] I'm pretty sure I'm already over [00:51:17] the time you've allotted [00:51:19] for me to share this [00:51:19] stuff, but [00:51:21] I'll try to go quickly and move on [00:51:23] to to the other portion of the interface [00:51:25] here, but also they can equip skills [00:51:28] and spells brady here is a warrior, [00:51:30] so he doesn't have spells, [00:51:31] but he's got a bunch of skills [00:51:32] you can use in an [00:51:33] encounter and [00:51:34] they do various things. [00:51:36] So yeah, we we then go over when [00:51:39] we're ready to play, [00:51:41] go over into the play interface. [00:51:43] And this is where we [00:51:44] manage our encounters [00:51:46] during during our sessions. So I've [00:51:50] this has kind of been a work [00:51:52] in progress where I've realized [00:51:54] one of my recent [00:51:56] editions, for example, [00:51:57] is I created a formula field [00:51:59] that rolls up all of the [00:52:00] different effects that their equipment [00:52:03] is giving them because they were [00:52:05] having to go scroll down [00:52:07] and be like, what did this one do? [00:52:09] Okay, that one lets me do this thing [00:52:12] and it was just kind of a pain [00:52:14] to to go down and figure out [00:52:15] everything that they [00:52:16] had available to them. [00:52:18] So I rolled all that up [00:52:20] into a formula field that I'm [00:52:22] displaying here for them [00:52:24] to make it easier. [00:52:25] One of the things I didn't have [00:52:26] at the beginning was this counter. [00:52:30] So they were just having to literally [00:52:33] count the hearts, like how much health [00:52:35] do I have left? one, [00:52:38] That was a pain. [00:52:39] So I created, you know, [00:52:40] added to that formula field to add this. [00:52:42] How many do you have left [00:52:45] out of your total? [00:52:47] and then during the encounter, [00:52:49] this is where they would [00:52:52] add effects. So if their character [00:52:55] gets stunned, I tell them All right, [00:52:57] you know, the boss that [00:52:58] you're fighting just stunned you. [00:53:00] So Brady, You need to [00:53:02] you need to add the stunned [00:53:05] encounter effect. [00:53:06] And when he does that, [00:53:08] he's gonna see all of his defense. [00:53:12] Is he [00:53:14] is he going to see his [00:53:15] defense score go down? [00:53:18] We're not in an encounter. [00:53:20] That's why. Watch. [00:53:22] So he asked at the beginning [00:53:24] of an encounter, [00:53:25] we click begin encounter and [00:53:27] now that button shows [00:53:28] were in an encounter. [00:53:30] Now if he equips this, [00:53:31] see you got stunned [00:53:32] and all of his defense is gone. [00:53:35] All of a sudden [00:53:37] we have to manually track [00:53:40] a refugee. Yes, very nice. [00:53:44] We have to manually track [00:53:46] the rounds. [00:53:47] Like how long if you're stunned for two [00:53:49] rounds. That's the thing we have to [00:53:51] manually track and then once what's [00:53:53] it's expired. I tell him [00:53:55] he can take it off and goes back there. [00:53:57] And then taking damage. [00:53:59] This is the stuff that's [00:54:01] that's done by the [00:54:03] automations. So I say, you know, [00:54:05] the boss hits you for three damage. [00:54:07] So type three into there [00:54:08] and click the damage. [00:54:10] The automation is gonna run. [00:54:12] And it's not immediately, [00:54:13] you know, doesn't register immediately, [00:54:16] but a couple of seconds later [00:54:18] that registers, [00:54:19] let's say one of his teammates [00:54:21] heals him. [00:54:22] You take two healing so you [00:54:25] can hit that and apply it and [00:54:27] a couple of seconds later [00:54:29] you've got a couple hearts back. [00:54:32] Yeah, that's how we we [00:54:34] manage our encounters. [00:54:35] temp health is there because [00:54:37] that's separate from healing [00:54:38] because you temp health [00:54:39] can actually temporary [00:54:40] health can actually put you [00:54:42] over your health limit. [00:54:44] So let's say he gains five temporary [00:54:46] health from a skill that he uses. [00:54:49] Now his maximum health [00:54:50] is higher than it was before, [00:54:52] but healing can never [00:54:53] put you over your your [00:54:55] your healing your health maximum. [00:54:59] So yeah, [00:55:01] that's my, my fun little gaming [00:55:03] system that I've built. [00:55:06] We play our sessions [00:55:07] with dice, just like D. And D. And [00:55:11] manage all of our [00:55:12] statistics here in Airtable. [00:55:14] That's so cool. [00:55:16] This is insane. Congratulations. Yeah, [00:55:21] it's a lot of fun. [00:55:22] It's been it's been [00:55:23] really fun to build too. [00:55:25] That's so cool. [00:55:28] Thank you, Jeremy [00:55:29] for sharing that. [00:55:31] I'll just say, [00:55:32] I'm glad my kids don't watch [00:55:33] my videos because [00:55:34] they would be jealous [00:55:35] and say, dad, you could be doing this at [00:55:37] work [00:55:38] again. I gave up [00:55:43] Awesome. [00:55:46] Yeah. one more. Oh sorry. [00:55:48] I just I know that I talked [00:55:50] nonstop through that whole [00:55:52] thing. I wanted to just check [00:55:53] and see if there were any other questions [00:55:56] we'd be here all day. [00:55:58] Okay. I have several. [00:56:01] Yeah. You might need to connect with [00:56:03] top shelf gaming [00:56:04] wants to figure out how to [00:56:06] have the temp health, [00:56:07] be another heart color to differentiate. [00:56:09] That's an interesting thought. [00:56:11] Yeah, I was waiting for that, [00:56:12] but I didn't want to bring it up. Okay, [00:56:16] cool. Things you can do with that. [00:56:19] Yeah, that's that's amazing. [00:56:21] Yeah, one of one of the challenges [00:56:23] has been trying to keep it [00:56:25] all within Airtable. [00:56:26] And then, you know, also [00:56:28] I don't want to pay [00:56:30] for all three of my kids as [00:56:32] pro users. So actually [00:56:34] the other thing that I do [00:56:36] to kind of get around that is I [00:56:38] have a free workspace [00:56:39] for each of them [00:56:41] that that is shared, and they have editor [00:56:43] access to that free workspace. [00:56:46] So their own hero base lives [00:56:48] in that free workspace, [00:56:50] but when I need to sync [00:56:51] everything right, [00:56:52] like I'll spend the week working [00:56:54] on new items and whatnot, [00:56:55] and when I'm ready to sync it all, [00:56:57] I'll move their hero base into my pro [00:57:00] workspace, run all the syncs [00:57:02] to their sync tables [00:57:03] because you can't you can't do [00:57:05] sync tables in a free base, right? [00:57:09] So I'll run all those syncs [00:57:11] in my pro workspace, [00:57:12] and then I'll move the [00:57:13] entire base back into their [00:57:14] free work space [00:57:16] for them to do their shopping, [00:57:17] and for us to play our game sessions. [00:57:20] That's kind of how I get around that. [00:57:25] Cool, thank you, Jeremy [00:57:27] for sharing that. That's awesome. [00:57:30] Yeah, you might get people [00:57:31] reaching out to to learn more, [00:57:33] let's finish up real [00:57:34] quick. A shout out to our community. [00:57:36] We'd love to have you join [00:57:37] builtonair.com/join [00:57:38] gets you into our community [00:57:40] and join our slack, [00:57:42] or subscribe to us on our youtube [00:57:45] channel trying to grow that as well [00:57:47] we're gonna finish off with [00:57:49] some scripting time with Alli [00:57:52] awesome. Can you see my screen? [00:57:55] Yes. All right. [00:57:57] So here I have a very basic [00:58:00] example of a crm [00:58:01] The two tables that we're interested in [00:58:04] for this example are [00:58:05] just people and interactions, [00:58:07] which is something very [00:58:08] common that people are [00:58:09] using Airtable for. [00:58:11] We've got rows of interactions [00:58:14] that are each linked up [00:58:15] to a person. [00:58:17] Some notes involved with that, [00:58:19] a date etcetera, all sorts of little crm [00:58:22] things that you could use over here. [00:58:25] But this is a [00:58:28] use case that people often ask [00:58:30] about and this is what [00:58:32] I've settled on doing to [00:58:34] address this for now until Airtable [00:58:36] hopefully someday comes out with a toggle [00:58:39] that we can just use. [00:58:41] And that is having to do [00:58:43] with the order of these linked [00:58:45] records in this linked record field. [00:58:48] So one cool thing I've got going [00:58:50] on here is this roll up [00:58:52] field that's showing [00:58:53] all the interaction notes [00:58:55] in there each time stamped. [00:58:57] But you do have to [00:58:59] scroll down all the way [00:59:00] to the bottom to find [00:59:01] the most recent ones. [00:59:02] So if I add a new one [00:59:06] for john doe here, [00:59:08] let's just put in today's date. [00:59:14] Now when I look at this interaction notes, [00:59:16] it's all the way down at the bottom [00:59:20] and it's also the last record [00:59:22] in this linked record list here. [00:59:25] Now you can manually drag [00:59:27] these around if you want, [00:59:28] but nobody really wants to [00:59:30] do that for every interaction [00:59:32] that's logged. [00:59:33] And most of the time people want [00:59:35] to see that most recent one at the top. [00:59:38] And especially when it comes to [00:59:40] a field like this where we're rolling up [00:59:42] based on the date would be great [00:59:44] to have these in a particular order. [00:59:47] So I'm hopeful that maybe one day [00:59:49] within this field [00:59:50] configuration you'll be able [00:59:51] to choose a field to sort this field by. [00:59:54] That would be amazing. [00:59:55] But until that happens you can [00:59:58] accomplish the same thing using a script. [01:00:00] So I've written a script [01:00:03] that will function in an extension. [01:00:05] I also have an automation [01:00:06] version of it and [01:00:07] I'll touch it really quickly, [01:00:09] but you can see when [01:00:10] I click that button here. [01:00:12] Now this field has resorted [01:00:14] and my most recent one is at the top [01:00:16] and [01:00:18] same thing here, [01:00:19] You can now see the most recent [01:00:20] one is at the top. [01:00:23] It's a very simple script. [01:00:25] I marked it up cause [01:00:26] I'm thinking I'll probably [01:00:27] post this somewhere [01:00:29] if anybody wants to use it. [01:00:31] But I'm basically just defining [01:00:33] the two tables and then the linked record [01:00:35] fields between each [01:00:36] and also the field I want to sort by [01:00:39] and then I'm choosing that record [01:00:41] on the parent table. [01:00:42] So the people table in [01:00:43] this case [01:00:44] and then I select all of the records [01:00:47] on the child table if you know for a fact [01:00:50] that you're gonna have [01:00:51] less than I believe it's [01:00:52] 100 linked records per record [01:00:55] you could just put the record [01:00:57] ids as a parameter [01:00:58] into this step here. [01:01:00] To limit it so you don't have [01:01:02] to suck up everything and [01:01:03] then filter through. But I wrote it [01:01:07] assuming that people might have more than [01:01:08] 100 records to sort through. [01:01:11] So essentially this is the part [01:01:13] that's really important is when you select [01:01:15] records on a table you can pick [01:01:18] the fields you want to suck up. [01:01:20] You can also pick the sort order. [01:01:22] So the order in which [01:01:23] you want these records [01:01:24] to appear and you can define [01:01:27] a field and then also a direction. [01:01:29] So in my case because I want [01:01:31] the most recent date [01:01:32] at the top I've picked [01:01:33] descending. [01:01:34] If I wanted it to go the other way [01:01:37] I would have written ascending asc [01:01:40] but that picks everything up [01:01:43] in order by date [01:01:44] and then I'm filtering it down [01:01:46] to only the ones that are linked [01:01:48] to the parent record that I chose. [01:01:51] And then just updating that linked record [01:01:54] field with the sorted interactions. [01:01:59] The only difference I have for [01:02:02] my automation is [01:02:03] because I've got this button [01:02:05] clicked [01:02:06] at the people level. [01:02:08] I have instead I have my [01:02:11] automation triggering off of [01:02:14] the interactions table. [01:02:16] And I thought that that was [01:02:18] the safest thing because [01:02:21] especially when you're sorting [01:02:22] by date as soon [01:02:23] as you put a date into that [01:02:25] interaction Airtable [01:02:26] starts trying to evaluate [01:02:28] what that date is. [01:02:29] So if you're just saying person [01:02:31] is not empty and date [01:02:32] is not empty for a new [01:02:33] interaction go sort everything. [01:02:36] You might not have the right [01:02:38] date fully entered [01:02:38] yet before this triggers. [01:02:40] So I've flipped it so [01:02:42] that I need to also put in a [01:02:44] status of logged for that interaction [01:02:46] in order for it to trigger everything off. [01:02:50] And I manually would do that [01:02:51] after I know I've entered [01:02:53] everything in for the [01:02:53] automation. Don't have to worry [01:02:55] about this if it's coming from a form. [01:02:57] But if you are doing manual entry [01:03:01] then I would do it that way. [01:03:03] And then so the only [01:03:05] difference here is that [01:03:07] I'm grabbing that linked record [01:03:09] of the person the interaction is linked to [01:03:10] instead of the actual [01:03:12] interaction record itself [01:03:16] if that makes sense. [01:03:17] I know we're over time but [01:03:19] very cool and very useful. [01:03:21] I agree that it should be a toggle. [01:03:23] Yes that would be wonderful. [01:03:27] Didn't the original [01:03:29] version go the other way. [01:03:31] So if you have a legacy base [01:03:33] isn't there a toggle of [01:03:35] switching the order? [01:03:36] Okay. I've been so confused [01:03:38] because I feel like that toggle [01:03:41] appears and disappears [01:03:42] with no rhyme and reason [01:03:44] like some of the linked record [01:03:46] feels I see have that toggle there. [01:03:48] That's a show linked records and reversed [01:03:50] order. Some of them don't [01:03:53] I don't know why some do and some don't. [01:03:56] And also it's [01:03:58] very superficial because it's just gonna [01:04:02] it doesn't actually work well. [01:04:06] Very cool. Thank you for sharing [01:04:08] that Alli and Kamille for joining us. [01:04:10] And Jeremy thank you so much [01:04:12] for joining and sharing [01:04:14] your your game with us. [01:04:16] I imagine your kids are enjoying [01:04:19] that and getting [01:04:20] straight A's because of it. [01:04:24] Very cool. Thank you all [01:04:26] for for joining. [01:04:27] That is the end of our show. [01:04:29] And we will see you. [01:04:30] We'll be back next week for episode eight. [01:04:32] Take care everyone.
![[S09-E08] Full Podcast Summary for 11-02-2021](https://builtonair.com/wp/../uploads/segment_image_1-42-440x264.png)
![[S08-E07] Full Podcast Summary for 06-15-2021](https://builtonair.com/wp/../uploads/segment_image_1-17-440x264.png)
![[S12-E07] Full Podcast Summary for 10-25-2022 – The Ultimate Automation Battle: Make.com (Scott Rose) vs Zapier (Ben Green)](https://builtonair.com/wp/../uploads/segment_image_1-80-440x264.png)
![[S10-E11] Full Podcast Summary for 03-15-2022](https://builtonair.com/wp/../uploads/segment_image_1-61-440x264.png)
BuiltOnAir Podcast
- [S18-E02] Full Podcast for 04-09-2024 - Sync Airtable to Wordpress with WP Connect; Voting System for Daretable April 15, 2024#airtable #on2air #builtonair 4/9/2024 - BuiltOnAir Live Podcast Full Show - S18-E02 ___________________________ The BuiltOnAir podcast is a live weekly show highlighting everything happening in the Airtable universe. Check us out at BuiltOnAir.com/join. Join our community, join our Slack channel, and see what's happening. ------------------------ SPONSORED BY On2Air - Airtable Apps and Integrations to run […]
