- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Oct 19, 2022 07:00 AM
Is there a way to set up a lookup field without duplicates? I asked this here and I just noticed that the response didn’t fully solve the issue: The rollup formula ARRAYUNIQUE(values) still includes duplicates.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Oct 19, 2022 08:17 AM
I’m not 100% sure if this will work, but you may want to try this formula to see if it works for you:
ARRAYUNIQUE(ARRAYFLATTEN(values))
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Oct 19, 2022 08:58 AM
Hmm this doesn’t do the trick. Any other suggestions?
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Oct 19, 2022 09:20 AM
Add a formula field containing ARRAYUNIQUE({Purpose (from Interventions}). This should work.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Oct 19, 2022 08:47 PM
Read this discussion. May be this can help you here https://community.airtable.com/t/how-can-i-make-a-lookup-field-show-only-unique-results-uk49s. If yes then please mentioned me here.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Oct 25, 2022 12:29 AM
Well I had the same question becasue of same issue. Thank you to Scott for the answer