2/20/2024 – BuiltOnAir Live Podcast Full Show – S17-E07

Duration: 0 minutes

Be Sure to Subscribe to the podcast!

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

FULL EPISODE VIDEO

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

FULL EPISODE AUDIO

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

Listen On: Apple | Overcast | Spotify


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

In This Episode

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

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

Todays Hosts

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:01:40 –

Meet the Experts – 00:01:41 –

Meet Leslie Burke.

I worked in Product Management for a software company out of college then in Sales Operations for a company leading up to their acquisition by Salesforce. When I had kids, I stepped out of that and did a few random things (selling locally grown baby food at the downtown Indy farmers market! Treasurer of a preschool!) and then helped my husband when he started a software business. Then in January 2022, a former co-worker asked if I would help him create a custom guest management and reservation system using Airtable for a dude ranch. That was the beginning of LassoBook. I continue run the day-to-day of LassoBook while also consulting independently on Airtable projects.

Base Showcase – 00:01:41 –

We dive into a full working base that will Leslie shares an Airtable app called Guestbook which can be used to manage a set of rental properties. As part of that, she uses Fillout to create the invoices using their Stripe payment option, which is an alternative to building a Stripe integration using scripts or Zapier/Make.

Field Focus – 00:01:43 –

A deep dive into the Dependency Fields Dates – Airtable recently announced new Date Dependency functionality we will explore. 

Learn More Here

Full Segment Details

Segment: Round The Bases

Start Time: 00:01:40

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

Segment: Meet the Experts

Start Time: 00:01:41

Leslie Burke –

Meet Leslie Burke.

I worked in Product Management for a software company out of college then in Sales Operations for a company leading up to their acquisition by Salesforce. When I had kids, I stepped out of that and did a few random things (selling locally grown baby food at the downtown Indy farmers market! Treasurer of a preschool!) and then helped my husband when he started a software business. Then in January 2022, a former co-worker asked if I would help him create a custom guest management and reservation system using Airtable for a dude ranch. That was the beginning of LassoBook. I continue run the day-to-day of LassoBook while also consulting independently on Airtable projects.

Segment: Base Showcase

Start Time: 00:01:41

Guestbook

We dive into a full working base that will Leslie shares an Airtable app called Guestbook which can be used to manage a set of rental properties. As part of that, she uses Fillout to create the invoices using their Stripe payment option, which is an alternative to building a Stripe integration using scripts or Zapier/Make.

Segment: Field Focus

Start Time: 00:01:43

Learn about the Dependency Fields – Airtable recently announced new Date Dependency functionality we will explore.

A deep dive into the Dependency Fields Dates – Airtable recently announced new Date Dependency functionality we will explore. 

Learn More Here

Full Transcription

The full transcription for the show can be found here:

[00:00:00] Intro: Welcome to the Built On Air Podcast, the variety show for all things Airtable. In each episode, we cover four different segments. It's always fresh and different, and lots of fun. While you get the insider info on all things Airtable, our hosts and guests are some of the most senior experts in the Airtable community.

[00:00:26] Join us live each week on our 

[00:00:27] YouTube channel every Tuesday at 11:00 AM Eastern and join our active [email protected]. Before we begin, a word from our sponsor on. On2Air Backups provides automated Airtable backups to your cloud storage for secure and reliable data protection. Prevent data loss and set up a secure Airtable backup system with On2Air backups at on2air.

[00:00:49] com. As one customer, Sarah, said, Having automated Airtable backups has freed up hours of my time every other week. And the fear of losing anything. 

[00:00:59] Long time customer [00:01:00] David states, On2Wear backups might be the most critical piece of the 

[00:01:03] puzzle to guard 

[00:01:04] against unforeseeable disaster. It's easy to set up, and it just works.

[00:01:08] Join Sarah, David, and hundreds more Airtable users like you to protect your Airtable data with On2Air backups. Sign up today with promo code built on air for a 10 percent discount. Check them out at onto air. com. And now let's check out today's episode and see what we built on air.

[00:01:38] Dan Fellars: Welcome back to the built on air podcast. We are in episode seven of season 17. Good to be with you myself, Dan Fellers and special guest, Leslie Burke. Welcome, Leslie. 

[00:01:49] Leslie Burke: Thanks. Thanks for having me. 

[00:01:51] Dan Fellars: Good to have you with us. We've got, I seem, I think some bug going around. Both Kamille and Ali are out today.

[00:01:59] And [00:02:00] so it's going to be just the two of us unless, unless somebody joins midstream. We'll see. So excited to have you on. We'll get to know Leslie and her story a little bit later in the show. But first I'll walk us through what we're going to be doing today. As always we do four segments to keep you up to date in Airtable.

[00:02:19] We always start with our around the bases and talk about any new updates or things going on in the world of Airtable. Then a quick shout out to our sponsor, On2Air. Then we'll learn about Leslie and her background and how she came into this world of Airtable. And then she will then show us a base and application that she built called Guestbook.

[00:02:42] And then join our community, how to get involved with, with us and what we're doing. And then finally, we'll talk about the new date dependency field functionality that, that Airtable just rolled out. So exciting to talk about that. 

[00:02:58] ROUND THE BASES - [00:03:00] 00:02:59

[00:03:00] Okay, with round the bases. A few things that are new in the world of air table.

[00:03:06] They had a couple announcements. And like I mentioned, we're gonna be talking about it. But there's a few other things that they announced. They now have Gantt in interfaces. So they had previously the Gantt has a view at the data layer. But now you can import Gantt inside of your interfaces. And so you can see there's now a layout option so you can switch between a list view and a Gantt view on there.

[00:03:37] So that is nice. If you rely on Gantt really a lot of what they're, what they launched this, this week. Are really big on project management. I think they're like going directly after monday. com and other project management tools to make sure that that you can switch over and and have that functionality.[00:04:00] 

[00:04:01] The 2nd, 1 is date dependency configuration. This is 1. We're going to showcase how how you actually do this. And how that works. And so that is new. And that that's obviously with Gantt being dates that that's involved heavily with with the Gantt views as well 

[00:04:19] at the day where I have a marketing client who has loved wanted to do Gantt view.

[00:04:23] We've used it in the past, but it just hasn't been useful because there hasn't been a day dependency piece. So we're really, really excited for that. 

[00:04:30] Cool. Yeah, that'll be good. Yeah, let's see. Well, we'll talk about this later in the show. We'll review those. Okay. See who's free when assigning tasks.

[00:04:47] So when assigning tasks, you can preview team utilization before and after assigning the task. So that's kind of cool. This utilization [00:05:00] feature. I think that's on a collaborator field. We'll share that. I have not played with that one, so I'm curious. I'll, I'll dig into that this week. 

