Getting a cell value according to the latest date

Ask for Help
1

Hello!

Just started using Glide and finding it an amazing tool. Still learning and I think I may be having some trouble with relations.

I have two tables. One, lists bins where I have the bin number and two relations to the other table. The relation is to the number of the bin and I have a rollup which shows the latest record date on the second table.

First table, bin list
First table, bin list1409×239 26.4 KB

The second table, records the level of each bin, according to different dates. This table has the same bin number as the first one and a relation between their numbers.

Second table, records bin level and record date
Second table, records bin level and record date1405×408 49.9 KB

What I am missing is that I want as well to show along with the latest date, the latest level of each bin, a unique value. I’ve tried playing with single value, but I always get the maximum value of all bins and not the latest.

What am I doing wrong?

Thanks in advance!

2

Use a Query instead of a relation. Filter where bin is this row→bin, and sort by date in descending order. Don’t check match multiple. Then use a lookup through the query.

Or alternatively, use a rollup→ latest through your relation.

2 Likes