11/12/2024 – BuiltOnAir Live Podcast Full Show – S20-E06

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

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.

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 Ben Green from Optimize IS.

My name is Ben. I started Optimize in college. I was working in factories and studying Information Systems & Operations at Indiana University. I was learning how to combine technology and business with the goal of working at a Big 4 Consulting Firm. When looking at my peers 20-30 years ahead, I realized I did not want to follow their path. The tech skills I learned are only shared with the largest Fortune 500 companies. The University was not teaching how to help Small and Medium sized businesses. I realized SMB’s can benefit the most from tech, and they are a lot more fun to work with. I chose to not take a job and instead make YouTube videos showing how SMB’s can use tech. Those first Youtube videos have turned into 143 happy customers. These customers use us to build systems and tech around their business.

Visit them online

Field Focus – 00:01:42 –

A deep dive into the Array Slice Formula Formula – Ben will showcase the power of the slice 

Audience Questions – 00:01:43 –

Alli Alosa answers the Airtable question: “What is best way to dedupe/cleanup data”

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

Ben Green – Founder, Optimize IS

Meet Ben Green from Optimize IS.

My name is Ben. I started Optimize in college. I was working in factories and studying Information Systems & Operations at Indiana University. I was learning how to combine technology and business with the goal of working at a Big 4 Consulting Firm. When looking at my peers 20-30 years ahead, I realized I did not want to follow their path. The tech skills I learned are only shared with the largest Fortune 500 companies. The University was not teaching how to help Small and Medium sized businesses. I realized SMB’s can benefit the most from tech, and they are a lot more fun to work with. I chose to not take a job and instead make YouTube videos showing how SMB’s can use tech. Those first Youtube videos have turned into 143 happy customers. These customers use us to build systems and tech around their business.

Visit them online

Segment: Field Focus

Start Time: 00:01:42

Learn about the Array Slice Formula – Ben will showcase the power of the slice

A deep dive into the Array Slice Formula Formula – Ben will showcase the power of the slice 

Segment: Audience Questions

Start Time: 00:01:43

Airtable Question – What is best way to dedupe/cleanup data

Alli Alosa answers the Airtable question: “What is best way to dedupe/cleanup data”

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 YouTube channel every Tuesday at 11 a. m. Eastern. And join our active community at BuiltOnAir. com. Before we begin, a word from our sponsor, OntoAir Backups. OntoAir Backups provides automated air table backups to your cloud storage for secure and reliable data protection.

[00:00:43] Prevent data loss and set up a secure air table backup system with OntoAir Backups at OntoAir. com. As one customer, Sarah, said, having automated air table backups has freed up hours of my time every other week. And the fear of losing anything. Longtime customer [00:01:00] David states, OntoAir Backups might be the most critical piece of the puzzle to guard against unforeseeable disaster.

[00:01:06] It's easy to set up, and it just works. Join Sarah, David, and hundreds more Airtable users like you to protect your Airtable data with OntoAir Backups. Sign up today with promo code BUILTONAIR for a 10 percent discount. Check them out at ontoair. com. And now let's check out today's episode, and see what we built on air.

[00:01:37] Dan Fellars: Welcome back in to the built on air podcast. We are in season 20, episode six. Good to be back with you. I've got myself, Alli Alosa with us. Camille is out this week, but we've got special guest Ben Green joining us. Welcome Ben. 

[00:01:52] Ben Green: Thanks for having me. Excited to have you 

[00:01:54] Dan Fellars: back on. Ben's been on a few times, but we'll get caught up on Ben's story later in the show.

[00:01:59] [00:02:00] So I'll walk us through what we're going to be talking about today. Built on air podcast is an hour long show. We'll keep you up to date on everything in the world of air table and no code, low code, we'll start with around the bases with what people are talking about in the communities, then sponsor from onto where backups.

[00:02:19] And how you can get started with that. And then Ben Green will get caught up on Ben, his story and background and what he's up to. And then Ben's going to be walking us through how to use a ray slice in your formulas and the power of. The slice and then shout out to join our community. And then Ali is going to wrap us up, answer a very common question of what's the best way to de dupe or clean up our data.

[00:02:46] I'm going to show us some, some best practices on that front. So with that around the bases, 

[00:02:53] ROUND THE BASES - 00:02:54

[00:02:55] let's start with a big announcement. Airtable made public. [00:03:00] Guest access with portals, so they just put this up on their website. It's in beta early access. You can click on this link. It goes to a form you fill out and not sure.

[00:03:15] I assume that the beta or this early access They won't charge you yet, but they do list their pricing. I think it's free to like January or something like that. Free to January. 

[00:03:28] Alli Alosa: Yeah. I think I heard said early February, but yeah. 

[00:03:33] Dan Fellars: Okay. Have either of you got somebody signed up on this for the early access?

[00:03:38] Ben Green: So we technically, I don't know if by air table standards, we were the first, but we used it for their table. 

[00:03:44] outro: Yeah, 

[00:03:45] Ben Green: the link at the top of the dare table website was to the portal, 

[00:03:49] Dan Fellars: but 

[00:03:51] Ben Green: technically that was a portal. 

[00:03:53] Dan Fellars: Yep. That's where I first saw or had the experience with it. So, so I'm curious, like how quickly [00:04:00] they'll approve people if it's just fill out the form and, and they'll get approved or if, you know, They're limiting who they actually give access to.

[00:04:07] But yeah, so it has a customer sign in page and then the experience is pretty much the same as it, you know, you're essentially just getting access into an interface application. But You know, so you won't be able to see the data layer or the, or the automation layer. But it's pretty much the same as if you had editor access to to an interface app.

[00:04:30] Right.

[00:04:35] Alli Alosa: That's my understanding. 

[00:04:36] Ben Green: Yeah. Except I think the, the big difference would be if you're not somebody who knows what Airtable is and you were, I think eventually once they get through some of this white labeling that you're seeing here, you could send this to somebody and they wouldn't know that it's Airtable.

[00:04:52] Unless they like knew what Airtable looked like, you could send it to someone and it would look like, Oh BuiltOnAir has a custom app for any of their [00:05:00] speakers. 

[00:05:01] Dan Fellars: Yeah. Yeah, especially if they would allow you to like put it on your own domain and not be the Airtable domain, which doesn't say you could have a custom domain for it, but That would be cool.