[00:05:13] Leslie Burke: Yeah, me either.

[00:05:13] I haven't had a chance to try that yet. I 

[00:05:16] Dan Fellars: haven't seen that one. Yeah. Yeah. Yeah. I'm not quite sure. I don't think this is a new field type. I think it's, I think it's, A percentage type, maybe, okay, coming soon. This is something we've, we've teased in the past dynamic filtering. These views allow you to compare utilization when choosing team members.

[00:05:44] But imagine you also want to filter the selection to people who have the required skills, role, or team for a task. We'll be releasing a feature which allows you to filter record selection dynamically, which means the filter can depend on a property of the task you are trying to assign someone to. [00:06:00] It will not only help with resource allocation, but numerous other use cases such as Filtering offices to a given location or products to a given vendor.

[00:06:09] So that is exciting. 

[00:06:11] Leslie Burke: Yeah, that's really exciting. A lot of people have been waiting a long time for that. Yep. 

[00:06:15] Dan Fellars: Yep. Yeah. And they've been teasing it in, in the community for a little bit, but, hopefully that really means coming soon. I wonder if they were hoping to get it live, but it wasn't quite ready.

[00:06:27] Yeah, 

[00:06:28] Leslie Burke: and it'll probably sneak out and we won't know it or. We'll see. And maybe someone will have it, but some people for a while. Who 

[00:06:35] Dan Fellars: knows? Yep. Yep. Somebody will spot it in the built on air community. They're good at spotting those new features. Yep. All right. And then the last one, a couple of templates, which actually I'll be, I'll be showing one at one of the templates in my segment.

[00:06:50] So really good way to just get started with how to use some of this new functionality. They've got template. Faces with interfaces that you can [00:07:00] use to get started there. So, so yeah, those, excuse me, those are, new features. If you go to the what's new, it talks about those. Let's see if we talk about, let's see, informed task assignment.

[00:07:16] Is this the same thing? Summary utilization feature. We've made it easier. So that's the, that's the utilization, feature. And then this was one they didn't talk about. They actually refreshed the icons. I don't know if you noticed new icons. Yeah. So there's, there's new icons, for and after. Actually, I don't, I don't know if I even noticed.

[00:07:48] They're not too different. They're not drastically different, but maybe a little bit smaller. It seems like, 

[00:07:56] Leslie Burke: yeah, they're enough similar. And if I wasn't going to look, [00:08:00] I probably wouldn't actually notice. 

[00:08:01] Dan Fellars: Yeah. Yeah. Yeah. Yeah. People may not notice those. So anyways, new refresh and then this last one, the date dependency that we'll be talking about later in the show.

[00:08:14] So that is some of the new functionality. There's also this down. There's also oh, yeah. So in the built on their community, they spotted it. Ben spotted it. The Gantt layout in the timeline view. Interesting. You can switch between stacked and Gantt layout options. So it's an actual timeline. View in the interface that has a Gantt layout.

[00:08:52] So that is interesting. Yeah, new layout options. Okay, so [00:09:00] it sounds like, I actually didn't look at this. So it sounds like it's not a new Gantt view. It's it's the timeline view, but a Gantt 

[00:09:09] Leslie Burke: layout. Yeah, yeah, I haven't tried it. I read about it a little bit when they released information about it, but I haven't actually tried it out.

[00:09:17] I'm excited to see 

[00:09:19] Dan Fellars: it. Yep. So those are a few things. And then there was also some quiet improvements to the mobile app. Max says the UX, the charts. And so it looks like, new dashboard view is accessible in the iOS mobile app. So it looks like they're making some improvements to the mobile apps that they, that they didn't put on the what's new section.

[00:09:51] So that's good. I think, Android was behind iOS and in feature and functionality. So, so it looks like [00:10:00] Android starting to catch up. 

[00:10:01] Leslie Burke: Great. And a lot of all the Android users of the world rejoice. Yes, they're ready for some mobile mobile. 

[00:10:10] Dan Fellars: Yep. Yep. Yeah, it's good to see that. Yeah. And you can kind of see with the IOS.

[00:10:16] They've got the new bit dashboard interface. So IOS looks to be ahead still. 

[00:10:21] Leslie Burke: Yeah, it probably always will be a little bit. 

[00:10:23] Dan Fellars: Yeah. Yeah. All right. Okay. Here's an interesting one. Somebody, Talks about interface limits. They want to have a hundred interfaces. This there's a couple of things I want to highlight in here.

[00:10:41] One Scott does a good job of, of talking about, alternative ways to, to reduce the need for so many interfaces. And maybe even like using an external solution. For, for whatnot. [00:11:00] But then there's another item in here that comes up, that talks about,

[00:11:10] oh, yeah, the users. So, so they talk about how if you share, if you share access to an interface, let's see, where is this? Yeah, the full list of invited users to the interface will always show up in the managed sharing section. There's no way to hide that from any of the users. So when you're logged into an interface, and you click on the share menu, and click on manage access, even if you're a read only user, you'll see a list of all the other people with their email address, who also have access to that interface.

[00:11:47] Yeah, that's 

[00:11:48] Leslie Burke: interesting. Yeah, that's a that's a major problem. I think people have mentioned this in other threads before to that. This becomes a problem when you're trying to share outside of your organization, you know, with clients or whatever creating that [00:12:00] user dash or interface that is has for the user records only would be great to be able to do that.

[00:12:06] But this is a problem, right? Because they still see anyone else that you've created or give access to the dashboard. So Yep. 

[00:12:17] Dan Fellars: Yep. Yeah, that's definitely so one thing. Oh yeah, that's about notifying.

[00:12:31] Yeah. Interesting.

[00:12:36] Yeah. So that's something to be aware of. Yeah. If you don't want people to see. It's also interesting. Sometimes I do like I've been shared to bases that are like public bases shared with everybody and you can kind of see, Oh, who else has access to this space? 

[00:12:51] Leslie Burke: Right, right. Yeah. Yeah. Do they give a workaround in 

[00:12:56] Dan Fellars: that thread?

[00:12:57] Not, not to, not to hide [00:13:00] that. No. 

[00:13:01] Leslie Burke: Yeah. It's more just be aware of it. Yeah. 

[00:13:04] Dan Fellars: Yeah. Yeah. So, yep. That's something to be aware of. Okay. A couple other things in the air table community, something we we've seen and talked a lot about is OAuth refresh token grants fail intermittently. It's this one's interesting being, being a developer, having implemented OAuth here.

[00:13:30] This is definitely something we faced in the early days. I feel like Airtable has improved, in, in, in how they handle this. And so. It was a little bit surprising to me that, that people are still seeing this. Cause we don't see it nearly. We don't see it. How is like, we were seeing it in the early days of OAuth.

