One formula for Filter() + First()

Suggestion Box
1

There is a lot of cases when Filter() result is the list with just one value. It will be convinient to have a formula like FilterFirst(...) or just First(...) with an ability to pass condition, like in LINQ.

2

Hi @Denis_Peshekhonov - thanks for the suggestion. Wondering if Filter().first() does what you are looking for.

3

Yes, I know. Filter().First() works well. But I think this is so usual case, it deserves a separate formula for simplicity :slight_smile: And also there is some trouble with First() after Filter().

4

Don’t some programming languages treat a single-element list as the element itself when appropriate? Maybe there’s some more “magic” Coda can treat us with here?