valid if expression

[bolognesiedalla]

sorry for the probably trivial question.

In table INTERVENTI i have 2 enum fields

I would like that in the field [MOD-DISTRIBUZIONE],  choosing "radicale" in [DISTRIBUZIONE], only these values ​​appear:
-spandiconcime
-fertirrigazione
-a doccia
-a barre

While choosing "fogliare" in [DISTRIBUZIONE]
in the field [MOD-DISTRIBUZIONE], just appear "fogliare"

how should i fill in the valid if field?

[JuneCorpuz · Accepted solution]

Hey. Your Valid_If expression will look like this

IFS(
	[DISTRIBUZIONE] = "radicale",
	LIST(
		"spandiconcime",
		"fertirrigazione",
		"a doccia",
		"a barre"
	),
	
	[DISTRIBUZIONE] = "fogliare",
	LIST(
		"fogliare"
	)
)

[bolognesiedalla]

THANK U VERY MUCH. I had done the same formula but it gave me an error. Maybe I had forgotten the second LIST. good

[Suvrutt_Gurjar]

Hi @JuneCorpuz ,

Sorry, while I was slowly typing in my mobile, you had already responded. 🙂

I wish ,we could get an alert on a response being posted while we are typing.

[JuneCorpuz]

No worries!

[Suvrutt_Gurjar]

Please use valid_if in [MOD-DISTRIBUZIONE] instead of defining values in column setting as

IFS( [DISTRIBUZIONE]= "fogliare", LIST("fogliare"), [DISTRIBUZIONE]="radicale", LIST("spandiconcime", 
"fertirrigazione" ,
"a doccia" ,
"a barre")

)

Alternatively,  please use SWITCH() instead of IFS() for more compact expression.