[00:05:16] Alli Alosa: That would certainly be cool. 

[00:05:19] Ben Green: I will just not comment on things that are allegedly coming. 

[00:05:24] Dan Fellars: Fair enough, fair enough. But yeah, so I guess right now they don't have the white label experience that's coming. So right now it doesn't look like it just says powered by air table. So there is some, some branding there on the, on the sign in page, but then eventually you can remove that and put your own logo there.

[00:05:44] I'm guessing that's maybe an enterprise feature. But maybe, maybe that'll be available on the team. Not sure. My understanding of how it works is, so I'm sure people are thinking like, Oh, I could get all my internal users. Signed up here because [00:06:00] it's only 8 a month versus the editor pricing. The big difference, if you're using, you know, SSO, you wouldn't be able to have somebody with your domain email, log in through the portal and believe there's a restriction there that if you log in with like a company domain, that's associated with the, with the SSO.

[00:06:23] It would not work to, to go through the portal. Is that fair? 

[00:06:28] Ben Green: Yeah. The, the portal's, the main like user persona you would have for a portal is anybody not with your same domain, people not 

[00:06:36] Dan Fellars: on your core team. Yeah. There it says that user does not share your team or company's email domain. 

[00:06:44] outro: Yeah. 

[00:06:44] Dan Fellars: Or uses a personal domain.

[00:06:47] Interesting. Yeah. So you can't log in with a Gmail to the portal. 

[00:06:53] Alli Alosa: No, you can. It's you'd be considered a guest. So you could invite somebody that technically [00:07:00] is an internal user, but if they're using their personal email, then. They'd be considered a guest. 

[00:07:06] Dan Fellars: I guess I was confused. Does not use a personal domain or a guest user is one who uses a personal domain?

[00:07:14] Alli Alosa: Yeah. That is the grammar is a little strange there. 

[00:07:18] Dan Fellars: Gotcha. Yeah. That'd be interesting if they didn't allow you to log in with the Gmail. 

[00:07:25] outro: It would 

[00:07:26] Dan Fellars: the one 

[00:07:27] Ben Green: thing I would say on this is because I've seen a few examples of the pricing if you're like you have sticker shock still because it's that price per user that's listed on the website, which is like, I think it comes out to eight.

[00:07:41] Is that did it say 8 per user per month above? After the one 20 for 15. Yeah. If you're concerned about how that scales, I'd say reach out to the air table sales team and tell them how many users you have, because it does say there's bulk discounts available for large volumes of guests. So don't [00:08:00] think it's going to be, if you, let's say you have a hundred users, my guess is that price would go down and you'd be able to negotiate 

[00:08:06] Dan Fellars: something.

[00:08:07] Hmm. Julian says, I think that means that if your air table account is, if the owner uses a Gmail account, you can't use portals. That'd be interesting. 

[00:08:18] Alli Alosa: That would be quite interesting. 

[00:08:22] Dan Fellars: So portals only works if you have it tied to a corporate domain so that they can then filter anybody else. So interesting.

[00:08:38] Yeah, because you always wonder like how are they gonna, you know, there's been rumors of this for like a year or or desires for it for years and that was always the thing of like how are they going to manage. A price discount for, you know, all the users that you're already paying for. And so this is kind of their, the middle ground to separate internal users versus [00:09:00] external.

[00:09:03] But if you invite people with a Gmail domain and you have the same domain that breaks the stated rule, 

[00:09:09] outro: assuming 

[00:09:09] Dan Fellars: if, if you're on a Gmail account, yeah, the admin is right. So that means the Gmail team can't use their table toast.

[00:09:24] All right, so yeah, this is exciting. It'll be interesting how this shakes out with industry players, third party apps that, that solve this problem. And there's still definitely differences of functionality, things you can't do in the interfaces that you can do with some of these third party apps. So it doesn't completely eliminate the need, but definitely eliminates a lot of use cases.

[00:09:49] Ben Green: I I'd say in general, just my take on how much the Airtable product team has released in the last year. I'd be shaken in my boots if I was one of these external players with just [00:10:00] like the, the velocity that Airtable has been releasing things. I know for a lot of like the community that we're in, the enterprise features aren't maybe as exciting, but like they've been shipping a lot of stuff on the enterprise.

[00:10:13] This one is targeted towards some of these external use cases. And they've been testing on things like the product central and which has new features in it that we've never seen. They've been consistently releasing new. Interface page types and just. Making it better for everybody. So I'm pretty proud of like, I don't, not part of the air table team at all.

[00:10:36] So I don't want to sound like too much of a shill for them, but like, they've been putting in a lot of hard work and releasing a lot of good stuff. Yeah. Yeah, for sure. 

[00:10:46] Alli Alosa: Yeah. I'm excited to see where, where everything goes and not surprised that most of the third party tools are. Diversifying as much as they possibly can at the same time.

[00:10:56] You know, a lot of them started out as kind of air table [00:11:00] was the main data source. And now they're branching out to allow for all sorts of different things. So I think that's the smart move. 

[00:11:09] Dan Fellars: Yeah, there are some use cases where the price point, you know, if you're building something that's like Okay. You want like a community or something like 8 a month just wouldn't be feasible.

[00:11:21] And even if you got that down to half that, you know, softer I think gets down to 1 a month per per external. So that's probably, I have seen, it used to be weird. We all remember where there was some tools that didn't charge you per user and it was just like flat tiers and you could have like unlimited users.

[00:11:42] It seems like. Those have all gone away, right? I don't know that JetAdmin maybe, I think they might still not, but all the main players have moved to a per user pricing. 

[00:11:55] Alli Alosa: Or tiers of users, like Softr, they've recently changed their pricing, [00:12:00] like in the past few months, I believe But now their, their professional plan, which is 1.

[00:12:04] 39 a month, only allows for up to 100 app users. And then you can pay 10 per, 10 for another bucket of 10 users. After that, 

[00:12:20] Dan Fellars: so yeah, it'll be interesting to see what people do, how they respond. They're all moving, you know, softer, just announced notion. We talked about that a couple of weeks ago, so they're trying to expand beyond our table, but I got to imagine what 80 90 percent of their customer base is, is on top of our table.

[00:12:42] Yeah. So 

