So that's what I want to show you for this lesson in the next one. The date at which this candidate was added to this table and then the date of interview which will set. And it tells us where in the pipeline our candidate is their email. And we have status which is a single select. So we have the beginnings of our hiring pipeline name which is a text description. So you just double click and then you could have a calendar selector. So I'll leave this one empty but I'll show you how it works. 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 now I have name status email the date at which this candidate was added the last one. I'm not going to add to the time I'm going to save it and I'll automatically populate for our whole table. And so we're going to call it the date of entry. We're going to use this to know exactly what time this candidate was added to our pipeline. 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. 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. Now our table conveniently allows you to select email as a field type. The third field is going to be their e-mail. So new interview second interview hired and then rejected. What possible statuses can this field take. And so once you create a single select it will ask you what options do you want to give. And so in every table that is a single select. So what I want this field to do is allow me to select one single status among a bunch of options. 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. 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 then we're going to decide whether or not we want to interview them. 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. So let's go ahead and fill in John Smith.Īnd the second I want to use is a status. 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 how I want to start is I want my first column to be the name of the candidate. 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. And as I do I'll be showing you various different types of field types. And I'm going to go ahead and start constructing my table. So how that works in error table is that each column has a field type. So let's start configuring our table to be able to start adding candidate information to it. I'll be using that vocabulary throughout and you'll get used to it as we go along. Now that may sound like a bunch of mumbo jumbo. And in each record we put information into cells and the structure of those cells is governed by columns. Those tables are composed of rows or records. So what you need to know is that every base is composed of tables. And we put information in the cells of that record and then each one of those cells is part of a column. And each one of those tables has records. Let's take a moment to explore how this works. So here we are we've created our first base. 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. There is a lesson later on about importing spreadsheets. As I've talked about before we're not going to import a spreadsheet. 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. Field types are how you manage data in our table and we're going to explore four of them. And while we're creating it I'm going introduce the concept of field types. So by the end of this lesson we're going to have the beginning of that hiring pipeline created. I'm going to use our table to manage all of the people applying for that open role. So imagine I'm a hiring manager and I've got candidates coming in for an open finance manager position. 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. 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.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |