dirk_s
July 26, 2025, 1:42pm
1
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?
tomaz
July 26, 2025, 8:30pm
2
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
dirk_s
July 26, 2025, 9:41pm
3
…is it given, that the retrieve view will respect the same sorting?
I now turned the search block into a script and sort within.
tomaz
July 27, 2025, 11:00am
4
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.