Formula help: Make enddate empty after accomplishing task
I“ have made a simple but for me efficient Projectmanager in Ninox. The enddate for task. is linked with my calender. However, due to a lot of tasks my calendar becomes overcrowded. I Would therefore like to automatically delete the content of my enddate field, when a task is done. Reason: empty dates doesn”t produce calendar entries. So I would like to make a formula: if status is “done” then delete content of enddate in this record. Any idea how I can do this?
4 replies
-
I am assuming that you have a yes/no field called TaskDone (or similar)
so in the trigger after update propetry of that field
you could put Enddate := null
Mel
-
Forgot to say a formula field itself won“t let you modify another field
so simply have a yes/no field (make it a slider if you want it to look nice)
then insert the script into it so when you slide to YES he task is done your enddate date will clear as you wanted
Mel
-
Or you could simply add a button and set the same script on the on click event
just depends if you want to see that the task has visually been done (ie a switch showing) or your just happy to press a button! -
Thank you very much for your help! It works perfectly!
Content aside
- 4 yrs agoLast active
- 4Replies
- 483Views