Inside this article
How do I add an Image to a table?
How do I add a calendar to a column?
How can I set the default value for a column?
How to use Column Formats
To set the column type:
Hover over the column name, and click on the column format icon that appears in the top right. Then select Column type.
When you create a new column, you'll be prompted to choose a format or type it in to search.
For some column formats, you may be prompted for additional parameters, such as selecting the format in which you'd like to view dates.
Watch a video about Column Formats
Why Column Formats matter
Column formats in Coda help you customize how data is displayed and expressed in specific columns. In Coda, columns usually represent attributes of things. Column formats help you express the nature of these attributes (e.g. birthdays should be dates) and better display the data (e.g. the image column format will display image urls as actual images).
Column formats can be useful in many different ways. Here's a few of our favorites:
Data Input: Column formats can assist with data input by maintaining uniformity and giving you a shortcut. For example, you may want to restrict the options in a Status column in a project tracker to "Not Started", "In Progress" or "Completed". The Select List column format allows you to restrict data inputs to that list of items AND provides a drop down for easy data entry
Present information in a useful way: Column formats also display the data (and input options) in more useful ways. For example, the date column format allows you to configure exactly how you want the date to look and how you want to interact with it. Not to mention the ability to create quick checkboxes and sliders.
Types of Column Formats
We offer a number of different column types, and sometimes even add new ones.
We even offer a wide range of pack columns, depending on which packs you're using in your doc.
Regardless of which column type you choose, you'll be able to make adjustments to the column via the column options. To access this, click on the format icon in the column header, then select [column type] options.
The Power of the Lookup Column Format
One of our most powerful column formats, Lookups allow you to link information from another table to the current table. This is a great way to ensure that information in your doc is consistent across tables and sections. As a heads up to spreadsheet aficionados, our Lookup Column format works a little differently than vlookup.
How to use Lookup Columns
Lookup column formats allow you to reference an entire row from another table. You can then project information from the newly-linked row to other columns in the current table.
When you set up your column to Lookup, you'll be asked to select a table within the current Coda doc. You'll be importing row information from this table.
To reference a specific row, you'll want to select the display column value of the row you are referencing.
After you set up the lookup column, you can then reference data from the looked-up table.
To make changes to information in looked-up columns, head to the original table and update the source material.
You can read more about the power of lookups here.
Column Formats FAQs
How do I add an Image to a Table?
Start by clicking the column menu and select the Image column format.
Now, simply paste the links to the .jpg or .gif of the image, and you'll see them render in your Coda doc.
How do I add a calendar to a column?
For any column where you want a calendar option, click the column header and choose Date Picker or Date Range Picker. You can also add dates using formulas in your canvas.