[00:13:54] But I also know that we had to, it's actually very difficult to implement [00:14:00] to do this right. And so it's very possible that the developer here needs to just be aware. There's lots of edge cases of. How you can trigger this toe to fail. So if you're an OAuth developer, this is tricky. Feel free to reach out in the built on air forum.

[00:14:19] And actually, that's what Scott mentions to go to the slack community. And there's other developers that they may be able to help. But I will say it is it is not straightforward. There's things that Airtable could do to make it easier for developers that I've asked them to do that that they don't seem interested in doing at this point.

[00:14:39] But so it's not an easy thing, but I think it is possible to. To work around it. All right. Last week we talked about spreadsheet dot com. Going out of business. And so this was interesting to see somebody asking for help on how to [00:15:00] migrate their data out of spreadsheet dot com to air table. I don't think air table has any kind of built in, Spreadsheet.

[00:15:09] com. I believe another competitor smart suite does. They, they announced that, that, that they can help people migrate over. So my guess is most people from spreadsheet are going to smart suite, but it does look like some people are coming to air table. And you would basically, if you are in the spreadsheet.

[00:15:31] com world and want to move to Airtable, likely the easiest would be to just export all your data as CSV, and then do an import CSV into Airtable. But you'll likely lose some functionality. It's a different experience having played with spreadsheet. com. It's, it's not exactly like Airtable, although there's definitely a lot of overlap.

[00:15:53] Yeah. All right, next one. This is kind of our [00:16:00] monthly reminder. Man, it seems like every week somebody is asking for how to get help from Airtable support. They this one doesn't say what tier they're on. But Airtable with their last pricing change. Made it. So you have to pretty much be on like, I think team to get support.

[00:16:26] Might even be enterprise to, to where they actually say you'll, you'll get support. 

[00:16:32] Leslie Burke: Yeah, the lowest two tiers don't. And so my guess is this person just doesn't realize that their, their tier doesn't actually come with life support. 

[00:16:41] Dan Fellars: Yeah, yeah, yeah. But it does pay like they did get an automated reply saying that they'd get a response.

[00:16:47] So, so that reply, I don't know if that goes to everybody or, or just to people who actually can access support. I don't know. I haven't accessed support in a while. 

[00:16:59] Leslie Burke: [00:17:00] Yeah, I haven't had to either lately. Yeah, 

[00:17:03] Dan Fellars: but this is common. This is definitely something people are not happy with. So there are forums.

[00:17:10] There are locations. This person didn't get any response. I have seen we shot showed somebody a week or 2 ago that actually got a response from an air table employee in their thread saying that they would get a response. So we'll see if Andy here gets get some help here. Yeah, 

[00:17:29] Leslie Burke: I do think Airtable employees must sometimes at least look through some of the forum threads because they do periodically chime in here and there.

[00:17:37] Dan Fellars: Yeah, yeah. All right. A few more. Back to, oh, we already did that one. Okay, now we're going to X or Twitter. These are just kind of fun. Airtable should rebrand itself as I think this says AI air table to instantly get 10 exits valuation in this [00:18:00] market. I'm referring to anything with, with AI in it, the stock market's going crazy for right now.

[00:18:07] Although there already is, I believe there's a. AI table, already out in the market. I've seen an AI table product. Oh, really? Yeah. What is it? A table that kind of looks like it's kind of more of a backend database API is more developer centric. But yeah, so that name I believe is already taken, but maybe Airtable can buy them.

[00:18:36] All right. Here's an interesting one. So talking about competitors, somebody, somebody posted this on X. Atlassian basically launched an air table product. I thought, Oh, that's interesting. Let's pull it up here. So Atlassian, if you, if you've used any Alassian product, very big and in [00:19:00] developer world, they, they have a lot of developer centric products.

[00:19:06] So if you look at it, here's kind of some screenshots, looks very similar to a database in air table. It has views, layouts, filters, or hide fields. And then it has field types. And so you can create a page or a whiteboard or a database or a blog. So they have more than just database functionality.

[00:19:33] So it's just interesting. All these products are kind of incorporating what, what Airtable is built into their product. 

[00:19:41] Leslie Burke: Yeah. Yeah. Well, and page piece reminds me kind of Coda docs, you know, it's like they're kind of trying to bring these things together. Yeah, 

[00:19:51] Dan Fellars: it'll be interesting what kind of adoption this gets.

[00:19:53] I could see, you know, for for basic database, like, just kind of your your general list, [00:20:00] type stuff, you know, might make sense to do it in Atlassian. If you're already in that world, So it'd be interesting because I know one big integration, like, like they have a direct integration with Atlassian.

[00:20:16] So clearly there's a lot of customers that use both Airtable and, and Atlassian products. It'll be interesting if this eats into that use case. Yeah. 

[00:20:26] Leslie Burke: Yeah. It might. 

[00:20:28] Dan Fellars: Yeah. So it kind of has a feel of, so you can do a slash. So kind of like a notion where you can. Yeah. Yeah, 

[00:20:37] Leslie Burke: it's interesting. It feels like they pulled a lot of ideas from, you know, what's already out there and Maybe they have an idea of what they think works best and it's trying to pull it all together into one.

[00:20:48] Dan Fellars: Yeah, yeah, yeah. Yeah, so I can see the use case of like internal documentation, especially like developer docs and things like that. [00:21:00] You know, most people that use Atlassian are in the developer world, although I think I've heard of marketing departments using it. Product departments. So yeah, that'll, this'll be interesting to see how this plays out.

[00:21:16] Yeah. 

[00:21:18] Leslie Burke: Feels like probably the people that already have a bent towards the developer side and are in it more, be more like that's where the adoption will come earliest. 

[00:21:27] Dan Fellars: Yep. Yep. Yeah. If you're, if you're in this world of confluence, Alessian let us know if you're going to use, if you're going to use their new database feature and instead of air table.

[00:21:41] All right, let's do one more. This one's from Reddit. So this is a question about replacing a dumb source of data with the sync source. So I thought this would be an interesting discussion. So this person already has sort of like [00:22:00] by dumb source. I think it just means like a just data entry. So a normal table that they're entering.

[00:22:07] But they want to replace it with a sync source coming from an external, external data source. And so you can do that. So they, so they, they know they can create like a new synced table that's coming from that source, but they're already using it. So they're kind of asking like best practices of how you would convert from a static source to a live sync source and they didn't get any comments.

[00:22:38] I don't know any thoughts. My, my thought would be, I mean, you really, you know, you kind of just would, I would create both and then you kind of would just have to update your links to, to point to the new one if you have any linked records. 

[00:22:53] Leslie Burke: Yeah. Yeah. I think, I think that's where you, where you have to start.

