Skip to main content

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)

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


ARRAYUNIQUE(values)


This answers the technical issue but not the question in the title. How would airtable users create a calculation that only shows the first value in a lookup field? i.e., Is there a way to return value[0] of a lookup array?

This answers the technical issue but not the question in the title. How would airtable users create a calculation that only shows the first value in a lookup field? i.e., Is there a way to return value[0] of a lookup array?


This worked for me, using a formula field:

IF(
FIND(",", {LookupField}) > 0,
LEFT({LookupField}, FIND(",", {LookupField}) - 1),
{LookupField}
)

 

Reply


Terms & Conditions