Lookup from other table

Hey @Jean_Pierre_Traets

EDIT: it even works with, and coda automatically refers it to the current row

=Kartela_ID.TOD 

i think it should be enough to just insert:

=thisRow.Kartela_ID.TOD 

Because if your column “Kartela_ID” in “Orders ALL” is a “Lookup from Table” than it selects the whole row (and shows the selected display column), and you can just reference to any other column of the table with thisRow.Kartela_ID.COLUMN_NAME

You can also do it with a lookup, but in your case it is more complicated and shouldn’t be necessary :-1:t4::

=Kartela.lookup(Kartela_ID, thisRow.Kartela_ID.toText()).TOD

Hope that helps :slight_smile:

3 Likes