[00:22:56] So. Yeah, I mean, I would still [00:23:00] say, move over, get the sync data as opposed to keeping it, you know, dumb or static. Yeah, 

[00:23:08] Dan Fellars: but you can't, unfortunately you can't switch an existing table to be a sync table. It has to be a new table that gets created. Right. Yeah, I don't, I don't think there's any way to automatically convert a table over.

[00:23:22] Leslie Burke: But also I think sometimes that's good in terms of, I always think about like, what happens if something doesn't go right. So, you know, you can always bring in the sync data and the new table and try to make the changes that things go awry. You still have that table of all your old static data from that you could move back to if you need to.

[00:23:39] Yeah, that's, yeah, it's in some ways comforting. 

[00:23:43] Dan Fellars: Right. Yeah. Even if you could, it probably wouldn't be the wise thing. Cause yeah, it could mess up your data. Yeah. Yeah, for sure. All right, that concludes what's new in Airtable and all the communities and keep you up to date on [00:24:00] everything. 

[00:24:00] SPONSOR SPOTLIGHT - ON2AIR BACKUPS - 00:24:01

[00:24:02] Let's jump to our sponsor, OntoAir.

[00:24:04] If you are running your business on Airtable, you definitely need to follow best practice, which is to have a secondary source of your data. Airtable OntoAir Backups is the solution for that. It gets your data into Box, Dropbox, or Google Drive so that you know you've got your data, your schema, and all your attachments stored outside of Airtable.

[00:24:26] So check it out at ontoair. com 

[00:24:30] MEET THE EXPERTS - LESLIE BURKE-00:24:41

[00:24:32] All right, Leslie, get a chance to learn about you and why don't you give us kind of, give us your story. What's your background? How'd you come into this world? 

[00:24:42] Leslie Burke: Yeah. Yeah. Thanks. So I, I came into the air table world a few years ago. I actually, my professional.

[00:24:49] Life started in software world. So I was in a product management group of a banking software company. And then I eventually worked in sales operations for a company [00:25:00] that was, and then led into their acquisition by Salesforce. So I've worked in traditional software. Early in my career when I had kids, I decided to take some years off because that, that those roles were really time consuming and it didn't allow me to like do the parenting that I wanted to.

[00:25:17] So I did a few random things. Like I had a. Or locally grown organic baby food company for a short time. And also I was treasurer of preschool. And then eventually I helped my husband launch his software business. So I used some of those skills again. And so I think like a lot of the people that come on here, we have, you know, different backgrounds.

[00:25:40] I know Kamille has done, I think she's a landscape architect too. And Allie is a fine artist. So sometimes those. Different experiences throughout life can really enrich the work that we eventually get to do here in Airtable and working with other businesses. So that's where I started. That's my background.

[00:25:57] And then a couple of years ago, a friend who [00:26:00] I had worked with previously had connections to a dude ranch in Colorado and they needed a new guest management reservation system. And so, We launched lasso book with the goal of really providing great technology for great folks who and to serve a market that because of its, you know, pretty small size.

[00:26:20] I think there's somewhere between like 100 and 150 dude ranches in the United States and Canada. And so it's a really small size that isn't served by traditionally. Like venture backed software companies because it's just a small market. So Airtable made it feasible to create an economic, like a economically feasible option for them to create an app that really then meets their needs because they provide a super, super customized experience for their guests.

[00:26:49] So that's how I got into it. So we founded Lassabook and it really started the first ranch started on that in early 2022. So it's just a couple of years old. [00:27:00] And then we've, shared it at, we go to a, something called the dude ranch associations convention every year and we get to share it with other ranches there.

[00:27:07] So that's a super fun client base. They're great people. Having done that, then I started doing some of my own independent consulting for air table. And I talked to a friend who runs several Airbnbs in the Louisville area. And so when I was talking to her, she was talking about, there's a movement in.

[00:27:26] The Airbnb host space away from Airbnb and maybe to direct booking. So that way you can recoup some of those fees that Airbnb is charging. And for a host that have a lot of guests, you know, that amounts to thousands of dollars over the course of a year. And so if people are interested in putting that in their pocket, there are ways to do that.

[00:27:47] So I thought I'd look at how could I do something like that with Airbnb with air table and so the use case I'll talk about is really mostly geared towards someone who has [00:28:00] Properties who have high occupancy but also mainly from repeat customers or repeat guests So they, they don't necessarily need tons of marketing that, you know, Airbnb, VRBO, something like that would provide them, not that you couldn't still have your property listed on there.

[00:28:16] So, yeah, that's, that's where, that's how I got to this point today. 

[00:28:21] Dan Fellars: Awesome. Yeah. I'm curious, like you, you came. From kind of the software world, like how has, how has air table, like changed your perspective of like what you're capable of? And I assume you didn't have a software development background or anything.

[00:28:37] And so just talk about how it's changed your perspective of, of how business can be done. 

[00:28:44] Leslie Burke: Yeah, I think it, it's really exciting because in the air table. Consulting. I do. I work with a lot of high growth companies. And one of the really cool things is that I get to share with them how air table can evolve with them.

[00:28:58] So as they grow, the product [00:29:00] can grow with them and evolve. And so when they need to make process changes, we can do that. And so that's where, you know, traditional software, it definitely has a place. And so I'm not Anti software and try and I traditional, at all, but I think sometimes it can be a little rigid, especially for companies who experienced a lot of growth and changing within their organization.

[00:29:22] So that's, I think, one of the advantages of air table. That 

[00:29:28] Dan Fellars: cool. Have you gotten as your husband incorporated it into his business? 

[00:29:32] Leslie Burke: I, I he, his business, we, he is launching kind of a new beta for something new. And I actually created the prototype with air table and, you know, softer, a few other integrations.

[00:29:46] And so the first beta customer is using that. And so he decided as opposed to going ahead and, you know, Putting the capital into developing that new product right off the bat. Let's try it as a [00:30:00] prototype this way. And then once he gains traction with a few clients, we can prove the concept before going ahead and doing that, you know, large capital investment into.

[00:30:10] The, the development of the new product. 

[00:30:12] Dan Fellars: That's awesome. Yeah. That's a great way to, to prototype and get it out there. Yeah. 

[00:30:17] Leslie Burke: Well, it's so it's fast and economically it's just so much cheaper and it allows you to make those tweaks and refine it before that, that. Big development project gets underway. Cool.

[00:30:31] Dan Fellars: Yeah. I'm curious on the, on the in the dude ranch world, like that, that sounds like a fun conference to go to the dude ranch conference. What's been the reaction to the software? Are you guys like the new kids on the block with like the cool, fancy technology? And what's been the response 

