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.