Help

Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

Duplicated Content in Lookup

Topic Labels: Formulas
Solved
Jump to Solution
585 2
cancel
Showing results for 
Search instead for 
Did you mean: 

Has anyone seen duplicated content resulting from a Lookup?

I’ve noticed this in a couple different tables and it is causing formula errors for me.

For example, I have a lookup on a single select field with only these options: http://photoville.org/uploads/2020-08-05_073451_3zvyyjo.png

Yet, in the resulting field, there are sporadic entries that appear as ‘Clinical Trial, Clinical Trial’

When I subsequently attempt to use this field in a Switch(), I get ‘#ERROR!’ in those case where the entry is duplicated.

1 Solution

Accepted Solutions

Welcome to the Airtable community!

Is the record with the duplicate content in the lookup linked to multiple records? More specifically, is it linked to multiple “Clinical Trials” records? A lookup field shows the lookup value for all of the linked records. If a record has two record links, the corresponding lookup would show two values, even if they are the same.

An alternative is to use a rollup field with the ARRAYUNIQUE(values) formula.

See Solution in Thread

2 Replies 2

Welcome to the Airtable community!

Is the record with the duplicate content in the lookup linked to multiple records? More specifically, is it linked to multiple “Clinical Trials” records? A lookup field shows the lookup value for all of the linked records. If a record has two record links, the corresponding lookup would show two values, even if they are the same.

An alternative is to use a rollup field with the ARRAYUNIQUE(values) formula.

Thank you, that totally was the problem, and a nice solution!