[00:30:48] Leslie Burke: there? That's a great question.

[00:30:50] So the dude ranch industry, I would say is a little bit leery of technology. There are like several branches that. still use paper and pencil to keep their calendars. [00:31:00] Which isn't a bad thing. I think, they are also, you know, and leery of anyone new. So this was just our second year at that conference.

[00:31:10] And so they want to see you there a few years before they really trust you. There is one other kind of player in the market and. They pulled together several kind of smaller companies that have, you know, eventually they started, but then eventually gone out of business or haven't been maintained.

[00:31:29] And so they're really migrating everyone. And I, and to my knowledge and what I've heard is it's not going great. So, it's a perfect time for us to be here. And I think. In terms of the response, people like it. I think we've also gotten into, you know, they, they present us with new problems like herd management, which wasn't something I thought of, you know, when you have a hundred horses, you have to keep, there's a lot to keep track of in terms of vaccination schedules, shooing schedules, and that sort of [00:32:00] thing, and so actually we've been able to talk with some of them and talk about adding on to Lassa book features like that, which again, the rapid development that you can add apps like that is a huge bonus.

[00:32:12] I'm working in your 

[00:32:13] Dan Fellars: table. That's cool. And I love the name lasso book. That's great. Yeah. 

[00:32:17] Leslie Burke: You know, a friend of ours, both the other people I work with in Lassa book and we share a mutual friend. It was just this marketing guru and he was the one that named it. He named both Lassa book and guest book.

[00:32:28] So maybe he's reading a lot. Books are on his 

[00:32:31] Dan Fellars: mind. Awesome. Cool. 

[00:32:35] BASE SHOWCASE - GUESTBOOK - LESLIE BURKE- 00:32:37

[00:32:37] Well, let's let's dive into what you've got and we will see. base. And so this is the guest book one that's on the, on the Airbnb side that you're going to share. 

[00:32:49] Leslie Burke: Yeah. So I'm actually, I'll kind of walk us through the use case. I shared this.

[00:32:53] This is just a test or pretend website that someone could put together. I use Canva to put it together. I'm a huge fan of Canva. I'm [00:33:00] not naturally an artistic person. So Canva is a super big help with that. So when I, so I just do this together using Canva. This is my idea of if I was hosting Airbnb, like multiple Airbnb properties, the way I could use air table.

[00:33:17] So I put together a website, you know, it's pretty easy. I show these are my. Hypothetical accommodations. Wish I owned something like this, but in reality do not. Right. But as I scroll down, you can see here, I've added a, a view of my calendar. I made a public view that only just shows the book dates. And so if I look here, I can scroll through dates where I might want to book something.

[00:33:40] And then I utilize, you know, a request a reservation button that would allow me to request something. So let's, we'll just kind of walk through this and pretend. That we're going to do that. So this opens the Airtable form for, I'm calling my company Beach Street Cottage and Carriage [00:34:00] House. And so you know, a little note.

[00:34:03] And so I'm going to just pretend to be someone named Maxine Thompson. And I have, I'm going to say I have stayed with us before, I'm going to put in a phone number. And then Have an email address. I'm going to put in there. And so I'm going to request to stay. I think I saw on that calendar that March 2nd to March 9th was open in the cottage.

[00:34:38] And we'll say that I'm going to come with five friends. And so I'm going to request the cottage, And I won't request anywhere else, but that's where if you wanted to request multiple properties you could do that. And so we'll just say I'm having girls. And so I would verify that I'm old enough to rent, [00:35:00] and then I can submit.

[00:35:02] And so, you know, just like an Airtable form that'll go in. And so this is my dashboard. So this is where I have all my scheduling. I keep track of what's going on. And so this is the main kind of, Yeah, dashboard or scheduling, place I work from. So each of these represents a, one of my, the properties.

[00:35:24] And so if, if you have someone else working with you, sometimes this can be helpful just to help them remember if they're talking to someone or responding to an email, the details about each property. And then this is my calendar. So I can see the bookings for each property. Red shows me, I have a reservation that they're within a week of their.

[00:35:46] Arrival, but they haven't made their final payment. And then, this kind of teal color is a reservation that is two weeks out. And so I've sent them their email to request their [00:36:00] final payment. And this is my new reservation. So it's yellow and it just alerting me that, Hey, this is a new requested reservation.

[00:36:06] And if I scroll down, I can, I have different grids here. So this is my new request that I need to review. So there's the one I just added. Then I have a list of reservations that I've offered. To people, so I've accepted them and offered them, but they have not. Either pay their deposit and or submitted their lease agreement.

[00:36:27] And so there's also some conditional coloring that would come in if this was, you know, a few days old. And then down here I can see the arrivals that I have coming in the next week. And again, that one reservation is highlighted in red because she's within a week, week of her arrival, but has not paid her final payment.

[00:36:43] And then the, just, a list of the departures that I have in this week. So if I. Open up this request. I can review. I can see that. She said that she's stayed before, but I also confirm that she's an [00:37:00] existing customer using her email address. If I have any, you know, notes or thoughts, I can add them here.

[00:37:08] But then I would generally. At this point, decide, do I want to approve the request or decline the request? And either way, I can include a note back to her, but this time I'll say I'll accept it and I'll say we're excited to have her back.

[00:37:27] And then I'll approve that. And so kind of double screen that thing going. Yeah, so you can see it fell out of the new request and then came over here into my reservations offered but not yet accepted. So when I look at this, something that you'll notice is, and I'll, I'll show you this, I, there is a payment record on here now.

[00:37:48] So when I. The system is built so that when I accept the reservation, it automatically, updates this to reservation offered and then creates a payment record on [00:38:00] here. But this is just a requested payment. It is not actually succeeded or gone through yet. And so you can see here still the total payments is 0.

[00:38:10] And so, what's happening here behind the scenes is I am. I have this automation that when the status is of the reservation, it starts as a new request, but then I accept the, the request, it updates the reservation to being reservation offered, notes the date, creates the booking deposit payment.

[00:38:36] And then sends the person an email with a link to pay their deposit and also a link to their lease agreement. So you can see here's my inbox. Here's the email that just came and it says, Hey, pack your bags because our rental request has been accepted. And so it gives, you know, all the details of the [00:39:00] reservation, but also a link to pay the deposit and to sign the rental agreement.

[00:39:04] With both of these, I'm using fill out. I'm a huge fellow fan. And so this is actually a process that can replace. It's filling. There it goes. So, yeah, fill, create, replace the process of actually generating invoices and stripe. So in Lassabook, the way we built it, and we worked with the fantastic Jen Rudd when we first built Lassabook.

