this is a full tutorial where I describe to you first what air table is and then go into how to actually use it I even made this handy table of contents that you can use to reference later airtable has incredibly passionate users but if you ask one of them how it actually works you often don't get a very satisfying response so first and most importantly why is airtable so special it's actually because it has a talent that we as humans are also quite good at I'm talking about the human ability to understand relationships think of three of your friends who have a dog even by trying to think of friends with dogs you might have thought of those three firsts because they were related through other similarities like maybe they're friends with each other or they live in a similar place it's pretty cool that you can call up all of these people and categories so quickly but if I ask you to list every single brunch you've ever been to with those friends you'd probably be a lot less good at that and that's where a spreadsheet traditionally really shines a spreadsheet can hold a whole big list of tiny details but a spreadsheet is generally just good at holding one type of information so for example like every line is one brunch if you wanted to record information about your friends that would be a new tab or a new table and information about their dogs would be a third tab airtable is the Goldilocks in this scenario because like you it understands relationships but like a spreadsheet it can record all of those tiny details relational databases like airtable are not new they're the basis of pretty much everything on the internet but airtable is the first one of these that is easy to use as a spreadsheet it even looks like a spreadsheet but it's better let me show you how airtable actually works and we're actually going to use the friends and brunch analogy except because you're probably using airtable for work let's say that those friends are actually clients and the brunches are meetings that might turn into a sale what you're looking at here is my airtable workspace and a workspace is basically like a folder that holds all of your airtable databases or bases for short if I wanted to create a new base I could click this little button here to create a new base for this tutorial I actually created a base for us already and put in some example data so I'm going to open it up by clicking this juliancrm and you can see that I already made a table for clients one for meetings and one for the client's dogs if I wanted to create a new table like I did for these three I would click this plus button here and click create a blank table now airtable is set up like a well-designed spreadsheet and what I mean by that is there is one line of headers here and then each row or record is a new line of information or package of information that starts with this leftmost column here which identifies kind of what that line is about so in the example of clients this is a client right so we've got the client name here and then we've got identifying information about the client to the right and then when we go to the next line that is a new client in airtable a column is called a field and a row is called a record you also specify what type of data each field is so for example this first name field here if I open it up I can see that it is a single line text field and over here the birthday field is a date field meaning I can actually double click here and use this date picker to pick a date or I can just type it as well airtable even has attachment Fields where you can actually drag and drop something like a picture into a cell and so we're going to use these pictures here that I've dropped in later on when we build our interface to build client profiles where we can actually see their picture attachment fields are also super useful for holding things like invoices or receipts if I want to create a new field I would click this little plus button here and then I could name the field and pick the field type and we'll do that for a couple Fields later in airtable we can also write formulas so this name formula all the way on the left here is a concatenation of the first name and last name with a space in between and so this formula once we pick formula type it gives us this little window here where we can start typing and in the air table a column is applied to an entire field or an entire column and one of the benefits of that is that we can actually use the field names in our formula so instead of using some confusing coordinate like C5 we just say I want to take the first and then a space and then last name if I click save then I've got the person's full name so that's our clients table here and if I go into the meetings table you can see I've got a date and a location of the meeting and I've done the same thing here that I did in the other table I concatenated these two things together to get a more unique identification of each meeting once we've linked this table to the client and then in the dogs table we've got the dog's name and then the type of dog and this is where things start to get interesting because now we're going to establish the relationships between these three tables so if I go into clients here I'm going to create a new field this field is going to be called meetings and I'm going to click this first option link to another record and when I do that then it gives me the option of the other tables that I can link to so I'm going to click meetings here and I'm going to allow linking to multiple records meaning yes one client can have multiple meetings associated with them and then I will create the field just skip this for now and what that's done now is if I go ahead and click this little plus button within a cell for Danny Rojas then it gives me a list of all of the meetings in the other table and so now I can just say okay I know I met with Danny on 816 and also on 8 13. when I go over into meetings here on the flip side of that I can now see for both of these meetings they're associated with Danny Rojas and it's worth mentioning that just like you can have multiple meetings per client you can also have multiple clients per meeting so for example if I wanted to add a client to this meeting that I had on 8 16 I could actually do it I could do it here or in the first table but here I'm going to add Keely to the meeting and so they're they're both here on this meeting and then if I go back into clients I can see that keeley's got this meeting associated with her now so I'm going to go ahead and fill some more of these out so that every meeting is associated with a client and then we'll move on all right so I'm gonna try to make a little bit of room here so we can get in our new fields that we're going to add so next of course I want to establish the relationship to the dogs every client's got a dog so we're going to go in here and I'm actually just going to skip field naming even because if I click link to another record and then click dogs again I guess I can allow linking to multiple records in case someone's got multiple dogs if I hit create field airtable is pretty smart I can skip this step it's gonna automatically name the field dogs it knows that that's probably what I was gonna name it now I can see the list of all the dogs and I'm going to go ahead and Link all the dogs up so the last thing about establing relationships is that they can allow us to aggregate important information when we want it for example if I want to know in this table for some reason what kind of dog each client has I can go ahead and just create a look up here and so this is going to be called let's see dog type and it's going to be a look up field type if I choose dogs here it's going to look up and it gives me the option of which linked record to look up from and then I can choose the field that I want to look up so in this case it's the type if I hit create field here it's going to now pull in all the types of the dogs leveling probably more importantly I could use this to say look up the last date that I met with a client so if I want to do that I actually would use a field called a roll up which is used basically for looking up information when you know that there are multiple values and you might want to average those values or get the latest of those values or pick one out of a bunch of different options this is going to give you so in this case I am going to call this latest meeting and then I will start typing roll up here to find my roll up field type and so the roll up field type also asks me to pick which linked record I want to look up so I'm going to go to meetings here and then I can choose the date so looking at the date in the linked meetings and here you can see that actually guessed which formula I wanted to use with a roll up we use a formula to tell it how we want to aggregate the data and it's wrong I don't want to use oreganique array unique would give us all the unique values meaning in this case all of the unique dates that we've met with that particular client what I want is the latest one so what I'm actually going to use is the max function and for any of these functions values just lowercase values represents the the information that it's sending to us that we're going to aggregate so if I type this Max here with values in parentheses hit create field it's going to give me the latest meeting I had with each client pretty cool right by the way sometimes I might want to just see a subset of this information and in a spreadsheet often you kind of copy the whole table paste into another table and then sort it and maybe remove the stuff you don't want to see in airtable we create a view for that and just filter it so for example let's say I only want to see clients who have a sheepdog I'm going to click this little grid view button here to create a new grid View call this people with sheepdog create new view and then I'm going to go ahead and filter where dog type has any of sheepdog now I can see just the clients with The Sheepdogs here and these fields if I edited them are still going to edit the same data right it's all the same data we're just looking at a different way if I change Jamie tart's birthday to March 30th rather than 31st if I go back into the grid View than uh his birthday is changed here as well let's change it back to his real birthday you can see that over here we've got a number of really useful views the one other one that I'm going to call attention to in this tutorial is the form view let's say you have a colleague who is often taking notes and recording information about your meetings you might not need to give them access to this whole base but you want to have a way for them to enter that meeting info and have it end up here so if I click this form View and create new view here it is going to automatically create a form for me with all of the same fields and now you can probably get an idea of why they're called Fields because we we use them in different contexts not just as a table but it's already created this nice form for us and when they fill out this form that information will just end up as a new record in your table so in this case I think that all of these fields are probably useful although you know are they going to have the picture when they entered in maybe not so maybe I'll remove picture here and I'll let them fill out the rest in order to share that with someone I would just click this share form button here and then I can copy this link and if I were to actually click this this is what it would look like if your colleague opened it up and filled out the form one other advantage of form views is that you don't need to be logged in to fill out this information so this person does not have to have an airtable account they can simply click a link anyone can click a link and then fill this out and hit submit and that information will end up in the table now I want to pause for a second because you could get a lifetime of value out of just the features that I've showed you so far and as a beginner I encourage you to start simple and to just start using something that you're going to get a lot of value out of so if this sparked a cool idea for you by all means go create your idea you can always come back and see the rest of the features but I do want to make sure and include these other features because the stuff I'm going to show you next is really so cool so the next thing I want to do is I want to use this setup to actually save me time at work and automate some of the processes that I have to do manually right now and the first one one of the really low hanging fruits here is following up with client after the meeting so if I go into the meetings table here I can see that I've got the date of the meeting and it would be really cool if two weeks exactly two weeks after every meeting I had with a client airtable automatically emailed them for me just as a follow-up maybe thanking them for their time or so we can keep the conversation going so in order to do that we need to get all the information we want into this table and then we're going to create the automation actually clicking the buttons to create the automation is probably the easiest part of this but we always need to do a little bit of setup first to make sure we have all the info we need so in this case we've got the date of the meeting we're going to need to calculate the date where we send the email which is two weeks after this date and then we also need the client's email address and we might as well pull in their name as well so that we can address the email to them so let's make some room here and the first thing I'm going to do is create our date field so this is going to be a follow-up date and we're going to create a formula here and the formula that we're going to use is called Date add so if I start typing date add it's going to pop up from here and the date add function takes a date time which is what a date field is and then we give it a number so in this case it's going to be 14 days and then a unit we also could do two weeks but I'm gonna do 14 days so let's go ahead and start typing date here this is how we actually specify this date field here we can just type it in and then when I click it you can see that it's purple so the green is for the function purple shows you that you're referencing a field in the table and if I hit comma here I can now say 14 comma and then within quotations and you can use either single quotations or double quotations I like to use single ones because it's only one button to press instead of two and I'm going to say days here and then close the parentheses and if I go ahead and create the field it is going to give me two weeks from that date now it by default gives you a time as well if I want to get rid of that time I can go into the formatting here and then untoggle this box that includes the time click save so now I've got my follow-up date here I want to bring in the client's email address and their first name so let's go ahead and create a lookup field this is going to be called email or maybe client email and it's going to be a lookup we'll look up in clients email address create field remember that we sometimes have multiple clients per meeting and so if we create this role up here it's actually going to put multiple emails for us which actually will work in this case if I want to send an email to both people at once which is how we'll set this one up this will work this way if we wanted to send individual emails we can also do that but we would set it up differently and then lastly we are going to get their name so we'll do client first name and I'm going to create a lookup in clients first name create field and so in this case you know we're going to create an email that's gonna be addressed to so it's going to say Hi Sam or it's going to say hi Danny kamakili I think that's good you know again we could set it up so that it's emailing people individually and then it would just say hi Danny following up with you but in this case I'm going to roll with the group emails here so up at the top here I also want to Now call your attention to these three pills here and these pills are really cool because they really show you kind of like the overarching structure of air table and how there are really three pillars of how this whole system works we've got data which is what we focused on totally so far right this is your database your structure your relationships and if you think about actually like what it takes to create software because I didn't want to freak you out at the beginning but really what airtable is for ultimately or what it allows you to do is to create your own application create your own software and the three things that you need to create software are data logic and a graphical interface and that's true if you think about any app you use you have a graphical interface with just say a Google search so you have your Google search bar then you're going to type in data and there is logic behind it that is then going to go find the results that you're looking for and then display it for you and where it's going to find the results is the data layer so obviously that's a much more complicated version of this but in this case we're doing the same thing so we are now going to move on to our logic and an airtable logic is automations I would also count formulas as logic but they've set it up here I think really so that we can think about it in this way and so I'm going to go ahead and click on the automations here and any automation that we use starts with a trigger and then it has actions that we're going to take so in our case the trigger is going to be when the date that two weeks later date matches today's date and so I can do that by actually let's name this first this is going to be two-week follow-up and I can go in and add a trigger here and the trigger is going to be when record matches conditions which then allows me to go over here and pick the table so I want to look at the meetings table and then when the follow-up date is today it's going to trigger this automation so now that I got my trigger I can add my action and in this case the action is to send an email you can see other actions are create a record update a record find records and we can even run scripts connect with other applications like slack and Microsoft teams so there's lots of options here in this case I we actually can send an email that goes from airtable so it comes from an airtable.com domain but we can also link it with our Gmail account and send from our Gmail account this is also more compatible with the free plan and so if you're starting out with a free plan the Gmail option is a good option I'm going to go ahead and use it so if I click this send email here then I can connect it I've already connected to my account so I can just select my account here and this is where I can then dynamically use those details that we set up so the to field is going to look in that record that matches the conditions from the trigger right so basically anytime we use this little plus button here to take what we call Dynamic information that's coming from somewhere else we have this used data from window which shows us where it came from so what I want here is the client's email address so I just start typing email and now I can see this client email that we set up before and then I want the value just meaning like the text value of that email for the subject I'm going to say checking in and then in the message I will say Hi and then I want their first name so I can go in here and find the first name client first name comma it was great to see you a couple weeks ago I'd love to meet again soon pass Julian and that's it we've created our automation I can go here and generate a preview which is then going to ask me to run tests and actually pick an example record so I can pick this this record because it actually was two weeks ago and then it's going to run the tests here and then show me what the email will look like so we can see this particular one is going to go to three people Danny Rojas Jamie tart Rebecca Welton and then it's going to say hi Danny Jamie Rebecca it was great to meet you a couple weeks ago love to meet again soon looks great to turn this thing on I just click this toggle here and this will now send an email two weeks after each meeting in the system so now that we're saving all that time I also want to just design a much nicer way to look at my clients information because you know spreadsheets are great but let's be honest this is not the most pretty way I can look at this information so I'm going to go ahead and create an interface here by clicking this interfaces pill click Start building say this is client dashboard go ahead and click next and I am going to use we've got lots of different options of how we could set up our interface and layouts I'm going to choose the record review layout click next gives me options for how to initially sort the information I'm just going to go ahead and click next and then let's see what I want to keep in here I want to have their name their picture don't need first and last because the name already has that in it email address is good let's say birthday dogs latest meeting and I'm going to go ahead and click next here and lastly it's going to ask me for the page name and this is because when you create an interface you can have multiple Pages for that interface and so this one let's say client summary go ahead and click finish and man that was just so quick to get to this minimum viable product here that we've created and of course we could create a lot more pages and different pieces to this but if I just go ahead and click publish now I've got this nice format here where I can see each person and I can see the information about this person the latest meeting I had with them Etc and you can see that these things are currently not editable but if I actually go back into edit and then I click on these here and on the side I toggle them to be editable so I'm going to do this with each of these things for a linked record that means it's going to allow users to link existing records and for latest meeting of course that's not editable right because that's a calculated field so now if I go ahead and publish I've got this nice format here but then if I wanna update healy's email address I can go ahead and just go in here and change that interfaces just like the data layer can be used to create forms as well so if I actually go back into edit again one other really great enhancement I can make to this is if I click on my record picker over here I can then scroll to the bottom here and allow users to create new clients and that's going to create a form for me here that if I go ahead and publish I can now click this little plus button or someone else who's logged in and then they can fill this out to create a new client so I think I've given you enough to chew on for one lesson I'm going to go ahead and go back to our data layer because this is really you know where things start and where we want to Anchor ourselves so should you use airtable in your business if there's a tool out there that does exactly what you need you'd probably use just that airtable is for people who need more flexibility it's about creating your own software that meets your own unique needs and typically in the past that function has been served by spreadsheets because if you're a really large company and you have a huge budget you have the ability to really to hire engineers and create custom built software for your application but most teams or even teams within those large companies who need to move faster will create their own systems with spreadsheets and airtable is now a solution that sits in between the spreadsheets and the custom code because it is much faster to iterate with than the custom code you can see how quickly we just set up the system that we just did but obviously it is much more structured and has many more features than you get out of a spreadsheet so if you like this video and you want to learn more check out my channel for lots of specific build tutorials on how to create a really great inventory system in airtable how to use it for hiring for collecting RSVPs lots of different specific use cases and if you're a part of a business who could use professional help in creating your airtable systems or maintaining them I also offer services for that and you can learn more about those services in the video description below so I hope you have a great time exploring airtable and I will see you next time