Can’t retrieve correct coefficient from Klase/Suga table with Relation + Lookup

[Kristaps_Lagzdins]

Description:
I have two tables:

1. Koki (Logs)

• Suga (no Konteinera) → lookup from Konteineri
• Garums (mm) → lookup from Konteineri
• I need to fetch the correct coefficient from the Klase/Suga table based on both species and length.

2. Klase/Suga (Species/Classes)

• Column Suga (e.g., A Priede, B Egle)
• Column Garums (mm) (e.g., 2700, 2900, 4000…)
• Column Koef (the coefficient value I want to retrieve into Koki)

What I’m trying to do:

• In the Koki table, I created a Template column Species-Length Key, expected to look like “A Priede - 4000”.
• In the Klase/Suga table, I created an identical Template column with the same format.
• Then I made a Relation: Koki → Species-Length Key to Klase/Suga → Species-Length Key.
• Then I added a Lookup to pull the Koef from Klase/Suga.

The problem:

• Glide shows me all the rows from Klase/Suga instead of just the matching one (e.g., “A Priede - 4000”).
• Sometimes in the Template replacements, my column “Suga (no Konteinera)” doesn’t even appear in the dropdown, only an empty option.
• As a result, the Lookup doesn’t return a single coefficient, but instead a list of all values.

Question:
What am I doing wrong? How can I make the Relation + Lookup return only the single correct coefficient for a given species and length (e.g., A Priede + 4000 → 1.80)?

[Darren_Murphy]

• If your Lookup is returning an array of values, that most likely means that your relation is a multiple relation instead of a single relation.
• Also, the template should not be necessary. If you use a Query column instead of a relation, you can apply filtering directly in the column configuration. It would be something like:
  – Species is This row->Species
  – Length is This row->Length
• If you switch to a Query column, then instead of a Lookup to fetch the coefficent value, use Single Value->First

[Kristaps_Lagzdins]

– Species is This row->Species ( It doesnt appear such choice )

[Darren_Murphy]

Is Species a lookup column from another table?
Just looking at your earlier screenshots, it appears it might be a lookup via a multiple relation, so it’s returning an array:

If you make the relation a single relation, then the lookup will correctly return a single text value as opposed to an array, and then it should appear as a filter option with the query.