Enum select from 2 different colum

[Mark_11]

Hello,
i have an enum column [grade]
i would like to filter the choices by key.

table1 has [key][grade1][grade2]
table2 has [key][grade]
In the form i would pick one between [grade1] and [grade2] based on [key]
Is it possible and what would be the valid if condition?
I tried with Select but i’m not able to pick from 2 different column

thanks

[Bahbus · Accepted solution]

Use a SELECT()+SELECT(). They both create return as lists and you can just add the lists together.

[Mark_11]

Thanks, it works
I didn’t try the “+”

[Steve]

help.appsheet.com

List Expressions and Aggregates

List expressions use operators that result in a list or numeric value.