Select lists as table with multiple columns

Hi I’m new to coda and quite a beginner with smart tables.

I would like to setup a master “Table 1” that get some “data” from separate table “Data” in multiple columns. I know it’s possible to convert select list into a table, but I would like to set specific column from which the options would be pulled from.

I made a quick example on the screenshot below. And can’t find any option on “Lookup” popup where to set from which column form my “Data” table it should get the values as select list.

Is this even possible? Should I use some formulas, or get rid of this idea and create 3 separate single tables for each select table individual?

Hey @Jan_Zmuda, welcome to the community!

While you certainly do what you want with a formula, this is not the right way to organize data. You shouldn’t think of Coda tables as pieces of Excel sheet where cells are only as linked as you want them to be (e.g. by visually placing them near each other). In Coda, one table = one list of items of one kind (i.e. that share the same meaning — list of colors, list of countries, list of products in inventory etc), and columns are extra properties of those items (e.g. for the list of Sizes it could be separate columns for European size, UK size, US size, Japan size etc).

If you have lists that are totally unrelated (in terms of your system), they should go on separate tables.

Dear @Jan_Zmuda

Next to the valuable feedback of Paul, I recommend to have a look at the Coda YouTube channel, to get a feeling how this great tool works:

Thanks for the answer.

But let say that I have a separate table with some related data as you mentioned, how to point which exactly column to create a list? My situation in example:

So two columns, EU Size and UK Size, how to point to specific column in my master table?

1 Like

You don’t select a “column”, you select an item (a row) from the table.

The value that’s displayed for you to select is of that column that you designated as Display column:
image

You can open the menu of any other column and select that one as a display column. It is important to understand, though, that regardless of the display column, you’re NOT selecting just that one value but you’re linking the whole row (e.g. the Small size, which corresponds to different numbers in different systems).

If you’re only interested in a plain selection list to select one value from, then no need to use Lookup, just use Select list column type.

I think it is really strange that you can only get 1 column back. for example in the screenshot below:

I would also like to get “colorname” in my TEST table but that is not possible via lookup formula because I already get the material back. Hope I make sense…

For sure I can also make another table with color & colorName but that is really not what I want.
101 is connected to the material and “white”

Hi @Jeroen_Broerse
and welcome to Coda Community! :handshake:

If I correctly got your point, you can in fact easily get the lookup-relative columns.
In the TEST.colorname column just set the formula thisRow.Material.color Name and you’ll have the relative column.

Please, let me know if this helps.
Otherwise, sharing a sample with your needs would help to directly put hands on your solution.

Cheers!

1 Like

Hi Jan,

Welcome to the CODA Community! Or can I say “Welkom bij CODA?”

The first time that you use lookup, it will link automatically to your display column, which is typically your first column in the table. That will then establish a link between the two tables, so that it knows which row to relate to in the second table, You can then use that column to create additional lookups:

There various ways to link tables to each other, I explain how to do a few ways in a reference document that I maintain here.

1 Like