Filter an Ref enum of another table

AppSheet AppSheet Q&A
1

I´m trying to select only the contacts that are set as “User” in the table of “Events”, I´ve tried with diferent functions… but no mater what i put always returns all of the “Conctact list”.

This are some of the expressions I have tried:

1. Filter(
“Contactos”,
ISNOTBLANK(
Contactos[Es usuario]
)
)

2. Select(
Contactos[ID],
ISNOTBLANK(
Contactos[Es usuario]
)
)

3. Filter(
“Contactos”,
Contactos[Es usuario]=“Si”
)

In #3, cant do it because appears: “****Cannot compare List with Text in (Contactos[Es usuario] = “Si”)”, I´ve tried with: TEXT(Contactos[Es usuario]) = “Si” but nothing…

  • Table where the colum with a ref enum is set: "Evento" (event)
  • Colum where the ref enum is set: “Vendedor” (Saller)
  • Ref table to enum: “Conctactos” (Contacts)
  • Colum in the table “Contactos” that determines the parameter: “Es Usuario” (Is user)
  • Colum data type “Es usuario”: “Enum” whith the only value “Si” (yes)
2

Please try in the valid_if of the reference column:

Filter(
“Contactos”,
[Es usuario]=“Si”
)

Or please simply try:

Filter(
“Contactos”,
[Es usuario]
)

The assumption is you are trying this in the valid_if of the reference column in the "Evento" table where you are referencing the Contactos table. [Es usuario] is assumed to be Y/N type column or enum column with options “Si” and “No”