The Airtable Course: Use Airtable to Advance Your Career | Shenin Mark | Skillshare
Drawer
Search

Playback Speed


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

The Airtable Course: Use Airtable to Advance Your Career

teacher avatar Shenin Mark, Business Developer

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

    • 1.

      Intro

      1:52

    • 2.

      How I Currently Use Airtable

      3:40

    • 3.

      Version for phones and tablets

      4:23

    • 4.

      Updates to Portfolio Base

      6:16

    • 5.

      Updates to the Company Base

      3:32

    • 6.

      Updates to the Project Calendar Base

      9:11

    • 7.

      Synchronizing Among Bases

      8:57

    • 8.

      Sharing and embedding

      7:18

    • 9.

      Making and Utilizing Forms

      13:09

    • 10.

      Information on business

      8:08

    • 11.

      Work Calendar

      5:57

    • 12.

      Calendar for email marketing

      9:04

    • 13.

      Market research

      8:59

  • --
  • Beginner level
  • Intermediate level
  • Advanced level
  • All levels

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.

170

Students

--

Projects

About This Class

With the help of Airtable, multimillion dollar businesses' approach to digital marketing has been dramatically transformed.
In previous roles, I utilized Airtable to cut my workload by 60%.
Currently, I run my business, my websites, and, to be honest, the majority of my personal affairs using Airtable.

Seriously, it has had a significant financial and personal influence on me.
positive way. The good news is that you can also utilize Airtable.

The need of discipline is often stressed.
Good systems, however, are often debatably more significant than discipline. You may create a system that makes you appear superhuman using the task management and database features of Airtable.

Meet Your Teacher

Teacher Profile Image

Shenin Mark

Business Developer

Teacher

Hello, I'm Shenin. I assist businesses and entrepreneurs in achieving and exceeding their objectives as a strategy consultant and business development. My approach is built on years of experience working for both regional startups and worldwide cooperatives. In addition, I have a master's in business engineering and a bachelor's in business management and IT.

See full profile

Level: All Levels

