Skip to main content
Question

Edit a field 1 time

  • April 12, 2018
  • 0 replies
  • 14 views

Forum|alt.badge.img+7
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.
This topic has been closed for replies.

  • Quickbase Alumni
  • April 12, 2018
You will want to use a 'dynamic form rule' to accomplish this.

Just add your logic the conditions and then make the action populate the date field with "today".  

You might have to make a 2nd rule that makes things read-only when the date is populated and for specific roles.