Solved: Get Enum/Enum List from a data sheet in a specific... - Page 2

dalebyers

Hello, I am using a data list to pull a dynamic enum list based on Category, Subcategory & Field chosen. This is working great, except I need to be able to control the order of the list. Appsheet is not pulling the order as it is listed in my google sheet. Example:

My expression:
SELECT(
DetailValues[Value],
AND(
[Category] = [_THISROW].[Category],
[Subcategory] = [_THISROW].[Subcategory],
[Field] = "In Attendance"
)
)

Category = Inspection Details

Subcategory = General

Field = In Attendance

Values:
Client
Client's Agent
Listing Agent
Home Owner
Other

But the enum comes in as:
Client's Agent
Listing Agent
Home Owner
Other
Client

I would like to use this method for many columns, but order will be very important - any way to control the order the list displays?

Steve

@dalebyers wrote:

So I would have a field showing the Key for the item that was chosen from the enum and another recording the Value for that Key?

Yes.

so that would mean adding a lot of additional columns to dereference each

Yep.

is there any way to dereference it inside the expression that captures the selection?

Nope.

View solution in original post

Get Enum/Enum List from a data sheet in a specific order?