How to write conditional expression for filtered list (first or last thing)

[jasonturo]

Hi Bubblers,

How can we write a conditional expression in a RG that finds the first/last thing of the filtered list in the RG, not the first/last from the whole list in the DB field?

Example: Parent thing, has a list of 10 things.
The RG shows 4 things after filtering. We want to identify the first/last things of the parent’s filtered RG list of 4, not the first/last from the list of 10 in the DB.

Thanks for the help.

Cheers

[jasonturo]

Oh, got it. Need more rest.

RG’s list of stuff:filtered:first item IS current cell