1 00:00:04,440 --> 00:00:05,780 [Autogenerated] high in this lesson. I'm 2 00:00:05,780 --> 00:00:08,460 gonna show you how to add text columns to 3 00:00:08,460 --> 00:00:10,860 a list. And I also want to add that this 4 00:00:10,860 --> 00:00:13,300 process is the same with the SharePoint 5 00:00:13,300 --> 00:00:16,010 library. We're gonna go to our operations 6 00:00:16,010 --> 00:00:19,700 applicants list, and we're gonna add a 7 00:00:19,700 --> 00:00:22,940 single line of text column. Single line of 8 00:00:22,940 --> 00:00:25,460 text columns are the most popular, the 9 00:00:25,460 --> 00:00:29,730 most commonly used, I should say column in 10 00:00:29,730 --> 00:00:33,000 a SharePoint list. Now our operations 11 00:00:33,000 --> 00:00:35,110 applicants list doesn't have much going 12 00:00:35,110 --> 00:00:36,970 on. There's only one column, the title 13 00:00:36,970 --> 00:00:39,750 column, and this is here by default when 14 00:00:39,750 --> 00:00:43,330 you first create the list. Now this is 15 00:00:43,330 --> 00:00:47,710 gonna be a list of names, addresses, maybe 16 00:00:47,710 --> 00:00:50,900 email addresses. Things like that. And 17 00:00:50,900 --> 00:00:55,840 title isn't really a column that we want. 18 00:00:55,840 --> 00:00:59,130 However, you can't get rid of the title 19 00:00:59,130 --> 00:01:02,960 column, but you can rename it, and that's 20 00:01:02,960 --> 00:01:05,140 what we're gonna do. First, we're gonna go 21 00:01:05,140 --> 00:01:07,530 here and click on the little Drop Down and 22 00:01:07,530 --> 00:01:10,450 go to column settings and you'll see 23 00:01:10,450 --> 00:01:13,630 Rename is the top option. You were gonna 24 00:01:13,630 --> 00:01:17,550 rename it from title to last name because 25 00:01:17,550 --> 00:01:20,720 that's what we want our first column to be 26 00:01:20,720 --> 00:01:23,340 in this list. So we're going to save it 27 00:01:23,340 --> 00:01:25,710 and there you have it. Last name. Great. 28 00:01:25,710 --> 00:01:27,990 Now let's go ahead and let's add a new 29 00:01:27,990 --> 00:01:30,570 column and you see the big ad column 30 00:01:30,570 --> 00:01:32,730 button here. That's the one we want. We're 31 00:01:32,730 --> 00:01:36,480 gonna click on that, and the very 1st 1 is 32 00:01:36,480 --> 00:01:40,370 single line of text. So it opens up to 33 00:01:40,370 --> 00:01:42,290 create a column panel on the right, and 34 00:01:42,290 --> 00:01:44,040 the first thing we have to do and it is 35 00:01:44,040 --> 00:01:47,030 required is to give our column a name. So 36 00:01:47,030 --> 00:01:52,270 this will be our first name column, and 37 00:01:52,270 --> 00:01:54,150 you can add a description if you want. But 38 00:01:54,150 --> 00:01:55,740 I think first name is pretty self 39 00:01:55,740 --> 00:01:59,330 explanatory. Now the type is single line 40 00:01:59,330 --> 00:02:01,190 of text. Like I said, that's what we want. 41 00:02:01,190 --> 00:02:04,440 There are other types here, but we're not 42 00:02:04,440 --> 00:02:07,560 gonna look at those today. Default value. 43 00:02:07,560 --> 00:02:09,880 Do we want to put a default value in here? 44 00:02:09,880 --> 00:02:12,870 No, we don't. We want to leave that blank, 45 00:02:12,870 --> 00:02:16,080 and we have a more options button where we 46 00:02:16,080 --> 00:02:19,390 can set the maximum number of characters 47 00:02:19,390 --> 00:02:22,430 now to 55 is the most that you can do. You 48 00:02:22,430 --> 00:02:27,400 can't say make it 500 but to 55 is plenty. 49 00:02:27,400 --> 00:02:30,480 We don't I think need more than that do we 50 00:02:30,480 --> 00:02:32,450 want to require that this column contains 51 00:02:32,450 --> 00:02:35,030 information? No, we're fine with that. Do 52 00:02:35,030 --> 00:02:37,720 we want to enforce unique values? No, 53 00:02:37,720 --> 00:02:39,530 because a lot of people are likely to have 54 00:02:39,530 --> 00:02:42,080 the same first name. And do we want to add 55 00:02:42,080 --> 00:02:44,690 this column to all content types? Yes, we 56 00:02:44,690 --> 00:02:50,340 do. So we're going to simply click on Save 57 00:02:50,340 --> 00:02:53,460 and there is our first name column. All 58 00:02:53,460 --> 00:02:56,440 right, I'm gonna add a couple more columns 59 00:02:56,440 --> 00:02:58,080 and you don't have to watch. I'm going to 60 00:02:58,080 --> 00:02:59,830 do the same thing we just did. It's the 61 00:02:59,830 --> 00:03:03,370 same process and I'll be right back. All 62 00:03:03,370 --> 00:03:05,020 right, I'm back and you'll see that I 63 00:03:05,020 --> 00:03:08,730 added three columns Address State City, 64 00:03:08,730 --> 00:03:11,730 and I want to add one more column. I want 65 00:03:11,730 --> 00:03:14,440 to add a column for the ZIP code. Now, the 66 00:03:14,440 --> 00:03:18,010 zip code zip code is a five digit number 67 00:03:18,010 --> 00:03:20,090 or possibly five plus four if you're going 68 00:03:20,090 --> 00:03:22,730 to go that route and you might be tempted 69 00:03:22,730 --> 00:03:26,470 to use number as the type of column. But I 70 00:03:26,470 --> 00:03:28,650 want to show you you have to be careful 71 00:03:28,650 --> 00:03:31,190 with this. So our zip and we've got 72 00:03:31,190 --> 00:03:35,310 number. We're going to save it now. I am 73 00:03:35,310 --> 00:03:40,550 going to add a new list item and I'm 74 00:03:40,550 --> 00:03:49,860 simply going to put in simple, easy, not 75 00:03:49,860 --> 00:03:51,630 gonna worry about address state and city. 76 00:03:51,630 --> 00:03:54,660 But when I come to the zip now, some 77 00:03:54,660 --> 00:03:57,140 states like Massachusetts, have zip codes 78 00:03:57,140 --> 00:03:59,520 that start with a zero. That's gonna be a 79 00:03:59,520 --> 00:04:02,340 problem in an Excel list if you have the 80 00:04:02,340 --> 00:04:05,430 column formatted as number. So I am going 81 00:04:05,430 --> 00:04:09,430 to put in a Massachusetts ZIP code here 82 00:04:09,430 --> 00:04:15,600 that is 01702 When I save it, look over 83 00:04:15,600 --> 00:04:18,750 here, see what happens. It took zero off 84 00:04:18,750 --> 00:04:22,190 because you can't start that number in a 85 00:04:22,190 --> 00:04:25,860 SharePoint list with zero and made it 1702 86 00:04:25,860 --> 00:04:28,840 and even put the comma in the third place. 87 00:04:28,840 --> 00:04:32,550 What we need to do is make this a text 88 00:04:32,550 --> 00:04:35,770 column, So let's go ahead. We can still do 89 00:04:35,770 --> 00:04:37,540 that. We're going to click here on the ZIP 90 00:04:37,540 --> 00:04:39,860 column and we're gonna go to column 91 00:04:39,860 --> 00:04:43,950 settings and click on edit. Now we're 92 00:04:43,950 --> 00:04:47,110 gonna change the type from number to 93 00:04:47,110 --> 00:04:50,820 single line of text. And when we say that 94 00:04:50,820 --> 00:04:52,500 we're gonna get this warning that says we 95 00:04:52,500 --> 00:04:54,300 may lose some of our data because we're 96 00:04:54,300 --> 00:04:57,570 changing the column type. That's Okay, now 97 00:04:57,570 --> 00:04:59,820 the commas gone. Now it's looking at this 98 00:04:59,820 --> 00:05:07,910 as text. And if I go here and I edit this 99 00:05:07,910 --> 00:05:12,780 item and put the zero back in once we save 100 00:05:12,780 --> 00:05:18,340 it now the zero is there. 01702 So now you 101 00:05:18,340 --> 00:05:22,150 know how to add text columns? Two A share 102 00:05:22,150 --> 00:05:32,000 point list. Thanks for listening. And I'll see you next time.