I have this table, which shows all the different Units I can build. When I select the dropdown, however, the list that it offers is really really long. [image] How can I make this only offer the unique Unit Types from other unit tables? The Unit Data Table I am pulling from looks like this: [i…

Looks like you’re getting good help here but on the point of “transition a column to a lookup column”, there’s a little trick for how to do it without doing a lot of work: [image]

Lookup Table with Unique Names Only

Ander February 20, 2019, 5:15pm 7

@cnr

More tables are better than fewer tables.

You probably need at least one more table.

Topic		Replies	Views
How to get Lookup columns to display only unique values?	4	378	February 1, 2023
Showing only the unique rows in a table without repeats	8	4127	July 23, 2019
How to filter Lookup options to omit duplicates	8	749	October 3, 2020
How to create/filter a unique select list when Coda see data as unique but it is not?	2	460	January 4, 2023
How to get all the unique values from a select list of select from table	7	4329	January 7, 2021

Lookup Table with Unique Names Only

Related topics