Dependend enumlist with values which are not selected in other Enumlist

[Arjen_Ruitenbee]

Hi,

In a row I have two enumlists of the basetype ref. both refer to the same table.

Is it posssible to make sure that in the enumlists values which are selected in the other list can't be selected anymore?

I tried NOT(IN([Clubkey],[_thisrow].[Clubkey])) 

[Joseph_Seddik]

List Subtraction | AppSheet Help Center 

[Arjen_Ruitenbee]

I still can't get it working..

SPLIT(List(clubs[ClubKey]),“,”)
- List([_thisrow].[ClubKey])

works, but not onchange on the form. So it only looks at saved data

[Joseph_Seddik · Accepted solution]

Just try: 

SPLIT(List(clubs[ClubKey]),“,”) - [ClubKey]

If it doesn't work, please show your table columns.

[Steve]

SPLIT(clubs[ClubKey],“,”) - [ClubKey] should be sufficient, without LIST().

[Joseph_Seddik]

Oh yes. Thank you @Steve !!

[Arjen_Ruitenbee]

BOOM! thanks this works!