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
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.
User | Count |
---|---|
41 | |
31 | |
31 | |
16 | |
14 |