Searching for Unique elements based on 1 field

Currently I am trying to display datatype “Account History” in a table. Each row in the table should be an “Account History”.

I want the app to only display the oldest account history (search by creation date) entry by each unique student. The “Student” field is of User datatype.

How do I do this? I tried using the :unique elements operator but it returns a list of Users instead of a list of Account Historys


In the User datatype you may add a list field of type Account History then use a complex formula to achieve the filtering you want.

Or you may just add a field of type Account History to store only last Account History of the user (this field updated whenever the user add new Account History), then you will be able to search for users :each item last Account History.