Filtering / searching for a record based on "latest/oldest" in a date/time field?

I think there is no native way to:

  • create a filter that gives you just 1 result based on a fields value (newest/oldest)
  • create a search in automation, that finds a record based on a field value (newest/oldest)

Current closest workaround seems to be using an automation “search block”, turn it into a script and manipulate the search script?

We are achieving this via:

  • create new view, sort that one by newest or oldest first, save that view
  • after that use that view in automation and you can limit search to one result and later do whatever you need to
1 Like

…is it given, that the retrieve view will respect the same sorting?
I now turned the search block into a script and sort within.

From my experience it respects the sam filter.
We are using this method for numbering where record id is not the same because record can be deleted and then numbers are not following. This way we get what we need.