Feature Request: Lookup field type returns unique values

It would be extremely useful to have the ability to control whether a lookup-type field only returns unique values versus showing the full list of lookup values. For example:

Table 1:
Record A
Record B
Record C

Table 2:
Record X, Category 1, Links to Record A
Record Y, Category 2, Links to Record B
Record Z, Category 2, Links to Record B

If I add a Lookup field to Table 1 showing which categories are in the values linked to these records from Table 2, I get:

Table 1:
Record A, Linked to Table 2: “Record X”, Category Lookup: “Category 1”
Record B, Linked to Table 2: “Record Y, Record Z”, Category Lookup: “Category 2, Category 2”
Record C: Linked to Table 2: “”, Category Lookup: “”

The desired behavior is that this Lookup field would show “Category 2” without the duplicate for Record B in Table 1.

Did you try using the ARRAYUNIQUE function in your Rollup field?

Also, you can check out this workaround here:

Thanks for that suggestion @ScottWorld - I’m going to test out that automation approach now.

I mixed up my nomenclature in the original post (just edited it to correct) - I am hoping to use a Lookup field, not a Rollup Field, so that I can retain the linked fields functionality rather than returning a text string alone.

1 Like