[00:12:43] Alli Alosa: they just released a rest API as well. Softer did too. Really expand the sources that you can use, which is exciting. 

[00:12:53] Dan Fellars: Yeah. Yeah. So we'll see how it all evolves. All right, let's move on. That's the [00:13:00] form to fill out. Okay. We talked about this, so there was a summit last week in London.

[00:13:07] This is a picture of just the partner summit, which I think is similar to what they did at their table. It looks like there was a bigger. Europe air table summit, and then they, they had a partner summit. Nelson's looks like Nelson was there. I didn't realize he went out to London and met with the team out there.

[00:13:24] So if you were out there at the London air table meetup, we'd love to hear how it went for you. There was, we had a team member that went and they said it at the conference. I think I'm okay sharing this, but and he wasn't sure if this was like information that this person wasn't supposed to share or not.

[00:13:48] But they said that they have in the works the ability to get to 500, 000 records per table and not, not talking about hyper DB. But within Airtable, [00:14:00] 500, 000 and the goal to get to a million within a year or so, something along those lines was mentioned at this, at this conference. So that, that could be interesting.

[00:14:12] So that, that, for me, that's good to know that they're still trying to expand Airtable and not just say, okay, if you need more, you got to go to HyperDB. 

[00:14:21] Alli Alosa: Absolutely. 

[00:14:23] Dan Fellars: So hopefully that's true and not misinformation out there. So don't quote me on it. It's third hand at this point.

[00:14:34] All right, next one. We always are interested in competitors to air table. Here's a new one that I hadn't seen before. No code DB. I have. We've talked about that one, but Grist, maybe we mentioned this. I don't, I don't remember seeing this one. So appears to be open source, but also has a paid hosted offering, you know, very similar to, to Airtable.

[00:14:57] So if you'd like to explore open source [00:15:00] solutions, here's another one you could try out. There's probably five or six at this point, at least that we've talked about over the years. Be interesting to see if. Which ones went out? Okay, one more. Yeah, so it looks like this. I think we talked about this like six months ago, but there's a there's a malware email going around that links to an air table base, like a shared base or table.

[00:15:31] And then inside of there, there's a link that I think the last one we saw made it, Try to look like it was like one drive or make you think that it was like one drive and you would have a link to a file and it would download a program that would, that would install malware on your computer. So something to be aware of, don't be clicking on random phishing links that take you to Airtable.

[00:15:54] It's not going to download it if you click on the Airtable link, although you shouldn't anyways, but it's once you get to [00:16:00] that. And then there's another link inside of a, a grid view that, that takes you to something else. So, 

[00:16:07] Ben Green: So are they using the Airtable share link to redirect to their, like, shouldn't Airtable look at shutting down whoever owns that app ID?

[00:16:21] Dan Fellars: Yeah, yeah, this is something I know the last one, they said they reported it to air table. No, if, if these guys have, so 

[00:16:31] Ben Green: I remember this was a few years ago in the Facebook community, there was somebody doing, there was some illegal activity that they were like managing through air table. And I remember this post of this guy saying like that they had reached out to support asking for support help and they had added team to their base.

[00:16:51] And then they posted in the community, like, Oh, I don't, I can't access my account anymore. Who can help? And it was, I'm pretty sure because [00:17:00] they had illegal stuff in their base. So I know Airtable does care about their terms of service. And I don't, I'm pretty sure that's what happened. I'd never talked to this person in the group, but I just remember seeing that post.

[00:17:11] So they should remember that. Yeah. 

[00:17:15] Dan Fellars: Yeah. So here's the app ID right here. So air table, I know you're watching faithful watchers of our show, the air table security team watches every week. So your app ID. Okay. Something, Oh, this one's interesting. So. Tara Shehan looks like an author and used to work at Stripe.

[00:17:40] Wrote this pretty interesting long form, kind of on the state of internal software builders. And so definitely worth checking it out. Here's the, here's her, here's her report that she wrote up. 17 page Google doc. I have not read all of it, but I plan to just to kind of get a sense of where [00:18:00] she's viewing kind of the state of the no code, low code platforms and how there's just a huge graveyard of all these products that just never quite.

[00:18:09] You know, had initial success, but never quite broke through and failure to launch at the teenage, you know, stage. And includes kind of, although her analysis is that she thinks air table still in that teenager stage, which I think might be fair compared to some of the legacy platforms Salesforce and whatnot.

[00:18:31] So but I don't think I'd put it in the failure to launch stage. I think there is still upward trajectory. Obviously we're all biased in that choice, but yeah, pretty interesting. If you like to kind of get into the philosophical AI plays a huge part in this, and that's what she talks about of like, you know, what is the next phase of like platforms that at their core are built around AI, You know, anything like air [00:19:00] table, you know, obviously has a I now built into it, but it wasn't started in the era and how that might look different.

[00:19:07] In a couple of years when these, you know, a I first platforms emerge. Any thoughts on where things are at as an industry high level view?

[00:19:29] Alli Alosa: It's hard to say. I think

[00:19:35] I don't know. There's a very fine line, I think. It's great that more people have access to build these tools and spin them up very quickly. But I think then you also have a lot more tools that are more fallible because people that don't have the experience and things like know what to look for, then are creating things that can break.

[00:19:58] But then you learn from it. [00:20:00] So it's, it's both good and bad. 

[00:20:04] Dan Fellars: Yeah, pretty interesting. Anything else? Yeah. So here's kind of this, this chart. It's kind of interesting. Ease of customization, you know, and power. And so you kind of lose some power functionality to make it easier to use. And you know, what does AI do to this curve? So things like that, anyways, definitely worth 

[00:20:31] Ben Green: keeping an eye on.

[00:20:33] I'd say in general with Airtable, that's every time, as much as I do love their product releases consistently, like every single month, every time I do see the product release, I always think. This is more job security for me, Dan and Allie because every time they're adding more customization, it means it's harder, a little bit harder of a tool to pick up, like, especially if I think about what Airtable looked like four and a half years ago, [00:21:00] when I first started it, there were no interfaces, there were no automations, it was just the.

[00:21:06] The data layer. And it was relatively easy for me to pick it up back then. Cause it was like pretty much just access being the data layer. But now with AI, with interfaces, with automations, with all the other stuff, it, it makes it harder to customize for a general user. 