Class Ratings

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

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. Intro: Running your own business as a self-employed artist is hard. And I'd venture to guess that most of us never received any formal training on the business side of building an art business. Which means we were forced to learn through our mistakes and waste a ton of time in the process. My name is Shannon McMahon. I'm a self-employed surface designer and illustrator. I've been running my design business for the past few years. One of my biggest frustrations has been trying to organize all my art files and important documents because they end up scattered all over my computer. About a year ago, I stumbled upon an app called peer table. And seriously, it changed my business. That's because air table combines the usefulness of a spreadsheet, that dynamic capabilities of a database, and that pairing is magic because it means you can literally organize anything. Through this course. You'll get an in-depth look at the various ways you can use air table to organize your creative business. I'll walk you through the basics of the app, then discuss three unique ways. I use the platform using my actual portfolio, client and calendar files. So you can see exactly how I use air table for my business. Also share the benefits of using certain tools and functions like views, grouping, filters, and more. By the end of this class, you'll have enough working knowledge of air table to be able to collect and organize anything using the app. So if you're just starting out and your creative business journey and have no clue how to organize things. Or you're an experienced designer who's continually frustrated at the amount of time and energy you waste. Searching for documents on your computer in this class is for you. 2. How I Currently Use Airtable: I thought the best place to start with this follow-up class is to talk about the differences between how I used air table back when the first-class launched versus now. Because back in 2019 when air table for artists first launched, my primary focus was just for surface design, but now I truly use it for everything. So I still have my surface design workspace. But beyond surface design, I now use it primarily to run my educational business with the help of my virtual assistant. And so I have several bases dedicated to just that. You'll actually get to see behind the scenes of some of these in the second half of this class. But truly, the biggest change for me is that I upgraded my main education workspace to a paid plan. And one of the annoying things about air table is when you upgrade your only upgrading a single workspace, so you have to pay per workspace that you upgrade. Unfortunately, you can't do it for your entire account. If you are ever curious about what features are included in the different paid options, you can just go to air table.com slash pricing and it'll show you the differences. Now, I will try and call out paid features throughout this class and kinda show you the differences between paid and free versions. So those are the high level changes that I've made to my overall account. But I wanted to cover one very exciting feature. That was not something I really knew about the last time I did the class and I wanted to make sure to share it right at the top of this class. And that is air tables restore feature. So if you happen to delete something, say you decided you deleted something like an entire table and you didn't really mean to say this had a bunch of information. I'm like, Oh, I don't think I need this. So I go and delete it. And you can see right here recently deleted tables can be restored from the trash. So I'm gonna hit Delete. And then in a few days I'm like, Oh, you know what? I actually needed some of that information. So I would go to the little trash can icon and you can see right here, you deleted this table a few seconds ago and you just hit Restore. And how much time you have to actually restore really depends on the plan you have. So for a free account you get up to two weeks, which is actually I think pretty generous for free plan. The plan, which is the ten dollar a month version, is six months. And the Pro plan gives you one year, which to me is more than enough time. And you can see it has reinstated that table. But there's also a way to restore an individual record that you deleted. So let's say I start with a new record and then I decide I don't need it. So I delete it. All you have to do is hit Control Z. So it's basically undo, just like if you were using an Adobe program, if you forget that, all you have to do is go to this looks like a clock with the arrow around it and just hit the Undo button and then it will bring that back. So again, this is something I wish I had known two years ago when I did the first-class, but now you know how to restore things if you ever need to. 3. Version for phones and tablets: So before I get to the updates I've made to my surface design basis, I first wanted to talk about the air table app for phones and tablets. It's something I didn't really use much before the first-class, but now, seriously, I use them all the time in so many ways. I've utilized air table to add items on my to-do list when I'm out and about and something pops in my head and I don't want to forget it. Or when I'm about to go to bed, that's usually when I get all my ideas flooding in to my brain. And so I put them in the air table so that I can actually fall asleep. I also love to upload product photos for company research now directly in the app. And this is something that I've added to my company and client base, and I will show you that in that corresponding video. But it's really great when I'm doing a little window shopping, looking for new companies and I come across products. I always take photos and upload it to air table. I've also used it when I need some info or a link really quickly. This happens when I'm talking with customers on Instagram or I'm doing research for something and I need to find a link. I use a lot. It's really easy to use air table for that. And again, a lot of times I'm usually in the evening when I have my iPad, when I'm sitting on my couch. So those are just a few ways I've used the app, either on my phone or tablet, but there are some very big differences between the desktop version and the app for your phone or tablet. So I kinda wanted to go through some key differences with you and I will be demonstrating these on my iPad. So the first big difference is there are limited view types. On the desktop. You have all the options available to you, but currently in the app, you only have the grid gallery and Kanban view. Hopefully eventually they will add in the calendar and form fields, but right now it's just not available. Next is adding new records and tables is a slightly different process. For individual records. You're going to use the giant plus sign at the bottom of your phone or tablet. And then four tables, you're going to use. The small plus in the bottom right. Next, Records can only be updated in an expanded view. So unlike the desktop where you can add information in without expanding an individual record, here you have to click on any record that you want to update and it will open to the expanded view. And this is the only way to add information and edit it. Probably one of the biggest differences is actually adding or adjusting fields within a table. So just like on the desktop, you can move fields the same way where you drag and drop them, but adding them, there's actually two different ways to do that. So the first way is to click on the field name next to where you want to add a field and then select, Insert left or right. Or option two is to click on the table name itself, then customize fields. Then you would add in a new field. And from this view you can actually adjust any field setting here too. Then last but not least, scrolling through records. I find this not quite as easy as the desktop version. On the desktop, all you have to do is use the little up and down buttons in the top left corner when you're in the expanded view of a record, It's really, really simple. Well, the app doesn't have those up and down buttons. So what you have to do is swipe up from the bottom of your screen. But you can't do it too forcefully because that's sometimes means you'll end up closing the app, which I have done many, many times. It's just not as easy to scroll through the expanded view of records. So I hope that gives you a better understanding of the differences and functionality of the app on your phone or tablet, and hope it inspires you to download the app to your multiple devices if you haven't already. 4. Updates to Portfolio Base: Okay, so let's take a look at some of the updates I have made to my portfolio and contracts base, which is one of the most important that I demonstrated in the first-class. And for comparison's sake, Here's what it looked like back in 2019 and here's what it looks like now. So right off the bat you can probably see there's one major difference, and that is the row height of each of my designs. And this was actually something that was available as a setting back in 2019. I just didn't notice it was there. So now I'm going to share what I found and how helpful it is, which is row height. It's this little icon right here, and it gives you four different options. So short is the default setting that you're probably all familiar with. But they also have medium, tall and extra tall. And for this particular table, because so much of it is about the artwork itself. I love having the extra large row height because it was so hard back in the day to see which design it was from the tiny the little thumbnail. So now I just have it huge and it's a lot easier to see. The next thing I'm going to show you is probably my favorite addition, that air table added into the app since my last class. And that is multiple views. And you can see over on the left-hand side, I have four different grid views. Back in the day before they offered this as an option, you could only have a single view of each type, so you could only have one grid, one form, one calendar, one gallery, and one con bond. That was it. Well now you can have as many views of each type as you want. So back when you can only have one, I really leaned on the grouping feature a lot, which you probably recall from that first-class. But now I love to use the multiple views in the same way. And so here I have a version that has my entire portfolio, absolutely everything. But then I have separate views specifically based on the status of the design. So you remember status was one of the columns and it was basically licensed on hold or purchased. So instead of grouping like I did previously, I now have multiple views based on the status of a design. Now how you actually go about doing this, I'm going to demonstrate I copied my entire portfolio into a demo so I could show this to you. So the first thing you're gonna do is rename it something like all total, complete in the name. Because the most important thing that I want you to remember when you're using multiple views is to always have a view that contains absolutely everything in the table. And then from there, all you have to do is click the little three dots and say duplicate view. So here we're going to do a licensed designs. And so all I have to do to update this is go to the filter feature, add a filter and choose where the status is licensed. And you can see it updated. And now it's only the licensed design. Now, if you want multiple views that have very similar type filters, the easiest way to do that is to actually duplicate a previous view. So for purchase designs, e.g. all I would have to do is duplicate this one and then change the filter where status is licensed to Purchased. And that's all I would have to do. So I hope your wheels are turning a little bit on how you can use multiple views. And I will definitely be calling out in many later videos on how I've added the multiple view functionality to many of my bases. So let's get back to my portfolio based and I'll show you the rest of the changes I've made. So let's go to buyout contracts. I did also make a change to that. So previously this was purchased contracts and it included everything that was either a buyout or also all the freelance commission projects I did. But because of the changes that I've made and specifically to my projects calendar base, which you'll see in a later video. I actually moved all of those commission projects into that table. So I change this to just be buyout contracts where the companies purchase a design outright. And last but not least, is clients. So if you remember, in my last class, I had a pink clients table that included all of the information of each client that I worked with and how much I was earning from them and how many designs? Well, what I found was I was not updating it as frequently as I needed to because it was getting too difficult and time-consuming. So what I decided to do instead was actually delete that table and replace it with a client's table that's actually linked to my company and clients. Base. Sinking is something that is fairly new to air table and it is amazing. And I walked through how to use that entire feature in the sinking between bases video. But basically what this does is pull all the information from my company and clients base. And then I can use that just like I used my paying clients where when I have a company field, it is linking to another record field type. And if you need a quick refresher on how to use the link to another record field type. I highly suggest you go back to my first air table for artists and view the new bonus video that I added to demonstrate how to successfully create link to another record easily. 5. Updates to the Company Base: So just like my portfolio base, I've only made a few minor changes to this since my last class. And the first of which is something you probably already guessed is using multiple views. So I have one that includes all the current companies that I've reached out to. But I've also created views to include both a list of those who have been clients. And this illustrates one of the benefits of having multiple views because this company client's view is what's linking to the client's table. I showed you that sink inside my portfolio and contracts base. But then I also have a view of all the rest of the companies I reach out to that aren't clients. The only other change that I made was updating my notes and I've done this pretty much globally for all of my basis, is toggling on this option enabled rich text formatting. And what that means is you can include links, have bullet points, have titles. And so it really helps if you have a lot of information on a company that you can organize it a little bit easier this way. So now let's talk about contexts. I've only made one little change and that is adding the frequency column. And the reason is because I have so many people that I am contacting on a regular basis. It was getting to be a little bit too much trying to contact all of them every month, especially because some of them don't need to hear from me that frequently. So I added a frequency column to adjust things on sending monthly all the way to yearly based on my previous interactions with all of these contacts. Now what that means is I'm not contacting as many companies every month, which means I'm spending a little less time with admin for this part of my business. I means I can spend that time elsewhere. Next up, I wanted to call out the product photos attachment. I mentioned back in the phone and tablet app video, I have a product photos and attachment field. And so anytime I take photos on my phone, I literally just upload them directly into the IR table app. Now one final note, this isn't something I have added in myself, but it's a suggestion that was made from my course students. And it's to include a field to help you decide whether you're going to contact a company or not. So I have an example in here that I've added to illustrate this is I just put it as match. And the reason being is if you're doing a lot of research, especially online, you will probably encounter a lot of the same companies over and over. So you don't want to be redoing that research every single time because that would be a waste. So my students suggested actually including every company name you've taken the time to research. So the next time you go hunting for new companies, all you have to do is use the find view and start typing something in and you'll see if you've encountered them before. And so you immediately know if they don't have the checkbox, that means it's not someone you need to spend any time researching. So again, this is just a suggestion. If you find that you're researching lot of the same companies and use this as a way to differentiate between those you want to contact and those you don't. 6. Updates to the Project Calendar Base: So truly the biggest change between my demo in my last table class versus this one is my project calendar base. It has definitely evolved a lot. So just as a reminder here is what it looked like before. It was much simpler than what I'm going to show you now. So first up, I changed the tasks column to call it project tasks calendar. And yep, you guessed it. I added in multiple views, just like I've done for the other two. So again, I have absolutely all tasks, a completed view. And the filter here is anytime the done checkbox is checked, then progress, it's the opposite. So these are all in progress projects where the checkbox is unchecked. Another change to this table was I actually added a task type. And so this was to identify the different stages of each project process. So I have brainstorming, sketching, design, revisions, Print Production, file cleanup, and then client communication. So this is really helpful because then I can see which task very easily is up next. So that's the main changes I made to my tasks table. But I also wanted to call out something specifically in the calendar view. Another awesome piece of functionality that they added is if you go to the Share View and sync to an external calendar, you now can have all of your tasks added to Google Calendar, Apple Calendar, or Microsoft Outlook calendar. So since I personally use Google Calendar, that's what I have. Sync all of my air table calendars too. And if you're not sure how to do that with whatever specific calendar application you use outside of air table, all you have to do is click this little question marks and it will open up all of the documentation and show you how to do it for each of the options. So next up is my project list tab, which previously was just called projects. And you can see there are a lot of different fields here. So I added a project details section and yes, enable rich text formatting is included. And if you remember, when I talked about the purchase clients and how I had removed the freelance projects from that table. The reason why is I now have a project fee field in this table. Then if it's a long-term project, I always ask for a deposit upfront to start the project. And so I also included a deposit received checkbox. After that, there are a bunch of different date columns based on the different deadlines of any given project. And then the rest are pretty similar to what was in the table previously when I demoed it. The one big difference is this last one, project type, long-term versus short-term. And the reason I added this, so I could have long-term and short-term views. So let's look at those now. I don't currently have any outstanding long-term projects, but this basically looks exactly like the all projects because it has all the information there. But for the short term, you can see if I scroll over, there aren't nearly as many fields. And the reason being is I don't need as many due dates or have a deposit check box because it's a much smaller project. It's not usually something I ask for. Another functionality with multiple views is you can use the hidden fields option to further customize individual views. Instance. You can see all you have to do is toggle on or off which fields you want to see. And so I removed deposit received both the first and second round. Do. So. I love using the hidden fields view to hide things that aren't relevant to whatever current view I'm looking at. And again, it's another way to further customize multiple views. The next table is a completely new edition, and it's one I think you're really going to enjoy. So when you hear from companies that they have certain submission deadlines, like they're looking for Christmas in March, but then they're looking for Valentine's Day in November. If you have those dates, it makes sense that you would have a place to store them? Well, previously, I had a bunch of different notes all over my computer and then I realize, why don't I have all this information into air tail, just like I do everything else. So I figured the projects calendar is the perfect place for it and that's why I actually changed the name to projects and submissions calendar. So it's just themes they needed the due date that they're asking for the submissions to be submitted by a cent checkbox. And then all the company information, company name, contact, email, product categories, and then ideas and notes. Now one call-out I want to make here is the product categories tab. Because you might notice this little magnifying glass and this is a field type I haven't previously talked about. It's called the lookup field type, and it's a little bit more advanced. And what's great about a lookup field type is it's actually pulling the information from the company on the company list table. Now, how does it do that? Well, I'm going to take a step back first. You have to make sure that somewhere on the table before you add a lookup field is that there is a field type that link to another record. So that's what this company field type is. Let me, just, for demonstration sake, I'm gonna change this to single select real quick. And you can now see the product categories disappeared because when I switched the company field from a link to another record field type to just a single select. This table no longer has a link to record, to pull that information from. And that's why it's crucial when you're using the lookup field type that you first create. A field that's linked to another record that you'll be looking up additional information. So that's why here the link to another record is the company and the lookup field is the company's product categories. So if I go back customized field type, link to another record and I'm doing company lists. And so now it's returned. So I'm actually going to delete this so that I can show you how to create a new one. So we're going to scroll down to look up and you can see this is why so field on this table that links to the records you want to look up. So we want to look up the products that the company produces. So we want the company table and then company list table field that you want to look up is products they make and then create field. And you can see now it's working. Okay, Last but not least, I wanted to touch on again, the multiple views feature when you have specific dates in mind. So obviously I haven't all submissions again, you always want to start there, but I also have a 2021 submissions. So let's talk about how I filter to only include this year's submission. So the first filter is where the due date is after an exact date. That exact date that I chose was December 31, 2020. So the last day of last year. So anything past that will be included. So basically starting with the first of 2021 and then I also added a due date that is before the 1st of next year. So what I'm doing here is basically saying include anything that falls between the 1st of January to December 31st, 2021 with these two filters. Now one additional thing that sometimes I like to do is filter out anything that I've already sent. Like I only want to see things that haven't happened yet, deadlines that are still looming. I might also decide to add temporarily a filter where the due date is after today. And you can see it automatically updated and it will automatically keep updating. So that's another way if you only want to see what's looming, not what's also already happened in a year. You can add that filter as well. 7. Synchronizing Among Bases: Okay, so hopefully you enjoyed and appreciated seeing the updates I've made to the bases that I showed you in the first air table for artists class. And now we're going to start covering additional features that I haven't talked about before and the remainder of the class, we'll be demonstrating other ways to use air table. So first off, we're going to talk about sinking. And this is really exciting because artists have been asking me whether this was possible since my first-class launch until just a couple of months ago, it wasn't. But table finally added a sinking feature where you can connect two bases at the same time. And there's actually two distinct ways to use this feature. And so I'm gonna go through both of those with you. The first is to meet the simpler of the two to grasp. And that is simply to copy the data of one table that you've created into a different base. Let's say I wanted to copy all of my portfolio information into another table, maybe as I prepare for an upcoming trade show or something else. So what I would start is I need to click Share View, create a shareable link. So now this can be shared, but you also need to click this second toggle, which says allow data in this view to be linked with other bases. And you can see as soon as I've done that, additional options show up. And specifically the sync feature, sync this view to another base. So I'm going to click on this, and it's going to open up this dialog box. And this is basically asking you where you want to move the information to. Let's say I wanted to put it in one of my previous trade show files. So that'll be my surface design archive. Then I would choose that specific base within that workspace. So let's go ahead and choose surtax 2020. Now, here are two different options. These are the two different ways to use this feature. We're going to first start with this second option, which is just to copy this data into the new table. So it won't be linked between where it originally was and where we're moving it. It will literally just be basically copy and pasting the whole table into this base in this workspace. So I'm just going to click Create Table. It takes a second. And now you can see it has put everything into the cortex 2020 base. Now, any styling that you have in the original doesn't translate the row height, e.g. you can see it automatically did the default, which is small, so I would probably go and redo that two extra tall. So that's option one. Anytime you decide you want to move information from one into a completely different base or workspace. This is how you do it. Option two is to sink a table between two bases. So this is when there will actually be a link created. So whenever you want to see the same information in a different base and you don't want to have to copy or paste the info and have to redo it all the time. Like when I showed you my update to my portfolio and contacts and how the clients is a sink base. And the way you can tell if a base is sink is it will have this little lightning bolt next to it. And then we'll have a little lightning bolt next to the icon of every field as well. You can see when I hover over, it says sync. So how do we actually go about doing that? So I'm going to start the same way which share view? And since I previously had the share view link already created, I don't need to do that step again. So I'm just going to sink this view to another base and click that. So let's say, instead of just copying the information into my search text-based, say I was planning for this year and I wanted my portfolio in there, but I wanted it sink so that anytime I added new artwork into my portfolio base, I could see those pieces already inside my search tech space without having to duplicate those records and add them in myself manually. So we're going to do the same thing, archive and 2020 surtax. And instead of copy this data, we're going to use the sink because it will be kept up to date as this data changes. So again, we're going to click Create Table. Now you can see the little lightning bolt it is now sink. Again. I'd probably go back, adjust the styling. And so those are the two ways you can utilize the sync feature in our table. But there are a few limitations that sinking has that I want to make sure to mention here. So the first thing I want you to remember is when copying or sinking a table, it only syncs the current. View. So in the instance where you have multiple views, it's always best to make sure you're on the right view. And so that's why I advocate for always having a view that has all designs because that means there's no filters, there's no hidden fields, and all this information will be duplicated. So let's say e.g. I accidentally was on my purchased designs view when I wanted to share. You'll also notice that I had to create a share view. So there's a unique URL for actually every single view you create. But so let's just say I didn't realize I was on the purchased view, but I was moving forward exactly like I did previously. And you can see all that ends up here are the pieces that were in that view. So that's why it's very important before you copy or sink, is that you always have the view that's visible to be the view that you actually want shown wherever you're moving it or sinking it to. The next limitation is that you can only edit a succinct base, the one that's actually linked from one to another, from the original base. That it's in a good way to think about this is if you can see the lightning bolt, that means you can't edit it. So let's say I try and update the status of this. It'll give me a error message. This field is saved from an external source and it cannot be edited. What that means is in order to make adjustments, I would have to go back to the original, change the status here, and then come back to the sink base and press sync now. And now you can see it's been updated. So remember if you're having trouble editing, go back to the original place where the table was created. The next limitation is specifically if you have a free plan, you can only have one sink table per base. I don't know if you noticed when I tried to add in the purchase designs. You can see it only gives me the option to copy the data because I already have a sink table in this space, so I couldn't have a second. Now this is only for the free plan, for the Pro Plan, which is the one that I have for two of my workspaces, I get up to 20 sink tables. Most of the time you'll probably be fine with only having one, but it's just something I wanted you to be aware of. And then the last limitation is another free versus paid version. So if you have a free plan, you will have to manually re-sync the information. Where if you have a paid plan either plus or pro, it will automatically make those adjustments for you. Say I wanted to update a few of these pieces and then I would come back here and you can see they haven't been updated. So all I would have to do is go up to the table name and press sync. Now, to me this isn't that big of deal, but it is good to get into the habit of once you've added information from the original one and you know that table is sink to other locations that you go to those tables and immediately re-sync them. So there you have it. That's how you both sink and copy information into different bases. 8. Sharing and embedding: So now let's talk about a few more features I wasn't able to cover in the first-class, sharing and embedding. So first let's talk about sharing. Why would you want to share info that you have an air table? Well, there's actually several instances where you might want to, if you have an assistant or team, but maybe you also work with an accountability partner. And maybe you have a calendar that you want to keep track of on milestones for each of you. Likewise, maybe you have a peer group or you're planning a joint event together. I've known several artists who have done trade show booths together. To me, air table is a natural place to have all the information in one spot for a bunch of different people. And then last but certainly not least, if you have clients and you want to give a little bit of extra communication, especially if you have in-depth projects, it might be worthwhile to share some of the information you've collected with them in air table. So how many different ways can you share information in our table? There's actually three different ways you can do so. The first is an individual tables, say I wanted to share my portfolio with a client or my VA. The first thing would be to make sure share view was activated. And if it wasn't, you'd know because it wouldn't have this little pink square around it. Each view has a unique URL. And so all you would have to do is copy and paste this link. And this is what someone would see when you share the table with them. And you can see they're able to filter and group and sort so that they could maybe find information that they needed. Also, if you'd like, you can restrict access with a password. So say you wanted to use this to show your portfolio to potential clients. But again, you don't want this information to just be accessed by anyone. You would just toggle on the restrict access with a password, type in a password. And then when someone goes to view it, they would need the password and this is what it would look like. So that's a great way to restrict access to just the person you sent it to. So beyond table, the next level up is to share an entire base. So let's say I wanted to share my entire portfolio and contracts table with my VA. For that, I would go over here where it says share. And you can see here it's giving me two options, either workspace or base, but here we're going to choose base. And so you have two options here. You can either put in the person's e-mail address and they will get an invite link. Or you can create a shared link that will give them access to the whole base, much like how the table link worked versus if you wanted to invite them by email. And that would mean that they would need an air table account themselves. And the shared base would show up at the bottom. Just like you see here, base is shared with me. So that's what that would look like if you invite them. The last option is if you want to share an entire workspace, which the easiest way I've found is to go to your account page, navigate to the one you want, and then click the share button. Here for workspace, the only option is to invite by e-mail, where the entire workspace would be shared with them in their air table account as opposed to buy link. One last thing I want to call out is right over here you have a few settings on what type of permissions they have. If you want to restrict their access to, just be able to comment or C, give them either the commenter or read only option, because otherwise they will be able to edit and configure things. Now what if you decide later on that you've shared something but you don't want to continue sharing it. Well, it's really easy to disable that. For table, you just navigate to the shared view and then disabled shared view link. For an entire base, you go back to the share button. And then where it says share-based link, you change it to disable link sharing. And then finally for workspaces, when you wanted to disable someone from being able to use it, you would have to remove them as a collaborator. So that's sharing using air table. Now let's talk about embedding, which is basically where you add a specific view of a table to your website. So why would you use the embedding future to add information on your website? Well, you could do a few different things for the grid view, it would be a great place to have a list of resources or links that you want to share that people could access easily. For a gallery, this would be a natural place to maybe have portfolio browsing for your private portfolio on your website. I've also used it to highlight student art for one of the challenges that I've run in the past. For the calendar view, maybe you have regular events like craft markets who exhibit at or you teach in-person. This would be very easy way to embed a calendar onto your website so that people could easily see when the next event is happening. And then finally, my favorite is using the Form View. I've used this for so many different reasons, but the most common is client on-boarding or for hiring. And I will show you exactly how to build your own surveys using forms later in this class. So how do you actually go about embedding information onto your website? Well, say I wanted to include a art supply wishlist onto my website. First, you would need to go to Share View and create the grid view link again. Then instead of using the URL, you're going to click here, which is embed this view on your site. And it will bring up a snippet of code. So if you use Squarespace or WordPress or Wix, anytime you use this, you need to make sure you're using a code block. And so I'm just going to click here and copy it. And then I have a demo ready to go with a code block in Squarespace and just copying the code. And you'll see it automatically populates. Now, one thing is if you want to restrict how they can view the information, you can toggle off this show view controls button. And now you can see the controls at the top have been removed. Let me toggle back on. This right here, gets removed and the code itself does change. So fight already placed the first one and then realized I didn't want to give people the option to be able to change the view. I would have to copy it and go back and paste in the updated code. And now you can see it was removed. So that is how you embed things into your website. Embedding can be really great because it saves you time from having to duplicate information that's probably already in air table and adding that into your website. This way you just copy a snippet of code and it's going to be immediately available. 9. Making and Utilizing Forms: So now I'm going to talk about another one of my favorite uses of air table, and that's actually using their Form View type to create surveys and questionnaires. First, I want to talk about different ways you can actually use the forum feature and irritable. So the first thing is client or student onboarding. So if you're a graphic designer and you normally send a onboarding form to your new clients. You can easily do the same thing by creating a form in air table. And what's great about it is it will keep all the information that you collect from all your clients in one space. Next up, customer feedback. And this can be helpful for those of you who have a product-based business or a art-based business. So anytime I decide I want a little bit of information from my followers, I just create a form and air table and send it off. Next is a wait-list of some kind. It could be for an upcoming class you're creating, for coaching, or if you're planning a upcoming product launch. Having a place where you can gather all the people who are interested in hearing about it, makes it really easy so that when that happens, you have a list to pull from and immediately send that information to those customers. You can also use it for any type of submission, whether that's artists who are asking you questions, maybe in an upcoming class or Instagram or Facebook Live. Or for me, I have a monthly recurring feature on my educational site blog that highlights upcoming artists. I've built a submission form, IR table to collect all of that information. And finally, client or student testimonials. If you've been an artist for awhile, I probably don't have to tell you how impactful testimonials can be for your credibility as an artist. So if you have a place where you can collect all of those in one spot, again, irritable form feature is a phenomenal way to do that. Okay, so now that I've talked through the different ways you can actually use this, I wanted to demo how to build one from scratch. So the first thing you have to do, obviously is create a new table for your survey, but we need to create a form view. But before I do that, I'm actually going to delete these extra fields because I'm gonna be building everything in the form view. Okay, so now I'm going to click on form. The first thing you wanna do is name your form. So let's say I wanted to capture emails for an upcoming class launch. And you can see it automatically changed it here in the title. And actually, if I decided I wanted to rename this to just class waitlist, you'll see it automatically updates it there as well. So the next step is if you have information about the form that they're gonna be filling out, you would add it here, add a description for this form. So the next step is adding in extra fields so we can capture their email address. So you would go to add a field to this table and it will automatically bring up the field type. And so I'm just gonna put in email address, change the type to email address, and hit Save. Now let's say I wanted the email address to be at the very top of the survey and named to be after it. So to move fields on a form, it's very similar to on a grid view where you just click on that field and then drag and drop it where you want it, just like that. Okay, and then moving down, you can also update the thank-you message. So once someone presses the submit button, they would get a message. Thank you for submitting this form. But if you wanted to change it to something else, you could just update this text. So that's how you create the most basic of forms. But there's a lot more that this form can do. So let's do a little bit more customization. So the first is if you want to have a field that is required, so they have to answer it, otherwise they won't be able to submit the form. You just click on the one you want to be required. And then there's this little toggle on the right that says required and you just toggle that on. Next up. Let's say I didn't need their full name. Maybe I just want to know their firstName so I could go in here and make a change to the description text. And so one thing I wanted to call out here is when you update the description, it will not update the name of the field. So if you want these to be exactly the same, It's always best once you've made the change to copy and paste into the field and see now they are both the same. The next setting is help text. So just like the description of The page itself, it's sometimes helpful if you give them a little bit more information for the specific question that you're asking. Maybe it's something where you need them to give you a response in full sentences as opposed to a one-word answer. So you would just type in something like please respond in full sentences. Now obviously that doesn't make sense with the firstName. So that's not something I would obviously include here. Now beyond collecting a e-mail address and name, maybe you also want to get a little bit more information from them when building this waitlist. So let's say you wanted to give them a couple of options to choose from. So I would add a new field and then use either the single select or multiple select. So remember, a single select only allows you, or in this case them to choose one option where a multiple would allow them to choose as many as they wanted. So in this instance, I'm just going to choose, single select. And let's say I want to ask them whether they've taken a class from me before. So the two options here would be yes and no. When there are only two options, one thing I do like to do is update the colors so they're very different. And so let's make this orange. And so you can see they now have two options. Now, one thing I prefer to do is have this as a list as opposed to a drop-down, which once you've made a single or multi-select field, you just click back into it. And then it says right here show field as dropped or list. And so I'm going to pick list and you can see now it gives them the choice visually as opposed to having to click through the drop-down. Now let's say I wanted to ask them another question based on their answer to this. So if they answered yes, they've taken a class from me before, I'd want to ask a specific question and then if they answered No, I'd want to answer something else. So let's start with the yes. I would probably change this to long texts so they would have enough room to write. But because I only want this to appear if someone has chosen the yes, what I would have to do is go into this and see this show field only when conditions are met. I'm going to click that toggle on and then it will give you options. I like building these right after the question itself. So it will automatically have that as the chosen options. So have you taken a classroom you before and that condition is yes. And so you can see it updated right here to say conditional field. And if you hover over, it will show you the conditions that you've set. So I also want to do the same thing, but for no. So I'm gonna go back, show when conditions are met. I want to make sure I choose. Have you taken a class? And this time it's no. And so again, if I hover over, you can see it'll only show when someone chooses no. Now I'm just going to add one more question to this. And so that is how you build a form from scratch and it automatically will create a share link for you. So you can just click on this and preview what it would look like. And you can see that the conditional ones that we created for yes and no aren't there. So when someone clicks yes, you can see it pulled that in and then if I switch it to know, watch it change to the other question. But let's say I've decided that this is too many questions for them and I don't want to include this one in the survey before I send it out. So instead of immediately deleting it from the form, what I typically do is drag and drop it into here. And you can see drag and drop fields here to hide. So it will still live in this table, but it won't actually be visible anymore. And that's in case I decide to add it in later, I can do it without having to recreate it. If I go back to the preview, you can see it's deleted it. So you might be thinking, Okay, Awesome, we're done. I know how to make a form, but there's actually one more step that I want you to always do before you send out this link to your customers. That's to go to the Grid View and make sure everything is good. Because there is a very weird quirk when you decide to make changes to the order of the questions in the form view, it doesn't automatically change the location in the grid view. So that's actually why I moved the email address to the bottom to illustrate this point, if I go back to the grid view, you can see it's right where we originally placed it, which was right after firstName. So you would have to go back in and drag and drop it to the last question. Now this isn't a big factor if there are only a couple of questions that you're asking. But in a few instances, I've had ten or 15 question surveys that I've sent out. And if they're not in the right order before I send it out, I can get really confused when I go back to review the information I've been given from everyone who's taken the survey. So just remember to go back to the Grid view, change the order manually to be exactly what you see in the forum. I hope you enjoyed this demo on creating surveys. But one thing I want to make sure to drive home is having a survey is only good if you use the information. Now, since I don't actually have any information built in this demo, I wanted to go back to the air table survey that I actually created and show you a little bit more about how you can use the information and analyze the responses you've received. So the thing I used most when I asked you what you wanted to see in this new class, was the different options you wanted to learn more about. I actually decided to filter based on that answer. What I liked to do was while I was creating the filter was too look down in the bottom left and it will actually tell you how many records include that filter information. And so for creating surveys, Video, 35 people wanted to hear about this. And then I would quickly toggle on and off to see how many people wanted each of these. So sinking information was super popular, which is absolutely why I included it. So that was how I decided what to specifically include in this class because I filtered and saw how many people wanted each topic covered. Now, let's say I wanted to target people based on how often they used air table. So in that instance, maybe I would group them based on their answer. So grouping would be really helpful if you were maybe creating a waitlist or a database and you wanted to collect certain groups of people, this would automatically be an easy way for you to do that. So the big takeaway here is, once you have created the form, make sure that you don't let that information sit. I always want you to go back and actually look through and analyze the responses you received. 10. Information on business: Okay, so now that I've gone through the updates of my previous bases and giving you a little bit of information on new features I've started using a lot. The rest of this class is going to be focused on additional ways you can use air table for your creative business. Because something that I got asked a lot from my students was basically just give me more, Show me more ways to use the app. And so we're gonna start with one of my favorites for my business, which is just business information. And it's one base where I collect all the information that me and my virtual assistant use all the time. I'm gonna walk you through how I've set this up. So the first table is literally my most important info table. This has a ton of different information in it, from branding to code to copywriting, to links. And you can see on the left here, I have many different views and I actually have this specifically because certain views are actually easier for me to find the information than others. So again, I always advocate when you build something like this to start with a grid view that has absolutely everything and then you can customize from there. So first I'm gonna go to the important info view, which is actually a Kanban view. Kanban is not something I have really touched on in the past, but it can be really helpful in a number of different ways. And what I like about the Kanban view in particular for this table is it's a much more visual representation of the information, especially this first column here, branding. I use this all the time. And probably the most common thing that I use is the hex codes for my education business because I don't know about you, but how many times do you realize that you need a color from your brand color palette, but you don't remember exactly what that is. And of course, you can save color palettes in Photoshop and Illustrator. What about all of those non design times when you need those colors? So I just find it's so easy to keep one specific spot for all of the colors in my color palette along with their hex codes. And so anytime me or my VA needs this information, it's easy to find. Likewise, one of my other favorite things that I've added to this view is HTML and CSS code. Again, just like color hex codes, where I don't necessarily remember that information easily. I can't tell you how many times when I'm adding something to our website and I'm looking for a specific piece of code that I would usually Google every single time. Instead of doing that, I was like, why don't I add it into air table. So that's exactly what I did. And since this is the first time I've really showed you a Kanban view. I also wanted to show a few different ways you can utilize it. One is if you have a very in-depth project that you're working on, it can be really helpful, again to have a visual representation where all the information you need is broken up into categories. So e.g. my picture portfolio, of course, I built it so that each module is its own stack of information. So if I ever need to remember where a video is, I can come to this Kanban view and immediately see it. Then the last way I have used this and this is probably, I would say the most common way people use Kanban is for the status of either tasks or projects. So you can see here not started, written, recorded, edited, uploaded. This is actually for this class and you can see business information. This is the one that I'm working on right now. So once I'm done recording this, this will be moved into the recorded section. And that's the nice thing about the Kanban view is you can literally just drag and drop things into the new stacks and it will update the information for you. Okay, so let's move on and talk about the other views. So lnx is another one that I have. And to meet the GridView is the obvious choice for having a list of links. And so I have all of these broken up depending on the type of link. So for my website, for any newsletter lead magnets, I have Instagram, Facebook, other any thing that you log into regularly like my Zoom meeting, I use that all the time or my Google Drive main link. All of these things, you can add a section just to keep track of all the links that you commonly find yourself going too. And then I also have an option for affiliate. So if you're someone who likes to make some income from affiliating for products or companies and you want a place to store all the information. I highly suggest you build those links and your important info in air table. The important info table is not the only one I've built here. And so I wanted to show you the other ones that I have and why they're useful. So the next one is Google Drive. And I've started using Google Drive because when I hired a VA, It was a lot easier for us to store massive amounts of information using Google Drive so that she could access it as well as opposed to it all being on my computer. And what we found was it was a lot easier to have a place where all the links were stored inside air table because it meant we can immediately access it as opposed to logging in, finding the right folder. And so having a place where it's all together in air table with all of our other important information is really useful. Next is idea bank. Now this is specifically for my education business, but you can use this for your creative business as well. So anytime you have idea that you think of, like I said, a lot of times I think of these when I'm falling asleep in bed, having a spot where you can immediately jump on your phone or iPad and add it in so that when you wake up tomorrow, you don't go, oh, shoot. What was I thinking? And for Skillshare, e.g. I'm always thinking about the next class I want to build. And so you can see at the top here, all of these are class ideas that I've thought about over the past year or two. If you're using this for your art business, maybe this is just an idea bank for ideas for designs that you want to add to your portfolio or your product catalog. Basically, anytime you think of an idea, put it in your table, next is hiring. And I'm not going to show you that one only because there's a lot of personal information from people that have submitted their information to me. But it's basically if you ever want to hire someone and you want to collect the information of all the submissions you get. Air table is a phenomenal place to do that. So that's what this tab is. But the last one and this is a recent addition for me is visual assets. So I'm actually right now in the process of doing a slight update to my educational business branding with a graphic designer. And so I thought it'd be really useful to have a place where we could store all of the visual assets. Once we're completely done with the brand refresh, this will be completely populated with all the imagery. So if me or my VA ever need something, we can immediately go here and find what we're looking for. So that's just some of the ways I've used air table to collect the most important information for my business. And I highly suggest if you find there are certain things that you go and look for time and time again that you consider adding a table to collect all that information into air table so that you don't have to continue looking for it again and again and immediately can find what you're looking for very easily. 11. Work Calendar: So next up, I'm going to show you my business calendar. This is a little bit different from my projects calendar because beyond surfaces on projects, especially once I built my education business, I found a lot of my to-do items on my to-do list. We're outside of surface design. I wanted one calendar to be able to house all of my regular to-do list items. So if you're doing things outside of freelance projects with clients, I highly recommend having a business calendar. Here is the first table that I have, which is my admin calendar. It is the thing that me and my v a share. And you can see a bunch of different views. But the ones that I use most frequently is my calendar, which are specifically my to-do list items. And then my VA Jenna has her own to-do list. And the way I'm able to create those different views is by using the collaborator field types. So under task owner, you can see collaborator right here. And what's awesome when you have a virtual assistant or a team, or maybe a group project that you're working on. Having everyone in your calendar as a collaborator really helps for communication between the group on every different task. So anything that I'm working on, I can immediately assign it to Jenna and it would switch into her view. So she knew that she was assigned a new task. Also, one fantastic thing with calendar view is the comment field, which this is actually built into every single record. You have an irritable, but I primarily use it here for the calendar. And so all I would have to do is type in a comment. And once I hit Send, you can see it's saying that my VA will be notified, so she will actually get an email notification anytime I add a comment. And the same thing happens when you switch them as a task owner. If I switch this from me to Jenna, she would get notified that she now owned that task. So let's go back to the admin calendar. And so there's a few other things I wanted to call out. I also include a Google doc link and an air table base link inside my admin calendar. Because anytime we have something that's related to a document or another air table base that we've created. It's fantastic to put those links in here. So when I'm starting a new task or when Jenna is starting a new task, we can immediately click on this link and start the task immediately instead of having to go hunt for that information. So if you use a different app, maybe use Trello or Asana, you could do the same thing. And then obviously notes and end date. And another thing that we always include is an Images section. We don't always need them for every task, but when we do, It's really helpful because it allows you to share assets. So here, e.g. we created a surface design survey at the end of 2020. And so Jenna was tasked with creating all of the infographics for it. Well, what she would do is every round she would put a new set of images in here for me to review. What's amazing about this. This is a new feature that air table added is if you click on an image, if you wanted any updates, you can see these little boxes. All I had to do is drag and drop this section I was specifically talking about and then give her information on what I wanted changed. And so this is a wonderful way to record the changes you want very easily without having to use a secondary app or jump on a call and demonstrate it for them live. So it's a real timesaver. These image comments were exactly like a task comment. So these will be sent to whoever is assigned to the task. That's the basis of my admin calendar. So you might be wondering, well, what's the master calendar about the master calendar instead of daily tasks? The master calendar is for any event. Meetings that I have, recurring tasks, big deadlines. You can see I have a photo shoot coming up with my photographer. I'm gonna be out of office. All these things to me are really helpful to have in a separate place, still within my business calendar base, because then I can easily go back and forth to know when to assign tasks to myself or my BA. Now one thing I did want to call out here is that my business calendar is part of a workspace that is on the Pro plan. And so what you're seeing here looks a lot different than what you will be able to do if you only have a free plan. The free plan, unfortunately is very limiting when it comes to the calendar view. So here, e.g. this is my projects and submissions calendar I showed you earlier and you can immediately see the differences. The first thing right off the bat, you don't have the option to add color. You have to upgrade to the pro plan in order to be able to see multiple colors. Personally, I have found using color based on the task type that I'm using to be very helpful. So that is one negative about using the free plan. And then the other thing is you might notice again, when I'm out of office here, it's on more than one day. But with the free plan, you can only have tasks that are on a single date. So you can't actually build something that straddles more than one date on the free plan. So those are just two call-outs I wanted to make. If you're interested in using the calendar view, much like I have the master calendar, it might be worth it to upgrade to the pro plan. 12. Calendar for email marketing: So the next base I'm going to show you is email marketing calendars. And I probably am not the first one to say to you that having a newsletter for your creative business is incredibly important, especially because it's still the best way to reach out to your customers and clients directly. But I also know that tracking all the information of your newsletters can be a bit a pain. And I used to use Excel to house all of that information. But now of course, I'm using air table. And since then, tracking the info has been a lot less of a pain, especially because I have two newsletters. The first is my art newsletter that I sent directly to art directors that companies, and my educational newsletter for my students and community. And I'm going to show you how I created both of them. The first one I'm going to show you is the Art Newsletter because it is a much simpler version of an e-mail marketing calendar. So this base is pretty straightforward. I have a table to collect all my newsletter information and then I have a separate table for all of my available designs. And if you notice, it has a little succinct lightening bolt, which means this is a sink table and it is linked from my portfolio and contracts base. And I specifically use the available designs view when I select it. So it would automatically remove all of the purchased designs from that list because obviously I would not be sending designs that have been purchased to companies. You'll see why I included this in a minute. So the first field I always like to start with is the date. One thing I like to do is actually have it sorted by the latest date first. And the reason for that is when I go to add the next month newsletter, Let's say I'm adding in July. Once I've added in the date, it will automatically move that to the top, which means it's a lot easier to view quickly. Next step is the subject line. I always like to keep track of it just to make sure I'm not using too similar of words or phrases in the last few emails. The next column is the designs columns. So my art newsletters are pretty simple. They basically have a little snippet of copy at the top. And then I include three to four designs from my portfolio that are available to license or purchase. And that's why I've included the designs column because when I go to create my July newsletter and I decide what designs I want to use for it. I'll just click the plus sign and start typing in those pieces from my portfolio. And you can see as I was adding those in, it automatically pulled the images of those designs into the next column, which is thumbnails. And the reason for that is that this is a lookup field. So if you remember in a previous video where I showed you how the lookup field works. This is just another reminder that you need to make sure you include something that links to that table first and then you can come and create the lookup field. So I have this looking up from the designs that column, and I'm pulling in the thumbnail images from that artwork. So that's why if I wanted to put in a new design, let's say my autumnal owls piece, it would automatically make that change. So to me, this is probably my favorite way I've found to use the lookup field type. Then the last two fields are pretty straightforward. The first is a sent to. So I do like to keep track of how many people are receiving my emails and then also my open rate. That is the most basic, I would say, newsletter format in air table. And this has been a wonderful addition that I've added pretty recently. I basically started at the middle of last year, even though I have been sending newsletters for over five years. And I will definitely say this process has gotten a lot quicker. But like I said at the beginning of this video, this isn't the only newsletter I send out regularly. I also have an educational newsletter that I send out to students and my community. And I will say that my educational newsletter is this table, but on steroids. And now you see what I mean. I added a ton of additional information into my educational newsletter. So you can see right off the bat, it is configured a little bit differently. Instead of starting with the date, I actually start with the campaign name. Now this isn't something I use for my art newsletter because I send my art monthly. I just named the campaign the month and year that I'm sending it. But for my educational newsletter where I'm sending out at least one email a week. It's very important to have a campaign name. Now I use active campaign for my educational newsletter. And because it's more than just me now, I have a VA who helps me a lot with sending newsletters. It's very important that we have campaign names labeled correctly so that we know exactly which newsletters are which. So the next column is the date column. Just like with our newsletter, having the date column is very important. But I also occasionally will send newsletters at specific times, especially during course launches. So I also include the time here. Now, in order to add the time to a date field, all you have to do is click this toggle field right here, include a time field. And you can decide whether you want to be on a 12 hour or 24 hour clock. Next up is my segment column. Now, for those of you who aren't very familiar with e-mail marketing, segments are a great way to break up your email list and then send them more focused email campaigns. Now segmentation isn't something you necessarily need right off the bat if you're just starting a newsletter. But as your list grows, I highly suggest you consider it. The next column is status because it is more than just me handling my e-mail list. We added a status column because I typically will write the emails but might VA is responsible for scheduling the emails and then making sure they go out. The next column, again, subject line, just like my art newsletter. And then the following one is link to Google Docs. So this is very similar to how I use link to Google Docs in our calendar because we lean on Google Docs so heavily and we actually create all of our email text directly in one document. And one reason I specifically love using it for my newsletter is if you create headings inside Google documents, it will actually create a unique link. And so we do that for every single newsletter. So I just copy and paste this URL. And so when my VA is going to create the e-mail inside active campaign, she can immediately click this link and find the exact copy of the e-mail she needs. Very similar to the Art Newsletter. The next two is sent to and the open rate. But I also include a column for click rate. It's not something that I find very important to me for my art newsletter, but it's an extremely important for my educational newsletter. And for those of you who maybe you have a product line or you're an educator yourself. Having the click rate information is incredibly useful to you to know how well your emails are performing. The next column is unset, which is to track how many unsubscribes we're getting to each newsletter campaign. This is useful because sometimes you'll see unsubscribe rates that are higher than others and that might also inform how you create future newsletters. Now, one word about unsubscribes, these are not a bad thing. No matter who you are, you will get unsubscribes. And the more people you have on your list, the higher your unsub rate will be. And that is okay. So that is how my education newsletter is configured. And again, I know this was a lot more than my art newsletter, but I wanted to show you the simplified and more complex versions so you get an idea of what pieces of both would work well for you and your unique email situation. 13. Market research: The last base I've decided to share with you is my marketing analytics space, just like email newsletters being important. So is tracking your marketing efforts. Because if you don't track the stats of the different marketing channels you use, at least on a monthly basis. It'll be hard to know how well each channel is working for you. Because I'm such a big believer in goal-setting, having a way to track my growth over time and be able to set more realistic goals for myself down the line is incredibly helpful. So on the first of every month, I spend an hour or two cataloging the status of each major traffic avenue that I use. For me. What that means is first and foremost, my website. Next is my e-mail marketing, Instagram, because it is by far my favorite social media channel. Now I also have a Facebook group. And finally, I also like to track my Skillshare numbers. So that's my list of marketing channels so that I track. But just because that's what I use doesn't mean that's what you use and yours are probably going to look a little bit different than mine. Maybe you want to track LinkedIn or Pinterest metrics. That's totally okay. I just wanted to give you a starting point to show you what's possible. So I include a lot of the same information for each table. So I figured it would probably be best not to overwhelm you with all of them and just show you one. So here is my Instagram table. The first column is the written out month and gear, and the second column is a date column. And you might be wondering, why do I bother including both? Well, I include the written month because it's much easier to read, but I need the date column in order to use a pro feature functionality that I will show you at the end of this video. Alternatively, though, if you wanted to do a date format that had the month included, you could do that. Instead. I just prefer to have both. The next column is channel. This is probably something that you won't have to use. I personally at this point, have two separate Instagram channels. One is my sketch design, repeat Instagram, and the other one is my personal Instagram. So I like to have this included. So again, I can have multiple views for each. Next step is pretty straightforward. It's the followers field. So the first of every month I will go into later and whatever it tells me what my number was for May 31st, that is what I would add in on the 1st of July. When I go into add June's numbers, I would log into later, see what it was showing me in the analytics and type in that information. And you'll see when I add in that information that these two columns to the right will automatically update. And that's because they use the formula field. Now before I go over that, I do want to mention one field that I have hidden, and that is the last month's follower number. And it's because I need to pull last month number in order for the function fields to work properly. So I usually copy and paste last month's number into the appropriate column where it says last month's followers. And I just like to keep it hidden as opposed to out because it's just a little bit more clean. And you can see when I did that, it made a major change to the functions and now it's working properly. So I do want to mention before I talk about this that I only recommend formulas for very advanced air table users. Because to be completely honest, I still don't completely understand the more intricate formulas and have even on occasion asked my husband for help because he was always an Excel function spreadsheet not so I had him actually build the percentage field, but I can show you how I created the number field. I'm actually going to delete this and then redo it. So the first thing is I need to find a formula because we're just dealing with numbers and not percentages. This is fairly straightforward. If you want to dip your toes into using the formula field type. This is what I suggest, because the number that I'm looking for is this month's followers minus last month because I want to see how many new followers I have. And so to do that, I'm going to find the followers because that is my current number and click on that field and then minus last month's followers. And this is why it's so important to include the last month followers as part of the table. And then press Create Field. And so that's how you recreate it. Now you may be wondering, well, the number is here in maize followers. Why can't I just pull that number into the function for June? Well, that is one major difference between how Excel works and how air table works is you have to have everything completely contained in a single record. So that's why I have to basically duplicate this information in as last month followers. And so that's why I included this as a separate thing because you can only do a function based on the information in a single row. Now, functions Something I am trying to get more familiar with. And if you would like to learn more about how to build your own formulas, I have included in the about section of this class a link to IR tables resource guide specifically about formulas. Okay, let's move on. The remaining fields that I have here are all based on the information that later provides. So depending on what analytic information you have, you might not have all of this. But for me, I like to track as much information as I can. So if that means reach impressions, link clicks, profile views. And then anytime I'm provided with visual data, I find it really helpful to also include an attachment field. And so in the case with Instagram, one thing that later does at the bottom of their analytics is it gives me the five most engaged posts of that month. And so I always find it really useful to screenshot these and then upload them to air table. Because when I'm building future Instagram post, I like to look back and see what posts are having the most impact. And a lot of times, it can be really helpful if I have all of that historical information here. I do this also for my website stats because I get monthly emails from Google Analytics. So I think it's really helpful to screenshot and upload them here because I don't want to have to sift through a ton of different emails to find that information. So at the end of the year when my VA and I are doing a recap and planning the next six to 12 months. We can easily find the information we need. So one last thing I wanted to show you is perhaps my number one favorite thing about being on the Pro plan. It's probably the reason I finally decided it was worth paying for. And that is their apps feature. With air tables app feature, you can include a lot of different information inside your bases. I have found this especially helpful for the chart, which is what I love to use it for with my marketing statistics. So I'll pull this out here. And you can see I've created charts for my Instagram followers and my Facebook members. And I actually have several versions of this. So I have another one for website and email marketing and Skillshare. And because I'm such a visual person, I love using charts. So let's say I wanted to update the number for June. Watch this after I've made the change. It automatically updates it based on the information. So having apps isn't an absolute necessity, but if you're a very visual person and plan on using air table for the long haul, it might be worth it to upgrade to the pro plans so that you unlock this feature.