i have a certain number of rows in a table.
I have a deadline colum; i would like to auto set the value of another enum column like if([deadline]<today(),“EXPIRED”,“ON GOING”).
Something like a calendar trigger; i don’t want to enter in that row to edit some value in order to trigger a workflow “set value…”. I’d like to see an auto update of my database.
Is it possible?