Enumlist based on Enum value

AppSheet AppSheet Q&A
1

Hi,

I have two tables as below

Table A (ID, ExportType, Country) - ExportType is an enum type, Country is an Enumlist type

Table B (ID, CountryCode, CountryName)

I want to allow user select multiple countries if a specific type of ExportType is selected otherwise only allow 1 country to be selected. And the Country dropdown will look up CountryName in Table B.

What I tried so far in Valid If setting of Country column in Table A is that

IF

(

[ExportType] = “Drugs”,

TRUE,

COUNT([Country]) <= 1

)

And the Initial Error Value is set as “Only one country can be selected for this Export type.”

I’m struggling on how to get CountryName from Table B rather than Country column itself.

Can someone help me on this issue?

Thank you in advance!

2

Make the Country column of type EnumList with a base type of Ref referencing Table B.

1 Like