[00:21:27] Dan Fellars: Yep, absolutely. But Salesforce. Yeah.

[00:21:35] Ben Green: And there's so much demand still for. Airtable solutions. Like people still are asking for it more than they were four years ago. 

[00:21:48] Dan Fellars: Yeah. It's definitely interesting. How it's evolved. I'm not, what do you know what logo this is? It looks like a Microsoft logo. Yeah. Is that the power? Yeah, that's probably [00:22:00] what it is.

[00:22:02] All right. Move on a couple from the built on air community alley. We're going to feature you. Oh, Justin says that's a visual studio code. So I guess that makes sense. So. Ben, you didn't know that one? Okay, Allie, let's ask you a question. Any documentation around this, so this is related to fill out, doesn't support user collaborator fields from Airtable?

[00:22:24] Did 

[00:22:26] Alli Alosa: you get 

[00:22:26] Dan Fellars: an answer? 

[00:22:27] Alli Alosa: I did and the answer is that no, they do not. And I meant to comment back on this to update Martin, so thank you, Martin, for that. All you're digging into that as well. Yeah, it, it does have to do with it being difficult to grab them and you need to have an enterprise account in order to even have access to that API call.

[00:22:47] So, and this is honestly news to me. I, I was rebuilding a mini extensions form in fill out and in many extensions, I had a dropdown that was a user field from air table and worked. No [00:23:00] problem. Although this was. The client's account is an enterprise account. So maybe many extensions never had problems with it because it was pulling it from an enterprise account.

[00:23:10] But I was very surprised. I didn't think that this would be a thing, but it is. So yeah, there's I had to find a workaround and just use a easiest solution for me. It was just a long text field. I was just trying to capture like somebody's saying, I'm the one that did this using fill out. Yeah.

[00:23:32] Rather than rebuild a whole new table with it. With all the employees, we just decided to do a long text, but or single line text either way. 

[00:23:41] Dan Fellars: Yeah, yeah, I'm not sure why we, I know we, you know, we had a form solution and we supported user fields. 

[00:23:51] Alli Alosa: Yeah, I, I was surprised. I didn't think, but yeah, they, they did fill out confirmed, but no, they don't, they [00:24:00] don't support it.

[00:24:02] Dan Fellars: That is interesting. Maybe because it changes all the time, they could, they could get, they could get deleted more, you know, you could remove somebody's access so that breaks things. Okay, another one, Allie, you've been busy. This one, last week, field metadata, explain what's going on here. 

[00:24:24] Alli Alosa: Yeah, so I have a script that I use to populate a table of tables at a table of fields.

[00:24:32] And so I access the metadata via scripting and populate all these field values on a table and I noticed because I was trying to translate. What is currently something I run in the extensions panel to an automation, which that's been a heck of a project to try and do it's working around the 30 second time limit and trying to pass things from one step to another and figure out where it's [00:25:00] slowing down.

[00:25:00] But regardless, in doing so, I figured that I figured out that in the automation script. If you call the same exact code and access the property of options from the field metadata, it gives you something completely different than if you ran the same code in the extension. Mainly around, this appears to affect just lookups of select fields, so lookups of multi select and single selects.

[00:25:28] If you run it in the automation script, you get A result property, which shows you all of the choices that exist in that select that's being looked up. Whereas if you run it from the extension, you don't get that result property or you do get a result property, but it doesn't show you all the choices.

[00:25:48] It just actually erroneously categorizes it as a single line text. Result, which is, I think, a remnant from [00:26:00] before they retained the look and feel of select fields when you did a lookup of them. Previously, years ago, it was just it would be single line text. If you did a lookup of a single select, it would look like.

[00:26:13] Just text. Sorry, that's a long explanation, but 

[00:26:19] outro: yeah, 

[00:26:20] Alli Alosa: the same code produces different results in the automation panel versus the extension. 

[00:26:26] Dan Fellars: Yeah. Yeah. And the API handles it differently as well. So you've got three different variations depending on how you're accessing the data. 

[00:26:37] Alli Alosa: Which is interesting.

[00:26:38] Dan Fellars: Yeah. Yeah. Yeah. The API is different. And then if you implement webhooks, it's different there as well. Everything, there's some differences, lacking consistency. All right, last one. Okay. Let's see if we can answer this for Leona enterprise. Customers can choose different LLMs for air table [00:27:00] AI. But you know what the sources for non enterprise account default to believe it's open AI.

[00:27:08] It's chat, GPT. I'm not sure which version. 

[00:27:12] Ben Green: Everything defaults to open AI. But maybe we could show how to figure that out if you, so you go into an AI field and in the field, there should be a little settings wheel. And then that settings wheel, you're able to change the. Yeah, 

[00:27:30] Dan Fellars: yeah. I don't, yeah, I have enterprise accounts, so I don't know if I could show it or I've I don't have a team account that I could easily access.

[00:27:38] It's not a client. 

[00:27:39] Alli Alosa: I, I did this the other day. I 

[00:27:43] Dan Fellars: know on enterprise, it gives you that option. I don't know if it gives you the option, but there's only one drop down on a team plan. 

[00:27:52] Alli Alosa: When I did this with a client, it wasn't in an AI field. It was the AI automation step. And I'm pretty sure it did give a dropdown.[00:28:00] 

[00:28:00] I know that it included a bunch of different models of chat GPT. And I want to say that it defaulted to 3. 5. But then you can choose like 4. 5. From the dropdown. Can't remember if I saw other ones. I know there was a couple of different chat GPT models though. 

[00:28:20] Dan Fellars: Yeah. Yeah. So yeah, but I, for sure, I'm pretty sure it defaults to chat GPT.

[00:28:26] That was the first one that they did. So likely it defaults to that. Yeah. Leona let us, let us know if you get confirmation on that and see if you can find it in the dropdown. All right. That concludes our round the bases. 

[00:28:41] ON2AIR BACKUPS - AIRTABLE BACKUPS - 00:30:11

[00:28:43] If you are running your business on Airtable, best practice is to make sure your data is stored outside of Airtable and that's where onto where it comes in, we help back up your data.

[00:28:54] To places like google drive box dropbox, and we now support one drive as [00:29:00] well so check us out onto air. com. We also have the ability to restore your base your backup back into your table and Lots of new functionality that we're working on that i'm excited about to share in the coming weeks. So use promo code Built on air that'll get you a discount onto where.

