1
00:00:03,940 --> 00:00:04,670
[Autogenerated] Hi. We're here in

2
00:00:04,670 --> 00:00:06,590
SharePoint. We're on our customer sales

3
00:00:06,590 --> 00:00:10,130
list, this list UI created recently from

4
00:00:10,130 --> 00:00:12,300
an Excel workbook. And in this lesson,

5
00:00:12,300 --> 00:00:14,990
we're going to create a new default view

6
00:00:14,990 --> 00:00:17,450
for this list of you that everybody will

7
00:00:17,450 --> 00:00:20,290
see when they come to this site. Now, if

8
00:00:20,290 --> 00:00:21,400
you're familiar with the modern

9
00:00:21,400 --> 00:00:23,550
SharePoint, you know there are ah lot of

10
00:00:23,550 --> 00:00:25,780
things that we can do in terms of our

11
00:00:25,780 --> 00:00:28,640
view, each of our columns has the ability

12
00:00:28,640 --> 00:00:31,500
to sort and filter. We can even go over

13
00:00:31,500 --> 00:00:34,620
here and then save those views for our

14
00:00:34,620 --> 00:00:37,880
individual use. We-can also apply filters

15
00:00:37,880 --> 00:00:40,650
this way as well. There's lots of great

16
00:00:40,650 --> 00:00:43,130
options for us, but what we're going to do

17
00:00:43,130 --> 00:00:46,080
is create a view in our settings. We're

18
00:00:46,080 --> 00:00:48,630
going to create a default view in settings

19
00:00:48,630 --> 00:00:51,360
for this list. Now, before they do that,

20
00:00:51,360 --> 00:00:54,580
we want to take a look at this list. When

21
00:00:54,580 --> 00:00:57,050
we look at all of our columns, they don't

22
00:00:57,050 --> 00:01:02,240
seem to be sorted in any particular order,

23
00:01:02,240 --> 00:01:05,750
not by state, not by city, not by

24
00:01:05,750 --> 00:01:09,190
certainly the name or address. So what we

25
00:01:09,190 --> 00:01:11,400
want to do is we're gonna sort this list

26
00:01:11,400 --> 00:01:13,210
in a particular way. We're gonna actually

27
00:01:13,210 --> 00:01:16,140
do a custom sort where we'll sort by state

28
00:01:16,140 --> 00:01:21,610
and then within each state, we will do by

29
00:01:21,610 --> 00:01:26,610
the most, to the least sales. Now, we also

30
00:01:26,610 --> 00:01:29,030
look at this. We don't need this column.

31
00:01:29,030 --> 00:01:30,580
We don't need telephone numbers. We're

32
00:01:30,580 --> 00:01:33,710
going to get rid of that as well. And

33
00:01:33,710 --> 00:01:35,800
before we even get started with any of

34
00:01:35,800 --> 00:01:40,070
that, I'm going to change title to first

35
00:01:40,070 --> 00:01:44,250
name. Our title column is always here in

36
00:01:44,250 --> 00:01:50,470
SharePoint, but we could rename it. We

37
00:01:50,470 --> 00:01:53,440
can't get rid of it, but we can rename IT

38
00:01:53,440 --> 00:01:56,160
all right now, when we want to create the

39
00:01:56,160 --> 00:01:58,680
view and we're not going to keep this view

40
00:01:58,680 --> 00:02:02,270
the way it is. So we're going to edit this

41
00:02:02,270 --> 00:02:06,770
view, which is all items, and you see, we

42
00:02:06,770 --> 00:02:10,130
have here edit current view when we click

43
00:02:10,130 --> 00:02:13,190
there, it takes us to our settings, the

44
00:02:13,190 --> 00:02:16,950
list settings to edit view. Now we see the

45
00:02:16,950 --> 00:02:18,900
view name is all items. We saw that

46
00:02:18,900 --> 00:02:20,420
already. We're gonna change that. We're

47
00:02:20,420 --> 00:02:25,670
simply going to call this default. Then

48
00:02:25,670 --> 00:02:27,380
we're going to scroll down and look at the

49
00:02:27,380 --> 00:02:31,200
columns. These check marks represent all

50
00:02:31,200 --> 00:02:34,720
the columns that we see. You see that we

51
00:02:34,720 --> 00:02:38,630
have a number of other columns that we can

52
00:02:38,630 --> 00:02:40,890
include these air, all different

53
00:02:40,890 --> 00:02:44,450
SharePoint fields. But we're OK with ones

54
00:02:44,450 --> 00:02:48,030
we want. Except we decided we don't want

55
00:02:48,030 --> 00:02:49,890
telephone number. So we're going to

56
00:02:49,890 --> 00:02:52,570
uncheck that and that will be hidden. That

57
00:02:52,570 --> 00:02:55,700
won't be shown in our view. Next, we want

58
00:02:55,700 --> 00:02:57,750
to change the order of these first two

59
00:02:57,750 --> 00:03:00,550
columns. I would like surname to be the

60
00:03:00,550 --> 00:03:03,260
first column to change that. What I need

61
00:03:03,260 --> 00:03:04,740
to do is come over here to the right and

62
00:03:04,740 --> 00:03:06,800
you see where it says position from left.

63
00:03:06,800 --> 00:03:08,570
And these air, the numbers, these air, the

64
00:03:08,570 --> 00:03:10,490
order, the columns are gonna be shown from

65
00:03:10,490 --> 00:03:14,330
left to right. So I wanna make surname

66
00:03:14,330 --> 00:03:17,020
number one. I select the drop-down, go

