EnumList Referencing Another Table and Allow User to Input New Values

AppSheet AppSheet Q&A
,
1

I’ve got a column (type EnumList) in one table that refers (base type Ref) to a second column (type EnumList) in another table. “Allow other values” is enabled.

If I set the “Valid If” field to that column second, the user can see the values from that column but cannot select more than one value from that EnumList add cannot add any additional values.

Please let me know how I can allow the user to make multiple selections and add new values to that list.

Thanks.

2

To add values, you need to change your Valid If and use a Suggested Values instead.

You are telling AppSheet that the values that are valid are only those of the Valid_If expression, that’s why you can’t add them

1 Like