When creating a Ref column, the full item list from the base table is populated in dropdown list by default. However, when defining the same column as an EnumList with a Ref base type, only the first item is populated in the list. I am then forced to implement a SELECT() function to populate all items in the dropdown list. Below are images of just the basic column defined - no expressions specified.
Default for Ref type column
Default for EnumList of Ref base type
Solved! Go to Solution.
Yep Iโve also seen this many times before. Iโm not sure if this is a โbugโ, but rather the column definition follows Enum/EnumList rules rather than Ref rules. You have to give options or a valid_if/suggested values List for Enum/EnumList columns.
The simplest solution is as @Brand-It mentioned, just putting table[key-colum] (or FILTER(table,TRUE)) into valid_if/suggested .
@WillowMobileSystems I believe what youโre seeing with only the single item is actually the dropdown just showing you previously used values from other records in that table, as Enum columns always do when โallow other valuesโ is true.
I had the same issue & thought that I was doing something wrongโฆ A workaround for me was to enter the table[column] into the โSuggested Valuesโ expression field instead of the โValid_ifโ field.
Yep Iโve also seen this many times before. Iโm not sure if this is a โbugโ, but rather the column definition follows Enum/EnumList rules rather than Ref rules. You have to give options or a valid_if/suggested values List for Enum/EnumList columns.
The simplest solution is as @Brand-It mentioned, just putting table[key-colum] (or FILTER(table,TRUE)) into valid_if/suggested .
@WillowMobileSystems I believe what youโre seeing with only the single item is actually the dropdown just showing you previously used values from other records in that table, as Enum columns always do when โallow other valuesโ is true.
Ah, yes you are correct. I didnโt think of that. The fact it was showing only a single value was the only reason I labeled it as a bug. Iโll retract that.
User | Count |
---|---|
36 | |
33 | |
27 | |
23 | |
18 |