Creating your first base

Welcome back.

I'm really excited for this lesson because in this one we're actually going to go ahead and create our first base and start using a table for real. So our first example that we're going to go through and use for the rest of the section is creating a candidate management pipeline in our table. So imagine I'm a hiring manager and I've got candidates coming in for an open finance manager position. I'm going to use our table to manage all of the people applying for that open role. So by the end of this lesson we're going to have the beginning of that hiring pipeline created. And while we're creating it I'm going introduce the concept of field types. Field types are how you manage data in our table and we're going to explore four of them.

So the moment we've all been waiting for let's actually go ahead and create our first base we are not going to start with a template. As I've talked about before we're not going to import a spreadsheet. There is a lesson later on about importing spreadsheets. We're going to start from scratch. So every time you create a base or two was going to ask you to name it let's go ahead and call it a candidate hiring. Let's give it a pink color. An icon.

So here we are we've created our first base.

Let's take a moment to explore how this works. So every base is composed of tables. I can have multiple tables. And each one of those tables has records. And we put information in the cells of that record and then each one of those cells is part of a column. So what you need to know is that every base is composed of tables. Those tables are composed of rows or records. And in each record we put information into cells and the structure of those cells is governed by columns.

Now that may sound like a bunch of mumbo jumbo. Don't worry about the vocabulary. I'll be using that vocabulary throughout and you'll get used to it as we go along.

So let's start configuring our table to be able to start adding candidate information to it. So how that works in error table is that each column has a field type. And I'm going to go ahead and start constructing my table. And as I do I'll be showing you various different types of field types. So you'll notice that there are a lot of them don't worry we're going to take a few lessons to go over the most important ones when working with only one table.

So how I want to start is I want my first column to be the name of the candidate. And in this situation we're going to use a single line text which is just a short piece of text which is appropriate for someone's name. So let's go ahead and fill in John Smith.

And the second I want to use is a status. So what I mean by status is that candidates that are new that have just applied for the position are going to be named as new. And then we're going to decide whether or not we want to interview them. And there's going to be a status that is interview if we don't go ahead we're gonna put them in the rejected column. And if they go to the interview they're going to have a second interview and then they're going to be hired if they pass that stage. So what I want this field to do is allow me to select one single status among a bunch of options. And so in every table that is a single select. And so once you create a single select it will ask you what options do you want to give. What possible statuses can this field take. So new interview second interview hired and then rejected.

The third field is going to be their e-mail. Now our table conveniently allows you to select email as a field type.

So now we have their name their status their e-mail the next column we're going to add is the date or the time at which this candidate was added to our list. So this is a created date field type and this is automatically generated whenever you create a new row every table will remember the date at which it was created and allow you to use that as one of your columns. We're going to use this to know exactly what time this candidate was added to our pipeline. And so we're going to call it the date of entry. I'm not going to add to the time I'm going to save it and I'll automatically populate for our whole table.

So now I have name status email the date at which this candidate was added the last one. I'm going to add another date field which is going to be date of interview for now the all the candidates we have are still in the news status. So I'll leave this one empty but I'll show you how it works. So you just double click and then you could have a calendar selector.

So we have the beginnings of our hiring pipeline name which is a text description. And we have status which is a single select. And it tells us where in the pipeline our candidate is their email. That's self-explanatory. The date at which this candidate was added to this table and then the date of interview which will set. Once they have an interview date.

So that's what I want to show you for this lesson in the next one. We're going to go ahead and complete this table with other field types.

Up next

Completing the base