[00:29:17] com will be the place to make sure your data is safe and secure outside of air table that Ben regular 

[00:29:28] BEN GREEN - OPTIMIZE IS - MEET THE EXPERTS - 00:31:02

[00:29:32] Ben, you should know Ben's name. He's everywhere. Let me get you big screen. So Ben, tell us a little bit about just kind of your history and story and how you came into this world of air table. 

[00:29:46] Ben Green: Happy to.

[00:29:47] I did not know I was going to be talking through this before this. I thought I was just talking about array slice for the record. So this may be a little bit rough, but I've been in the air table community really since the first air table users conference. Do you guys remember the [00:30:00] virtual one? So the, the virtual one, I think it was either that same day or the day after I posted my first YouTube video.

[00:30:08] But like three months before that, I had found Airtable that really long story short. It may be a long story. I don't know. I was trying to work for this guy for free. He said, no, but if you can do anything like go learn Airtable and or learn a tool called active campaign. I was like, well, Airtable seems easier to learn.

[00:30:30] So I chose Airtable and I'd come from from getting my degree in Information systems and operations. So I had learned how to code in a few different languages, hated it, still hate it and, but I'd also learned like Microsoft access. So I was coming from all these like classical training of software development from Indiana university.

[00:30:51] And then I found Airtable and I was like, Oh, this is actually so much easier than I thought, because I had also taken classes in Excel. So I knew the formulas pretty well. Microsoft [00:31:00] access, as far as Getting the fundamentals of a relational database was pretty, pretty similar to air table. So I picked up air table pretty quick, went back and like work for some people for free.

[00:31:11] I actually found like some of my first first testimonials from helping people out in the built on air community. That's how I got started was I would just answer people's questions. Then they would say, Hey, can we jump on a call? And then I'd help them out for free for a little bit so that basically I could get some proof of value.

[00:31:26] And. Then ended up getting my first few clients. So that's how I first got, first, first got started 

[00:31:33] Dan Fellars: was how have you gone back to that person that turned you down and said, look at me now. No, 

[00:31:38] Ben Green: they ended up hiring me later though. So it did end up coming full circle a few months later. Once I had learned Airtable, they just didn't have the time.

[00:31:48] I wanted to work for them so that. They could teach me air table, which hindsight, it was going to be more work for them than it would cost them to just hire somebody. 

[00:31:57] Dan Fellars: Very cool. So 

[00:31:58] Ben Green: that's how 

[00:31:59] Dan Fellars: you're [00:32:00] a talk a little bit about origins. Let's, let's do the Facebook community and also dare table. 

[00:32:06] Ben Green: Yeah. So the Facebook community, let's see if I can share my screen for those who have not.

[00:32:12] Yeah. Join the Facebook community or sticklers like Scott Rose. I'm going to call Scott out because Scott says he does not have a Facebook account, but I know he created one, one, and he tried to 

[00:32:22] Dan Fellars: join. He does. Cause I I'm friends with him on Facebook. He's been posting about his trips. 

[00:32:26] Ben Green: Yes. Yes. I think he got one maybe for that trip, but the Facebook community is near and dear to my heart.

[00:32:32] I started becoming an admin of this. There was a, I, when I first, like this group is, Been around longer than I've known about Airtable. So it's existed for quite a long time. There's a lot of people in it, but I had connected with the former admin of this community probably around four years ago. And I was just like trying.

[00:32:52] At that time I was, I was in college. I was just basically trying to put out as much free value as I could posting YouTube videos and answering people's [00:33:00] questions. And so I was just answering people's questions. And then that connected me with the admin of the group. Now I think I'm an admin, Chris is an admin.

[00:33:09] Charlie is an admin of this group. But basically we just try to keep it as a similar to the built on air community, where it's just very helpful. People come in here, ask questions and we try to get them answers. Now there's like a lot of people answering questions, which is pretty cool to see. For a few months when I was first starting out, it was mainly just me.

[00:33:30] Occasionally we get a few AI people in here answering questions with like really chat GPT answers that don't make sense, but for the most part, people get help just like the other communities. So. 

[00:33:41] Alli Alosa: I will say you've, I think, it seems like you and Chris have done a really good job of cracking down on that.

[00:33:47] I've seen that get reduced quite a lot in the last few 

[00:33:51] Ben Green: weeks. 

[00:33:51] Alli Alosa: Facebook 

[00:33:52] Ben Green: has some good features that like, allow you to ban somebody and also ban their future profiles. [00:34:00] So like it, no, it knows based on maybe them using the same device, I think, to to block their future profile and not even let them see the group.

[00:34:08] So we've been doing a lot of that and a lot of cleaning up answers in there. Yeah, 

[00:34:13] Alli Alosa: it's a cool, 

[00:34:14] Dan Fellars: so yeah. Join that that's the largest Facebook community of air table users. So join that there. Talk a little bit about their table. 

[00:34:23] Ben Green: Let's see, so their table, I can pull up the website in a second.

[00:34:27] The other things I was just going to reference, I don't know if the screen share is still on, but I S this was the channel where I started. So if I go to the oldest video, this. One of these videos, I think probably this one right here was the first one that I had posted back in 2020, but I go through some, some consistency, some inconsistency of posting whenever I have something that I think would be helpful.

[00:34:52] And then recently we are also started posting different videos with clients and different videos with team members that we've brought [00:35:00] on. Cause since I started for me for a while, for like two years, it was just me. And then about two years ago, I partnered with Charlie. And so Charlie and I have been partners and we've slowly grown a team too.

[00:35:12] We have now four full time employees. We have a lot of people helping us out on different projects. So if you want to meet the team, this channel is a good place for you to meet the other people on the team. But dare table. Which we had a live stream of, if you just saw the URL, their table. Like I said, when I posted my first video, the day after the first user conference, which at that time it was called the air table on official user conference was the name of it.

[00:35:39] And I met up like Chris hosted that I was just a participant. Yeah. Chris Dancy. He'll actually be on next week. And you mentioned notion earlier. You can ask him what he thinks about notion. Maybe next week, he had some funny responses about that. But I met up with Chris after that, because I posted in the Facebook community because there [00:36:00] was at that at the time, there's this thing called clubhouse if anybody remembers clubhouse, and we were like, let's start an air table clubhouse.