[00:39:31] She was the consultant we hired. She was fabulous. But she and she, I think, also at DareTable last year did a session on building an integration with Stripe, doing invoicing with Stripe, that sort of thing. And so you can definitely do that. Lassabook utilizes that. And we use we create an invoice in Stripe and then bring that Stripe invoice URL back.

[00:39:52] And then that allows them to Send that to their guests to pay their, their, make their payments. This is essentially achieving the [00:40:00] same thing without any, you know, scripting or Zapier or make, and it's utilizing fill out as the tool for creating the invoice. And so the way I do this is by you, this is my.

[00:40:13] Form. And so I, I use the update record integration here. So in my Airtable integration, this is an update record integration, which is why I create that deposit payment before actually sending this. So then in that table, in my deposits, or excuse me, in my payments table, if I go, this is my This is like what I call under the hood.

[00:40:40] You can see my, tables here on the payment record. There is this payment link. And this is just that, fill out, you know, that link right here. So it's utilizing the record ID and updating. And so we can pull all those details from [00:41:00] the existing payment record. And so that is how that's working. And so it works.

[00:41:06] It's a great alternative for someone who doesn't want to have to maintain scripting, doesn't want to have to use Zapier or Make, and kind of achieves the same thing. Now, what happens if I would pay this? It would actually come back and bring me back in here the Stripe payment ID. So you Do you have to have a Stripe account?

[00:41:24] Of course, to do this, you could use if you wanted to get in for more information, you know, or go back and look at the payments that you've received. You can go into your Stripe dashboard and find the payments using the Stripe payment ID. Also brings back the name on the card, the email for the receipt, and then the status.

[00:41:41] And, And so that comes back as succeeded. So this, the way I do it is I have the payment amount. So the amount I've requested for the deposit, it stays as requested until the payment succeeds and it brings, comes back in as succeeded at that point, the approved amount is then [00:42:00] equal to that same, you know, it'd be 560.

[00:42:03] And then that then reduces the amount of the reservation, the amount due on the reservation. So, but that's how that works. So it's a nice little trick to be able to create invoices and there could be so many uses for this, even, you know, in consulting, sending invoices. If I wanted to just keep most of that happening with an Airtable, this would be a way to do that.

[00:42:23] Utilizing fill out and then you could actually push, you know, to QuickBooks or something like that after the fact, if you, for accounting. But yeah, so that's once I would accept both the, so here's my payment invoice, and then you can see I also created my rental agreement here, fill out, and I think I have a little, I did it quickly.

[00:42:48] I have a little formatting. So I need to finish. But so something like this would be easy. And then they have, you know, fill out has, e signatures available. I'm on a free plan for this test account. So I [00:43:00] just put lines in here to make it look like that. But in real life, we would connect it using signatures and allow people to submit that their reservation lease agreement that way.

[00:43:10] And so then once that's done, you get something like this, that you're confirmed. So basically it would say, hey, we've received both your deposit and signed rental agreement and you are confirmed. We can't wait to see you. Also just if you have it set up in your Stripe dashboard as to send receipts when payments are made, they, they would also receive.

[00:43:31] A receipt from stripe when that payment is made also so they would in theory get both a stripe receipt And then when they've confirmed with you both the payment and rental agreement, they would get this from you, which is cool So this is where air table super handy because all of this is automated, right?

[00:43:48] So for the host all of this happens without them touching it Until so once they've confirmed. We can go back to the dashboard. You can see, you know, it would really, it would change status [00:44:00] and, and then it would change color so that and so you can right now it's a little, I guess we'll call it peach.

[00:44:05] This is now my reservation is. reservation offered and then they can accept it. And so this stays hands off until either someone doesn't pay. So kind of like this person, I probably need to go hunt them down, give them a phone call, something like that to ask where their payment is. Or, you know, the point of arrival.

[00:44:27] And so at the right now, the system is set up so that two weeks before arrival, it'll send them an email requesting their final payment. And once they do that, then it sends them on their date of arrival, a, an email with like their arrival instructions. It also includes their door code. And I have it set up so that their last four digits of their phone number will become their door code.

[00:44:52] And so then, yeah, so which is super handy. But then and. One of the beautiful things is there are ways to connect [00:45:00] Airtable with even, like, remote key. Systems. So I think like next key is one that I saw that has both like it has an integration with Zapier where you could trigger that on the arrival date, you could remotely set the key to that last four digits of their phone number and then automatically also send them a, date of arrival. So I think I have that here. Yes. So this is what that email would look like is today is a day. Here's your door code. And then also I send them a little form asking, hey, would you just let me know when you're in the property and also look around and make sure it looks okay. So this is giving me a chance to actually like make sure that They are in, but also that things look okay.

[00:45:46] And I think this is a proactive step that avoids the, you know, Hey, we got there and actually things that look the way we wanted them to, but maybe they don't communicate that with you until after the fact, this really keeps that [00:46:00] nips out in the bud. You're able to kind of get on top of any problems right from the beginning.

[00:46:06] And so then, you know, you get, you notice whether they're, checked in or not. And then really, you know, the process flows again, mostly, hopefully, right. Without any problems, you can manage it on your dashboard. You see them leave. So then really the other pieces that need to come together are just turnovers from an operational standpoint.

[00:46:27] So this is like my turnover dashboard. The number I have in the next week, the number that are unassigned. So this is where I would come in. I could choose a contractor that I want to assign it to. This would then, it moves it to assign and sends that contact. An email saying, Hey, you're assigned for this, this cleaning, you know, there's a lot of ways you could do this.

[00:46:47] I was thinking about this and thinking, Oh, this would be a great use case too for, I think Scott, when we shared simple texting and that, you know, you could connect this with that and you could either use simple texting to [00:47:00] send your guests text or your cleaners. I think that would be a really good use case.

[00:47:07] So a lot of different things. And then also there's this metrics dashboard that really get, it shows you, okay, how much, what's my utilization, how many nights are each of my units rented in the last 30 days? What about the next 30 days? And then gives you kind of an idea of your payments collected and also turnover costs that are going to be, accrued as you go.

[00:47:30] So yeah, that's guest book. 

[00:47:33] Dan Fellars: That's amazing. Is this, is, like, is this pretty much people are doing this manually? All the, all the things that you just showed here or, 

[00:47:44] Leslie Burke: you know, that's a really great question. I think it varies from person to person. There's a lot of different just variability because some people they'll utilize Airbnb for their listings and for their bookings.

[00:47:55] But then all of the other backside, they'll be doing either just text [00:48:00] email with their cleaners. And then some of the I know Airbnb has some analytics, but they'll be doing, you know, a lot of that just in Google spreadsheets. And so it really differs. I think for people that wanting to move to direct booking, there are some, there's a tool called like logify.

