ENUM VALID IF

[anonymous]

Hi all i need some help here, I am a newbie

I have a table with name ABSEN,

and i have a column STATUS with enum type with value “MASUK” or “KELUAR”.

What i want to do is if there is no value in table ABSEN with condition like this

tanggal = today(), nama = user, and status = “masuk” , then enum list in form STATUS will be “MASUK”, else it will ber “MASUK” and “KELUAR”.

Need help, thank you

[baba_sawane]

Hi,

In Status column options, you can set the type to Text and your Suggested Values to :

if(and(

contains(ABSEN[tanggal] = today()),

contains(ABSEN[status],“Masuk”),

contains(ABSEN[nama],“user”)),

list(“Masuk, Keluar”), list(“Masuk”)

I don’t know if the logic behind is good tough.