1
00:00:00,540 --> 00:00:03,367
You've just learned how
easy it is to manage and

2
00:00:03,367 --> 00:00:06,370
look up data from multiple tables in Coda.

3
00:00:06,370 --> 00:00:10,880
Next, I'll show you several different
ways you can view data in tables.

4
00:00:10,880 --> 00:00:15,444
With Coda, it's easy to dynamically add
color to a cell or row to highlight

5
00:00:15,444 --> 00:00:20,740
different types of data depending on
specific values that show up in the table.

6
00:00:20,740 --> 00:00:23,935
You've already had a sneak peek of
how conditional formatting works in

7
00:00:23,935 --> 00:00:25,570
a previous Coda workshop.

8
00:00:25,570 --> 00:00:29,020
Now I'm going to give you an opportunity
to try it out for yourself.

9
00:00:29,020 --> 00:00:33,791
You'll start by customizing your learning
plan so that when you select Done in

10
00:00:33,791 --> 00:00:38,790
the Status column, the background color
of the Done cell will turn green.

11
00:00:38,790 --> 00:00:41,738
When you select In Progress,
it'll turn yellow, and

12
00:00:41,738 --> 00:00:44,570
if you choose Not Started,
it'll turn light gray.

13
00:00:45,720 --> 00:00:48,865
All right,
go to your Treehouse Workbook now and

14
00:00:48,865 --> 00:00:51,250
select the My Student Planner page.

15
00:00:52,420 --> 00:00:55,467
Hover over to the right
of the Lesson column and

16
00:00:55,467 --> 00:00:59,940
click on the column header to
view the lookup type options.

17
00:00:59,940 --> 00:01:04,505
Notice how the lesson drop down
list options are being pulled from

18
00:01:04,505 --> 00:01:09,200
another table called Lessons
on the Admin & Data page.

19
00:01:09,200 --> 00:01:12,630
Here are all the lessons,
each has a title,

20
00:01:12,630 --> 00:01:17,840
topic, Treehouse link, and
the estimated time in hours.

21
00:01:17,840 --> 00:01:23,183
You can view all this data in the Learning
Plan table when you hover over a lesson.

22
00:01:27,969 --> 00:01:32,472
Now, hover over to the right of
the Status column header and

23
00:01:32,472 --> 00:01:39,390
click the select list data type icon to
view the select list data type options.

24
00:01:39,390 --> 00:01:44,263
Notice how the status options aren't being
pulled from another table like the lesson

25
00:01:44,263 --> 00:01:45,550
options were.

26
00:01:45,550 --> 00:01:51,610
Instead, they've been manually listed
here as options separated by commas.

27
00:01:51,610 --> 00:01:54,820
So we have Not Started,
In Progress, and Done.

28
00:01:58,230 --> 00:02:02,740
Back in the select list data
type drop down, go to Format,

29
00:02:02,740 --> 00:02:07,529
then select Conditional format,
and you'll see a list of all

30
00:02:07,529 --> 00:02:13,160
the status options such as Not Started,
In Progress, and Done.

31
00:02:13,160 --> 00:02:17,365
We're going to customize this table so
that whenever you select a status,

32
00:02:17,365 --> 00:02:20,620
this cell displays
the color you've specified.

33
00:02:20,620 --> 00:02:21,728
Let's set this up now.

34
00:02:21,728 --> 00:02:25,506
So first, if status is Done,

35
00:02:25,506 --> 00:02:31,257
I'll make the background
of the cell green.

36
00:02:34,298 --> 00:02:38,184
I'll duplicate this, and here,

37
00:02:38,184 --> 00:02:42,204
I'll say if status is In Progress,

38
00:02:42,204 --> 00:02:47,440
I'll make the background
of the cell yellow.

39
00:02:49,760 --> 00:02:56,765
I'll duplicate it again, and
here I'll select Not Started,

40
00:02:56,765 --> 00:03:03,651
and if status is Not Started,
I'll make the cell light gray.

41
00:03:06,225 --> 00:03:10,586
Conditional formatting lets you
not only change the color, but

42
00:03:10,586 --> 00:03:12,600
also the text style as well.

43
00:03:12,600 --> 00:03:16,490
It's a great way to highlight data
presented in a table based on specific

44
00:03:16,490 --> 00:03:17,271
conditions.

45
00:03:23,962 --> 00:03:29,425
To extend, the power of a table like this,
Coda also lets you add automations with

46
00:03:29,425 --> 00:03:34,840
packs that are triggered by conditions,
such as changes to values in a row.

47
00:03:34,840 --> 00:03:38,844
So in our example here,
each time the status changes to Done,

48
00:03:38,844 --> 00:03:43,772
you can use the Gmail or Slack packs to
configure Coda to notify someone to let

49
00:03:43,772 --> 00:03:46,633
them know via email or Slack, for example.

50
00:03:46,633 --> 00:03:50,830
I've posted resources about Coda packs
in the teacher's notes with this video.

51
00:03:50,830 --> 00:03:51,335
Up next,

52
00:03:51,335 --> 00:03:55,260
I'll show you how to hide the amount
of data you want to display in a table.