Help

Re: Display a single value in a lookup or formula field from another table

Solved
Jump to Solution
2124 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Brilliant_Admin
6 - Interface Innovator
6 - Interface Innovator

I have a table where we have products defined something like:

Product name | Client | Other product info

In another table, we have the columns:

Products selected | Client

You select multiple products for Products selected and the Client column is a lookup.

However, the same client shows up multiple times in the Client field if more than one of their products is selected. Is there a way to show any given client a single time in the Client field?

I had hoped that using a new field, Client unique with the ARRAYUNIQUE function would do it. But ARRAYUNIQUE only seems to work on numeric arrays.

Any idea how to accomplish this?

Thanks.

1 Solution

Accepted Solutions
Btbml
7 - App Architect
7 - App Architect

ARRAYUNIQUE should work, just make sure you don’t have an extra space before/after a client name that would force it to be unique

See Solution in Thread

4 Replies 4
Btbml
7 - App Architect
7 - App Architect

ARRAYUNIQUE should work, just make sure you don’t have an extra space before/after a client name that would force it to be unique

Thanks. I had not explored rollup fields. So a rollup field with ARRAYUNIQUE(values) did it.

Thanks.

I just reread your post and noticed you were using lookup. You beat me by 30s to mention rollup

I marked yours as a solution… I figured it out as I was going but wanted to credit you.