How I get the first value from enum list

AppSheet AppSheet Q&A
1

Hi,

I have a EumList column. I would like to get the first selected value in the enumlist.
I tried using TOP(Table[Column], 1) in a virtual column , but I got the first value not the first selected value.

thanks!

2

Referencing a Column value in a Table, versus referencing ALL Column values in the entire Table Tips & Tricks ?

Having answered this question about 1 million times now, I guess I should make a tips-and-tricks post about it. Expressions of the form Table[Column] return a List type data value that contains the values in Column for ALL records in the entire Table. Most likely, If I’ve referred you to this post, the answer to your question is simply to change it to just: [Column] One of the most common places I’ve seen new app builders use this, is within SELECT() expression, like: SELECT( Table[Col…

Also. TOP() returns a List, you probably want to use ANY() or INDEX(…,1) instead.

2 Likes
3

Thanks Marc

1 Like