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.
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.
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:
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:
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 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”
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.
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: