I have an enumlist field in a form with a ref base. The suggested values total over 150 names. Currently, all names are selected when the list is first opened. I would prefer that the names appear unselected as the user is most likely to only want to select a few of the names. How can I make the suggested list appear without them being pre-selected?
Also, when the list of names is displayed and the Clear button is pressed, instead of the checkboxes becoming unchecked, the whole list of names disappears. This seems like a bug. Is it?
FWIW, I have some Enumlist columns with base type Ref and some with a suggested values expression (although no single column that uses both those features). In my case, these columns function as expected–i.e., no values are initially selected.
Thanks. I actually spoke too soon. I went back and discovered that the expression I had for listing was in the initial value. I tried moving it to the suggested value, and it didn’t work. I tried making the suggested value members[id] (the key value) and it gave me an error saying that the output doesn’t match the expected type. I tried members[name] (the label value) and it presented the correct list (with the annoying yellow icons), but didn’t save any value for the field. So, I’m closer but it’s still not working correctly.
Since the column is referenced to another table, its values indeed must be from the referenced table’s key column. So, this is presumably on the right track.
This sounds like something is off in your expression such that it doesn’t return a list, which, of course, is the data type required for the Suggested values property.
Right–since these aren’t values from the referenced table’s key column.
Thanks @dbaum ! Your last note spurred me to try some stuff. It turns out that tableName[Column] does not produce a list, but a list of lists, according to something I read on in an article on constructing lists. So members[id] doesn’t work but SPLIT(members[id], “,”) works like I was expecting! To get them in order I thought I’d need to wrap that in a sort function, but it turns out the reverse wrapping was the way to go:
That applies when the column uses a list data type itself–either List or EnumList. That’s somewhat uncommon for a table’s key column–especially one named “id”. It may make sense for your use case, but I note it in case there’s yet something else unintended going on.
In the AppSheet table definition for members, the [id] field is a number field. The source is an auto incrementing INT field in a MYSQL table with a primary index. Perhaps it’s the index that causes APPSheet to interpret it as a list?