Rows make up the horizontal element of your tables, while columns make up the vertical elements. Use different columns to add different attributes to your data.
A range of column types provides various ways to format your data, allowing you to store data in the way that makes the most sense. The days of your numbers mistakenly turning into dates are gone, instead of keeping tallies for a vote, try using a reaction column! Column types allow you to change the column to fit your data, rather than change your data to fit a cell.
Within this article you’ll find...
Create a column
In Coda, a row is a single, structured data item in a table. Rows compose the horizontal elements of a table. Columns are the vertical elements of a table, which allow you to store more information in your rows. Column types allow you to add various attributes to your row data.
To create a new column, click the + icon in the upper right corner of your table. From here, you can type or select the type of column you would like to create. Give your new column a title!
Change column types
The various column types allow you to store data in a way that makes the most sense for the data. When you create a column, you can select which column type you want, but you can change this type at any point in time!
Should you decide you would like to change the type of column you’re using, click on the column type icon on the right side of the column title, hover over the Column type option in the menu, and select the column type you’d like.
With over twenty different column types supported, there is a column type out there for your data. Pair your column types with formulas and relations, and the options are endless! To see all of the columns available, right-click on a column header, and hover over Column Type.
Edit column options
To open the settings for a column, just right click on the column header, then select Edit column. Here you’ll find two tabs: Settings and Fill values.
Settings
Each column type has their own unique list of settings. For instance, Date columns will include a setting to specify the format of the date. People columns will include settings regarding notifications. Select list settings allow you to create and edit selectable values. If you’re unsure about a particular setting, you can typically hover over the ? next to the setting to learn more.
The one setting that all columns share is the Value for new rows setting. This determines what value - if any - to assign to newly created rows. You can learn more about this setting here.
Fill values
For most column types, you will have a Fill values tab. This is where you can determine if and how the column values should be automatically filled for each row. If you want to be able to manually fill this column for each row, you won’t select any option from the Fill values tab. But if you do want values to be dynamically filled, you have three options:
Calculate: Calculate values based on a formula. This formula can reference other columns and row properties. For instance, maybe you want to calculate the End date of a project based on the Start Date and the Duration (other columns in your table). The structured builder makes it easy for you to set up this calculation - even if you aren’t familiar with our formula language. Read all about this calculation builder here.
Compose: Automatically write (and format) text based on values in other columns. You might want to use this if you’re trying to dynamically generate an email message based on other values in a given row. Check out this article to learn more about the Compose feature.
AI: Prompt AI to fill this column. Learn all about Coda AI here.
Hide (and unhide) columns
Just like you can change your view to have a filter or different display type, you also have the ability to change which columns in your dataset are visible in each view. Learn more about views here.
To hide a column, right-click on the column header and select Hide from the list of options.
To view hidden columns, click on Columns in the right corner of your table. The options panel will open on the right, displaying all of the columns in your table. Columns that are visible in this view will appear with a blue eye next to them, indicating they are visible. Below you will see the columns that are hidden in this view (under Hidden columns). To unhide a column, click the grey eye icon next to the title of the column you’d like to unhide.
Change the width or order of columns
You can adjust the width and order of your columns as needed. Note that these adjustments will be visible to all viewers of the doc, not just yourself.
To resize a column, simply hover over the right edge of the column header, click, and drag to your desired width.
To change the order of columns, hover over the very top of the column header (where you see a series of horizontal dots appear), click, and drag into the desired position.
Other column adjustments
When you right click on a column header - before you select Column options - you’ll see a list of other adjustments you can make to your column.
Summarize
You can use this tool to easily summarize data in your column. Check out this article to learn more.
Add descriptions
Use this to add a description to your column. This is particularly helpful if you have others collaborating in your table, and you want to make the purpose of each column very clear. Once a description is added, there will be a small i symbol visible next to the column header. When someone hovers over this symbol, they’ll see the description.
Freeze columns
If there is a column you would like to freeze to the left of the table, you can do so by right-clicking the column header and selecting Freeze. You then have the option to freeze anywhere from 1 to 5 columns. The frozen column(s) will remain on screen regardless of scrolling horizontally.
Wrap contents
You can adjust the size of your columns by dragging them. You can wrap the column name by dragging the bottom line of the column title down. You can control whether or not the content in the column will wrap by right-clicking on the column header and selecting Wrap.
Display column
The display column, denoted by the small ribbon icon, should house the most unique information to the dataset. The display column is the default column that referenced in a relation column (learn more about relations here). You can change the display column by right-clicking on the column header, and selecting Set as display column.
Delete
To delete a column, right click on the column title, and select Delete. This column will be deleted in all of the views of this table throughout the doc.
FAQs
Why am I not able to see all of my columns?
Why am I not able to see all of my columns?
If you are not seeing a column you’d expect to, it is often times because the column is hidden. Learn more about hidden columns here.
How do I add an image to a table?
How do I add an image to a table?
Right-click on the column you would like to be an image column, hover over column type and select Images & Files, select which type you would like.
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 set a default value for a column?
How do I set a default value for a column?
You can use the value for new rows field (within column settings) to specify default values for new rows. Learn all about this setting in this article.
How can I wrap column headers?
How can I wrap column headers?
To wrap your column headers, simply drag the column header down to create another line or two. Then drag the divider between column headers to the left or right to resize the width of the header.
What are some common column types?
What are some common column types?
You can see all the column types by searching within a column in Coda. But here are some of the most common and most powerful:
Text: A text column is the foundation of many tables, great for display columns.
Number: The tried and true, a number column can be as simple or complex as you’d like it to be. You’re no longer committed to integers though, try out a scale or progress bar!
Canvas: Canvas columns are like the older sibling of a text column, allowing you to store bodies of text, images and even another table, within a single row. They are also collaborative and can be edited by multiple people at once - it’s a party!
Date: While the days of your numbers being mistakenly turned into dates are over, there are still instances you may want the date format, luckily we support a variety of dates types.
Time: Find the Time column type under the Date options.
People: Instead of typing names over and over again, the people column type allows you to put names into your cells easily, and opens opportunity for the popular User( ) filter and easily enables you to notify people.
Reaction: Reaction columns allow you to easily survey votes or react to data, rather than using tallies and counting manually.
Relation: Empowering anyone to build a relational database since c. 2015!
Button: Take actions from your table by using buttons!
and many more!
How can I pre-fill my columns?
How can I pre-fill my columns?
If you want to automatically fill all the values in that column, you can do so under the Fill values section of the Column options. You can read more about this in the section above.
If you want to assign a default value to new rows while still being able to edit and override those values, you may want to use the value for new rows features instead. Check out this article to learn more.
Can I use different column formats for different rows?
Can I use different column formats for different rows?
A column type is uniform for the entire column, meaning you can not have different formats in different rows of one column.
How do I freeze columns in a table?
How do I freeze columns in a table?
To freeze a column (or multiple columns), right-click on the column header and select Freeze from the option. Then choose how many columns you would like to freeze. If you choose 3, for instance, the three left-most columns will be frozen. Alternatively, if you choose Up to this column, all columns to the left of - and including - this column will be frozen (limit up to 5 columns).
