Dereferencing Refs inside an EnumList

[Stelios_Papamic]

I have a WO_MASTER table which has an EnumList of Refs to another table named WO_ACTIONS. The master table also has a [description] column which i only wanna show if the [Action Name] column from the WO_ACTIONS table pointed to by the refs in the enumList is equal to the value of “Other”. How can i dereference the refs inside the EnumList?

[Steve · Accepted solution]

See Constructing a List from a List Dereference here:

help.appsheet.com

List Expressions and Aggregates

List expressions use and/or produce lists of values.

[Marc_Dillon]

@Steve This does not appear to work for EnumList real columns.

---------------

Confirmed this in another app as well.

[Steve]

Marc_Dillon:

This does not appear to work for EnumList real columns.

Ugh.

[Marc_Dillon]

Unless I’m mistaken somewhere?

Be real nice if it did work this way.

[Steve]

I’ll ask about it.

[nkadonaga]

Hi folks, I am currently working on fixing this. I’ll update the thread when it’s been rolled out to everyone.

[nkadonaga]

The fix for this has been rolled out to everyone