[00:36:06] There's not air table and clubhouse now. I don't think anybody uses clubhouse. But at the time, it was the cool thing to do. So we started doing. Audio live streams on there. I guess we ended up wanting to do some videos. We ended up switching it to zoom and kind of still holding our phones up. So if people were on clubhouse, they could join, but through that, we started talking, maybe we should do a user conference in person.

[00:36:29] And so at that time we landed on Austin and we started organizing this event. Austin, I'd say every dare table though, Chris has done. 80 or 90 percent of the work. He's like the main organizer and I've been there basically as a partner to make help with what I can offer the Facebook community to help get people to go there and see how I can support Chris.

[00:36:52] But the first year we did Austin, then we did San Francisco at Airtable headquarters, and then this year we did it in New York, which was. [00:37:00] Two weeks ago now, roughly two weeks ago. And this year it was every year it's grown bigger and bigger. This year was the largest. It was, there was like 275 people I'd say, but the room was packed.

[00:37:12] I had to yell at Dan to go sit down because not enough seats and he had to go squeeze in places. That's right. 

[00:37:21] Dan Fellars: Very cool. So yeah, so Ben's been everywhere. And now Optimize IS is, is the company that Ben runs with Charlie and help companies of all sizes and I'll toot your horn just received. Top partner of the year or what's the official, 

[00:37:39] Ben Green: Air table partner of the year, 

[00:37:40] Dan Fellars: partner of the year.

[00:37:41] Okay. So doing great things there to optimize is so you can find them optimize is. com or your YouTube channel. 

[00:37:51] Ben Green: Yep. Exactly. Optimizeis. com, the YouTube channel. You could message me on Facebook or LinkedIn, but those first two places are the easiest [00:38:00] places to get in touch with us. 

[00:38:02] Dan Fellars: He's also in the BuildPounder community and I don't know how much you post in the Airtable community anymore, but at one point was active there.

[00:38:11] I don't think anybody posts there anymore. 

[00:38:13] Ben Green: That's actually a little bit relevant. The Airtable community just a quick plug for them. They're starting these things called user groups. And I actually just led the first call with the marketing user group last week. So I think it was last week. I hosted one and I basically went through like one on one for, For marketing and air table.

[00:38:34] And there was like 20 people that showed up, which was pretty awesome to this. It was like a zoom call. So everybody was in the zoom call. People ask questions and you got some pretty good engagement, but that's the extent that I've engaged really in the air table community so far recently. Yeah. Okay.

[00:38:51] And just another quick plug. Jen Rudd has, she's the user group leader of AI. I don't want to say specifically when her event [00:39:00] is, cause I'll get it wrong. But soon in November, she's hosting a user group for AI. 

[00:39:06] Dan Fellars: Gotcha. Those are the two that they are doing right now. Right. Or is there another one? Just those.

[00:39:13] So yeah, they're kind of moving to user groups around specific topics. So let's see how that goes. Awesome. Thank you, Ben. 

[00:39:22] FIELD FOCUS - ARRAY SLICE IN AIRTABLE - 00:41:19

[00:39:24] And now Ben's going to show us. Secret to the slice. 

[00:39:31] Ben Green: Sweet. Have you, have either of you used the ArraySlice formula? 

[00:39:39] Alli Alosa: I haven't, I haven't needed to really yet. 

[00:39:44] Dan Fellars: Okay. Dan? I think I have, yeah, but it's 

[00:39:47] Ben Green: been a while.

[00:39:50] Okay, so, in regards to like, the history of Airtable formulas, this one is relatively new, I'd say. You want to share your screen? Yep, I'm just pulling it up.[00:40:00] 

[00:40:05] Alli Alosa: Yeah, I would say it's probably even the new list. They very rarely add new functions. 

[00:40:12] Ben Green: Yeah. 

[00:40:13] Alli Alosa: Yeah. 

[00:40:14] Ben Green: So yeah, array slice, as far as them, it's probably like two years old now, but it's relatively, it's like the newest batch of formulas. I think before array slice, it was regex that came out which actually you'll see a little bit of regex, not regex that I wrote, of course.

[00:40:30] Cause I don't care. Now I write it. Yeah, exactly. So what I'll be going through is the array slice and why you would want to use array slice. I have a very specific use case that I'll be. Talking about, but it may give you ideas if you want to use it as well. So the problem that I came up with was I needed to do a matchmaking.

[00:40:53] If you think about something like match. com or like dating services or [00:41:00] anywhere where you want to do matchmaking, it could be you with your vendors. AI functionality around trying to suggest linked records. That's like a concept of. error table trying to help you do matchmaking and linked records. But really, if you want to calculate the similarities, similarities or differences in two data sets, that's what I'm talking about with matchmaking.

[00:41:22] The specific example that I am going to use and show on this demo is if I look over here on the left, we have these five linked records. How many of these are similar with the ones on the right? Some key considerations that makes this difficult is the order of these linked records may be random.

[00:41:40] They're not going to be in the same order necessarily as over here. Like over here, virtual reality gaming comes before astrophotography. It's the opposite over here. And then it also must be scalable. I'm going to add like a pen in that comment because it is. I've made array scale, array slice scale, but up to a certain point that I'll talk about [00:42:00] later.

[00:42:01] But in an ideal world, like some of the solutions I'm going to talk about that used to be maybe a solve for this, they're not very easily scalable to hundreds of records. So why is matchmaking like this difficult? If you have like a hundred comma separated values, and I want you to tell me what the 42nd one is using a formula.

[00:42:26] Not a script, just a formula output that's like pretty difficult because maybe if you're trying to use commas to use it to like figure out which one it is, and you're most likely using something like regex or the find formula nested a ton. And. That's like pretty error prone. Cause there could be commas in one of the values that you find.

[00:42:49] So it's not going to be a perfect solution. Now I'm going to show a few examples of community posts that I found from like pre array slice to show like maybe how certain people came up with [00:43:00] similar solutions to this, but just in the past, this one is not using comma. It's not using like a roll up or lookup or even commas as the separator.

[00:43:10] But I just saw this formula, had no idea what, what this part of the formula regex, regex extract meant. So I threw it in here. Justin is watching right now. So, 

[00:43:21] outro: yeah. 

