Filtering multiple repeating values in a related field

[Gilbert]

Hello FM lovers,

I use a portal to display values in a related field. The problem is the field could have multiple repeating values of each of the values I need to display in the portal

Sample:

MyField--------------------------Portal should display

A123---------------------------------------A123

A123---------------------------------------B753

A123---------------------------------------C147

B753

B753

C147

C147

Can I use a calculation to accomplish this?

Thanks in advance.

[Razumovsky]

You mean values that repeat, not values in repeating fields, correct?

So, you are asking about showing unique fields in a portal?

typing:

+Unique +Portal

in the search should also bring up many relevant posts.

In a nutshell, the three most common options are:

Value list

SelfJoin relationship

Custom function with get nth record

HTH

-Raz