Inside this article

Select list basics

Select list vs. Lookup

Select list options

Converting select lists into tables

Creating select lists from entries in tables


Select list basics

Select list is a common column type in Coda. This column type allows you to create a list of selectable text values. They can either be single-select or multi-select. Select lists allow you and your collaborators to adhere to specific naming or labeling so everything stays organized in your tables. You can add as many options as you want and see them clearly in a dropdown list.


If you have an existing column that you want to turn into a select list column, click the header, select “Change column type”, then choose Select list. Coda will then use the items that already exist in your column to populate the options for that list.

Screen+Recording+2021-04-29+at+04.37.58+PM.gif

In addition to Select lists, Coda has a wide variety of other column formats to choose from. You can learn more about your options here.


Select list vs. Lookup

Select lists and Lookups may seem like similar column types. They both allow you to create a list of selectable items. The key difference is that Lookups reference a separate table, and allow you to select rows from that table. Select lists consist of text values, stored in the settings of the column.


Select list options

Under the column options for a Select list column, you’ll see a number of unique settings:

Screen Shot 2021-04-29 at 4.01.15 PM.png

Here, you can adjust various options for your column, including:

  • Selectable items: all the items of your Select list. These can be simply listed out and separated by commas. Or you can press the “f” symbol to write a formula to specify the selectable items.

  • Convert to table (read more on this below) pressing this button will generate a new, single-column table, with each item in your list automatically becoming its own row in this new table. Taking this action will automatically convert your column type to a Lookup, since the column is now referencing rows in a separate table.

  • Allow multiple selections: toggle on or off to dictate whether only one or multiple values can be selected for each row

  • Default value (learn more here)

  • Sort: sort the order in which your selectable items appear in the dropdown menu

  • Allow quick adding of new items: toggle on to allow new items to be quickly added to your list via the row itself (see example below). If you’ve converted your select list to a table, toggling this option on will also allow editors to add new rows to the referenced table.

Screen Shot 2021-04-29 at 4.05.06 PM.png

Converting select lists into tables

Sometimes, it becomes valuable to move information out of the column and into its own table as the doc grows.


Say you start a tasks table and add a select list column for each task's team. Later, you may want to start tracking other information about each team, like its members or location.


Or, say you have a select list for company milestones that you use in a projects table, and now also want to use in a separate goals table.


In both of these cases, the best option is to move the values of that select list into a separate table that other tables can lookup values from.


That's just a few clicks away! Open the Select list options and choose Convert to table. You can also adjust the name for the new table and its location if you like. This will generate a new, single-column table, with each item in your list automatically becoming its own row in this new table. Taking this action will automatically convert your column type to a Lookup, since the column is now referencing rows in a separate table.

Screen+Recording+2021-04-29+at+04.46.35+PM.gif

Creating select lists from entries in tables

Sometimes you'll want your select lists to pull content from another one of your tables. Not a problem! You'll use a lookup column format. Since lookups connect your tables to together, any changes you make in the lookup table will automatically populate your select list.

Did this answer your question?