[00:43:22] Ben Green: So this is not also not to hate on the people who did these, this was just pre array slice. And this is like, I don't know how to do this formula.

[00:43:31] Whereas array slice should make something like this easier if it is linked records or lookups that you're dealing with. Another one was this one. I can't remember who I should have screenshot of who exactly wrote this, but this is just another complex find formula. And I think so is the next one. This one is actually using Ellie's if you want to like start nesting, find, find formulas because in the find formula, like the last operator in it, you can [00:44:00] say define a start from position.

[00:44:02] So in theory, back to my like question of return me the 42nd comma separated value. In theory, you could like nest 42 find record formulas together more or less and get close to it, but it's like super clunky in my opinion. 

[00:44:21] Alli Alosa: Yeah, absolutely. So 2019, 2019. 

[00:44:27] Ben Green: Yeah. So, enter the erase slice form and this is just a screenshot from air table so sorry it's blurry it's usually much smaller than this.

[00:44:37] The race slice formula. Is it's used in a roll up field, I think exclusively. So you should be familiar with a roll up field at this point where it references the values of whatever field you're referencing, the key things to know is it has a start front, a start and an end position. So, in using an ArraySlice, if you, if I asked [00:45:00] you to give me the second value in a comp, like in a rollup field, I would use this formula right here, ArraySliceValues, start at position 2, and end at position 2.

[00:45:13] And then for the fourth value, just to show you a pattern, I would start at position 4 and end at position 4.

[00:45:22] So go to the next one. So the new way, how I've been using ArraySlice for matchmaking is using like in a rollup field, you can use a ton of different, you can use the same formula and reference like these array formulas multiple times. You can also reference other fields, like count all 

[00:45:43] outro: with 

[00:45:44] Ben Green: values. You can reference these multiple times.

[00:45:47] So by chaining a lot of these together, and if I go back to this previous slide, And in my example, if I went to reference these two datasets, the key thing, because the orders are not the same [00:46:00] as I want to evaluate each item or each maybe somebody can help me with the proper way to say this, but each item in a comp in the world, each item in the array separately.

[00:46:13] So I went to evaluate the first one, then I went to evaluate the second one. Then I went to evaluate the third one and see if they match the other field. So that's what this is doing. If we look in here just at the first, actually let's look at like the fourth one. So array slice values four comma four, that's going to return the value in the fourth, the fourth item in the array.

[00:46:40] But it's only going to evaluate that if we have at least four items. And then what I'm doing here is I'm trying to find that fourth value in this other field. And if I find it, I return the number one. And if I don't find it, then I return zero and a dating profile. This example is to [00:47:00] show like a compatibility score between two like return it as a percentage.

[00:47:05] So find all of the matches compared to how many possible matches there could be and return that as a percentage. So I think in this example, it's showing two of eight is 25%. So I'm going to go click into the demo of this and you can see examples, but the other concern is scalability because you do have to set a defined limit as far as how many linked records you'll allow the system to evaluate.

[00:47:34] I've, this is, as far as I built the formula up to, this was a while ago, I built it up to 1, 141 linked records and it worked fine. It saved the formula, it evaluated it. I never tested it actually with that many linked records, but I trust that it worked. So it is scalable up through hundreds of linked records and it's, you don't have to worry about like what position the comma is in using [00:48:00] this.

[00:48:00] So I would argue it's more scalable than a bunch of nested find formulas.

[00:48:07] The flaws with this before I dive into the demo is it doesn't account for partial matches. So if I used an example.

[00:48:20] Let's see the top, the one that's coming top of mind is maybe there's like two lists of companies and they're not like super clean companies, but maybe one is Ford and, and the list, you also have Ford motor company. It would find, because you're using the find formula, if it, if you're trying to find Ford in this list, but Ford Motor Company is there, it's going to return like a positive indicator.

[00:48:44] So it doesn't solve for that. The other flaw is you do have to set a defined limit. And then I tested this in a really large base with the 1, 141 linked record option. And there was probably six or seven different [00:49:00] tables where we were using it. And any, we are, the use case was we were trying to see what are the differences in sets of linked records between like a verified data set in Snowflake and like our, we wanted to enable the user to make edits in Airtable and to give a report back to the Snowflake gods of here's the differences.

[00:49:21] And so when we use like 50 plus formulas with a base that had a ton of records. It did slow down performance of the base. So just FYI, if you try to use a lot of these that's another flaw. So I'm happy to go into the demo, but that's, that's my array slice pitch for anybody. All right, let's do it.

[00:49:53] So this is my matchmake, which I actually used air table AI co builder to get me this base and the demo quick shout out for co builder. [00:50:00] 

[00:50:00] outro: Nice. 

[00:50:02] Ben Green: But what I'm doing is, and there needs to be an automation to stamp these values in this field. If you watch the video of me creating this demo, which will be posted on YouTube later, just cause I wanted to make the video about it.

[00:50:15] You can't run it off of the profile one field because all of like this, all of the interest should be pulled from profile one in this example, but the erase, the, the. The array, any of the array formulas consider all of these like one value in the array. So, when you create the matches table, you would have to have an automation like stamp the interest from whenever it was created in here.

[00:50:41] Does that make sense? 

[00:50:45] Alli Alosa: I think, yeah, if you were to, if that were a lookup of the interest from profile one, it's going to be looking that up as one. Array of it's like a sub array. That's yeah. I wonder if it might work if you used array flattened, but [00:51:00] array flattened kind of functions a little strangely sometimes.

[00:51:04] Ben Green: So this is what I create. I think I created this one for up to 10, but it's basically saying, give me the value one, if there are matches. And then some, all of those ones up and divide it by the total number of items in this. Linked record field. So if I looked at this one, if we just pop it open there are five options in this interest from profile one, two of those same options.

[00:51:31] These last two also exist in profile two. And so it's showing two of five is 40 percent in this example.

[00:51:39] Alli Alosa: Very cool. 

[00:51:44] Dan Fellars: Awesome. Good stuff. So that's very helpful to understand a race slice and how you can use it. Let's move on. We've got time here. Okay. Thank you, Ben.

[00:51:58] BUILTONAIR AIRTABLE COMMUNITY - 00:54:17

[00:51:59] [00:52:00] And if you want more insights from amazing people like Ben Alley and myself and many others, thousands of people in the built on air community, join us built on air.