[00:48:17] And I actually, I think you could connect to that if you wanted to. So that actually aggregates. The different calendars that you have on the various channels, like Airbnb, VRBO, Google Rentals, those kinds of things. It allows you to keep one calendar, but then you could actually integrate with that as well.

[00:48:35] So, some people are still trying to keep those open but then manage more on the backside. I think, The use case where I see this is again, probably more for people that have repeat guests and they, they want to be able to say, you know what, next time, just, just book directly with me instead of booking with on Airbnb and I can give you a better price and we'll both win because.

[00:48:59] I won't [00:49:00] lose all the 

[00:49:00] Dan Fellars: fees. Yeah, that makes sense. Cool. So you are packaging this up and selling to potential other? If 

[00:49:09] Leslie Burke: someone would, yes, I would love to sell it as a template if someone would love it. It's, I'm mostly, you know, still Baiting it with a friend. And, and so really, I think one of the things again, that is a little, it's a great thing, but it's also a challenge I find is when productizing something in Airtable, there's still so much customization that's possible.

[00:49:31] And so how do you present it as. A product of sorts, but yet so much can change, you know, and so I think because even on here I was thinking about the metrics. Well, because I had a friend who she said that they would actually also really love to look at that. Think about projected expenses because they know in all their rentals, they have to change over and get a new fridge every seven years.

[00:49:57] And so start projecting that sort of [00:50:00] thing like expenses. So I think that's been a challenge actually is kind of how to what to call the product. But then also with while communicating still the flexibility of what could change, you know, but yeah, 

[00:50:14] Dan Fellars: I'd love to agree if yeah, fair table. I've, I've seen some things.

[00:50:19] I don't, I don't think it's the intended use case, but. They are coming out with these, like, managed mini applications that might be able to help in this regard. We showed a little bit of that. It's more for, like, internal within a corporate, like, the IT department managing, you know, the, these mini applications that are.

[00:50:41] inserted into multiple bases. But there may be some overlap in use case for this scenario. Oh, cool. Yeah. That could be interesting. Yeah. That's definitely one of the biggest challenges I've seen is like, Hey, I have seen, I have, there are success stories out there of people, you know, [00:51:00] replicating a base and having multiple locations or, you know, multiple clients.

[00:51:05] And they, and I think in this scenario where I've seen it work is. They manage it for them and it's kind of more of a managed solution instead of you know, purchase a template and you run with it. That's, 

[00:51:19] Leslie Burke: that's actually how we do it with lasso book. We, we manage it for them. It stays in our workspace.

[00:51:24] Yeah. 

[00:51:25] Dan Fellars: Yeah. Yeah. That way you have, yeah, you can update as needed. It's just more of a manual update across. Yeah, that's awesome. This is really cool. You can see a real world use case of of the power of air table. Just air table and fill out are really the main things you're using here. 

[00:51:42] Leslie Burke: Yeah. And you so many things could be tacked on to do it, you know, other ways to and add, you know, add texting or whatever.

[00:51:49] But it gives you a solution with really just those two things. 

[00:51:55] Dan Fellars: Very cool. Thank you for sharing that guestbook and they can be, if people are interested, where [00:52:00] can they find 

[00:52:00] Leslie Burke: you? Yeah, probably LinkedIn. You can find me on LinkedIn, just Leslie Burke, or you can email me. You can use Leslie at lasso book.

[00:52:07] com. 

[00:52:10] Dan Fellars: Let's move on. 

[00:52:11] BUILTONAIR COMMUNITY - 00:52:11

[00:52:12] If you are not in our community, we w we want you to join. There's thousands of Airtable users talking about Airtable and our Slack community sign up for our newsletter. Join us on the podcast, subscribe to the podcast on YouTube or, or any of our podcast audio versions, we'd love to have you be a part of the community.

[00:52:30] So join us.

[00:52:32] FIELD FOCUS - 00:52:33

[00:52:33] All right. We're going to talk a little bit about the new date dependency functionality that's available. And this is a little bit of a, what they call like an unboxing. So I'm not an expert in this. I've actually only like spent a few minutes. So we're going to kind of discover this together.

[00:52:51] So Leslie chime in, I'm going to need your help because. There's actually, I was, there was some confusion already on, on, [00:53:00] on how this works. So basically, so this is the, the template they talked about. They, they made some new templates available. This is one of those templates which is actually a pretty nice, nicely designed interface.

[00:53:13] And so if you look at, this schedule template, you see that now they have the Gantt chart inside of interfaces. And so what we're talking about is the dependency between dates. So these dates have start and end dates, and there's there's some dependencies. So we're gonna we're gonna look to see, how this works.

[00:53:41] And so, so if you look on here, so this has a deadline date, and if I change the date, That didn't seem to work the way I thought it would. 

[00:53:54] Leslie Burke: So is that just changing is essentially is that the end date? 

[00:53:58] Dan Fellars: Yeah, I change. Yeah, it [00:54:00] changed the end date. So maybe, okay. Yeah. So it doesn't have the start date on here.

[00:54:08] So we're gonna go to the data layer. We're gonna look at this at the data layer. Okay. So what's new is you'll you'll see this new icon here. This is date dependency enabled. And so if you if you click on this you'll see down here. This is new. So it says this field is used with date dependencies. So the configuration.

[00:54:31] This is the normal configuration for a date. But on here, if you click this configure, there's a new there's a new configuration so you can turn it on or off here. And I wonder why, 

[00:54:50] Leslie Burke: so you could actually make it dependent on. It's like a record in a different table. 

[00:54:55] Dan Fellars: Yeah. Right. And so, let's see, so this is, [00:55:00] so yeah, so your dependency, so I'm guessing, if I change this date, then this list here is going to show, I'm like, I'm guessing.

[00:55:14] Yeah, it's it has to be linked between the task table and the table selected here. And so there's no, there's nothing here. You could create a new one or you don't need a predecessor predecessor field. But so on tasks. So there is. There is this predecessor linked, so it's basically a link to itself.

[00:55:39] So you have parent tasks with subtasks. And so that's what we're linking to here. And so you specify the start date field, here as a date. And it looks like it has to be a date field. It can't include time. So that's [00:56:00] interesting. It only works with date fields. And not date time fields. Wow. Yeah.

[00:56:07] That's kind of interesting. Let me see. Yeah, I guess there's only two here. And then you also need a duration field. And it has to be set to days. So there's a lot of like specific things that you need to get this to work. Yeah. So this only works with dates and days as far as the duration. So, and then there is a couple of advanced options.

[00:56:43] You can omit weekend and holidays, and I believe. So you can actually insert days. So I believe these are days that get [00:57:00] omitted. So these would be like special blackout days. Maybe. 

[00:57:07] Leslie Burke: Oh, so you get like, if you're coming at holidays, you could add those. 

