Just checking..Is there yet a way to pull a single REF item from a list and dereference it?

[WillowMobileSys]

Many times we have lists of REF items (such as for an EnumList/REF column). Occasionally, we want to pull an item from that list and access some of the other row attributes. Currently, we need to pull that item from the list and then use it for matching in a SELECT() function. For example:

ANY(SELECT(Table[Desired Attribute 1], [ID] = INDEX([REF Enum List], 1)))

ANY(SELECT(Table[Desired Attribute 2], [ID] = INDEX([REF Enum List], 1)))

ANY(SELECT(Table[Desired Attribute 3], [ID] = INDEX([REF Enum List], 1)))

It would be much nicer, and more efficient, if I could do something like:

INDEX([REF Enum List], 1).[Desired Attribute 1]
INDEX([REF Enum List], 1).[Desired Attribute 2]
INDEX([REF Enum List], 1).[Desired Attribute 3]

The use of the “dot” notation tells AppSheet I expect the item to be a REF and wish to dereference it. (PSST, this is not my idea, it’s used this way already in C# and other programming languages).

I was wondering if there isn’t already something like this available?