Coda Prep Doc

Learn by watching

Learn by doing

Relevant reading

Coda Prep Doc

Google Docs and office 365

Explore

Learn by watching

Designing docs

We’ve always believed that process is the product in and of itself. Your doc is a direct result of the attention—and intention—you put into it. So why not design your doc like an app designer designs an app, with careful consideration to what goes into your doc and how others will interact with that content?

The two video series below will help you recognize and leverage the patterns used in so many docs. And equip you with the structure to scale those patterns as your doc evolves.

Common doc patterns

The more docs you build, the more you’ll discover patterns repeated doc after doc (after doc). Many of those patterns are drag-and-drop templates that you can access by typing / in your doc, which you can combine to quickly level-up your doc.

5 Ways: Topic voting

Topic voting is a drag-and-drop template used to add ideas, vote, and prioritize discussions.

Short on time? Jump to the example you’d like to see:

Personal (

1:23⁠

) - Book club manager

Freelancer (

4:05⁠

) - Audience survey

Product Manager (

6:23⁠

) - Meeting manager

Small Business (

8:37⁠

) - Employee kudos

Consulting Firm (

10:21⁠

) - Staffing needs

⁠

Loading…⁠

⁠

5 Ways: Pulse check

A Pulse is one of the most quintessential drag-and-drop templates—used to gauge sentiment and check in on how everyone is feeling.

Short on time? Jump to the example you want to see:

Personal (

1:38⁠

) - Friend check in

Freelancer (

3:02⁠

) - Productivity accountability and habit tracker

Product Manager (

4:40⁠

) - Team pulse check

Small Business (

5:45⁠

) - Feedback survey

Consulting Firm (

6:45⁠

) - Client roundtable check in

⁠

Loading…⁠

⁠

5 Ways: Populate text with controls

Use a control, like a button, to connect a table to the text of your doc.

Short on time? Jump to the example you want to see:

Personal (

2:24⁠

) - Birthday message generator

Freelancer (

3:35⁠

) - Invoice generator

Product Management (

5:09⁠

) - Launch email generator

Small Business (

6:10⁠

) - Dynamic account plan

Consulting Firm (

7:00⁠

) - Invoice generator

Take it to the next level (

7:24⁠

)

⁠

Loading…⁠

⁠

5 Ways: Convert to table

Scale your doc by moving information out of a column and into its own table.

Short on time? Jump to the example you want to see:

Personal (

4:08⁠

) - Workout plan

Freelancer (

6:19⁠

) - Pitch record

Product Manager (

7:21⁠

) - Projects and sub-projects

Small Business (

8:59⁠

) - Vendor and inventory management

Consulting Firm (

10:00⁠

) - CRM

⁠

Loading…⁠

⁠

5 Ways: Email a page

Use a table-button combination to send a single page of your doc to a list of emails.

Short on time? Jump to the example you want to see:

Personal (

2:11⁠

) - Family trip reminder

Freelancer (

3:14⁠

) - Newsletter

Product Manager (

4:02⁠

) - Send meeting notes

Small Business (

5:08⁠

) - Email certificates

Consulting Firm (

5:46⁠

) - Timesheet reminder

⁠

Loading…⁠

⁠

Doc schema

There's an infinite number of ways to design your doc, but you don't want to use the same tool for every job. That's where designing docs come into play. Explore the basics of schema design in this video series.

Lesson 1: What is a schema?

Schema is the underlying organizational structure of your doc. In Coda, schemas create relationships between building blocks that repeat doc after doc (after doc). And they activate the power of those patterns to scale as your dataset evolves.

⁠

Loading…⁠

⁠

Lesson 2: Set up your doc

Before you start designing your doc, identify its purpose, and think about its content—including how you’d like people to interact with the information.

⁠

Loading…⁠

⁠

Lesson 3: Schema 1 - One Big Table

One Big Table schema a single table that houses all of the data in your doc and is ideal for:

Small projects

Small teams

Getting started quickly

Narrowly-focused information tracking

⁠

Loading…⁠

⁠

Lesson 4: Schema 2 - Star

Star schema uses lookups to create a series of connected tables and is ideal for:

Larger scale projects or initiatives

You want consistency.

You want to reference the same data in multiple places.

Your data has 1 to 1 relationships.

⁠

Loading…⁠

⁠

Lesson 5: Schema 3 - Base/detail

Base/detail schema includes a summary table (base) populated by a larger dataset (detail). Use this schema if:

You have a large dataset.

You need to answer specific questions with that data in a summary or dashboard experience.

⁠

Loading…⁠

⁠

Lesson 6: Schema 4 - Multidimensional

With the multidimensional schema, many tables (large and small) that are interconnected via lookups and formulas. No one table acts as the base or overview. Use if:

You have a large dataset and there's no clear hierarchy among your tables.

You have a lot of different questions you need to answer with your data.

Your data has many to many relationships.

⁠

Loading…⁠

⁠