Nice 
How will you use it?
Use it like a Single Relation, but with better filtering of data to get the single row you want.
For example, lookups that are single values instead of arrays, or being able to set columns in the row through the query.
3 Likes
Doesn’t this save the additional complexity for use cases where after running a Query which only returns a single row (I have loads of use cases) you then have to use “Single Value” to get the row that so you can use it for Lookup, etc?
Or is there another use-case in addition?
Previously, a Single Value column could be substituted for a Lookup column when using a Query. You wouldn’t have needed to pass it through a single value row first to get the Lookup. You could just use the single value column pointing to a specific column through the query. However, I could see a case if you wanted to set column values through the query…then you would have needed the single value row column as well.
Now you can directly use a lookup or a single value column to get the same result, as well as set column values directly through the query. It’s basically a single relation with more robust filtering.
2 Likes