![[S09-E03] Full Podcast Summary for 09-28-2021](https://www.builtonair.com/wp/../uploads/segment_image_1-37.png)
9/28/2021 – BuiltOnAir Live Podcast Full Show – S09-E03
Duration: 59 minutes
Be Sure to Subscribe to the podcast!
To get all the latest videos and demonstrations from the BuiltOnAir Podcast, subscribe and get notified on our Youtube channel here and our newsletter/community here.
FULL EPISODE VIDEO
Watch the full video of the show. See below for segment details.
The BuiltOnAir Podcast is Sponsored by On2Air – Integrations and App extensions to run your business operations in Airtable.
In This Episode
Welcome to the BuiltOnAir Podcast, the live show. The BuiltOnAir Podcast is a live weekly show highlighting everything happening in the Airtable world.
Check us out at BuiltOnAir.com. Join our community, join our Slack Channel, and meet your fellow Airtable fans.
Todays Hosts
Kamille Parks – I am an Airtable Community Forums Leader and the developer behind the custom Airtable app “Scheduler”, one of the winning projects in the Airtable Custom Blocks Contest now widely available on the Marketplace. I focus on building simple scripts, automations, and custom apps for Airtable that streamline data entry and everyday workflows.
Dan Fellars – I am the Founder of Openside, On2Air, and BuiltOnAir. I love automation and software. When not coding the next feature of On2Air, I love spending time with my wife and kids and golfing.
Show Segments
Round The Bases – 00:03:08 –
Following Articles Used in this Segment:
[Reddit] (1) A mess of charges : Airtable
[Reddit] (1) I built a tool to send Tweets from Airtable automatically : Airtable
[Twitter] (20) Ankit Gordhandas on Twitter: "@ChrisJBakke 8 Figure revenue: Airtable" / Twitter
[BuiltOnAir Community] Slack | airtable-help | BuiltOnAir
Meet the Experts – 00:33:47 –
Meet Kuovonne Vorderbruggen.
I’m an Airtable enthusiast with experience in both relational database designs and writing computer scripts. I have built databases and written scripts for small businesses, large companies, non-profits, hobbyists, solopreneurs, start-ups, and even other Airtable consultants. Clean design and custom code can take your Airtable base to the next level.
An App a Day – 00:38:21 –
Watch as we install, explore, and showcase the Ready Made Formulas App from the Airtable Marketplace. The app is described as “This app includes over a dozen "ready-to-use" formulas for common tasks such as
· formatting numbers and dates as text strings to include in reports
· generating urls for prefilled forms and prefiltered shared views
· extracting attachment filenames and urls
· manipulating dates
· consolidating data from multiple fields into JSON format ”.
Automate Create – 00:56:58 –
Watch as we review and work through automations. This is a quick and easy way to collect user/customer feedback with just Airtable
Full Segment Details
Segment: Round The Bases
Start Time: 00:03:08
Roundup of what’s happening in the Airtable communities – Airtable, BuiltOnAir, Reddit, Facebook, YouTube, and Twitter.
Following Articles Used in this Segment:
[Reddit] (1) A mess of charges : Airtable
[Reddit] (1) I built a tool to send Tweets from Airtable automatically : Airtable
[Twitter] (20) Ankit Gordhandas on Twitter: "@ChrisJBakke 8 Figure revenue: Airtable" / Twitter
[BuiltOnAir Community] Slack | airtable-help | BuiltOnAir
Segment: Meet the Experts
Start Time: 00:33:47
Kuovonne Vorderbruggen – I'm an Airtable enthusiast with experience in both relational database designs and writing computer scripts
Meet Kuovonne Vorderbruggen.
I’m an Airtable enthusiast with experience in both relational database designs and writing computer scripts. I have built databases and written scripts for small businesses, large companies, non-profits, hobbyists, solopreneurs, start-ups, and even other Airtable consultants. Clean design and custom code can take your Airtable base to the next level.
Segment: An App a Day
Start Time: 00:38:21
Airtable App Showcase – Ready Made Formulas – This app includes over a dozen "ready-to-use" formulas for common tasks such as
· formatting numbers and dates as text strings to include in reports
· generating urls for prefilled forms and prefiltered shared views
· extracting attachment filenames and urls
· manipulating dates
· consolidating data from multiple fields into JSON format
Watch as we install, explore, and showcase the Ready Made Formulas App from the Airtable Marketplace. The app is described as “This app includes over a dozen "ready-to-use" formulas for common tasks such as
· formatting numbers and dates as text strings to include in reports
· generating urls for prefilled forms and prefiltered shared views
· extracting attachment filenames and urls
· manipulating dates
· consolidating data from multiple fields into JSON format ”.
Segment: Automate Create
Start Time: 00:56:58
Airtable Automations – Creating a Customer Feedback Management Site
Watch as we review and work through automations. This is a quick and easy way to collect user/customer feedback with just Airtable
Full Transcription
The full transcription for the show can be found here:
[00:01:42] Welcome everybody [00:01:43] to the BuiltOnAir podcast. [00:01:45] This is season nine, [00:01:46] episode three [00:01:47] and we're coming at you live [00:01:50] with myself Dan Fellars, [00:01:52] we've got Kamille back again. [00:01:54] Hello Kamille. [00:01:55] And we have a new face with us Kuovonne. [00:01:58] Welcome. Good to see you. [00:02:00] So, hopefully Kuovonne's name [00:02:03] is familiar to everybody, [00:02:05] it's very commonly seen [00:02:06] in Airtable community [00:02:08] and we will get to know Kuovonne [00:02:10] in a later segment. We'll get to know her. [00:02:13] So, but we're glad that she [00:02:15] could join us for today's episode. [00:02:17] Alli is not with us again, [00:02:19] but hopefully next week [00:02:21] we'll see Alli again and [00:02:23] hear all about her wedding. [00:02:25] So with that, as always, [00:02:27] the BuiltOnAir podcast [00:02:29] is an hourly live show where [00:02:30] we meet and talk about [00:02:32] four different segments [00:02:34] that can help us be better [00:02:36] with our Airtable usage [00:02:39] and we do that each Tuesday [00:02:41] at 11 a.m. Eastern. [00:02:43] So, we're [00:02:44] hope that you can join us [00:02:46] live next time if you're watching [00:02:47] over the broadcast. [00:02:49] So, we always begin with our [00:02:51] first segment and that is Round [00:02:53] the Bases, where we go through [00:02:55] the different Airtable communities. [00:02:57] Talk about what's going on, [00:02:59] highlight a couple of [00:03:01] questions or topics that are [00:03:02] of interest. [00:03:03] So, we always start with [00:03:05] the Airtable community [00:03:07] and here's one that I [00:03:09] thought was interesting [00:03:11] and talking about the [00:03:16] if you're using that API [00:03:18] one of the challenges is [00:03:20] escAPIng characters in [00:03:21] your formulas. [00:03:23] And so, somebody brought [00:03:25] this up a while ago. I didn't even [00:03:27] realize Kuovonne, [00:03:28] you're on this thread. [00:03:29] So, you might be familiar with this one if [00:03:30] you can jog your memory, but [00:03:33] more recently it came back up [00:03:36] as somebody brought up [00:03:38] I think they were consolidating [00:03:41] and had different ideas Kuovonne any any, [00:03:43] do you remember this thread [00:03:45] and kind of want to summarize it? [00:03:47] Yeah, so the main thing is [00:03:50] and I think it's based [00:03:52] on using filter by formula [00:03:54] where you're using the rest API [00:03:55] so, first of all, [00:03:56] if you're using something [00:03:58] outside of Airtable and you're [00:03:59] using the API to get [00:04:01] to Airtable as opposed [00:04:02] to [00:04:03] something within like a script [00:04:04] or anything like that. [00:04:05] And the idea is if you [00:04:06] want to filter by formula, [00:04:08] you actually have to [00:04:09] create an Airtable formula. [00:04:10] And that Airtable formula [00:04:12] has to follow all of the [00:04:14] rules for regular Airtable [00:04:16] formulas. And so, you have to [00:04:17] have all of the syntax and all of that. [00:04:19] And if you want to do something like [00:04:23] search for text that has a [00:04:24] new line character or with [00:04:26] quotes or things like that, [00:04:27] you have to make sure that [00:04:29] the formula that you build [00:04:31] would have all of those [00:04:32] characters escaped properly [00:04:34] in the Airtable formula [00:04:36] once it was an actual [00:04:38] Airtable formula. So, [00:04:40] in general the main thing is [00:04:42] when you're writing a formula, [00:04:44] you have to put in [00:04:44] like literal values inside quote. [00:04:46] So, if you have quotes [00:04:48] inside your quote of the [00:04:49] string that you want to, [00:04:50] you have to escape them [00:04:51] and then if you have any other [00:04:53] strings that would not be [00:04:55] just a regular character such [00:04:56] as the new line character [00:04:58] or a tab or anything [00:04:58] like that. Those also have to be escaped. [00:05:01] The main ones really are [00:05:03] quotes because those [00:05:04] are what's most common [00:05:06] in an Airtable formula. [00:05:07] But if you have any other [00:05:09] unusual characters sometimes [00:05:11] that you have to escape those as well [00:05:14] the main trick with that is that [00:05:16] you have to escape it for the formula. [00:05:18] But then when you are writing your code [00:05:20] you might actually have to escape [00:05:22] that because of course you're using the [00:05:24] backslash character [00:05:25] so, you have to escape it for the formula. [00:05:28] And then when you're building [00:05:29] the formula in your code [00:05:30] to build up the string to [00:05:31] create the formula you [00:05:32] have to escape that again. [00:05:35] Does that make sense? [00:05:37] Yeah. And how you escape it [00:05:39] of course going to depend on how [00:05:41] you're writing your code. [00:05:42] Are you are you using single [00:05:44] quotes versus double [00:05:45] quotes? Are using back ticks [00:05:47] instead of what language are you using? [00:05:50] Yeah. Yeah and if you're familiar [00:05:53] with general database usually this is also [00:05:56] common [00:05:57] in just general database usage. [00:06:00] And usually most database [00:06:02] rappers have kind of [00:06:04] an escape [00:06:05] functionality that allows you [00:06:07] to overcome this pretty easily. [00:06:09] But [00:06:10] Airtable's API, it's still [00:06:14] young and so that functionality [00:06:16] isn't quite there yet [00:06:18] so, you kind of have to do [00:06:19] that yourself. [00:06:21] So, yeah. So, useful [00:06:23] if you're running into API [00:06:26] issues and the formula doesn't [00:06:28] seem to be working, [00:06:29] this might be a thread to [00:06:31] check out to look for answers. [00:06:33] Yeah. The main thing is [00:06:36] always build your [00:06:37] formula in the Airtable user [00:06:39] interface itself because [00:06:41] it's got all kinds of weird quirks [00:06:44] and then work backwards [00:06:46] from that formula to how [00:06:47] you're going to create it in [00:06:48] code. [00:06:49] Yep. Yep. [00:06:52] Very good. So good, good resource. [00:06:54] I have seen this where and it doesn't [00:06:57] always the API Air I don't think [00:07:00] you know is very useful in trying to [00:07:03] figure out, it just tells you [00:07:06] that it's an invalid formula. And so, it's [00:07:09] it's tough to figure out exactly [00:07:11] what's going on if you're not familiar. [00:07:12] So [00:07:13] good resource to check out there. [00:07:16] Okay. Next one. [00:07:17] This one I thought was interesting. [00:07:20] It actually is an old post. [00:07:22] I always like to see old posts [00:07:24] from a couple of years ago, [00:07:26] this one's from [00:07:27] 2018, so many years ago, [00:07:30] and they're asking about [00:07:32] the ability to have [00:07:34] comments [00:07:36] on a per cell basis, per record basis [00:07:41] and I thought was interesting. [00:07:43] Somebody else brought [00:07:44] it back up again [00:07:45] and [00:07:48] so just lots of demand [00:07:49] for this over the years. [00:07:51] It hasn't really been something [00:07:53] that [00:07:54] that I don't think they've addressed [00:07:56] any thoughts on, do you think [00:07:57] Airtable would ever implement [00:07:59] something like this? [00:08:02] I don't know [00:08:03] I don't think it's likely. [00:08:06] I feel like commenting on records is a [00:08:09] it is a feature provided in [00:08:12] Airtable, but it's not a [00:08:16] this I don't know [00:08:17] it's very at the basic level [00:08:20] and I don't know if we've [00:08:21] seen really enhancements [00:08:23] to commenting at all in the [00:08:25] past few years apart from [00:08:27] being able to comment directly [00:08:29] on individual attachments. [00:08:31] So, that's kind of like [00:08:33] they've skipped a step in [00:08:34] between where you can [00:08:36] comment on the whole record and [00:08:37] then as opposed to commenting [00:08:39] on the whole attachment field [00:08:40] you can comment on [00:08:41] individual attachments, [00:08:42] at the field as a whole. [00:08:44] So, in between there's [00:08:46] cell based or individual record [00:08:49] value commenting [00:08:50] that isn't quite there yet. [00:08:52] And I don't, [00:08:54] know if they care enough [00:08:56] about this particular segment [00:08:59] of their product. [00:09:00] The way I feel that is people [00:09:03] who want comments or an [00:09:04] individual cell that are almost [00:09:06] always coming from a [00:09:07] spreadsheet point of view [00:09:08] because they're used to [00:09:09] being able to do that [00:09:10] in the spreadsheet. [00:09:12] And it makes a lot of sense [00:09:13] in the spreadsheet because in a [00:09:14] spreadsheet every cell could [00:09:16] be something different [00:09:18] or doing something unique [00:09:19] but that's not the case [00:09:21] when you try and go with [00:09:23] a database mindset. [00:09:25] So in a database mindset [00:09:27] it's here is a particular [00:09:29] field for a particular [00:09:31] type of value and if you [00:09:32] want to have a comment on that [00:09:35] it just doesn't quite make [00:09:36] as much sense for that. [00:09:38] There should be more of a [00:09:39] where they already provide [00:09:40] record level commenting [00:09:41] or if you want to have a [00:09:42] whole another field that says [00:09:44] whatever special notes or details on it. [00:09:47] Yeah. Yeah you can just yeah [00:09:49] exactly just have another [00:09:51] field for your for your [00:09:52] comments or whatnot. [00:09:53] So, yeah that's interesting. [00:09:55] That's a good point. [00:09:56] I also thought of you could [00:09:58] easily build either a script [00:10:00] or an app that [00:10:01] you know you can store [00:10:03] your comments in like a long [00:10:06] text field or something and [00:10:08] then map them to a field. [00:10:10] Maybe the comments [00:10:11] are stored as like JSON [00:10:12] and you had like a script [00:10:14] that easily like matched it [00:10:16] to the field that you [00:10:17] wanted to comment on or something. [00:10:19] Well I think part of it is that this is [00:10:21] getting back to a database [00:10:23] point of view is in a [00:10:25] database you want to have [00:10:26] each cell is the most granular [00:10:28] level of information. As soon as you start [00:10:30] talking about [00:10:32] adding a comment to it [00:10:33] is suddenly you're trying to [00:10:35] store two things of data in [00:10:36] one cell rather than [00:10:37] storing just one unique [00:10:39] thing of data in there. [00:10:41] Yeah. Yeah. [00:10:44] Yeah. Or, [00:10:45] Brian mentioned you could [00:10:47] potentially do a look up [00:10:49] on another table that's [00:10:51] linked to that field or something. [00:10:54] Yeah. Yeah I mean if you [00:10:56] want a comment or [00:10:57] just notes on the field as a whole [00:11:00] you can also do the [00:11:01] field description on that. [00:11:04] So that's useful. [00:11:06] For example if someone saying, [00:11:08] okay, what's the format of the [00:11:09] value that you're supposed [00:11:11] to be getting? [00:11:12] Or where are you getting it from? [00:11:13] Or don't touch that. [00:11:14] But that's not so much [00:11:16] on the specific cell level. [00:11:18] Yeah, It would be like [00:11:20] use this field to store when [00:11:23] people's licenses expire and [00:11:25] not [00:11:26] why has Jim's license expired? [00:11:29] Yeah. [00:11:30] Yeah. Very good. [00:11:32] All right. So, those are some ideas. [00:11:34] If you're looking for cell [00:11:35] level commenting, [00:11:37] there are definitely some [00:11:38] workarounds that and and I think [00:11:40] like Kuovonne said, [00:11:42] if you have that database mentality, [00:11:44] it might not might not be [00:11:45] appropriate to think that way. So, [00:11:48] All right. I'm gonna do an audible here. [00:11:50] We got a question from Rebecca. Welcome, [00:11:53] Rebecca. Asking if anyone's [00:11:55] seen the new timeline view. [00:11:58] No, I have not. [00:11:59] So let's see, [00:12:00] I've got a brand new view [00:12:02] or a table that I created, there it is. [00:12:06] Look, there's a timeline right there. [00:12:08] So, you can now add [00:12:10] so, they have it at the top level [00:12:18] And so now you can get a [00:12:21] timeline as kind of a first level view. [00:12:24] So that's cool. [00:12:26] Customize labels, hold on. [00:12:28] You know what? Hold on, [00:12:30] hold on, hold on, hold on, [00:12:32] hold on, hold on, go back to [00:12:33] what the heck? [00:12:36] Or, do I go back to there? [00:12:39] Customized labels up at the top. [00:12:42] It's where customized [00:12:44] cards heard the gallery. [00:12:47] So, I see bold italics underline. [00:12:50] And also it looks like [00:12:52] you can build a multi. [00:12:54] Please put in some dates, [00:12:55] records, so I can see what this [00:12:57] is and marvel at it. [00:13:20] There's one, [00:13:25] wow, I'm wondering when was this released? [00:13:28] Today? Must be today. [00:13:34] So, they had this timeline, [00:13:36] didn't they have this as an app before? [00:13:38] Yes. So, similar to the Gant app, [00:13:42] which is now a view, [00:13:44] there was a timeline app that [00:13:46] is apparently now a view [00:13:51] there's a can't close this guy. [00:13:55] Thinking. [00:13:58] So, timeline might still be buggy. [00:14:03] Or, that's probably why Airtable [00:14:05] went down yesterday. Yeah, [00:14:07] anytime something big [00:14:09] happens like within the last 30 minutes, [00:14:12] Rebecca says. So, [00:14:15] yeah. So, typically [00:14:17] when they release something, it's like a, [00:14:22] it comes in waves. [00:14:23] So, some people get it first [00:14:25] and then over the course of the [00:14:27] day or the following day, [00:14:29] more people will get it. [00:14:31] and sometimes Airtable [00:14:33] slows down a little bit [00:14:34] or has a brief outage. [00:14:36] When a new features released. [00:14:38] I'm looking at the record there, test [00:14:40] one dash empty dash empty. [00:14:42] I think those are the [00:14:43] two extra fields you said to [00:14:45] apply to the label. [00:14:46] Oh my God, can you please, [00:14:48] can you go to calendar now? [00:14:50] I know we want to show off timeline. [00:14:52] Can you do that for a calendar field too? [00:14:55] I wonder? [00:14:58] Is that a thing? [00:15:00] No, I guess you have less [00:15:03] real estate but they should add that [00:15:07] to the calendar view. [00:15:10] Yeah. [00:15:13] Yeah, [00:15:14] request. I know. I've heard [00:15:17] that from many people. [00:15:18] Yeah. They don't have a customize [00:15:21] well maybe, maybe some day. [00:15:26] Look at this. Oh, create a new one. [00:15:29] You made a new one. [00:15:31] So, let's hold it. [00:15:34] That's such a good. [00:15:38] So, it's even on here. Yeah, [00:15:42] I guess it's [00:15:46] Look at that. [00:15:48] Very nice. [00:15:51] Cool. All right. Thank you Rebecca [00:15:54] for that suggestion to check out. [00:15:56] Maybe we'll do a deep [00:15:58] dive in a future segment [00:16:00] On that one. Alright let's keep going. [00:16:04] Okay so last week [00:16:05] we talked about the new scripting [00:16:08] API call to select just a [00:16:09] single record. This week [00:16:11] there was more discussion on it [00:16:14] coming from Bill asking the question of [00:16:19] what approach do they take [00:16:21] under the hood, or is this just a shortcut [00:16:24] to do a loop? [00:16:25] Or, does it have some kind of hashing [00:16:28] to where it will just query [00:16:29] that one which would obviously [00:16:31] be much faster. [00:16:33] So, he was asking under the hood, [00:16:35] is this just a [00:16:37] shortcut to perform that loop [00:16:39] to find the record you're looking for? [00:16:41] And it was good that we [00:16:43] actually got an answer from Airtable. [00:16:45] We don't always get that. [00:16:46] But they actually gave a [00:16:48] good answer basically [00:16:49] saying in automations, it will only [00:16:52] load the specific records [00:16:54] that are specified. [00:16:56] But in the scripting app [00:16:57] it just does the filtering. [00:16:59] So, my thinking is obviously [00:17:01] within scripting at that happens [00:17:04] within your browser [00:17:05] and all the data is already [00:17:07] downloaded from your table, [00:17:09] so the data is already [00:17:10] there so it's already looping. [00:17:12] Whereas automations [00:17:14] happens in the server doesn't [00:17:15] have everything in memory [00:17:18] and so, it can, it does perform [00:17:20] that specific one. [00:17:22] But notice that he also [00:17:24] kept it open saying that [00:17:26] the primary reason for in [00:17:28] scripting right now is [00:17:30] so that you can have compatibility [00:17:32] so you can develop [00:17:33] your script in scripting [00:17:35] app and then easily port it over. [00:17:37] However, the other thing [00:17:39] that's nice about it is it [00:17:40] sounds like they're keeping [00:17:41] that open for the possibility [00:17:43] to add enhancements later on. [00:17:46] So, I say start using [00:17:47] it right away and eventually [00:17:49] when they do add you know [00:17:51] maybe other indexing or [00:17:53] whatever underneath the hood [00:17:54] to take advantage of it, [00:17:56] it'll be right there. [00:17:57] Yep. Yep. [00:17:59] Very true. [00:18:00] So, and the other thing is [00:18:02] with limitations on the [00:18:04] scripting or excuse me, [00:18:05] automations has limitations on [00:18:08] memory usage and time [00:18:10] that it can execute that the [00:18:12] scripting app doesn't have. [00:18:14] And so, it's more needed [00:18:16] within the automations [00:18:17] environment, [00:18:19] I'm going on there. [00:18:21] So, good thread, [00:18:22] it looks like Kuovonne, [00:18:23] you were also involved [00:18:24] in this one. [00:18:25] And so, Bill was being accused [00:18:29] of being prophetic or near prophetic. [00:18:33] And so, that was good. [00:18:34] I thought that was a [00:18:36] good discussion if you're if [00:18:37] you're interested in [00:18:39] what's going on behind the scenes [00:18:41] underneath the hood. [00:18:45] Sometimes Bill and I have [00:18:48] side conversations on these threads. [00:18:52] Yeah, I always like to see that. [00:18:55] Okay, so every what do [00:18:57] you think Kamille? Every [00:18:59] three months we need to [00:19:01] bring up one of these [00:19:02] that talks about the billing and [00:19:04] how billing works within Airtable. [00:19:07] So, there's our quarterly reminder [00:19:10] this poor person three days ago, [00:19:13] I don't know [00:19:14] you know, their situation, but try [00:19:17] 0 was moving accounts from 517 00:17:39.1000 --> 00:17:41.480 a free to a paid and [00:19:21] didn't understand how the [00:19:23] billing works on paid work spaces, [00:19:26] paid, you know, bases [00:19:28] and sharing and adding users [00:19:31] and unfortunately got a bill [00:19:33] for, [00:19:34] I think that you mentioned in [00:19:37] another, $900 in charges that they weren't [00:19:41] expecting, [00:19:43] I think yeah, I saw this one [00:19:47] before and I think what happened [00:19:50] was that their their page wasn't [00:19:55] it didn't [00:19:58] Provide any sort of like visual [00:20:00] that oh the thing went through. [00:20:02] So, it like charged, and charged, [00:20:03] and charged, and charged, [00:20:04] and charged. And that's why it was [00:20:05] 900 versus you know 240, [00:20:07] whatever it would be if it was just two [00:20:10] collaborators. Rebecca just said that [00:20:12] something similar happened to her and [00:20:15] they fixed it immediately. [00:20:16] I can concur. I have an obscene [00:20:19] amount of Airtable credits on my account. [00:20:22] So, for the next 25 years, [00:20:23] I'm you know, [00:20:25] I'm flying free. [00:20:26] However, every now and again [00:20:28] I forget to apply my credits to [00:20:30] the appropriate pro workspace [00:20:33] and so I'll be charged for it [00:20:35] every single time [00:20:36] that's happened, I've just contacted [00:20:38] support and said, hey, can you roll back [00:20:39] that charge [00:20:40] so I can apply my credits? [00:20:42] And then you know, [00:20:43] take care of it. [00:20:44] And it's usually solved [00:20:46] in a couple of hours as opposed [00:20:49] to any other type of [00:20:50] interaction with Airtable [00:20:52] support. Which is very, [00:20:53] you know, depending on what your topic is, [00:20:56] it might take you days [00:20:58] to get a response. Billing, [00:21:00] I've literally never had a [00:21:01] problem. [00:21:03] Yeah. Yeah. I'm sure they worked [00:21:05] with this person as well [00:21:07] to get it squared away. [00:21:08] So, but it always is frustrating [00:21:11] to see those charges going through. [00:21:14] So, just be aware of [00:21:16] there's pricing at the workspace [00:21:19] level or if you share an [00:21:21] individual base that still [00:21:23] goes into the pricing model [00:21:25] if it's anything other [00:21:26] than a read only user. [00:21:28] So, just be [00:21:29] cognizant of that when you're [00:21:31] sharing your base or workspace. [00:21:34] Yeah. So along those lines, [00:21:37] I said one thing is contact [00:21:40] support directly and [00:21:42] they're usually very very helpful. [00:21:44] You just explain the situation. As far as [00:21:47] posting that on community [00:21:48] forums or on Reddit, the thing is [00:21:50] the only people that [00:21:51] can actually fix that [00:21:52] is Airtable itself. So [00:21:54] it doesn't help a lot complaining [00:21:56] elsewhere, just go straight to Airtable [00:21:58] explain what happened. [00:22:00] They understand these mistakes [00:22:01] and then they'll fix it. [00:22:02] And the other thing is [00:22:05] which is really useful on the [00:22:08] pro or enterprise plan [00:22:09] is you can actually set it up [00:22:11] now so that you can [00:22:12] restrict adding new users. [00:22:14] So, you won't get that surprise charge [00:22:17] when [00:22:17] someone doesn't realize [00:22:19] that adding someone else [00:22:20] giving them the same editor [00:22:21] privileges that they have [00:22:23] will suddenly cost a lot of money. [00:22:25] Yeah. And that's if somebody else does it. [00:22:28] But someone else, [00:22:28] you know, but Kamille, [00:22:30] I'm in a similar situation, [00:22:32] I don't have nearly as many [00:22:34] credits as you do, [00:22:35] but I do have some credits [00:22:37] and I try and reapply them and, [00:22:40] every now and then I have a [00:22:42] some of my other family members [00:22:44] where I go and I give them credits. [00:22:45] And the other thing that's really nice [00:22:48] is if I add myself as an owner and then I [00:22:50] go in and transfer the credits [00:22:52] and then I removed myself [00:22:54] all within like a [00:22:54] minute or two. [00:22:55] They're actually ends up [00:22:57] being no charge for me being [00:22:59] of the other workspace [00:23:00] for that brief period of time. [00:23:02] Yeah, that's the other [00:23:03] thing. Airtable is fairly good at [00:23:05] recognizing if a collaborator [00:23:07] is only there [00:23:08] for like 10 minutes. [00:23:10] For instance, if you're a developer [00:23:12] and you made a custom app for somebody, [00:23:14] and you just want to install it [00:23:16] in their base and then leave. [00:23:18] Usually you're fine. [00:23:19] Yeah. [00:23:22] All right, very good. [00:23:23] Good warning. I'm sure we'll bring [00:23:25] it up again in a few [00:23:26] months. Okay this is another [00:23:29] one on Reddit. [00:23:30] A product launch that I thought was [00:23:32] interesting, [00:23:35] so basically this product is [00:23:37] a way to to automate sending [00:23:40] out tweets from your [00:23:41] Airtable base [00:23:43] I think it's cool. [00:23:44] I think you could do more. [00:23:46] I was going to bring up you could [00:23:48] probably build this directly [00:23:50] within Airtable using their automation. [00:23:53] Actually, I know you can, [00:23:55] I've done it. [00:23:56] But I'm sure a dedicated product that can [00:23:59] add more functionality. [00:24:00] But now with Airtable's automations [00:24:03] they already have [00:24:03] built in integration to Twitter [00:24:06] where you can send out a [00:24:08] tweet or to hoot suite [00:24:10] which is what I use [00:24:12] for twitter integration. [00:24:14] They have both those built into [00:24:16] the automation so, [00:24:17] but if you want more advanced [00:24:19] functionality within there this [00:24:21] might be a cool product [00:24:23] to check out loop back dot com. So [00:24:27] check that out. [00:24:29] Okay next one. [00:24:30] This one comes from the BuiltOnAir [00:24:33] community and so, this was [00:24:35] somebody actually I think I posted [00:24:37] talking about the ability [00:24:39] to share apps and [00:24:40] because I saw somebody else [00:24:42] sharing an app on their website [00:24:44] and I said hold on, I [00:24:45] didn't think you could do that. [00:24:47] And so then I looked [00:24:48] in my base and sure enough [00:24:50] they added you can see here they [00:24:52] added [00:24:53] the ability to share an app [00:24:57] and as well as if you go [00:25:00] to the share based menu [00:25:02] you can actually share your [00:25:05] data with your apps included. [00:25:08] So, there's two ways you can do it, [00:25:11] one is share just an individual app [00:25:14] and the experience [00:25:15] is a little bit different [00:25:17] depending on how you do this or [00:25:18] you share the base [00:25:20] with all of the apps accessible [00:25:22] but unfortunately it's not [00:25:25] available to everybody [00:25:27] and so, like Kuovonne mentioned [00:25:29] maybe it's just the people [00:25:31] that signed up for the [00:25:32] beta because there was a beta [00:25:34] a year or two ago that [00:25:36] allowed for this and [00:25:38] then it stopped working, [00:25:39] they took away that functionality [00:25:41] so, they might have [00:25:41] just brought it back for the people [00:25:44] who signed up for that original beta. [00:25:46] Yeah, still unclear on [00:25:48] on who has access to this. [00:25:51] There is a support article about app [00:25:55] sharing for Airtable [00:25:57] and it references that it is a beta [00:26:00] I don't remember [00:26:01] if there's a link in that article [00:26:04] to join the beta if you're not already a [00:26:07] part of it, but I got a [00:26:11] a support request for one of my apps [00:26:13] asking is it possible to [00:26:15] embed it somewhere [00:26:16] else? And I linked them [00:26:18] to that article saying yes, [00:26:19] technically if you're one of [00:26:21] the select people who have [00:26:23] this added to their accounts. [00:26:27] Yeah, so this is where, [00:26:30] yeah, so when you share [00:26:31] a base link, [00:26:32] there will be this option to share, [00:26:34] show apps added to the space, [00:26:37] so you can do that. [00:26:38] Now. One thing, one thing [00:26:40] that is definitely worth [00:26:41] mentioning is [00:26:44] if you're sharing an app [00:26:46] at first [00:26:48] there's probably, [00:26:49] I don't have an app in this base, [00:26:51] but it will take you directly [00:26:52] to that app and you don't [00:26:54] realize that there's always a button, [00:26:57] it will be right here where [00:27:00] this copy base is [00:27:01] but it will say view data [00:27:03] and and then it will bring you [00:27:06] to this data view. So, the data is always [00:27:09] visible when you share a base. [00:27:11] So, just be aware of that, [00:27:13] that if you start [00:27:14] sharing an app they'll have, [00:27:16] they'll be able to access the base data. [00:27:19] Yeah. And it's not just the [00:27:21] data associated with that app. [00:27:23] Airtable doesn't [00:27:24] make any distinction between [00:27:27] if you have a chart app [00:27:28] linked to your table one, [00:27:30] if you have tables 2,3,4 and 5 [00:27:32] then you're going to have, [00:27:34] it's going to show [00:27:35] all of the data for all five tables. [00:27:38] Yeah. [00:27:39] Yeah. Rebecca mentioned she's [00:27:41] had it the whole time [00:27:42] and so, maybe I could be [00:27:43] confusing that they took [00:27:45] it away because, [00:27:46] but I'm pretty sure I had it and [00:27:48] then I stopped having access to it, [00:27:51] but maybe I was looking [00:27:52] in a free base when [00:27:53] when I realized it got taken [00:27:55] away or something. So, I could be wrong. [00:27:57] Maybe it's been there the whole time. [00:28:01] What's interesting is if you [00:28:03] look on that support website [00:28:05] it says that the [00:28:06] beta is no longer an active [00:28:08] development but is still available [00:28:10] upon request. [00:28:11] Interesting. That's where, yeah. [00:28:14] Maybe and I thought that [00:28:15] they had taken it away [00:28:17] but [00:28:17] maybe they kept it up. [00:28:19] Maybe if you were using it. [00:28:20] I don't know if I was ever [00:28:21] actually using it. [00:28:24] All right, next one let's move on. [00:28:29] Okay this was, this was from Twitter. [00:28:31] I thought this was interesting. [00:28:33] Either of you familiar with what [00:28:35] he's talking about here? So, he's talking [00:28:37] about how he can see [00:28:39] emails for people. [00:28:43] I don't know if I want to, [00:28:45] people may not, [00:28:46] I don't know if Airtable is aware [00:28:48] of this but it's out there. [00:28:51] So, if you share [00:28:54] a base, so there's like a lot of bases [00:28:56] out there that people say, [00:28:57] hey here's a cool base that I built, [00:29:01] I'll share it with you, [00:29:03] give me your email [00:29:04] and I'll share it with you. [00:29:05] Well everybody that they've [00:29:06] shared it with, [00:29:08] if you go into the share feature, [00:29:10] you'll be able to see all of [00:29:12] their emails [00:29:13] of everybody else that [00:29:15] has been shared with. [00:29:16] So, I've noticed that, that I've seen, [00:29:19] I've been added to a couple of [00:29:21] just comment shared free bases [00:29:23] that have like a database of [00:29:26] you know or a template or something [00:29:28] and you go in and you're like oh there's a [00:29:30] lot of emails in here [00:29:32] of other people that have [00:29:33] access to this base. [00:29:34] So, he's calling that out. [00:29:36] So, that might be something [00:29:38] that Airtable wants to [00:29:39] address. [00:29:43] Yeah, I think that's the way [00:29:44] it's always been there [00:29:45] where you go in and you look [00:29:46] in the shares and you can [00:29:47] see all the other collaborators [00:29:49] and you can actually [00:29:50] see also what's [00:29:51] their permission levels. [00:29:53] So, you can see who has read only versus [00:29:55] who has edit or create. [00:29:58] Yeah. Yeah. [00:30:01] All right, next one. [00:30:02] Okay. Question for you two, [00:30:04] anybody else call when you [00:30:07] share a table, A share table? [00:30:08] I'll send you a share table. [00:30:10] No, because I'm sure [00:30:12] that's either already another [00:30:15] product or soon will be. [00:30:19] And somebody responded, [00:30:22] please don't. Too late. [00:30:25] I'm with him. Yeah, [00:30:26] I don't know, I haven't heard that, [00:30:28] I haven't seen anybody use that on any of [00:30:30] the communities, but we'll see [00:30:33] if that sticks or not. Well, [00:30:35] Chris Dancy has, [00:30:37] I'm going to forget what [00:30:39] each of them are, [00:30:40] but he has like a series of tools [00:30:42] that he created for other people [00:30:44] that follow that same sort of [00:30:47] pattern. So, it's like care table [00:30:50] and flare table, [00:30:51] and there's two more and I [00:30:53] don't think share table is one of them. [00:30:55] So, at some point [00:30:56] you're going to hit one [00:30:57] that exists. [00:31:01] Yeah. [00:31:05] Yep. [00:31:07] There you go. Nice Brian. [00:31:10] Okay, next one, last one. [00:31:12] This is our last one, then we'll move on. [00:31:15] This was I thought was interesting. [00:31:17] I need to scroll up here. [00:31:19] So, somebody this Chris [00:31:21] who is the founder of a [00:31:23] company called Lasky [00:31:25] talked about how they built [00:31:27] their back end all the way [00:31:29] up until they were doing [00:31:30] seven figure in revenue. [00:31:32] They were, they were using [00:31:33] notion as the back end of [00:31:34] their product [00:31:36] and [00:31:37] says he has a company [00:31:41] looks like intersect labs [00:31:44] that's doing eight figures [00:31:46] and their back end is Airtable. [00:31:48] So, that's pretty amazing. [00:31:51] An eight figure revenue [00:31:53] company built entirely on [00:31:54] Airtable. [00:31:56] That's impressive. [00:31:57] I think what I find amusing [00:31:59] about that is you talk about a [00:32:01] three figure revenue. [00:32:03] Because three figure [00:32:05] revenue is $100 right? [00:32:06] Yeah. Got to start somewhere. [00:32:09] That's right, [00:32:09] that's right. You start there. [00:32:12] So, way to go on kit and team [00:32:14] and it's pretty [00:32:15] impressive. That'd be cool to get them [00:32:17] on some time on the podcast to share what [00:32:19] they've built there. [00:32:21] All right, that's Round the Bases. [00:32:24] Next we're gonna do a quick feature [00:32:28] talking about On2Air, [00:32:29] which is the primary sponsor [00:32:31] of the BuiltOnAir [00:32:31] podcast. I am the founder of On2Air [00:32:34] and it's an all one toolkit to run your [00:32:36] business on Airtable. [00:32:38] It's a suite of apps that help you [00:32:40] do all sorts of things. [00:32:42] Just real briefly, [00:32:43] I know we're short on time, [00:32:45] so, I just want to talk about [00:32:47] if you go to on2air.com/resources, [00:32:50] I just want to highlight our [00:32:52] resource library that we're building, [00:32:55] Hannah who's been a regular host on this [00:32:58] podcast and guests [00:33:00] she handles all the content [00:33:02] and writing great articles, [00:33:04] helping you do different things [00:33:07] with Airtable and using our product to [00:33:09] automate your workflows [00:33:11] and your business processes. [00:33:13] So, check out our resources, [00:33:15] we have some new ones up dealing [00:33:17] with Google integration and how to build [00:33:20] invoice templates and [00:33:22] generate pdfs off of your [00:33:23] Google docs and whatnot. [00:33:25] And we'll be adding [00:33:26] a lot more to this. [00:33:28] So, just a quick shout out [00:33:30] on2air.com/resources [00:33:31] for some great guides on how [00:33:33] to improve your workflows [00:33:35] with with Airtable and [00:33:37] using On2Air products. [00:33:39] Next segment we're gonna [00:33:41] do Meet the Experts. [00:33:42] So, that's where we get to learn [00:33:44] more about Kuovonne [00:33:45] so, I'm going to hand it over [00:33:47] to Kamille who's gonna [00:33:48] ask some questions there. [00:33:51] Hi Kuovonne. Hi Kamille. [00:33:53] I feel like we've done this before. [00:33:57] We have, back when [00:33:58] the podcast was a [00:34:00] non-live format there's a word for that, [00:34:04] I'm sure. You actually were on the podcast [00:34:06] before and you were talking to us [00:34:08] about your life and how you came [00:34:10] to join Airtable and be such a fixture [00:34:13] in the Airtable community for the [00:34:15] people who haven't seen that episode, [00:34:17] please remind us how [00:34:19] have you started with the Airtable [00:34:23] community and you're at [00:34:25] this one of the most valued MVPs [00:34:28] at least on the Airtable [00:34:30] forums in terms of [00:34:32] how often [00:34:33] you provide helpful information [00:34:35] to people who are new to the product. [00:34:38] Okay, so my background was [00:34:42] I don't have a computer [00:34:43] science background. [00:34:44] Well I kind of do because I was [00:34:46] always interested in computer science [00:34:48] and then I happened to take a database [00:34:50] class when I was in college. [00:34:52] I fell in love with the idea of databases, [00:34:54] moved on and had a life [00:34:55] as a technical writer [00:34:57] and did like a little bit of [00:34:58] scripting on the side and [00:35:00] whenever I had a chance to find [00:35:02] and play with databases, [00:35:04] I kind of did that [00:35:05] but I had no budget [00:35:08] at all. And [00:35:10] I actually was that at one [00:35:11] point where I was actually [00:35:13] going to my local library [00:35:14] so I could use Microsoft access [00:35:16] for free in two hour time segments. [00:35:18] And I said I need to have something [00:35:20] where I can have a database where I can do [00:35:22] it needs to be free. [00:35:24] And so I downloaded every single [00:35:26] free app for a database [00:35:27] that I could find with my ipad [00:35:28] and tested them all out. [00:35:30] And the only one that I didn't [00:35:32] delete was Airtable. [00:35:33] And this was before Airtable [00:35:35] had any scripting, [00:35:36] any automations and custom [00:35:37] apps, and just fell in love with it [00:35:40] and said this is what I want. [00:35:42] It works on every device, [00:35:43] it works on my phone, [00:35:45] it works on my tablet, [00:35:46] it works on my PC, [00:35:47] it works on my husband's Mac [00:35:48] and it's all in the cloud and it [00:35:50] was free and I'm like, [00:35:52] I'm sold [00:35:54] and then on the side [00:35:55] I was learning javascript [00:35:57] because I thought, [00:35:58] well that's interesting, [00:36:00] I want to learn how to do [00:36:01] more coding. And then Airtable [00:36:03] scripting came out [00:36:04] And it was in February of 2020, [00:36:07] right after COVID was [00:36:10] starting to be a thing and [00:36:12] I had just learned enough Javascript [00:36:14] that [00:36:18] hello? Okay, I don't know [00:36:20] if my sound was getting weird, [00:36:24] looked into that, [00:36:26] that's where I first met Bill French [00:36:28] and the rest is kind of [00:36:29] history. So, I went in and was [00:36:32] building writing scripts running [00:36:35] through the documentation, [00:36:36] looking at the Airtable community [00:36:38] forums and finding all these [00:36:40] interesting questions and then I [00:36:42] was like, [00:36:43] wait a minute, [00:36:44] I could actually, you know, [00:36:46] a, help people out with this [00:36:48] and b, make some money on the side too. [00:36:51] So, that's when I went ahead [00:36:53] and started working [00:36:54] as an Airtable consultant [00:36:56] and I just barely started doing that [00:36:58] when you had first emailed me when you [00:37:01] first interviewed me Kamille [00:37:02] and it's kind of grown from there. [00:37:04] So, [00:37:06] I've always had my eye out [00:37:07] for the little guy like [00:37:09] that's who I've always been. [00:37:10] So, I like helping people [00:37:12] who want to help themselves, [00:37:14] but just need that little [00:37:15] extra bit of help or like [00:37:17] they've got this base 90% [00:37:19] built out that they've got [00:37:20] this one thing that's [00:37:21] really stumping them. [00:37:23] So, I'm like [00:37:23] just have an appointment with me, [00:37:25] we'll talk it over in [00:37:26] half an hour and let's [00:37:27] figure it out. Or writing scripts is, [00:37:31] that's the most fun I've ever had. [00:37:34] And then writing custom apps came after [00:37:37] that and it's not as fun [00:37:38] as writing scripts [00:37:39] because it takes so much more work. [00:37:42] It does, it's like 10 times as much work [00:37:46] easily. Yeah. And with custom apps, [00:37:49] someone is [00:37:50] going to be reviewing your code [00:37:53] if you send it off to Airtable and for [00:37:55] everyone's reference Airtable [00:37:57] had a hackathon and [00:37:59] Kuovonne's entry was one of the [00:38:00] winners. So, congratulations to you. [00:38:03] But we have a different app [00:38:04] that you've made [00:38:05] more recently [00:38:07] that we wanted to go over. [00:38:09] Would you let [00:38:10] would you like to demo it for us? [00:38:12] Sure. Let me know when [00:38:14] this share is going on. [00:38:16] Yeah, we'll do that. [00:38:18] So, this will be our App a Day segment, [00:38:20] and Kuovonne is gonna [00:38:21] walk us through that. [00:38:23] Let me add your screen. There you go. [00:38:26] All right. So, this is one [00:38:28] of the apps that I created. [00:38:30] I actually, I think I [00:38:31] have four apps in the market place [00:38:35] right now and [00:38:37] the genesis, the idea for this was [00:38:41] there are so many formulas [00:38:43] that are out there [00:38:45] and some of them are just these [00:38:47] really big long monsters [00:38:48] and I don't want to have [00:38:50] to re type them all over again. [00:38:51] So I'm like, well what if we had an app [00:38:54] that could just go read the names of [00:38:57] your fields and then [00:38:58] create the formula for you? [00:39:00] And so that was the idea. [00:39:02] My first app was actually [00:39:04] for creating pre filled [00:39:06] forms. I think that is my [00:39:07] most downloaded app that has been used. [00:39:09] It's actually linked to that one [00:39:12] on the Airtable support web page for that [00:39:15] for creating a [00:39:16] pre filled form, U R L. [00:39:18] So, if you want to pre fill a form, [00:39:20] but I was like, [00:39:20] there's gonna be all these other formulas [00:39:22] that would be just really nice. [00:39:24] And one of the first ones [00:39:26] that I liked after that was [00:39:28] the idea is say you've got [00:39:30] a number field and you want to [00:39:33] have it written out as [00:39:35] a text field for various [00:39:37] reasons. Either for example, [00:39:40] say you live in Europe [00:39:41] and you swap out your comma [00:39:43] and your periods [00:39:45] for your decimal symbol [00:39:47] and your grouping symbol [00:39:50] or you want to have some [00:39:52] other kind of symbols in there. [00:39:53] So, the idea with that [00:39:55] is if you take a look at [00:39:56] this formula. [00:39:57] So here's the number here. [00:40:00] This formula is huge. [00:40:02] Like it goes on and on and on [00:40:04] and on and on. [00:40:05] And this is actually one [00:40:06] of the shorter formulas that are there. [00:40:08] It was inspired by formulas [00:40:10] that I found on the Airtable [00:40:13] community but trying [00:40:14] to get them to do [00:40:15] exactly what I want and all [00:40:17] the different variations [00:40:19] what people had was just [00:40:20] it was too much of pain because [00:40:21] you have like the same field name, [00:40:23] that would need to be [00:40:24] changed out like 20 times. [00:40:26] So here's like this little demo [00:40:28] basically can see here [00:40:30] here's the number field [00:40:31] and the way it works is [00:40:32] you just get this little menu [00:40:34] eventually I'm gonna have [00:40:35] add more formulas to it, [00:40:36] but it's just like about [00:40:38] a dozen of them now. [00:40:39] So, we can say here [00:40:40] if we want to format the number as a text [00:40:42] and then you can pick the table [00:40:44] and then it actually [00:40:45] will go through and say [00:40:46] okay which are the fields [00:40:48] that can actually do this with [00:40:49] and so, say I have my [00:40:50] number field and then you can [00:40:52] choose what format you want, [00:40:53] you want to be a US [00:40:53] currency. So it will always [00:40:55] have the decimals. [00:40:56] Do you want to have an integer, [00:40:58] a us decimal, percent, European [00:41:00] or you can do something custom. [00:41:02] So, normally what happens [00:41:04] if you do a normal [00:41:07] field [00:41:11] and here, if I put a number here, [00:41:16] you get another formula [00:41:18] and get another number and then [00:41:21] you get this formatting [00:41:22] and you can format it here. [00:41:24] But if you wanted to use [00:41:25] this in say a report that [00:41:26] you're doing and something else, [00:41:28] you lose all that [00:41:29] formatting and it ends up looking like [00:41:34] this. [00:41:35] So, you don't have [00:41:38] a guaranteed number [00:41:39] of decimal places, [00:41:40] you don't have your grouping symbols and [00:41:42] all of that. [00:41:43] So, if you wanted to use it here, [00:41:45] like as a us decimal so you can [00:41:47] just pick whatever format you want, [00:41:49] it gives you the formula here, [00:41:51] copy the formula, [00:41:53] and then you just paste it in here, [00:41:57] and then you've got your formula here [00:41:59] with whatever formatting you want. [00:42:01] If you want to do some kind of [00:42:03] custom formatting, you can say here. [00:42:05] Actually what I want is [00:42:07] I want to have some kind of, [00:42:11] I want to have a negative sign [00:42:13] and I want to have my [00:42:14] actually let's do like say [00:42:16] the euro symbol [00:42:19] and [00:42:22] I want to say you know, per item, [00:42:29] you go through, copy the formula [00:42:33] and then paste it in. [00:42:35] So, before I was doing this [00:42:36] with this formula, [00:42:37] whatever I wanted to [00:42:39] change something like this, [00:42:41] it would take me digging up the [00:42:43] old formula that I had [00:42:45] swapping out all of the things and [00:42:48] even though I'm really familiar [00:42:50] with formulas, its just that process, [00:42:51] it could take me into [00:42:52] like 10, 15 minutes [00:42:55] and I just, I end up doing it [00:42:56] so often that I said [00:42:57] I want a way of doing this [00:42:59] easily that will adjust [00:43:00] to all these different parts. [00:43:02] If you have to find a formula [00:43:06] then there are actually lots [00:43:08] of formulas out there. But a lot of them, [00:43:10] they have limits on the number [00:43:12] of decimal places that you [00:43:13] can use and they don't [00:43:14] have all the features [00:43:15] where you can just click and say, [00:43:17] you know actually what I [00:43:18] want is I want to have a thin [00:43:20] space for my grouping symbol [00:43:23] and a comma here [00:43:24] and so that you just click [00:43:25] and you choose what you want [00:43:31] and paste it in. So [00:43:33] you can get formulas like these, [00:43:34] you can build formulas [00:43:36] like your own but what [00:43:36] you're paying for when [00:43:37] you get the app is [00:43:38] you're paying for the convenience of [00:43:39] doing it. [00:43:41] Yeah, can you [00:43:44] go into that formula [00:43:46] a little bit so we can see [00:43:47] a little bit of more of what [00:43:49] it creates for you? [00:43:51] Okay, so... [00:43:53] Well, just to show it [00:43:56] because if I'm not mistaken, [00:43:59] I think I saw 4-5 [00:44:01] Different, yeah rejects. [00:44:02] Yeah, so this is [00:44:03] so, it's got a lot of things in it going, [00:44:06] first of all, it's [00:44:06] going to make sure that there [00:44:08] actually is a number in the [00:44:09] number field and it's [00:44:10] not blank. [00:44:11] It's going to find out if [00:44:12] the number is too big, in which case it's [00:44:14] just going to show an error message [00:44:16] that's actually an option. [00:44:17] You can turn on and off [00:44:19] because if you know your number [00:44:20] is never going to get [00:44:21] too big, it's never gonna have 21 [00:44:24] decimal, 21 [00:44:25] significant justice for that. [00:44:27] It figures out your side. [00:44:29] It does a lot of rejects replace. [00:44:31] And this is where it got a little bit tricky. [00:44:34] Earlier, we were talking about [00:44:35] escaping your formulas [00:44:36] when you have your code [00:44:38] as building the Airtable [00:44:39] formula. So, my code [00:44:40] actually has to go through [00:44:42] and it has to figure out when [00:44:44] it's creating this, [00:44:45] how it does all the different [00:44:46] escapes for all these [00:44:47] characters and the backsplashes. [00:44:49] And that took a while to figure out. [00:44:51] But it goes through all this, [00:44:53] it's got another rejects, it does rounding [00:44:55] because you're trying to figure out [00:44:57] okay if we have two different [00:44:59] decimal places [00:44:59] so, you have to put the rounding in [00:45:01] everywhere and then [00:45:02] adds in you know whatever [00:45:03] extra text and the thing is after [00:45:06] you have this formula [00:45:07] and you want to tweak it [00:45:08] a little bit [00:45:09] you can copy that into [00:45:10] a plain text editor [00:45:11] and then make whatever other [00:45:13] adjustments that you want to. [00:45:15] So, I don't think [00:45:16] many people will do that. [00:45:18] But, no. I brought it up just I mean you [00:45:21] reference what you're paying [00:45:23] for is you're paying for the convenience. [00:45:26] I don't understand rejects, [00:45:28] I don't think anyone [00:45:29] really understands rejects. [00:45:30] And the fact that it will do it [00:45:33] for you is beyond convenience. [00:45:35] It is a magnificent feature [00:45:38] and that is just one of the ready made [00:45:40] formula builders that [00:45:42] come apart of this app. [00:45:44] One of the other ones that [00:45:46] I like particular is dates [00:45:48] on formulas with dates. [00:45:49] One thing about dates is [00:45:51] it's always time zones [00:45:52] if you ever got something [00:45:53] particularly off on a time zone. [00:45:57] Well, like you you have a [00:45:58] formula and your time zone is off. [00:46:01] Well, that's usually because [00:46:03] of the time zone. [00:46:04] So, one thing that I have here is [00:46:08] here if we have, [00:46:09] if you say you want to [00:46:11] format your date as text, [00:46:13] so we can go through, [00:46:14] let's pick this and [00:46:15] I'm gonna pick a date field. [00:46:20] So, let's just say here [00:46:22] date field here, [00:46:23] you can pick which of these formats that [00:46:26] you want. So, say I want a U. S. [00:46:29] Date [00:46:29] and I want to, [00:46:31] don't want to include my time. [00:46:33] This formula always prompts you for [00:46:36] what time zone are you [00:46:38] actually going to be in? [00:46:40] And I am actually [00:46:43] let's say [00:46:45] I'm in central time zone. So, that is [00:46:53] where is it? That is Chicago. [00:46:56] And then I can go next [00:46:59] I copy this formula [00:47:03] and this is actually based [00:47:05] on the end date, [00:47:07] It's probably a hidden one. [00:47:24] and then say it's a formula field [00:47:26] and just paste it in. [00:47:28] And if you'll see here [00:47:29] it's gotta embed my set time zone [00:47:31] in here so that this will [00:47:33] be there. A lot of [00:47:34] times when people don't put that in [00:47:36] or they don't know how to nest it. [00:47:37] And then they say [00:47:39] why was my day off by a day? [00:47:41] and that it does nice little checking [00:47:43] things where if it's a blank thing here, [00:47:45] you're not gonna get the error code [00:47:47] saying that it's not there. [00:47:50] That is amazing. [00:47:52] This is one of those where you [00:47:54] don't need to know how the sausage [00:47:56] is made. Yeah. [00:47:58] So, okay, say here, you know, [00:48:01] so, one thing that say you [00:48:03] have a team that's working [00:48:05] in multiple different time zones, [00:48:06] what I recommend doing, [00:48:07] where you all want to see if [00:48:08] this is, how are your regular [00:48:10] daytime field [00:48:11] and have everyone say, [00:48:13] I turn this off, [00:48:14] use the same time zone for all, [00:48:15] kind of just, just, just turn that off. [00:48:17] So, everyone sees this in local time and [00:48:19] then create a new formula field [00:48:22] and then pick the time [00:48:23] zone of everyone for [00:48:25] where they're at, [00:48:26] so that you can see your local [00:48:28] time and then you can see [00:48:29] what time it would be [00:48:30] for everybody else. [00:48:31] So, say, for example, here [00:48:33] That we had other people [00:48:35] in New York and say, [00:48:37] I actually do want to include the [00:48:40] time in a 12 hour format. [00:48:44] And [00:48:47] let's use, [00:48:48] let's say we want a European [00:48:50] way of writing the times, [00:48:53] Next [00:48:54] copy formula. [00:48:58] that's all pasted in. [00:49:02] And so I can see here these people [00:49:04] that we're gonna be in New York when it's [00:49:06] this time here, for me, [00:49:07] this is what it is for them. [00:49:09] And it just does that here. [00:49:12] so you can see it's got the Europeans [00:49:14] time zone, [00:49:14] and then you can have it here. [00:49:15] I probably should have picked [00:49:18] a European city for that. [00:49:20] So it does several things with dates. [00:49:28] Eventually the goal is to look at [00:49:30] what are the different other times that we [00:49:32] have the other kinds of things. [00:49:33] I want to make sure that there's so many [00:49:35] formulas that could be made. [00:49:37] I'm trying to find what are [00:49:38] the ones that are the [00:49:39] most useful. [00:49:40] So, here's another one that [00:49:43] we have that I'm pretty proud of is [00:49:45] this is the show linked [00:49:47] record name without the extra quotes. [00:49:49] So, here say you have a linked record, [00:49:52] so, we hear of different ones [00:49:54] and they have [00:49:55] if you put this in a regular formula, [00:49:57] you'll see here. [00:49:58] It puts quotes around ones [00:50:01] that have commas or internal quotes [00:50:04] in it. [00:50:05] So, like here [00:50:05] this is my linked record field. [00:50:07] And if I just say that in my formula [00:50:08] field, it's got all this extra stuff. [00:50:11] If you want what the original version is, [00:50:14] then we have a formula that it [00:50:16] generates for you [00:50:17] that can get rid of those extra [00:50:19] quotes. So, that you can see [00:50:21] this without extra quotes [00:50:22] looks exactly the way this [00:50:23] is. [00:50:25] And yes, this also uses, [00:50:27] this is much of substitute [00:50:29] and some other things [00:50:30] going on in there to try [00:50:32] clear out that extra things. [00:50:35] This currently only works [00:50:37] if there is only one link [00:50:38] record, if you have [00:50:39] multiple linked records, [00:50:40] it doesn't work as well, [00:50:41] but in that case you probably [00:50:43] still want to have the quote [00:50:44] so that you can tell [00:50:45] which one was which. [00:50:47] Yeah. [00:50:49] But a lot of times like if you've got, [00:50:51] you know it's just someone's name or [00:50:52] company name and there's only one [00:50:54] and you say that's what it is. [00:50:56] I don't want to see those extra quotes. [00:50:57] You can do that [00:51:00] very cool. Yeah. [00:51:03] Can you give overview pricing? [00:51:07] So on this one, [00:51:09] it's if you go to Airtable, [00:51:12] if you go to the marketplace [00:51:15] is the easiest way to [00:51:17] get the licensing for it. [00:51:19] And if we find this, [00:51:25] you'll go here and you can say [00:51:27] you can get a license [00:51:28] at my gum road store and [00:51:29] I'm trying to make this pretty [00:51:31] affordable for everyone, [00:51:32] all of my apps currently [00:51:34] are you pay for it once [00:51:35] and then that's it, [00:51:36] you have it for the rest of the life [00:51:38] of your base. [00:51:39] So, this one right now [00:51:41] it's just currently $15. [00:51:43] And the thing is what you can [00:51:44] actually do is if you only [00:51:45] want to pay for this [00:51:46] for one base, [00:51:47] go and create in that one base. [00:51:49] And then you can create those [00:51:51] formulas there and [00:51:51] then you can actually, [00:51:53] as long as your field names match, [00:51:54] you can copy that [00:51:55] formula into any other base. [00:51:57] Don't say that. [00:51:59] But but if you actually want [00:52:01] the convenience because [00:52:02] what you're buying here is convenience. [00:52:04] You're buying the convenience. [00:52:05] I don't have to look up [00:52:07] and pick which one of these [00:52:09] five different formulas is [00:52:10] actually going to be the one that [00:52:12] I want because I've seen [00:52:13] a lot of formulas out [00:52:14] there and I'm like, [00:52:15] well that's really good. [00:52:16] Unless you get to this weird edge case, [00:52:18] in which case it's going [00:52:19] to blow up on you, [00:52:20] but you're not going to know it. [00:52:21] Yeah. You know, [00:52:23] and then it's a lot of the formulas [00:52:25] that I write that I'll give [00:52:26] you the most basic way you [00:52:28] could possibly write a formula [00:52:30] that doesn't do much [00:52:32] edge case handling. Usually [00:52:35] when I'm answering a question [00:52:37] on the forums, [00:52:37] the person isn't asking an edge case. [00:52:39] So just a, [00:52:40] you know, fair warning. [00:52:42] Don't always listen to me. You should, [00:52:45] but don't always. [00:52:46] But if you want to handle edge [00:52:48] cases Ready Made Formulas, [00:52:50] I'm telling you [00:52:52] $15 is nothing. [00:52:53] It's nothing. It really isn't it. [00:52:56] The idea is a lot of people, [00:52:57] they both, I'm like think [00:52:59] about your time, [00:53:00] okay, how much do you make an hour? [00:53:03] And if you're going to say, [00:53:05] say you, you make $15 an hour, [00:53:07] which most people, [00:53:08] if you're building your [00:53:10] own Airtable bases, [00:53:10] I would hope you make more than [00:53:11] $15 an hour because [00:53:13] that's barely above minimum [00:53:15] wage in California, [00:53:16] would you spend an hour [00:53:18] trying to find and tweak and [00:53:20] adjust a formula that you [00:53:22] found on the internet? Just get it, [00:53:24] saves you the time [00:53:26] and [00:53:28] then you have it and you can use [00:53:29] all the other ones that [00:53:30] are available in it. [00:53:32] And then the way it works [00:53:33] is you just go in [00:53:35] and you go to the settings. [00:53:36] The only setting that actually [00:53:38] is is you put into that license, [00:53:39] you type it in [00:53:40] and it is good only for a single base. [00:53:42] It gets tied to whichever [00:53:44] base that you use. [00:53:47] I think this one says internal [00:53:49] because I have this super [00:53:50] secret special way that I do it [00:53:52] where I don't have to pay [00:53:55] for a license myself. [00:53:57] But normally it will go [00:53:59] through Gum Road when you [00:54:01] buy it in Gum Road then it [00:54:03] will email you you know this [00:54:05] long 20 characters [00:54:07] some code you paste it in [00:54:08] there and then you forget about it. [00:54:12] That's awesome Kuovonne. [00:54:14] Yeah. [00:54:15] Thank you for sharing that. That is very [00:54:20] just thinking about like yeah [00:54:23] the formula it can save you, [00:54:26] another one words when [00:54:27] you're talking about edge cases [00:54:29] is on attachments [00:54:30] and this was one thing that is [00:54:31] really tricky on attachments [00:54:32] is this will give you the formulas [00:54:34] that if you have [00:54:35] one attachment it will [00:54:36] pull out the file name. [00:54:37] It can pull out a file name [00:54:39] if there's these weird characters [00:54:40] and I have no idea [00:54:41] why Airtable lets you, [00:54:42] but Airtable will let you have [00:54:44] all kinds of characters [00:54:46] in your file name like quotes [00:54:48] and slashes that are [00:54:49] actually not allowed in a lot [00:54:50] of operating systems [00:54:52] that they could be in there. [00:54:53] And then it also will go in [00:54:55] and have formulas where [00:54:57] it can build an image tag [00:54:58] of an html link where it will say, [00:55:01] hey, here is your your file [00:55:04] name and then a [00:55:04] link to whatever the attachment [00:55:07] name is in there. [00:55:08] Or if you want to have a [00:55:09] markdown link, it can do that for [00:55:12] if you want a markdown link to send in [00:55:16] like an email that uses the mark down. [00:55:19] Yeah, [00:55:20] so, [00:55:22] Various other ones, [00:55:26] just the ones that I think [00:55:28] they're useful basically, [00:55:29] whatever I come up with a [00:55:30] formula that I find I'm using a lot, [00:55:32] I look and say well how [00:55:33] much would that be [00:55:34] added to Ready Made Formulas [00:55:36] and I'm actually already [00:55:37] working on version two of [00:55:39] this that will had a few other features [00:55:43] and when it's ready [00:55:44] we'll push it through Airtable [00:55:45] that it will be available. [00:55:47] Cool. [00:55:49] Thank you, Kuovonne. [00:55:51] That is awesome. Get that. [00:55:52] Check it out in the marketplace. [00:55:54] Hopefully everybody installs [00:55:57] that and pays for it [00:55:59] and I think you can easily get [00:56:01] your value out of that in the first day. [00:56:04] Cool. Let's move on. [00:56:06] We've got a few more minutes. [00:56:08] Just a quick announcement. [00:56:09] If you are watching this video [00:56:11] and you are not a part of our BuiltOnAir [00:56:14] community then you need [00:56:15] to sign up today. [00:56:17] Check us out at builonair.com/join [00:56:20] and get in, sign up for the newsletter. [00:56:23] Get updates, [00:56:24] find out when we have new podcasts [00:56:26] and other content each week. And then also [00:56:29] join our slack community [00:56:30] where you get to hang out [00:56:32] with amazing people like [00:56:33] Kamille and Kuovonne [00:56:35] and many others were approaching [00:56:38] 900 members in our slack [00:56:39] community and we always [00:56:42] want to see more of you join us. So [00:56:44] please come visit us at builtonair.com [00:56:48] and be a part of that. [00:56:50] Okay, our final segment [00:56:52] we're gonna do an Automate Create [00:56:54] and this will likely [00:56:55] be a two or three part series, [00:56:57] what I wanted to do [00:56:59] and actually this could be [00:57:00] actually both of you. [00:57:02] Maybe we'll find this useful. [00:57:04] I think Airtable could use [00:57:06] something like this I'm, [00:57:08] I'm using this for our On2Air products [00:57:11] or going to be using this. [00:57:13] I figured why not create this live [00:57:16] with the BuiltOnAir podcast and hopefully [00:57:19] this is useful to other people. [00:57:21] So, if you are building an app [00:57:24] for the marketplace [00:57:25] or script or anything where [00:57:27] you need to get feedback [00:57:29] from your customers, [00:57:30] you want a system where you [00:57:32] can collect their ideas [00:57:34] and allow people to vote [00:57:36] on which features they'd like [00:57:38] to see. [00:57:40] There's some products out there, [00:57:41] probably one of the [00:57:43] most popular ones is this [00:57:44] one called a canny [00:57:45] canny.io and but if you look, you know, [00:57:49] $50 a month, that's a, [00:57:51] that's a pretty steep [00:57:52] starting price point. [00:57:54] I was like, could we not do this [00:57:57] you know using existing Airtable [00:58:00] functionality? So, what we're gonna do [00:58:03] in this three part or two part series is [00:58:06] we're going to walk through, [00:58:08] I need to refresh this [00:58:10] how we could set up a customer [00:58:13] feedback loop base and [00:58:15] implement the ability to collect data using [00:58:18] and I'm gonna try to do this [00:58:20] without using any third party tools. [00:58:23] We're going to do it all in Airtable and [00:58:26] we're going to implement the ability to [00:58:28] collect new ideas for new features [00:58:31] and then also the ability to up vote those [00:58:35] ideas for customers [00:58:37] and then we can generate a shared [00:58:40] base that allows customers [00:58:42] to see that and then up vote [00:58:45] features that they want to see [00:58:47] and that will help anybody [00:58:49] that is building a product, [00:58:51] see what their customers [00:58:53] want you to build next. [00:58:55] So, Kuovonne like in your [00:58:56] example people could suggest [00:58:58] new functions that they [00:59:00] want to see in your app [00:59:01] and others can up vote that [00:59:04] and what not. And so, with On2Air we [00:59:07] have six different apps [00:59:09] and always looking to hear [00:59:11] what people want us to build [00:59:13] next. So, for this for this phase [00:59:15] we're just gonna go over the basic [00:59:17] structure of the of the base [00:59:20] and how to get the initial data in. [00:59:23] And this one should be pretty [00:59:25] easy for anybody that's done anything in [00:59:27] Airtable. I just set up this took [00:59:30] me five minutes to set up a base asking [00:59:33] for, you know which app [00:59:36] they are looking to give [00:59:38] feedback on. The type of [00:59:40] feedback whether it's an improvement [00:59:42] to an existing feature or a new feature or [00:59:45] if they're reporting a bug [00:59:47] status will use internally. [00:59:49] I'll ask them if they're [00:59:52] our current customers [00:59:53] so that can help me kind of [00:59:56] give more leverage to [00:59:58] existing customers versus [01:00:00] non. Ask them for a title [01:00:02] and then the details [01:00:03] and then their contact [01:00:05] information. So, the basic way [01:00:07] is just create a simple form [01:00:10] where you basically just ask [01:00:12] for that information [01:00:14] and that will then get it into [01:00:16] your base. So, all of that [01:00:18] is pretty standard. [01:00:19] Where it's going to get a little [01:00:21] bit more tricky is how do we [01:00:24] automate the process of [01:00:25] allowing people to up vote [01:00:27] existing [01:00:29] feature requests or existing [01:00:31] new ideas that people want to see. [01:00:34] So, in part two that will do next week [01:00:37] we'll go through the process [01:00:39] of how we can implement [01:00:41] that using buttons and [01:00:42] automations to implement the ability [01:00:46] to up vote and existing data items. [01:00:50] So [01:00:51] check us out next week [01:00:52] we'll do a continuation of this process. [01:00:55] And after maybe two or three more segments [01:00:58] will have a fully functional customer [01:01:01] feedback loop and I'll share this space [01:01:03] with anybody who wants to also implement [01:01:06] something similar in your environment. [01:01:09] Save yourself 50 bucks a month or 200 a [01:01:12] month for bigger ones. Granted [01:01:14] this can do much more than [01:01:16] what ours can do. [01:01:17] But the basic functionality of [01:01:19] getting feedback from people [01:01:21] and allowing people to up vote [01:01:23] that so that you know [01:01:24] what other people want to see [01:01:27] will be a great system that I think [01:01:30] anybody could use and [01:01:32] getting customer feedback. So [01:01:34] stay in touch with us and that's [01:01:36] just kind of a teaser for for what will be [01:01:38] working on the next two or three [01:01:40] episodes in this in the segment. [01:01:42] So, with that any final words [01:01:44] were finishing right on the hour. [01:01:46] So, good timing Kuovonne, [01:01:48] thank you again for joining us. [01:01:50] You have other apps. [01:01:51] So I'm sure we'll get you [01:01:53] on in the coming weeks. [01:01:54] We'd love to have you on again [01:01:56] and get your insights in here [01:01:58] about your other [01:01:59] work that you're doing. [01:02:00] Thank you very much. [01:02:02] It's always a pleasure [01:02:03] to talk with you all. [01:02:04] And thank you so much for [01:02:06] all you do for the community [01:02:08] Kamille. Good to see you again. [01:02:11] We will that you next time. [01:02:15] Bye everyone. [01:02:16] All right until then we love to [01:02:18] hear from you, Priscilla and the [01:02:19] comments, I saw your comments. [01:02:21] We'll see if we can maybe [01:02:22] address those in a [01:02:23] future one those I think might require [01:02:26] more thought on our end to see [01:02:29] if we can help you out there. [01:02:32] So, but I appreciate the feedbacks and [01:02:34] we'll get to that. So [01:02:36] everyone, thanks for joining us. [01:02:38] As always, we love to see [01:02:39] what you build OnAir [01:02:40] so, please share with us [01:02:42] and if you're interested, [01:02:43] come on the show and show us. [01:02:45] Until then we'll see you next time.
![[S11-E03] Full Podcast Summary for 05-17-2022 – Airtable & Slack with DataFetch.io](https://www.builtonair.com/wp/../uploads/segment_image_1-65-440x264.png)
BuiltOnAir Podcast
- [S18-E02] Full Podcast for 04-09-2024 - Sync Airtable to Wordpress with WP Connect; Voting System for Daretable April 15, 2024#airtable #on2air #builtonair 4/9/2024 - BuiltOnAir Live Podcast Full Show - S18-E02 ___________________________ The BuiltOnAir podcast is a live weekly show highlighting everything happening in the Airtable universe. Check us out at BuiltOnAir.com/join. Join our community, join our Slack channel, and see what's happening. ------------------------ SPONSORED BY On2Air - Airtable Apps and Integrations to run […]
