Help with Enum List Ref Type

AppSheet AppSheet Q&A
1

I have an Enum List, Ref type connect to a Manifolds Table

In the verify if, I put in Manifolds[ID] and it brings in all the manifolds

I want to limit the selection to only Manifolds with the [Status] of “On Bid”

SELECT(Manifolds[ID],(Manifolds[Status])=LIST(“On Order”)
)

Returns no options even though there should be several, I have written the logic 20 different ways and I am not seeing why none are come through, Is there any special considerations?

2

The SELECT() is not constructed correctly. The correct form of the expression should be something like:

SELECT(Manifolds[ID], [Status] = "On Bid")
1 Like