Does somebody know how to make function that resets enum from yes to no button, at the end of every month?

Please Help.
Is there somebody who knows how to make function that resets enum button from yes to no , at the end of every month?

0 3 269
3 REPLIES 3

LeventK
Participant V

@ns_soft_studio1
You can use below expression in the Valid_if property of your ENUM column. Please remove provided you have preset values in your ENUM options. Provided you do have more options in your ENUM column, you can add them to the below expression inside the curly brackets within quotes and comma separated.

IF(
	TODAY()=EOMONTH(TODAY(),0),
	{"NO" , "OtherOption1" , "OtherOption2"},
	{"YES" , "OtherOption1" , "OtherOption2"}
)

Sorry for the late response, tnx a lot we will try this and let you know how it went.

It is not clear what you are asking. What do you mean by โ€œresets enum buttonโ€?

Top Labels in this Space