1
00:00:00,820 --> 00:00:04,560
You've learned how Coda in
many ways is just a doc.

2
00:00:04,560 --> 00:00:08,530
Now I'll give you a sneak peek of
the power behind the Coda doc.

3
00:00:08,530 --> 00:00:12,070
Like how it provides you with templates
to create things quickly, and

4
00:00:12,070 --> 00:00:15,020
how it lets you easily connect
to other apps and services.

5
00:00:16,340 --> 00:00:20,431
I'll start by teaching you how to create
and modify a table template that lets you

6
00:00:20,431 --> 00:00:23,650
pick and display images based
on keywords you provide.

7
00:00:23,650 --> 00:00:27,710
I'll display a table in my About Me
page to feature three photos that best

8
00:00:27,710 --> 00:00:29,070
describe me.

9
00:00:29,070 --> 00:00:32,490
Coda provides many commonly used
templates, like question and

10
00:00:32,490 --> 00:00:37,290
voting tables, meeting planners and to do
lists you can quickly add to your page.

11
00:00:37,290 --> 00:00:41,715
Simply drag and drop a template into
your doc from the Explore panel or

12
00:00:41,715 --> 00:00:44,880
insert a template using the slash command.

13
00:00:44,880 --> 00:00:46,720
Then type what you're looking for and

14
00:00:46,720 --> 00:00:49,550
select it from the template
options in the drop down list.

15
00:00:50,870 --> 00:00:55,316
Below my paragraph, I'll type /unsplash,

16
00:00:55,316 --> 00:00:59,993
then select "Unsplash image
picker" in this case.

17
00:00:59,993 --> 00:01:04,805
This template is a table that lets you
pick an image from the Unsplash gallery

18
00:01:04,805 --> 00:01:07,580
based on a keyword or phrase you type.

19
00:01:07,580 --> 00:01:10,730
Now I can customize this
table to fit my needs.

20
00:01:10,730 --> 00:01:14,661
If you've worked with spreadsheets or
tables, Coda tables look and

21
00:01:14,661 --> 00:01:19,730
work in similar ways, with columns and
rows you're probably familiar with.

22
00:01:19,730 --> 00:01:24,307
Coda sees tables as more like databases
that let you easily organize and

23
00:01:24,307 --> 00:01:27,540
manipulate data across multiple tables.

24
00:01:27,540 --> 00:01:32,523
When working with Coda tables,
the focus is more on rows and columns,

25
00:01:32,523 --> 00:01:34,910
rarely on individual cells.

26
00:01:34,910 --> 00:01:39,833
You can think of each row in a Coda table
as a unique record with a unique set

27
00:01:39,833 --> 00:01:40,880
of data.

28
00:01:40,880 --> 00:01:45,050
And the columns are pieces of
information that every record shares.

29
00:01:46,190 --> 00:01:52,119
So let's start by renaming the table,
"About Me in 3 Photos".

30
00:01:56,170 --> 00:02:01,205
Unlike spreadsheets, Coda lets you name
tables and columns any way you like,

31
00:02:01,205 --> 00:02:05,184
with punctuation, spaces and
with fewer character limits.

32
00:02:05,184 --> 00:02:08,964
If you hover over a column header,
like keyword,

33
00:02:08,964 --> 00:02:12,520
notice the data type
icon next to the text.

34
00:02:12,520 --> 00:02:16,283
The data type icon immediately
lets you know what type of data or

35
00:02:16,283 --> 00:02:19,850
content is being used or
displayed in the column.

36
00:02:19,850 --> 00:02:24,240
For example,
the "Keyword" column uses the text type.

37
00:02:24,240 --> 00:02:28,520
The "Picker" column is a number type,
shown as a slider scale.

38
00:02:28,520 --> 00:02:31,930
And "Orientation" is a select list.

39
00:02:31,930 --> 00:02:36,575
You would think that the "Unsplash
Image" column should be an image type, but

40
00:02:36,575 --> 00:02:41,218
in this case it's text because this column
contains a formula, someone else has

41
00:02:41,218 --> 00:02:45,900
kindly written for us, that communicates
with the Unsplash image service.

42
00:02:45,900 --> 00:02:49,513
I'll point you to resources about Coda
formulas later in the final step of this

43
00:02:49,513 --> 00:02:50,810
workshop.

44
00:02:50,810 --> 00:02:54,775
All right, if you're following along
go ahead and replace the three

45
00:02:54,775 --> 00:02:59,560
keywords with different keywords or
phrases that best describe you.

46
00:02:59,560 --> 00:03:07,477
I'll set mine to "Learning code",

47
00:03:07,477 --> 00:03:14,850
"Water sports", and "Reflective".

48
00:03:14,850 --> 00:03:18,174
I'll change the orientation for
all of them to landscape so

49
00:03:18,174 --> 00:03:20,910
there's some consistency
in how they display.

50
00:03:23,880 --> 00:03:28,810
Then slide the picker scale to find the
Unsplash image that best represents each

51
00:03:28,810 --> 00:03:30,070
keyword or phrase.

52
00:03:31,550 --> 00:03:36,590
I want to display only the keywords and
images that best describe me.

53
00:03:36,590 --> 00:03:40,430
So I want to hide these Orientation and
Picker columns.

54
00:03:40,430 --> 00:03:44,469
You can do that by clicking
the table's "Columns" button,

55
00:03:44,469 --> 00:03:48,437
then click the eye icon next to Picker and
Orientation.

56
00:03:52,430 --> 00:03:56,739
And the real beauty of Coda is that it
offers you many different ways to display

57
00:03:56,739 --> 00:03:57,750
your tables.

58
00:03:57,750 --> 00:04:02,675
For example, go to table options and
select the Cards view and

59
00:04:02,675 --> 00:04:06,660
notice how the images are now
laid out as cards.

60
00:04:06,660 --> 00:04:10,726
Nothing in the data is changed,
it's just a different way to view it,

61
00:04:10,726 --> 00:04:11,870
often more visual.

62
00:04:14,010 --> 00:04:18,183
You can display the data as a chart,
a calendar or a project timeline,

63
00:04:18,183 --> 00:04:20,321
if you have dates in it for example.

64
00:04:20,321 --> 00:04:22,380
I'll stick with the Card view for my page.