Lookup from other table

1

image
image.png958×256 8.54 KB
image

Dear Coda lovers, :sunglasses:

I have one table called “Kartela” that has to the “Kartela_ID and assigned TOD (Time of Delivery)
In the second table called Örders ALL” .

Please could you advise how to write the lookup formula to call the TOD that is connected to the “Kartela_ID”?

Thanks for your kind support,
//JP

2

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
3

Dear Daniel,

You made my day :smiley:, your first suggestion worked out well :+1::+1::+1:

Important is to mention to other users to benefit from this advise it to change the format to text to get the proper result.

3 Likes
4

Yes, I always struggle with this one until I remember what I forgot. Whenever you want to use the value from a select, multiple select or lookup from table in an if, filter or lookup, you need to format it to text, otherwise you just have the selected „object“, not the string.

2 Likes
6

Hi @Jean_Pierre_Traets,

I had a similar question and searched for something like VLOOKUP from Excel and got this create answer from Betty:
Step One - Create a table with e.g company names. You will use this when assigning companies to employees through the People lookup table.
image
Step Two - Create a table with e.g. employees, and the companies they work for.You can format the Company column as “Lookup from Table” to pull data from the Companies table created in step one.
image
Step Three - Create a task list, formatting the assignee column as “Lookup from table,” so you can use the data from the People table created in step two. If you want to view the company the assignee works for, set the formula of the third column to be =Assignee.Company.
image
So I guess this would be also a easy solution for you.

4 Likes
7

@Thomas_Hebes, Thanks for your input :bulb:, lucky enough I managed over time to learn this method myself.

Keep enjoying Coda, the Sky :rocket: is even not the limit :grinning:

Amicable,
@Jean_Pierre_Traets

1 Like