[00:57:10] Dan Fellars: Yeah. Yeah. Our date like reserve days that you don't want selectable. Let's do that. And we're going to save.

[00:57:20] Okay, so now so here's our dependency linked record. So this is linking to itself. So right here. So this iterate based links to implement a progress tracking system, which is right above it. So that means that that this one is dependent on this one. And so I believe, and so we have our duration here, and this is just, so here we have the precision set to days, and, so I believe how this works, so let's just play with these two that are linked.

[00:57:59] If I [00:58:00] change the start date, and I'm going to change it, so right now, this, this duration is set to five. Actually, let's start here. Let's change this to six. And you see there, it changed this date and this date. 

[00:58:14] Leslie Burke: Yeah. And it also changed, I think the start date for the design interactive one. Yeah. Yeah.

[00:58:19] Dan Fellars: Both of them. Okay. So it so this is the 25th. So just by changing the duration. So now these are six days. It, so it automatically changed the, the end date to be this duration, and then it modified this guy to be the start date. It looks like one day after 

[00:58:46] Leslie Burke: actually, I was just thinking about that. I wonder if there's a way to set it so that, or if there's not now, but if there will come a point where you could set that the dependent record either starts the same day or it starts the next day or [00:59:00] even at some point if you could set the number of days that it would start later.

[00:59:03] If that, you know what I mean? 

[00:59:05] Dan Fellars: Yeah. Yeah. You could have a field that says like, like in between, yeah. Yeah. So it looks like it's always the next day. If we change this to three.

[00:59:21] Oh, no, it didn't change. Did I get the right one? I think I got the wrong one. No.

[00:59:35] Hmm. Let's see here. What are we doing wrong? Okay, so this one is dependent on this one. So it should update. Yeah, because these are now not these are now two days. 

[00:59:52] Leslie Burke: I wonder if there's some kind of It only will scoot it back. But once you, 

[00:59:59] Dan Fellars: yeah, [01:00:00] interesting. So this, if you set it greater, it'll push it back, but it doesn't bring it forward.

[01:00:08] Yeah. So the start date that. So the thing is, is, do you know the original start date that was set for this? Apparently it saves it in memory because if I go back,

[01:00:24] it doesn't, it doesn't update it. 

[01:00:26] Leslie Burke: No, I think it just stays at like the last widest it's, or you know, the farthest back it's been pushed. So I guess, but probably I would, do you think it keeps it in the, revision history? Would you be able to find it there? Yeah. So you can see each of those. It 

[01:00:45] Dan Fellars: look interesting.

[01:00:47] So it only pushed back. It doesn't bring it forward. So it's a dependency for extending dates, but not adjusting them forward. That's interesting, right? 

[01:00:59] Leslie Burke: [01:01:00] Well, that's good to know, because if you are a person that's projecting, you know how long a project will take, you want to always, guess the lowest amount, right?

[01:01:10] And then you always push it back, which would update your dependencies. Yeah, if you go the other way and assume, oh, it's gonna take five days, but it just takes three. You're going to have a big manual job of updating everything else. 

[01:01:23] Dan Fellars: Yeah. Yeah. That's interesting. So that, that could be good in some scenarios, but yeah, sometimes if you're like, if one, if one takes less time, you want everything to move up.

[01:01:34] Yeah. And, so if, if I move this up, let's see if I move this to be before the end date. So if I moved this up, oh, there, it adjusted this one. So it does push back. So it does push the previous task to the day before and everything 

[01:01:59] Leslie Burke: adjusts. [01:02:00] Did it adjust? I didn't see it. Did it adjust the duration? Did it make it longer or did it scoot the end date forward too?

[01:02:07] Did it 

[01:02:07] Dan Fellars: keep the duration? It didn't. It did not change this end date, no. Okay. So it 

[01:02:12] Leslie Burke: increased the duration. 

[01:02:14] Dan Fellars: No, it didn't. It stayed three. Oh, there it is. 

[01:02:18] Leslie Burke: Okay. So instead of increasing the duration, it actually moves the whole. 

[01:02:23] Dan Fellars: Interesting. Interesting. 

[01:02:27] Leslie Burke: What happens if you change the second, the end date, it doesn't change the duration.

[01:02:32] It does change the duration, right? Yeah. Start date keeps the duration. If you change the end date, it changes the duration. That's interesting behavior. 

[01:02:42] Dan Fellars: Yeah, that is interesting. And yeah, and it does not move the start date. It just changes, it just pushes out the duration. Yeah. So there's a lot of variables going on that might get confusing.

[01:02:56] Leslie Burke: Right. There's a lot to keep straight of what, you know, the [01:03:00] behavior if, and I think that's really important to know ahead of time when you're setting this up, because it really would play into, you know, how long you set the standard, you know, projects or each of these steps. 

[01:03:13] Dan Fellars: Yeah, so my thinking is, is if you don't specify, if you don't specify a predecessor, so it's optional, it will still do the duration change maybe if you're changing the dates, but not pushing the dependencies.

[01:03:34] So there's kind of two parts to it. So you could. Modify automatically the duration time and the start and end or whatever, by, by playing with the duration or the end date, but it won't push the previous dependencies. So that's interesting. I wonder what would happen maybe for another time is if you had dependencies, if you created a [01:04:00] cyclical loop that you had dependencies that were like, went in a circle and how the dates would work there.

[01:04:10] I don't know. We'd have to try that. Yeah, we'll save that for for another segment. So 

[01:04:18] Leslie Burke: I wonder if there'd be a, or maybe they'll develop it at some point where you'd get a warning of almost like Excel. Doesn't Excel give you like, you have a circular reference. Yeah. 

[01:04:27] Dan Fellars: Yeah. And you do get that in some scenarios.

[01:04:30] I can't remember. But that, that does happen in air table. It will tell you, that you, yeah, that you have a cyclical dependency. Yeah. But yeah, anyway, so some interesting stuff there. Let us know if you're using it, how you're using it, the good, the bad, the ugly of, of date dependencies. I feel like there's, there's like most features, there's some good parts and some bad parts to it.

[01:04:57] Awesome. That concludes the show. Leslie, thanks for coming [01:05:00] on. You've been my good host with me and excited to see where, where things go with your products and what you've got going in the future, we'll have to have you on in the future and get an update. 

[01:05:11] Leslie Burke: I love that. Yeah. Thanks for having me. 

[01:05:12] Dan Fellars: All right.

[01:05:13] Take care. We'll see everybody next week.

[01:05:21] outro: Thank you for joining today's episode. We hope you enjoyed it. Be sure to check out our sponsor, Onto Air Backups, automated backups for air table. We'll see you next time on the built on air podcast.