Share
Explore

Old doc, new year: Part II

How I improved my most-used doc with Coda's 2020 product improvements.
When I’m not at Coda, I narrate audiobooks and do career coaching, which means I have a lot of projects to manage, expenses to track, and invoices to send. Last year, I
about how updating my doc for 2020 highlighted just how much the product changed over the course of a year. As we begin 2021, that doc deserves a sequel. So here we are again...Old doc, new year: Part II - The Doc-ening!

Easier, more detailed tracking in 2021.

The tracker I built a year ago saved me a ton of time, helped me focus, and kept me from missing deadlines. But, if there’s one thing I love about Coda, it’s the fact that you can always experiment and try new things. For the upcoming year, I wanted to add:
An automatic invoice generator
An easier way to add new opportunities

Let’s take a look at how these additions evolved my doc.

PDFs are pretty darn fabulous.

To start, I wanted to address one of my most painful pain points. Creating invoices take FOREVER. Well, not forever exactly, but the process is pretty tedious. Now, with the power of beautiful PDFs—one of my favorite Coda launches from 2020—I can make a polished invoice with one click. No exaggeration! Here’s how it works:

1) I have an
Opportunities
table.
Month
Type
Opportunity
Client
Status
Amount
01 - January
2
Voiceover 🎙
30 second commercial
Marty's Furniture
Won
$450.00
Coaching 🦄
Malia Bingly
Malia Bingly
Prospect
$750.00
02 - February
1
Audiobook 📖
The Best Book Ever!
Bookland
Won
$1,400.00
2
Consulting 💼
eLearning course
Barton Logistics
Won
$7,000.00


2) This table looks up to my
Client
table which has contact information and billing information.
Clients
0
Client
Contact
Email
Bill To Address
1
Barton Logistics
Bess Barton
bess@example.com
123 Anyland Drive Logix, CA 98479
2
Bookland
Albus Bookley
albus@example.com
764 Library Lane Bookishness, MA 18927
3
Malia Bingly
Malia Bingly
malia@example.com
458 Dingle Drive Austen, WI 54783
4
Marty's Furniture
Marty Martin
marty@example.com
89 Bench Blvd. Living Room, NV 84736
There are no rows in this table

3) There’s also an
Invoice Generator
page with a dropdown control that pulls from my
Opportunities
table.
Screen Shot 2021-01-12 at 10.50.49 AM.png

4) Then, through the power of formulas, I have an invoice page that automatically populates the details from the project. The formula here is simple: type the name of the control, a
.
, and then the field I want:
Screen Shot 2021-01-12 at 10.53.03 AM.png
Screen Shot 2021-01-12 at 10.52.54 AM.png

5) From here I can print to PDF and send it along!

Screen Shot 2021-01-12 at 10.54.38 AM.png

My invoices look great, and everything I need is populated automatically by Coda.
A little bit of setup, plus the power of print to PDF, has saved me at least three hours every month.

Forms make everything easier.

With invoices in better shape, I wanted to create an easier way to add opportunities. The button I was already using worked well enough, but it wasn’t quite perfect. Plus, I needed an excuse to try out the new form feature.

And I’m so glad I did. Forms are just a view of a table, so I didn’t need to write any fancy formulas or go through a special process to set it up.
Adding a form to my doc’s welcome page saves me three clicks—and now I can add opportunities quickly, whether I’m on mobile or desktop.

Screen Shot 2021-01-12 at 10.58.55 AM.png


And a few cherries on top.

When it comes to Coda, the little things bring me the most joy. Here were a few changes that make my doc feel new:
I changed my chart colors to be my favorites (green and purple) instead of the defaults.
Attachments can now be added to my table of proposals or emails.
Specifying colors for conditional formatting using a color code is so much easier (thanks Coda design team!).

Here’s to a happy, productive year.

I continue to save tons of time with adjustments to my doc, but as I work in my doc I’m reminded of all the people behind the features. Each feature, no matter how small, is the hand-crafted work of a designer finding the exact look, an engineer (or 12!) finding the most optimized way to execute, and folks putting their heads together to solve a problem.

Keep tinkering, keep playing, and I can’t wait to see what you Coda!
Want to print your doc?
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.