Airtable: 10x Your Financial & Personal Results | Will Harken | Skillshare

Playback Speed


  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x

Airtable: 10x Your Financial & Personal Results

teacher avatar Will Harken, Music producer with marketing brain

Watch this class and thousands more

Get unlimited access to every class
Taught by industry leaders & working professionals
Topics include illustration, design, photography, and more

Watch this class and thousands more

Get unlimited access to every class
Taught by industry leaders & working professionals
Topics include illustration, design, photography, and more

Lessons in This Class

12 Lessons (1h 13m)
    • 1. Introduction

      1:42
    • 2. Best Practices

      1:45
    • 3. Airtable Basics Pt 1

      5:58
    • 4. Airtable Basics Pt 2

      11:46
    • 5. Formulas

      5:07
    • 6. When To Use Separate Tables

      5:02
    • 7. Automation Options

      8:31
    • 8. Business Workflow + Improvement

      9:32
    • 9. Example: Ecommerce Digital Marketing

      4:58
    • 10. Example: Small Business

      10:53
    • 11. Example: Physical Fitness Tracking

      5:45
    • 12. Outro + Assignment

      1:44
  • --
  • Beginner level
  • Intermediate level
  • Advanced level
  • All levels
  • Beg/Int level
  • Int/Adv level

Community Generated

The level is determined by a majority opinion of students who have reviewed this class. The teacher's recommendation is shown until at least 5 student responses are collected.

18

Students

--

Projects

About This Class

I’ve used Airtable to completely change the way multi-million dollar brands handle digital marketing. I’ve used Airtable to reduce my workload by 60% in past positions. And at this point use Airtable to power websites, my business, and to be honest, most aspects of my personal life.

Seriously the impact on me, financially and personally, has been huge. In a good way.

And the good news is you can use Airtable too.

A lot of people say discipline is key. But in many cases, good systems are debatably more important than discipline.

You can use Airtable’s task management and database features to make a system that makes you seem superhuman

Whether you’re a solopreneur,  you’re working for a bigger company, or you’re just trying to organize art projects, I think anyone could get something out of this class.

A lot of people have tutorials about how to do one-off things in Airtable like content calendars. But when you do that you are missing out on a huge opportunity to tie results to the time and money you’re spending on projects

There are lots of task management tools out there, but what good is a task management tool if you can’t report on what happened and say what works and what doesn’t?

My name is Will and this is my advanced course for how to think about Airtable. How to become one with Airtable to make you and your company more effective and efficient. 

RESOURCES:

Meet Your Teacher

Teacher Profile Image

Will Harken

Music producer with marketing brain

Teacher

Skilled producer, songwriter, and marketer who has worked on over 100 songs. I started playing guitar at age 13 and graduated from Barbara Ingram School for the Arts in 2012. With over a decade of music XP, I take the “random melody you sang in your car” and create backing tracks with depth. My work has been featured in film and online promotions.

Using my past experience as a digital marketer at Money Map Press, Guitar Center, and Rite Aid I can help you think about your art or business through a marketing lens.

See full profile

Class Ratings

Expectations Met?
  • Exceeded!
    0%
  • Yes
    0%
  • Somewhat
    0%
  • Not really
    0%
Reviews Archive

In October 2018, we updated our review system to improve the way we collect feedback. Below are the reviews written before that update.

Why Join Skillshare?

Take award-winning Skillshare Original Classes

Each class has short lessons, hands-on projects

Your membership supports Skillshare teachers

Learn From Anywhere

Take classes on the go with the Skillshare app. Stream or download to watch on the plane, the subway, or wherever you learn best.

Transcripts

