Only show the first value in the lookup field

Hello,

In my base, one table has 2 records each. Currnetly, i do a lookup and it shows me both records. I only want the first to show up because it just doubles the name twice. How can I make it so that when i lookup from that table, only the first (or last) record shows vs having both.

Try using a rollup instead of a lookup, and use this formula.

ARRAYUNIQUE(values)

1 Like

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.