Enum dependent on another table column with criteria

[ssinghal]

Hi,

I have a to build a list with enum dependent on another table key based on criteria if its available and active

Currently I tried -

SELECT(Cold Chain Box[Box ID], and(Cold Chain Box[Active/Inactive]="Active",Cold Chain Box[Current Status]="Available"), true)

[Aurelien]

Hi @ssinghal 

What about:

SELECT(Cold Chain Box[Box ID], 
  AND(
    [Active/Inactive]="Active",
    [Current Status]="Available"
  ), 
  TRUE
)

Alternatively, if [Bow ID] is the key-column of the table "Cold Chain Box", you should prefer using:

FILTER("Cold Chain Box", 
  AND(
    [Active/Inactive]="Active",
    [Current Status]="Available"
  ), 
  TRUE
)

For reference:

SELECT() - AppSheet Help

FILTER() - AppSheet Help