In the Enum, can LABEL be displayed in a column other than KEY?

AppSheet AppSheet Q&A
1

I am in a column (EnumList),
Use expressions:
SELECT(TABLEA[ID],TRUE)
(Another “TABLE_A”：
ID(KEY) name(LABEL))
In the menu,
The displayed option is “name”,
recorded to the background is “ID”.

But if my expression is changed to:
SELECT(TABLEA[Question],TRUE)
(Question is not KEY)
There is also a way to put him in the menu,
Is the displayed option “name”?

2

I am trying to understand your question. It seems that you want to display the question (which is not the row label) in the dropdown but save the ID to the data source. Is that correct? If so, there is no direct way to do that. An alternative would be to display the questions and record the chosen question, then add another column that uses LOOKUP() and the chosen question to lookup and record the ID of the corresponding row from table A. This approach may produce incorrect results if two or more rows in table A have the same question.

1 Like