67
00:03:17,020 --> 00:03:19,080
ahead and click on number one and see that

68
00:03:19,080 --> 00:03:23,190
it automatically changed first name to-be

69
00:03:23,190 --> 00:03:25,420
in the second position. And that's the way

70
00:03:25,420 --> 00:03:28,220
I want it looking good. So far, we're

71
00:03:28,220 --> 00:03:31,040
gonna scroll down some more. Like I told

72
00:03:31,040 --> 00:03:34,340
you, we want to sort by a column. Well,

73
00:03:34,340 --> 00:03:37,140
the sort by default is by i d which we

74
00:03:37,140 --> 00:03:40,970
don't have. We don't have the i. D column

75
00:03:40,970 --> 00:03:43,600
shown in our list. So we're going to

76
00:03:43,600 --> 00:03:47,040
change that because we want to sort by

77
00:03:47,040 --> 00:03:50,410
state and we're going to do it

78
00:03:50,410 --> 00:03:55,390
alphabetically. A Sending A to Z. If we

79
00:03:55,390 --> 00:03:57,940
wanted to do a descending UI would choose

80
00:03:57,940 --> 00:04:01,260
this radio button. Now within that sort,

81
00:04:01,260 --> 00:04:04,110
we're going to do a second sort sort by

82
00:04:04,110 --> 00:04:08,640
the column sales and this one we're going

83
00:04:08,640 --> 00:04:12,390
to do descending order, highest lowest. So

84
00:04:12,390 --> 00:04:16,070
that means within each state sort it will

85
00:04:16,070 --> 00:04:20,420
show us the highest sales. All right, so

86
00:04:20,420 --> 00:04:23,980
that sorting is good. Now we can filter,

87
00:04:23,980 --> 00:04:25,590
but there's no filters that I need to

88
00:04:25,590 --> 00:04:28,750
apply, But we would have that here, but

89
00:04:28,750 --> 00:04:30,170
we're going to scroll down a little bit

90
00:04:30,170 --> 00:04:32,450
more and we're gonna look at this one

91
00:04:32,450 --> 00:04:34,010
here. Totals. I'm gonna click on the

92
00:04:34,010 --> 00:04:36,560
little plus button there, and it gets

93
00:04:36,560 --> 00:04:39,960
these fields out. Force these controls

94
00:04:39,960 --> 00:04:42,560
here, and what we want to do is add a

95
00:04:42,560 --> 00:04:46,710
total to our sales. So we see this A

96
00:04:46,710 --> 00:04:49,040
sales. So we're going to come across here

97
00:04:49,040 --> 00:04:51,920
and we see it's set to none, but these are

98
00:04:51,920 --> 00:04:54,660
the functions that we can add, but we're

99
00:04:54,660 --> 00:04:58,080
going to go ahead and choose some, and it

100
00:04:58,080 --> 00:05:01,940
will give us the some of our sales this is

101
00:05:01,940 --> 00:05:04,990
pretty neat. There's nothing down here we

102
00:05:04,990 --> 00:05:07,110
need to change. This is all having to do

103
00:05:07,110 --> 00:05:10,910
with mobile views of our site. We're going

104
00:05:10,910 --> 00:05:18,740
to simply click OK, and when we come back,

105
00:05:18,740 --> 00:05:21,780
we see that our list is sorted

106
00:05:21,780 --> 00:05:25,620
alphabetically by state. And if we come

107
00:05:25,620 --> 00:05:28,970
all the way over, we see that within those

108
00:05:28,970 --> 00:05:34,940
sorts within the states, they are sorted

109
00:05:34,940 --> 00:05:38,140
from highest to lowest by the amount of

110
00:05:38,140 --> 00:05:40,890
sales. And we have our total here at the

111
00:05:40,890 --> 00:05:43,870
bottom. Now the nice thing about that is,

112
00:05:43,870 --> 00:05:47,000
if I go ahead and filter by state, let's

113
00:05:47,000 --> 00:05:52,310
just take California, see that it's still

114
00:05:52,310 --> 00:05:58,110
totals just the amounts that are left

115
00:05:58,110 --> 00:06:07,640
visible here in my filter. So pretty cool.

116
00:06:07,640 --> 00:06:11,730
And now this view is the new default view,

117
00:06:11,730 --> 00:06:16,290
and you see default up here. And when

118
00:06:16,290 --> 00:06:19,490
anybody goes away and comes back to the

119
00:06:19,490 --> 00:06:25,000
site, that is the view that they're going

120
00:06:25,000 --> 00:06:34,080
to see because that is now the new default

121
00:06:34,080 --> 00:06:36,980
view. Now, if you want to create

122
00:06:36,980 --> 00:06:40,060
additional views, come up here to the

123
00:06:40,060 --> 00:06:45,220
settings Gear goto list settings. When you

124
00:06:45,220 --> 00:06:48,200
scroll down here, you can click on create

125
00:06:48,200 --> 00:06:57,400
view standard view, and now you can create

126
00:06:57,400 --> 00:07:01,420
another view. But now you can give IT a

127
00:07:01,420 --> 00:07:04,860
name and you can choose if it's a personal

128
00:07:04,860 --> 00:07:09,770
view or a public view. So now you know how

129
00:07:09,770 --> 00:07:13,350
to create views from settings in a

130
00:07:13,350 --> 00:07:15,860
SharePoint list. That's it for this

131
00:07:15,860 --> 00:07:25,000
lesson. Thanks for listening, and I'll see you next time.