Lookup Table with Unique Names Only

@cnr

I just played with this some more and it looks like you don’t even need .Unique(). That seems to be built into Coda’s ‘Select list’ algo.

To see this better, set up two Select columns and enter these Select options, one in each column:
types
types.type

The first references a table and returns a list of the table’s rows, and since every row is unique under the hood, it returns “duplicates” (because they aren’t really duplicates).

The second returns only uniques.

The reason you’re getting all the duplicates in your list is because you’re using a Lookup column which references all the rows in the Lookup table, and since each row is unique under the hood, it returns every row in your drop down list. This relates to what I said earlier about having unique values in your Display column.


4 Likes