I have a Date field called Date Investigation End and a check box called All Recommendations Sent to Leader.
I would like that when the check box is checked, it puts today's date in the Date Investigation End.
I only want it to do this the first time the box is checked, If it's checked today the date is 4/12/18 and it's un-checked and re-checked tomorrow I don't want it to change to 4/13/18.
Also, I only want a certain role to be able to edit the Date Investigation End date field (manually not through the checkbox) after the first time it is edited by the check box.
Sign up
Already have an account? Login
Login to the community
Login with Quickbase US – quickbase.com Login with Quickbase EU – quickbase.eu
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.