1. Introduction: I've used air table to completely change the way that multi-million dollar brands handled digital marketing. I've used their table to reduce my own workload by 60 percent in the past. At this point, I use air table to power websites to power my own business. And to be honest, most aspects of my personal life as well. Seriously, the impact of air table on me has been huge in a good way personally and financially. And the good news is that you can use air table as well. And you can even get started with their free version. A lot of people talk about how discipline is the key to success, but I would argue that good systems are debatable and more important discipline itself. And I think good systems can even help you build your discipline. You can use air tables, task management and their database type functionality to make a system that makes you feel and seem superhuman. Other people, whether you're a solopreneur or you're working for a bigger team at a, at a bigger company, or you're just trying to organize your own art projects. If you're a musician like me, I think anybody could get something out of this class. A lot of people have tutorials about air table and doing one-off things are really focusing in on something like a content calendar. This course is more about tying all of your efforts together and looking at, oh, well, what transactions are happening? Who's Who are you interacting with? What projects are you doing? So that at the end of the day you can report on what works and what doesn't work. Because if you don't know that you're kinda just shooting in the dark and you're probably not going to be as effective as you should be. My name is Will, and this is my course on how to think about air table and how to become one with air table so that you can become more effective and efficient. 2. Best Practices: The few things that you want to keep in mind, I think as a person who's trying to manage yourself or manage a team, a lot of the time people get confused between the difference of effective inefficient. And the most important thing is obviously being affected. So you could make something efficient that doesn't actually help you make money or help you get towards your goals. And it's really easy to go down a rabbit hole when you're using tools like air table are trying to automate things, to automate the things that don't matter. So the first thing is to always make sure that you are establishing what is effective first. And then thinking about how you can make those effective things more efficient. A lot of people use air table for very specific parts of their business. They'll use it for a content calendar. They'll use it maybe just as a CRM where they're managing their relationships with customers. And my 3. Airtable Basics Pt 1: I want to first just do a basic functionality run down. We're gonna go and air table and just kinda mess around here. Just to show you, just to show you what kinda stuff you can do. So first thing we're going to cover is this grid view, right? So basically when you have your data stored in here, it's very similar to a spreadsheets. Basically it's just the cells vertical and horizontal that represent different records and Airtable calls, each individual row or record. And you can create a pretty large number of different types of data in here, right? And then the cool thing about our table, or one of the very cool things that initially attracted me to it. They have the ability to convert this data here into other types of views. So you can make it a Kanban board, right? Where you can move the record across as the team is working on it. You can make it a calendar. And like I said, you can get a lot more details on these individual views on air tables. There tutorial site. That's incredibly useful and I will leave the link for that. But that's one of the cooler pieces of functionality, is just being able to look at your data in different ways to be able to help your team. So one person might need to see a Kanban view to operate most effectively. Another person might like looking at a calendar. Personally, I'm not a fan of Kanban boards, but I've had a lot of other people I've worked with that love them. So you can customize it for each team member and what they need to see in terms of actual things that you can add here in terms of data, the most important functionality is of course, Record Linking. So what does that mean? That means you can have two separate tables here within this base, and then you can link between them. So let's say we have one table here that represents social media posts. And you have another one That's the campaign. So you have higher-level campaign and you want to bucket these social media posts to a campaign. So let's say we're doing a Black Friday campaign. Black Friday just happens as I'm recording this, so it's top of mind. And then let's say you have a Twitter post and then Black Friday. And then you have an Instagram. And then you can link these records. The idea is that you can link these records back to apparent campaign so that later on you can report on what happened and understand, oh, what did we do for Black Friday? For social media, I would argue the most important functionality in our table is being able to link tables together and kind of bucket what is going on. And we're going to look at crazier examples of how to use that. This is a very simple example. Granted, there's other tools that have started kind of adding that functionality, but I still think air table executes on it the best and in terms of being able to use that data later and report on it. So we have our single line of texts self-explanatory. You know, that would be something if it's like a person's first name along line, a long texts would be if you're writing a paragraph or you're writing like an e-mail template or something like that. Within the last year too, I guess they added the rich text formatting so that you can kind of do that or you have your headers, you have your attachments, you can pretty much attach any type of file in here. I probably wouldn't recommend she attaching videos because there is a even on the higher plans, there is a pretty small, pretty low limit for how much storage space you have. So obviously, if you're doing something like videos, I'd recommend using Dropbox or drive or some other cloud storage service. Checkbox. This is just, you know, it's binary where it's either checker, it isn't. But this one, you have one option where typically this would be like your status. So we actually have one over here already. So this is a single select where it's either to do in progress are done and you can customize this to whatever steps you want. So you might have review, you might have post mortem. That's a good one where it's like saying, Oh, well, we need to actually evaluate what happened on this multiple select, which is similar. But instead, we're going to just change this where you can actually do multiple at the same time. So this would probably be something more like tagging. So if you had something like if you wanted to incorporate some type of tagging functionality within your air table base, you could say something like, oh, well, this social media post is about trumpets, brass, you know, And those so just say, you know, trumpets are a brass instruments. So these would be, these would be two categories that would make sense to include together, we have collaborator. So if you have people functioning in the base are working with you and they also have their own air table accounts. You can assign collaborators in this way. And if you're feeling cheap and not feeling like buying a air table account for everybody on your team. You can obviously get around that by just making a separate collaborator field, that is a single select. And then instead of here, here's me. Instead of that, you could just say, well, hearken. And then you could assign who's in charge of that thing that way, if you're all using the same account, which could get hairy if your teams really vague and you're all using the same account and someone changes something. So if you have the budget, I definitely recommend having separate accounts. So we have our date, pretty self-explanatory, phone number, email, URL. So that's if you're blinking does something, a number you can set integer or decimal. Okay, keep going. Currency, self-explanatory, got percent, duration. So that's just how much time. So we'll be looking more at that later when we're looking at time, the time tracking, rating, you can set how many stars you can give something. 4. Airtable Basics Pt 2: Okay, so now we're getting into the stuff that's actually super cool. And I think what makes air table awesome? I think these three in particular or maybe like these for the formula, the roll up, the count in the lookup functions are awesome because this is where you can start pulling data from other tables. We're going to do a separate segment on formula because that by itself deserves its own little time for me to really talk about that. So we'll be looking at that. But let's look at the role of basically the idea with a roll-up is that you can add a number here. So we're going to add something like number. And so let's say brought Black Friday makes $1000 and then Cyber Monday makes $2 thousand. We're going to add our roll up here, Table 1. And we're going to use this number. You'd probably call it something like revenue. But so basically you have these different options in here where you can pull the data from all of the records over there and then you could sum them together, for example. So if you want to know how much have all of our campaigns made cumulatively, you would do this. And then we can say, and so this would be kind of actually I kind of did this backwards where it would probably make more sense to be doing a lookup of something that the social media posted. But basically we can see, oh, because this is associated with Black Friday, this is going to pull Oh, this is how much we put for that number. So if we put Cyber Monday here, it's going to pull 2000. And yeah, that's kinda what's going on there. I would actually make more sense to do the other direction, but that is what the ROLLUP function does. We're also going to look at count function, which is very similar to the roll-up function. So if we wanted to count the number of, say, social media posts that have happened for this campaign, we would do count social. And you can also narrow it down based on specific criteria where, say you only want social media posts that have been posted or let's say you only want to count social media posts that are in post-mortem stage, right? So the way you would do that as you go down here and say camps, social, boom. And if you don't use this, it's just going to count them all. Use this it would count. Let's go to status is postmortem. And so it's going to count the ones that are postmortem for these, which of course none of them are. So let's change this one just to give you an example. So it should count 1. So there you go. So we see that we have one social media posts for Black Friday that is in the postmortem stage, lookup is basically just printing. So if we do this, I'll just show you what it looks like. So let's say we want the, the statuses of all of the social media posts. So this is going to look up and say, Okay, we have one postmortem and one to do for Black Friday. Or you could change it to something like, what is the who are the collaborators for the social media posts here you'll see me pop up. So those are the four most important functions. And of course there's lots of documentation on how to use these in terms of the four variables you can add to a record. Those are some of the cooler ones. Of course, you can add, Create a time last modified time. And these are all kind of automatic where you don't actually have to populate them. Auto number is bar-code. I've never really used that for anything, but I'm sure that could be useful if you were in something like physical products. I could see that being a useful function and then a button, the button function I haven't really used that one might very much, but like I said, a lot of documentation out there about how to use it. So now let's take a look at the apps themselves so you can add apps. And so at this point, I think air table has kind of opened up the app market to third parties where there's a lot of really cool stuff you can find in here. These are the apps that air table themselves have made. And I find that you can usually do a lot of the reporting that you might need to do within these apps here. So pages designers, pretty awesome because it can pull information about your record. So if we're looking at the campaign, we could make a little printout that shows, oh, well what, who's in charge of the social media posts on this campaign? We could do that. You could say, oh, well, how many social media posts and you can kinda print it out and present it as well, where it's like you could obviously make it look more like a slideshow if you're doing like a presentation for someone, but you're pulling all that data up and you can present it without having to make a separate Powerpoint presentation, which I've seen, that's all happens way too much where it's like, oh, well, we already have all of this data and you have to have somebody whose sole job it is to copy all the data out of from ten different places and then put it into a PowerPoint where you had something like this setup. You wouldn't have to do that at all. You would just go to, you just set it up at the beginning and then just go to this app here. And then you can just print out your or export it as a PDF and then just be done with it. There's just so many awesome ones in here. You have your pivot table, that one's kind of a classic charts. They can be cool. So if we do like a pie chart of social media posts, Let's do by status. So you can kinda do these steps, these printouts of, oh, what's going on with, you know, how many how many of our posts are in post-mortem, how many of them are published? So and obviously you can do line charts depending on what makes sense. So a lot of functionality there. I want to say there are some places where air table falls short with their, with data visualization where you might, you know, if there's a specific thing like a really specific type of data visualization you'll need, you'll probably going to need to export the data out and put it into something else like Tableau or whatever tool you're using. For the most part, I think air table really does get the job done for just basic data visualization and being able to say, well, this thing work or did it not work? So we'll look at the time tracker. We look in at that one later and a little bit more depth. There's usually documentation for all of these and it's very important for you to always kinda be to have a set time every month or so or every two months, whatever it is or maybe it's even every year, or you re-evaluate your air table base and say what things have been added on this last year and how can we incorporate that into our strategy? Of course, one of the most important pieces of functionality in air table is the filtering, the ability to filter sort, and group ideas. So it really depends on what you need to do. But you could say, for example, I want to filter everything that is not done. And then it will remove everything that's done in the status column here. And then you might wanna take it a step further and say, Oh, well, I want to group everything by the status itself so we can see all of our empty statuses here that don't have anything assigned. All of these are ideas that we have as a team, decide these random project names here. But you have basically you can group it by whatever you want. Usually I think people would probably be grouping by status or if you have a particular type, it might be based on the type of project. And then you can also sort as well. So let's say you sort by the status and then instead of grouping it, you sort by the status and it will give you a similar result, but instead there won't be groups and it'll just be a straight line of everything that way. So those are pretty cool. And I think one thing that air table added really recently that I think is a really awesome feature that I've used is the condition groups. So it used to be that they didn't have these instead of just saying AND, or, OR for everything you can do. So we can say something where we want, the status is not done. And all of these conditions are true. So use, not used to not be able to do that. Let's think, I'm trying to think of a good example here. So the status is not done and the due date is before, say today. And then you can also do, and here our change this to or so really you kind of have this nested condition type of thing, which I think is extremely useful. And I'm really glad they added that. You can kind of add coloring on the side here to kind of flag certain things. So you could do it based on, Let's get rid of this condition or you can color it based on the status or the different types of single select fields you have. So that's the coloring thing that can be useful depending on what you're doing and of course, view sharing. Yeah, I guess you can change the row height two. Don't really have never really used that. I don't really like looking at something that looks like that usually I just like the short one. Share view you can actually, this is pretty cool where you have somebody like a client who's outside of the company that you don't want them in their editing stuff or being able to see too much of what's going on. You can so say you want to narrow something down, but you could say, okay, well, I don't want this. I want to show the customer all of the projects that we're working on for, for them. And so this one, let's actually just say this customer areas projects, you know, a customer 1111. And so they have the one project and you just kinda wanna give them all the details that you have. Good hide everything except for the things that you want to show them like your notes there, maybe it's like a public-facing notes or, um, you know, whatever thing you want to show them and then share that view and then they will be able to look at that and not access anything else or see anything that you don't want them seeing. You can also add a form view as well, where I just added a form view for this. And this is another way where you could add something where the customer submits something that they need from you or maybe you use it internally for your team. So that's pretty cool as well. Definitely have seen a lot of use out of that. And some of the things I've used this for can download things as a CSV, renamed view, kinda get. You can also give the viewer a description so that people know what the heck's going on. Copying configurations is pretty important. Where you can say, Oh, well I want the field order. So that's like the order of the actual pieces of data. So look at this. So if we have, if we go here, we unhide everything. Show all. So right now we have this type of field order and say We don't like that and we want to reorganize it. Based on another view. We can copy the field order of, say, this view, it's probably the same, but it looks like it change something there. But the idea is that you can create a separate view and then organize the variables in the order you once. And then you can copy that to other views if you need to. Along with the visibility and all of these other cool things here. So that's just something to keep in mind. 5. Formulas: Let's talk about formulas because formulas are pretty important and definitely a really big part of adding efficiency to your base. Let's say an example here where you are posting on social media and you're posting about guitars or say that there's a category of posts where if air table, for example, sees the word guitar in the text that you're writing. Then instead of you having to write out all the hashtags on Instagram, for example, for guitar. So there might be hashtag, guitar hashtag 2020, one hashtag, you know, guitar craziness or whatever the hashtags are, instead of you having to write those out every time you could have air table generate those hashtags automatically based on the syntax of what you're writing. So it can see, oh, well in their posts, they wrote guitar. So we're going to generate these tags, and so we're going to look at how to do that. Here's an example where for me I like having it where my projects always have the date kinda tagged onto them. So what's going on here? Let me unhide the date field though. I have a thing called label, and this is how I actually changed the name of the project. But basically what's going on with this as we're running a formula. So you're going to be selecting formula. And then we're going to say, This one's pretty simple. But basically we're saying if the due date is blank, then we're just going to say the label name. So it's just going to be this value right here and then we're not going to add anything onto it. But if it isn't, but if the data isn't blank, then we're basically going to concatenate where we're going to join these two things together. We're going to combine the label and then the date itself in parentheses, so that the final output looks kinda like this, so that it's very easy to see, oh, this is the project that we're working on and this is when it's due. One thing that you will find is that it might be beneficial, especially with crazier ones, crazier formulas to open your code in something like Notepad. So this is an example where I started a CVD gummy website for people who want to be able to find CBD gummies easier and sort by price and a bunch of other stuff, right? So I found that one thing that CBD people really care about, people who like CBD gummies is they care about, well, is it vegan and gluten? And so I realized, OK, I could go through and manually assign these things. Or I could have air table search through the ingredient list and look for certain ingredients to say, Oh, well this isn't a Vg and ingredient, therefore, these gametes are not vegan. And so what you'll see is that this is just literally your air table syntax in here, just copied out. And then it may MI a lot of the time it just makes it easier to work and to build out your formula in Notepad or some other, even if it's Word or whatever else. Just because you can kinda have the full screen or work with and see what's going on. So what's going on here is we have and we're looking. So if vegan friendly override, this is a variable where we can assign manually, oh, this is VG in or it isn't. And so if we assign that it's me, Vigener isn't than air table doesn't bother trying to predict what it is. It just says, Oh, well, we said that this has begun and this is a single select field. And then we're gonna say that equals blank. Then we're going to try to predict whether it's VG and, or not. And so we're gonna say, oh, well, if this contains beef, basically that's what's going on here is it's saying if the ingredient list contains the word beef in this in this casing, then it's going to say, no, we actually added in lower. So we're actually converting all of the ingredients to lowercase so that there's no problem with, you know, if beef is capitalised, this will still pick that up, right? And then we're gonna say, okay, No, then this isn't vegan anymore. If you see the word beef in the ingredient list. So basically you're just going through and kind of copying and pasting this over and over again, looking for every single possible thing that could be considered not vegan. And then if it passes all of those, then it says yes, this is probably yeah, yeah, this is Vg and because all of these things are not in it. So that's an example and I could do a whole probably tutorial on teaching you how to write code for these formulas. But again, there's lots of really great tutorials out there and that's something where you just gotta kinda get used to it and kind of struggle through it. If, especially if you're not used to doing formulas in something like Excel or Google Sheets, going to be something where it's going to take a little bit of time, but it's incredibly useful. And you can also potentially hire people on Fiverr or Upwork to do this for you where if you're not really feeling like coding something like that, There's lots of Excel ninjas out there who would be able to figure that out pretty quickly. That's kind of the formulas in a nutshell where it's very helpful for categorizing things automatically. In a lot of cases. 6. When To Use Separate Tables: Let's talk about when and when not. You should use separate tables. In air table, I want to start by saying that typically the goal in our table I think, is to minimize the number of tables that you have and to have as few as possible. Because typically you can use the single select to try to minimize the number of tables you have. The first thing I want to cover is if you need to bucket things, assuming you're doing a list of campaigns here, we'll do St. Patrick's, Easter or something, holiday. So we'll just do five. Okay? So if you need to be able to say, oh, well, these five posts belong to this campaign. Let me change this so that's easier to see. These five plus belong to this campaign. You need to be able to do that. Then you probably should make it a separate table because here's what happens if he tried to, for example, make everything in one table. And let's say you're also doing your social media posts in here. So let's do Black Friday, social post. One, Black Friday social push two. And then it's due to Cyber Monday posts. It's giving you an example here of where you might run into trouble if you try to make one table when you need to bucket things together. Okay? So we have these and let's say in order to, you know, because we talked about this earlier, but let's say type. And we're saying, okay, let's theoretically we're saying we're going to just get rid of this and combine it into this bigger table. And we're just going to have one big table. Right? So that's what we're hypothetically saying here. And you're going to find out why this isn't a good idea. So we're gonna say there's a campaign type and then there's a social media type. Ok? And then we're going to flag these as social media because that's what those are. And then we'll fly while these as campaigns because that's what they are. And then, so let's make a, another hypothetical link here where we're going to link, try to link these two itself. So we're saying, say we want to link these two to this greater campaign here because that's what we wanna do and understand that we ran these posts for this campaign. So we're going to link it to itself. So we're linking, we're doing this table link, but we're linking it to the table that you're actually currently in. And so what we're going to just call this link for now. And we're going to allow linking to multiple records. And let's take a look here. So we want to, now we're going to not add a lookup field. And so we're going to link these two black Friday. And we're going to link these to Cyber Monday. Okay? So now when we look in here, we can see, oh yeah, this is like the Black Friday, but the problem is, is when we look in Black Friday. So let's, let's delete this for now because we're preventing the way we're not doing this or pretending that we just have one table, right? And we've linked these posts, social media posts, to Black Friday. The problem is, is when you go in here, you're not going to be able to see, oh, this is linked to the social posts because the way that air table is built, it's kind of a one-way relationship. We can see that these are linked to Black Friday, but it doesn't work the other way. And so you run into a problem later on when you're trying to report on things. So if you're reporting on a campaign, You're not going to be able to see very easily well, which, you know, you're not gonna be able to pull data from these individual posts about what happened. And it's just going to make it more complicated. So that is probably the easiest way to know. Okay, yeah, this should not be in the same table. It should be a separate table is when you want to bucket things together. One of the biggest things I look for when I'm trying to figure out whether something should be one table or two tables. Is that the actual similarity between the data? Say that you're talking about the difference between a task in a campaign, right? Those are both going to have dates. They're both going to potentially have time values associated that your teams working on. And it depends on your business, of course, but there's usually going to be some overlap between those two things. And so in that case, for my own business, I just made it one table where for me projects and campaigns are in the same table where for some businesses that might not make sense because there might not be any overlap between that data. Going back to the bucketing thing, you might want to keep them separate because you want to bucket the projects that are associated with a campaign or potentially the other way around. So it really depends. It's case by case. 7. Automation Options: We're going to cover automations now. So we're going to start with air tables internal. They're built-in automations that you can use to streamline some stuff in your business or for your own personal task management. And just to reiterate my earlier points, You probably don't want to tear too deep into automating things until you know for sure that it's been a repetitive process. So if you notice that you're e-mailing somebody, Hey, you know, this status is done, then that's a good time to evaluate that and say, okay, yeah, we should add this in as an automation. You don't want to automate first, you want to find, well, what are the things that we're doing that are effective and then automate those things. It does is how you access it right here where you are in your air table and then you click on automations. And this is kinda where you can start getting a little bit acquainted with it. They estimate suggested automations here, I'm going to be covering two examples because there's so many different things that you can do where it would be hard to make a comprehensive, honestly, you could do a whole tutorial on that by itself. But I'm going to be covering two use cases that I think are really cool. So first, let's just go ahead and look at the base functionality here. So with all of these no coding automation tools and including Zapier and integrity mat, which we'll be looking at in a bit. You pretty much have two parts. You have the trigger, which is what starts the automation, and then you have the second part which is what happens. And so this is a list of all the triggers you can use, an air tables built-in thing. I think all of these are pretty self-explanatory. Web hooks are a little bit more advanced, so we're not going to be covering that are again, are tutorials and I'll actually leave a link for how to think about web hooks as well. I think for the most part, in most cases these are going to have you covered. So these are the triggers that are happening within our table in the knees or triggers that are happening outside of air table. So something happens in Outlook and EMEA and you know, an e-mail, something happens on Google Sheets. If your team is also using Google Sheets, that could be cool. Google Forms and GU counter. So these are kind of all the built-in options that you have with their table. One of the cooler ones that I think is great is the send a Slack message. And you could also do a similar thing and create your own automation to send an e-mail. But one thing that I just see it, a lot of companies are that i've, I've seen a lot is people will be expected to send an email or send a Slack message after they update a status and say, Hey, this thing is ready for you to work on. And that doesn't make sense because that's just taking extra time. That doesn't need to be taken. Where if you can just send an automatic e-mail after you update the status, that makes a heck of a lot more sense to me. And so you could use this as an example. So when a record is updated and you can change, you know, obviously all the variables in here. But then you can send a Slack message and hook that up so that the person gets the message, hey, this status is changed and yeah, obviously you in here, you would have to narrow down the fields. So we're going to turn this off where we want to unwatched all and, and this example of the status. So you'd want to see the status changes. And you could also, instead of doing that, you can just make a view in air table that filters by status. So you would select whatever the view is that you pick and that would be cool. The other type of thing that I think would be used kind of like the weekly digest type of thing. I guess they have something like that here. So you're starting at a scheduled time. So every Monday, let's change this to this geniuses say you're in the morning and you want to send a report to yourself where you don't have to look at the report everyday, just comes to you as an e-mail and that's the new information of the week. Here's how sales were. This is kinda what it would look like where you have your trigger that happens weekly. And then you can narrow down your conditions here for what's happening and then for basically what you're trying to find, you might find two records where you might want to find something that's going on, maybe in the projects, and maybe find something that's going on and transactions and pile this all. So maybe you've sent an e-mail from Gmail or you send it from some other thing that I think those two pieces of functionality are really cool. Kind of the automatic status update and then the, you know, like a scheduled report that gets emailed. I think those are really cool. Let's look at how you can use Zapier in conjunction with air table to automate more than you can just within a air table itself, you might have something where you have a thing that triggers an air tables. So it could be new or updated records. So you could use one of these functions here. And then you could trigger an action. So again, you could accomplish a similar thing that we just looked at, you know, where it maybe it's like a weekly e-mail or a in this case, if you're starting with air table is the trigger would probably be something where there's a status update. It's built in a very similar way that air tables, as you can see, that air table got a lot of inspiration for how they built their automation system. You can see down here 4,400 plus applications. So it's very similar to integument, where they just have a lot more things that you can connect to. So if you're using some obscure tool, there's, you know, there's probably a good chance that it will be in here. You might have something where somebody fills out something on. Let's say you use Smart sheets and you want to connect that to air table for some reason, you would start with your smart Sheets trigger. I think smart Sheets is in here. Let's see if they have that spreadsheets. And so you might set it up where you have some type of event trigger here where you know, if there's a new attachment added, you can include that attachment or do something where you're updating within air table. You can do stuff that is outside of air table scope. So let's say after you update air table Here, you go on and say, Oh, well, I want to make a post based on whatever is happening here in Spark cheats on Facebook. You wouldn't be able to do that with air tables, built-in automation because that's kind of outside of their scope. We're looking at Integra Matt. This is all of the things that they have. Literally, it's an insane amount of things that you can connect to each other. I'll include a link for all of their supported integrations just so that you can reference that basically what this is doing is it's saying anytime that somebody signs up on Mailchimp, which is a newsletter platform, we want to put these people in air table and do our CRM or Customer Resource Management or as a customer relationship management, I can never remember, but basically your way to contact customers and manage what's happening with them. We're going to throw that in there and then we're also going to send them a welcome, kind of like a personalized welcome email. So that's what's going on with this. This is saying anytime we have a new subscriber, we're going to fire this automation. So this is kind of your trigger place right here. So you see how it's firing every 720 minutes because I don't want to, you can make it a lot, the number a lot smaller than that. But if you haven't firing more often, you use more data and I don't really need it to fire that often, so I make the number hired. You can also use filters when you're connecting. So you connect these things. So just to show you how you add modules, it would look something like this. So say you want to update something and Mailchimp at the end here for whatever reason you, you can connect them or you can unlink them this way. And then you can use filters between them. So I'm basically adding these conditions here. So some people are not getting put into air table. We're firing this and we are populating certain data in air table with email addresses, phone numbers, their name, and any other information we might have from mailchimp, just fire off a one one-off email to them through Zoho male. We kinda have this type of thing going on. So that would be an example of using integrity mat to automate in terms of whether Zapier or integra matt is a better third-party new coding automation solution. That's so many words. I would probably say that it depends on which tools you use because there's a lot of tools that are on integument and a lot of tools that are on Zapier. So you might end up having to use a combination of both. You're just going to have to look at the list of integrations that they have available. And once again, I will include the link to where you can find that there's going to be a link for Zapier and then a link for Integra mat, which current automations they have available. 8. Business Workflow + Improvement: I find that most businesses and even personal projects are going to kind of fall into a four-step life-cycle. And you don't have to copy this and you can even modify it to some extent. But I find that usually you have your idea and brainstorming type of thing at the beginning. And that's, that's one where everybody's coming together and saying, well, these are things that I think can work or things that I think can make us money or things that I think can improve my life or whatever it might be. Then the next step is kind of auditing those things and saying, well, which, which of these things actually do matter with, you know, collectively, which one do we think is going to work? You schedule the best projects to work on and you get them on a calendar so that they actually get done. The third step is actually executing them. That's pretty self-explanatory where whoever is in charge of executing which thing does it, hopefully. And then you move on to step 4, which is actually reporting and the marketing world. A lot of the times they call it a postmortem. But figuring out what worked and I think what ends up happening to a lot of even bigger companies, and especially solo printers as well, is that they get so focused on ideating and executing that they really kind of miss out on the full potential of reporting and figuring out how things happen. And the great thing with air table is that you can do that with almost no time where if you set everything right up at the beginning. So if you've set up your air table base correctly at the beginning, you should not have to spend a lot of time report. You should be able to pull up a report that says this is what happens and you don't have to spend anytime exporting data into a spreadsheet or trying to do all that, right? So I want to talk for a second about incorporating all of the different steps that a project or that an idea might take through your business lifecycle. To this is kinda what it looks like in my own base. I've kind of changed every project names of everything. So you guys can't see all my stuff. But you can see the way I have it set up is that you have a Kanban board here, and I actually don't use the Kanban, but this I think is the best visual representation of what's going on. Where I have a step in my process, where I say, Okay, here's an idea. Should we do the idea and basically just evaluating that? And then if it seems like a good idea and I'll talk, actually, I'm just gonna go ahead and go into detail about how I do that right now. So let's talk about, let's go into estimation. We'll just do this. So actually, I think I have a chart called ideas. So you might have something that looks like this, where you have a list of all of your ideas, right? And then you might have something that says. So you might set it up where you have a time estimation of revenue estimation and a cost estimation, right? And so typically when you evaluate, especially with a business, when you evaluate these three things, it's going to be difficult because you really don't know how much revenue certain things are going to make. But sometimes you can have a pretty good guess and then you can have it where you predict, okay, I think this is gonna take two hours to do and I think it'll make a $100 and it'll cost $20. Let's say that's the example. You can kind of make a formula for profit estimation and then profit per hour estimation. And then you can sort to figure out which things are the things worth doing where you might sort by profit per hour. And then you might be able to say, oh, well, this thing at the time actually let's do the other direction. This thing at the top that things that look good are the things that we kinda wanna do it wrong. And I'm going to do profit per hour Actually. Let's do, let's say you're focusing on overall profit, sort by profit estimation. Then at the top we'll have our best ideas theoretically that are the most profitable, right? And so this might be a good way for you to say, Oh, well, do these ideas make sense to do, for example, if you, For me, I made an album earlier this year and it's like, well, if the numbers are looking a little bit negative, maybe you should hold off on making another album and you should focus on other things until you have some reason to believe that that number is going to change. So that's kinda the idea step and kinda my way of thinking about how ideas, how to pick between ideas. You could also do something even simpler than this, where you just rank an idea. You can use something like the rating and say, oh, I think this is a five-star idea and this is a one-star idea. And then just keep it really simple where you do something like that or you have your team vote on which thing is the, is the best thing to do. It's really up to. However, your business is structured, right? Let's go to 1 second here, and let's go to this Kanban again. So kind of back to this view here. After an idea seems good, you can move it to the to-do. You can assign it to whoever you need to assign it to. You can set a date. And then you can kinda just see it all the way through this whole process here, right? And then I know I talked about the postmortem thing actually hit it in this view, but you would have most likely something like a reporting or you could call it postmortem, whatever you want to call that. I also have holding canceled here where these are ideas that, you know, for for whatever reason either get canceled or they're put on hold. I'm usually canceled. Mean this definitely isn't happening. Hold usually means okay, this might happen after we set a different date or if a client wants to set a different date for the project, it's on hold until we get some more details. Via postmortem would be a good one. Add in here where it's evaluating how well something did you know whether that's weekly, whether you do that weekly or monthly, that's really up to you and depends on your own type of thing. Okay, I see, yeah, that really covers how I would think about incorporating air table so that you're kind of seeing projects are you can incorporate campaigns in here or have a separate tab for campaigns. But thinking about how you move through every step in the workflow. One thing that I want to address is making sure that you're incorporating air table in improving air table into your projects and into your team or your personal process. You have your project or task tab here, right? This could be either or as either projects or tasks, depending on what you want to call it, you might have something where you want to schedule time every month. So say maybe the first Monday of every month to say air table evaluation or something along those lines with your team. And of course, you can replicate this just by duplicating it here and then just dragging, reassigning it every Monday of every month. Or you could do something where you go into the actual table and just so we just drag it out so that it happens, you know, every month or so. We're doing a new evaluation of air table. And that'll be on your calendar so that you remember to say, oh wait, there's this one thing that we're doing over and over again that could be automated or not even necessarily automated, but just improved in the way that we are organizing our data. Everybody uses air table. They're going to become more acquainted with what makes sense and what doesn't. And being able to make good educated decisions about how to manage what's going on. A really big thing that I don't see a lot of other people talk about when they're talking about air table is how important it is to have something like a reference table or a link guide for your team, especially if your air table is very comprehensive and includes lots of different parts of your business. Kind of like the index at the beginning of a book. If you're reading an informational book, Turn to page 35 to learn more about how the heart works. So it might look something like this, where you kinda name what the view is four and then you link out to it where you can immediately access whatever this view does. Somebody could reference this and say, Oh, well this, this is the homepage schedule, you know, and then, and then maybe that's like a calendar. So you could change this to a calendar and then you maybe write some notes about it and then attach other users from the base, especially if you have something that's crazier. This could be particularly helpful to have as this first table here for your team so that they know what's going on and will also be very helpful for onboarding how you create these links. You have your specific view. So say this is the view you want people to know about. You create a shareable link. You just copy this, might actually just copy this specific thing here, assuming that you're sharing it with people who have access to the air table base, you would probably just want to copy this and then throw that in here where you just say that's the view, that's the link to the Vue we want to share. 9. Example: Ecommerce Digital Marketing: In terms of talking about how you can use air table for an e-commerce business. I probably I'm not going to go too in depth in this table for legal and privacy reasons. But we can cover kinda the general idea of what's going on here. So we have campaigns, source, email, homepage header, paid, social, organic, and reviews. So campaigns is kind of at the highest level where all of these things, for the most part, I think are rolling up into the campaign. So you're gonna be using formulas and roll-ups a lot. Where in this campaign tab where you can roll up, Oh, well, what are all of the individual efforts that we did? How much money that each of these for every campaign that we did, how much money we make from e-mail, homepage, or social. All of these are going to have. So if you clicked an email here, you're going to find a linked view back to the campaigns. You might have a Black Friday campaign in here, and then you might have 10 Black Friday emails that link back to this campaign. And then at this campaign level you can say, Oh, these are the 10 e-mails that we sent for that what is the source? 14. So this is, in this particular case, this is very accompanying that tracks revenue by a source code. So you might have the source code XYZ. And so that is where we're storing all of the actual source code data. So say XYZ made $100, then we associate a source code with all of these different efforts. So you might have a paid social effort that's associated with a particular source code. Let's say our example of source code XYZ that made a $1000 is an e-mail. So we would associate these two together using air tables linking process. And so we would be able to say, oh, this e-mail had this source code, therefore it made $100. And then that information we would link back to the campaign. And so we would have, say, an individual source code for all 10 of our Black Friday emails. Those would all roll up into the campaigns automatically. There's no magic reporting, there's no downloading CSVs or anything. So that you can look at the campaign and say, Oh, here are the 10 source codes that we sent for Black Friday emails. And here's how much money they made. That's kinda what's going on for each of these individual efforts where you might have a homepage, a header homepage would just be maybe like the banner images that you're doing. Paid social is, you know, if you're paying for Facebook ads or whatever else, organic social, self-explanatory, that's if you're posting directly on Facebook, Instagram, you know, these days tiktok and terms of that source code data. And a lot of cases it might be something where you do have to manually import that every day. So if you're working at a company that has kind of their own separate way of reporting the source codes, you might have to export those out and then put them in here. Or if you're doing your own thing, you could probably have it has some type of automation setup. And then finally one that I left in here that I think is interesting is the Reviews tab where this is a separate table where you just keep track of all of your customer reviews, you know, your five-star reviews, the end, even you include all of them. But typically if you're doing marketing material, you want to include the testimonials that are five-star reviews. So you can even include a filter in this table that narrows it down to your five-star reviews. And then you can link this back to maybe your campaign or maybe even these individual tabs so that you can quickly query, oh, I want to include a testimonial that's a real five-star review from one of our customers. And so you can quickly access that data within here. Maybe you do a onetime thing where you export all of your customer reviews out of your review platform and then put it in here, and then you just have enough and you just always use that. Or you could have a automation setup, like we talked about earlier through Zapier integrity mat. Where say your review platform is power reviews. I think that's the name of one of them. It probably is. And you have it where whenever you get a new review, it automatically adds it into this reviews columns so that you can always query when you're making a new campaign. Oh, well, what are our best testimonials? What or where order our five-star testimonials that we can use for our marketing copy. One that I would include in here as well would be pay-per-click. That would probably be a good one to add where you're incorporating that data so that you can kind of see everything that's going on under one roof. That is how I would run, for the most part, run an e-commerce business out of air table. This is if you're working kind of just solely on digital marketing of what we're going to be looking at. If you are trying to build a whole business in air table, if you're a solopreneur or you're just building a business for yourself, how would you do that? So we're going to look at that next. 10. Example: Small Business: We're looking at how I run my own business through air table and how you can incorporate every different individual thing that's happening so that it all ties together in the end. And you can say, this is how much money this person is worth. This is how much money this project was worth. This is how much time I spend on this project. All those things come together so that you can have a good answer of what's working and what isn't. If I'm making everything run through the project where I'm linking to the business segment, the customer, the Time Log in the transaction. So all these things are funneling through the project, though I'm going to start at the very end here at the, at the time. So this is kind of time management. One thing I will say before I get started here is that all of these numbers are fake. A hall of the time, all of the profit, you know, it's all fake numbers just for the sake of example. So keep that in mind. I have not made negative $8 thousand. Not yet anyway. So let's look at time first. Basically the way I have this setup for myself and for anybody that ends up working on projects for me is I have it where we're linking back to the project. So we have our projects here and actually let's take a look at this view. And so basically we're linking to time log. So that's what's going on is we're linking to this table here. And we're linking to a project. So anytime somebody works on something or I work on something, I put a link it back to the project. I do my start time and then my duration. And the nice, this is calculated automatically based on the duration. So this is the end time. Of course we keep a just for the sake of record keeping Last-Modified. And I also have a subtask here as well. So if I am working on projects 63 and then I'm doing editing, for example. This is a way to differentiate between different things that are happening on this project. And so what does that look like in terms of making a new record? So it looks something like this where if I'm tracking my time, I'll link it to the project. So let's say we're doing project 43, I'm starting now, and then I use the time tracker app, subtle. So this app right here and a cancel this guy, I don't know why that's running. And then I'll start tracking and then just click this top one and then it starts counting. And then after you're done and hit Stop, this will automatically update your duration. So I only did that for a couple of seconds, but if you had gone in and done it for five minutes, they would log five minutes. So that's kind of how I do time tracking. And one thing that's cool in terms of time reporting is just doing pivot tables and being able to see, oh, well, this is how much time I spent on certain days last month. This is how much time I've spent today, five minutes, according to this, but you can use pivot tables to kind of break out by editing time and see what has gone on for each individual project. If you want to see, Yeah, I think the pivot tables are pretty cool. Another thing would be the pages designer. See here, you get set up something like this where you kinda have the project. This might be how much time was spent total on the project, how much revenue was made profit, it could be any number of things. And you can have a little printout of the amount of time that was spent. And again, this is just pulling data from our time field here. Do you might have something that looks like this where you have the duration and then, you know, if it, if say this to subtask was editing, it would say that. And so you can get a good idea of, you know, what happened and how much time was spent on each thing. So moving on to the CRM. So we have our list of customers here and it's being linked back to the project. You can add whatever you want and you could add YouTube followers or any notes that you might have about the person. You can see. I'm just concatenating the first and last name. So you know, you have your first name and last name and then it gets put together and being their full name, you might have something like a source code. So I do this where if I know that a person came from a particular place, I document that so that you can report on that later. And another thing that you'll do probably is counting how many transactions you've gotten from the customer, the lifetime value or the lifetime profit of the customer. So this customer here theoretically is worth negative $8 thousand. So you probably wouldn't want to bring them on as a customer again, you might want to talk to this guy who made you positive $6 thousand instead. That's why it's important to note because a lot of the times you're just guessing how much a customer is worth and you don't actually know unless you are reporting on it. Dollars per hour is a good one where you could say, okay, well, based on how much time was spent, it's really going to depend, but these are just some of the critical pieces that I would be looking at is how much time and this is rolling up From the time field. And how are we getting that piece of information? Well, we're pulling it from the project itself. So basically the time information is being fed into the projects and the projects, that information is again being transferred over to the CRM so that we can know how much time is being spent. You might ask where the dollar values coming from and that's where transactions come in. And so this is just a list of, you know, if you make money, you documented or if you lose money, you have to spend on some equipment, basically keeping a running list of that in here, right. And again, you could automate this. So say you're using PayPal, you can have it where every time there is a transaction that happens that affects the balance automatically gets logged into air table so that you have that as a transaction. And then maybe later on you have somebody go in and fill in the project that it's associated with. So this is again, we're connecting, we're running everything through the project. So once you associate this transaction with this product project, we can say, okay, this is a transaction that happened as a result of this project, whether it's a revenue or an expense. And you can see here this is the balance. If it's negative, that means it is an expense. Positive means it was a revenue. But you can also include a note here where I'm basically you're having this role as a formula where the final result is the name of the project, the day that the transaction happened. And then say, this is a gas expense or something. Say you spent $3 thousand on gas is might not be the best way to do it, but this is kind of what I end up doing where it's useful to be able to say, oh, this is the project that had the expense. This is the note for whatever happened and then that also is the day. So this would be an example of one of your metrics that you might care about this as being rolled up. So if we look at here from transactions, so we're selecting balanced because that's the thing we wanna roll up and then the sum. So then we can officially say, Oh, this project has made negative $5,654, not a good project. Shouldn't do that again because we covered time already so we can look at something time-related as due time total. This is summing up everything from our time. So you might have something that's dollars per hour. If I spent one hour and 30 minutes on this project, that means that for every hour I worked, I made negative $3,900, which again, not great. But these are all cool metrics and there's probably a lot of other KPIs that you can look at and experiment with that hope you're getting the idea that when you keep everything under one roof, it makes it a lot easier to pull things together and report on it more easily. And of course, in this project's tab, you can have as many. You know, I have a lot of different variables in here. Probably. It's not weird to have 50 to a 100 variables. Especially when you're doing something like this, where it's a campaign or a project where everything is funneling through that, you're probably going to end up having a lot of different variables. I have this other one here. This, this is just more for me. You don't probably necessarily need this, but I like having something where I roll up all of the projects that are related to a particular business function. Some people might do this where it's the campaign, where it's like, okay, well what are the different campaigns that were rolling up into? But for me, I just like looking at the actual business segments. So you could, I don't like right? Keeping them super alongside to say biz. And then, you know, you're linking all of these projects here. And then you can say, oh, well, you know, our taco businesses making this much money. But then we have down here, some of these other ones are not doing so well, so maybe we should discontinue those. Okay, so what is my reporting look like? Your options here, you actually could use their new interfaces tool, which is very similar to the 22, the apps that they have. So you might have something that looks like this where you have different dashboards that show, well, these are the different business lines. So oh, here are the different valuations of your customers here, this customer is worth the most, so they should be prioritized. Or it could be, let's see here. So this could be estimating. So what's going on with this one? You could do a rolling up all the projects together and then we're saying, oh, well, which business segment, based on our estimations is a group or for yourself, seem like they're the most profitable are worth pursuing it. Have your quarterly profit as a pivot table where that's kinda getting rolled up. And again, this is getting cold from the transactions table. You can pull things from all over the place from your different tables and then put them all into one dashboard that looks something like this. I know that there's a little bit more functionality with their new interfaces tool. So if we go in here, you can create something where we're looking at a high-level dashboard. So this is basically the same thing. It's probably a little bit better where there's a little bit more customization you can do. So I definitely feel free to explore that functionally. They accomplish a very similar thing, the app's dashboard and then this actual enter new interface designer that they've added a thing that's called I have on hand and your apps is just a search thing because that, that search function, I use that all the time. Where it's like, oh, well, I'm looking for a project for clients 777 galaxy, if anything comes up for that, probably not. Let's do Client 11. I know Client 11 is somewhere in here. It doesn't help that I just made them random numbers probably. But anyway, if you could look for a project and it would pop up and you say, Oh yeah, that's the project I want to look at and click into. 11. Example: Physical Fitness Tracking: As one of my final examples for how you can use air table. It's going to be a personal one where it's more about fitness and maybe how you can use it. If you're tracking your gym workout way I do it is I have three different tabs and Jim and I have it as a separate base as well because it doesn't really make sense to have your gym data talking to your business data. So that's for me, that's the best test for whether you should make an entirely separate base or not is, do you need the data? Do talk to each other. If you do, if you potentially do, then it should all be in the same base if the data doesn't need to talk to each other. So if you have your gym workout and then your your business, those two things don't really relate at all. So for the most part, you're probably going to want to keep those separate. So anyway, we have our three tables. And you might start by saying, Okay, I want to make a list of workouts, right? So this would be exercises. So basically I have my fat destroyer BY and then here are the exercises that I have linked to associate with that. And of course I have my list of exercises in here. I don't want a calendar. I think I accidentally added that a little bit ago. And so I have this list here. And you can include any number of things, but this is us linking to our workout tab. And so you can, of course in There's a leg curl can be incorporated in more than one workout. You have your target sets, your target rips. And then we have our max weight, which is actually pulling data from this column which is lifting. So we're looking, I'm linking here to the lifting log. So Here's the workout I did earlier today. And as you can see, it's a lot of stuff that is not squats, which I should do. I should do squats where you are tracking our weight or reps and force. And of course, if you're doing something like running, you could have a minute's column here. I don't want to spend extra time entering into date every time I enter a new thing and I have it where it automatically assumes that the day, the time you create it is the order that things happened. Of course, I have a manual option to where you can override the date of the thing that you're doing or of the exercise that you're doing. I usually never used that because I just take my phone, my Pixel 3 to the gym and I have the air table app on there and I just logged what I'm doing. And then this date created gets created automatically, so I don't have to worry about adding that extra variable I have to do is track, well how much weight and how many reps and then what exercise, why that? And then I also have this field called force, which is just, for me, It's probably not an important thing, but it's just multiplying the weight and the ribs together so that you know how much force you put out so that you can look at to see is that number going up over time or as my weight going up over time or my reps going up over time. It's kinda what's going on in terms of how all the data is talking to each other in this example. And then in terms of reporting and how you might want to look at it, you have something like this, where you have a chart where you can look at all of the individual things that you're doing. So I have this. So this is looking at force where we are multiplying the weight times the reps. And if that's going up over time, you could assume that might be a good thing. And some of these examples that are there outliers because maybe you've lifted extra for the day or something. But where is this pulling data from? We're saying in our log, we're doing the grid view. So this is just all time. And then we're gonna do our final date. So this is the x here. So what day that it actually end up happening in the final date is just that computed field where if the manual date is empty, then it's just the day that it was created. And then we're doing our order here, which is just ascending. And then we're doing it based on force. So we're selecting that and then we're doing the sum. So basically the sum of all force that happened on that day is what you're going to get here for that exercise. So that's what that would look like. And I'm sure you can see parallels between this and, you know, tracking revenue over time for a business or expenses or whatever else. You might also do something like a Pivot Chart, pivot table where you can look at the actual day of the week and then what the weight you ended up lifting was the I think this is doing it based on average weight. Yeah. So you can do that or you could do 4. So it looks like I didn't actually rename this one. B, I were doing an average weight. Here's it'll do force. And then you have a similar thing where you can look at, okay, well, here's my force and my cable squats and of course you can also filter it down or you just narrow it to specifically cable squats so it doesn't look so spaced out like this one does. But that is kinda what's going on reporting wise for fitness stuff. It obviously use this for running two, if you're tracking your running progress, you could also do wait, any number of other things, calories, you name it. It's all things that you can do. That's the thing that's great about our table is that it is extremely customizable and a great place to keep a lot of stuff under one roof so that you always have one place to go to say, are things good? 12. Outro + Assignment: I think that about wraps up our time together for this course. I really appreciate you taking the time to go through and educate yourself and see how you can use air table would have beef up your personal and financial performance. That kind of brings me to the last step, which is your project. So what we're going to be looking at here is two options. You kind of have option 1, which is to revisit a base that you've already made and maybe you can optimize it based on what we've talked about here today and figuring out, Oh, well, maybe these things shouldn't be separate tables or maybe I can add this automation, basically just making your base better and then telling me about that. And then option 2 is creating a base from scratch based on your business needs or you're personally as it could be your gym workout. It could be building out an entire base, kinda like the one we looked at where it's incorporating your customer management, your transactions and all that as well, where it's all kinda rolled up together. Basically just make something that's going to help you start hitting your goals. And that's going to be a system that makes you perform better. So once you've done one of those two things, once your bases built-in kind of finished in a good place, a screenshot of it. Make sure you blur out any sensitive information that you don't want everybody on the Internet to see. And then make sure you posted in this class so that other people can get inspired about how to build an air table base. And of course, feel free to ask me any questions. I am pretty good at responding quickly and I feel like I'm pretty knowledgeable about air table, so I think I can help with most of the stuff that you might run into. I'm going to sign off. Thank you again. My name is Will and until next time.