Help with Lookup Column type

Ask for Help
1

Hey Guys,

When I do lookup for a filed from particular column. It lists all the values present in the particular Column. Is there a way I can only get the single value from the row it is selected?

EX: I have a table A which has two columns “Brand Name” , “POC Name” “Owner”

In Table B I have a choice column, which lists all the “Brand Names” from Table A —> when I select one Brand Name —> It should auto populate the "POC Name " and “Owner” from Table A based on selected value in the dropdown.

Can someone please guide me as to how can we do this?

I was using airtable where Lookup can be limited to particular column value. Now sure how to do it in glide db

Regards,
Dilip

2

I did it using combination of relation column and Lookup from Relation column.

is this ideal way to do it?

Regards,
Dilip

3

Yes, that’s the correct way to do it. Your original way targets the whole column, the new way “filters” it through the relation, so it should be the correct value you’re looking for.

1 Like
4

Thank you for the reply :slight_smile:

5

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.