[00:52:09] com slash join. We have an active Slack community, also an amazing newsletter to keep you up to date on everything going on in this world. So join us at built on air. com. And we'd love to meet with you. 

[00:52:23] AUDIENCE QUESTIONS - AIRTABLE DEDUPE - 00:54:42

[00:52:25] Hey, Allie, walk us through de duping and cleaning up. 

[00:52:29] Alli Alosa: All right. Okay. So I had a client ask me last week about this use case, which is very common.

[00:52:42] And if you're using air table a lot, and especially when you're just starting a new Base. Maybe you've inherited a dataset from, I don't know, HubSpot or an old CRM or somewhere where somebody it's [00:53:00] like, let's say you've got a list of companies and. There hasn't been much validation against that list and maybe it's just grown unwieldy over time.

[00:53:08] And so when you grab it and try and put it into Airtable, you might see stuff like this, where we've got, this is all the same company, Borer and Sons. But it's been entered three different ways. We've got bore, ampersand, sons, bore and son without an S on the end, and then bore and sons. with the word and all spelled out.

[00:53:30] So there's all sorts of different examples of why this might happen over time, but how do you go about cleaning this up in an efficient way so that you can have just one version of this company instead of three different versions in your end result. There's so many approaches to this. I'm just going to show kind of how I would approach it.

[00:53:56] Everybody I think has landed on different ways of doing this, [00:54:00] but I'm just going to show what I would recommend to start. The very first thing that I always do when I'm trying to clean up this data is I duplicate this column and make sure I leave on the duplicate cells. toggle because I want to preserve how this data looked when it first came in.

[00:54:25] If you don't do this step, you are very likely going to get frustrated and you know, kind of have to go backwards again to revert to what you, like where you started because of a couple different things. So let's just say I, here, I'm just going to rename this to company backup. Let's say I take this and just edit the field, change it to a linked record field, and create a new table of companies.[00:55:00] 

[00:55:01] Things are going to look really bad. So when I go to my companies table, you can see these have been all changed into linked records. But anywhere where they had a comma, Has split that into multiple records. So now I've got this just ink here instead of strike strike comma ink. It made that on its own record anywhere where there was an LLC.

[00:55:28] Now I've got. This across a couple different records instead of being tied to where it was originally. So that's the first place that you might get really thrown off is anywhere where you have commas, it's going to split that into multiple. Records. And then you're already starting off on a bad note, which is not easy.

[00:55:49] So I'm going to undo that. I just hit control Z or command Z on my keyboard. And instead, and I'm actually going to go [00:56:00] delete this company's table too, because we don't need that. So first thing I do, I duplicate the column. Second thing I do. I'm going to create a formula field, and I'm going to write a substitute function where I'm going to take that company name and just get rid of any commas.

[00:56:23] So I know that I'm not, I don't have to worry about those records getting split up into two different buckets or possibly even three. And now I can take this and link this to a new table of companies. And let's just call this company link.

[00:56:52] So now my problem isn't a hundred percent solved because I still have all these different [00:57:00] versions of each company name. And what you do from here is totally up to you. There's I, I see two. Potential paths. One is you could manually actually just go group this together and see, as I'm going through, I'm like, okay, Bayer Muller in hand, Bayer Muller in hand.

[00:57:25] These are actually the same company. So I can choose which one I want to keep. I can check off the ones in the group that I want to lose. And then I can just grab these and put them into this other bucket. And if I do that all the way down my table, I'm going to end up with a bunch of records on my company's table that are now empty with the people link here.

[00:57:47] And then I can just come here, filter it by that, and delete the extras. So that's one approach. Another approach, though, is to actually use the ddupe extension, [00:58:00] which if you don't have a very large data set, this is actually really, really nice because you can do a couple things. You can say what field you want to define as the place to look for duplicates.

[00:58:16] And this is going to say no duplicates found, but that's because I don't actually have a real duplicates on this table right now because of the way that things are spelled out. But the great things about this de dupe extension are that you can change this to a couple of different levels. I can say, look for similar, and that's going to pick up these two.

[00:58:40] One has a period on the end of ink and the other does not. And then I can also use fuzzy, which is actually going to pick up even more. Doesn't grab all of them, unfortunately, but it's going to get you started in a really strong way which is really nice. So effort, if I hit review nine sets of [00:59:00] duplicates, I can now see I've got these two records, it's going to show me all the field values.

[00:59:08] I can say, I want to keep this one, actually no, let's keep Borer and Sons with an S on the end. We'll say, we're going to use that as our primary record. And then what's really great is you can actually merge the values of these two by just going through the one that you're not keeping and clicking this little plus on each field that you want to merge over.

[00:59:30] And then it'll show you on your merge preview on the right hand side and It's going to keep this one record and it'll keep both of the people that previously were linked to either one now merged into the same linked record field. So, this ddupe extension is really nice for being able to first identify where your duplicates are and actually do the work of merging them in a clean UI.

[00:59:56] And if you have a lot of fields, you can also turn on this hide [01:00:00] identical fields option and it would get rid of all the things that match between the two. So you really are only looking at the differences. One thing I don't understand is that it does actually display formulas in this list too, which really just clogs up the list, and formulas aren't going to be affected by Like there's no, you can't keep a formula on one versus the other, but either way, this makes it a lot easier to find where all your duplicates are.

[01:00:27] So you can do that, or you can actually just scroll through and say, I want to keep that group and kind of manually decide where everything should live. I could keep going, but we're almost out of time and 

[01:00:42] Dan Fellars: that's a 

[01:00:42] Alli Alosa: couple of different approaches. 

[01:00:44] Dan Fellars: That's awesome. Yeah. Very useful. Yeah. You can see, though, if you have a ton of data, that would take a long time to go through.

[01:00:53] But but you're gonna have to do that anyways to clean up unless you have another 

[01:00:57] Alli Alosa: way to 

[01:00:58] Dan Fellars: group them. [01:01:00] Awesome. Thank you Ali for showing that and thank you all for joining. We'd love to see you back next week for another episode. Ben, thanks again for joining us and we'll get you back on. In the future.

[01:01:13] So with that, we'll see everybody next week. Take care. 

[01:01:17] Thank 

[01:01:17] you.

[01:01:21] And he's gone.

[01:01:24] OUTRO - 01:03:58

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