List of values from a row

AppSheet AppSheet Q&A
, ,
1

Hi,
I habe in a table for example 3 columns.

Mother Father PrimaryContact
Susi Strolchi

I need to build a list for the column “PrimaryContact”, where the values are “Mother” and "Father.
I have tried this with enum, but in the values I can’t use the [Mother] Value.

I have tried to leave the values blank and use the LIST() command, but this does not work:
LIST([Mother], [Father])
The expression is valid but its result type ‘List’ is not one of the expected types: Enum

I have no idea what can I do to get the booth values Mother and Father into a enum column type.
Thx for your help.

2

Try to use LIST([Mother],[Father]) with the Suggested values.

3

sorry, my fault with copy and paste…
I have tried LIST([Mother],[Father]) but I get the error message: The expression is valid but its result type ‘List’ is not one of the expected types: Enum

The column is from type enum and no matter what I take for base type like list, text… nothing works.
I use the LIST() command in the auto compute app formula.

4

You have it in a wrong place. Move it from app formula field to Suggested values field.

1 Like