Currently by default if you create a drop-down column based on another table via ‘Lookup From Table’, the drop-down menu is in order of Row ID (essentially order of creation). Is there a way to change this? Simply changing the sort mode of the original table has no effect. In most scenarios you want the drop-down to be alphabetical for easy searching.
Adding a sort option to Lookup would be great. Will add this to our feedback tracker!
You can workaroud this by using Select list and using Sort() in the formula there but this is different from a lookup (where you get @refs in your column)
I am wondering, if there is an option to lookup in the list in Table 6, sort the list in Table 7 and at the same time have the option to enter new item to the list by typing it in Table 7.Column 2?
I find the lack of option to sort the dropdown menu of “lookups” and “select” types quite a deal breaker for solid implementation of Coda with large amount of data.
I am trying to accomplish the kind of stuff as described below but with many things (hundreds) and many locations (hundreds). So sorting is essential to find stuff efficiently.
This is how I want it really to be. The cells with small arrows on the right being lookups and the grayed ones are automated by formulas.
Problem is the dropdown menu of the lookups is not sorted according to alphabet but according to the creation order.
The workaround using sorted lists fields and described earlier in this thread works.
list is indeed sorted
BUT now the columns based on formulas referring to the lookup are screwed !!!
Coda doc is here
Has anybody any idea how to make this work properly ?
@mallika any news about the sort feature being implemented in the dropdowns ?
Thank you all !!
Hi Rolando, the issue here is a type mismatch. You’re trying to compare a Text value with a Column.
See this thread to understand.
The simplest way to fix your doc here is to change the Select List to fetch the row references
THINGS instead of the text only. Note that this also solves the
all owners problem you had.
Thanks @Dalmo_Mendonca !!
You’re a beast
And so basically, a select list type with a formula =[TABLE].sort( ) is exactly a sorted lookup type ?
Pretty much. Apparently,
Sort() with no arguments uses
ascending and the Display Column by default, but in some cases you may have to explicitly pass the args (https://coda.io/formulas#Sort).
The Sort() function works for lookups from List, but does not seem to be an option for lookup from Table. Can anyone provide some advise? Thanks.