How can I filter a select list for all yet unchoosen items?

1

Hi coda-experts,

often I use a table as a select list. If I klick into the select field, coda shows me all entries in the table for select.

Now I’d like to see only items which are not yet choosen before. So it prevents doubled entries.

I tried it with the following filter:

ListCombine([Select-Table].Name,[Target-Table].Name).Unique()

A pro like you see it doesn’t work. Can you help me to do it better?

Thanks a lot and kind regards
Franko

2

hi @Franko_Hoffmann-Samaga , welcome back to the community, it has been a while.

I believe this question has been answered before a few times, anyway here we go:

go to the lookup column, go to option settings and custom filter like below:

image
image1502×1470 168 KB

in my example (employees) I don’t need it, but in case I would like to apply the logic it would go like this and you replace the name of my column (employees) with yours and it works.

image
image1535×787 74.7 KB

In coda everything is a list and the filter you access via options defines which items in the list you want to see, in our all case the currentvalue (the item) can contain all items but not the already used ones thisTable.columnName

More info on related matters in my blog:

Enjoy, cheers, Christiaan

2 Likes
3

Hi Christiaan,

thank you so much (for repeating this solution again and again as well). It would never have occurred to me to use CurrentValue for this. I tryed a lot and used the search of course. Sometimes its so simple when you got a hint.

Have a nice day and best regards
Franko

4

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.