Forum Discussion

StephanieHarris's avatar
StephanieHarris
Qrew Assistant Captain
7 years ago

Edit a field 1 time

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.
  • MCFNeil's avatar
    MCFNeil
    Qrew Captain
    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.
    • StephanieHarris's avatar
      StephanieHarris
      Qrew Assistant Captain
      Thanks!  I had the first rule to fire the change but couldn't think of a way to only make the fields editable by an administrator after the first change.  That's why I love this community and being able to bounce ideas off other QB users.