I want to use a time stamp to notify if a modification is made after a approval checkbox is checked

  • 0
  • 1
  • Question
  • Updated 2 years ago
  • In Progress
I have a situation where our legal department must review all the fields that others have filled out.  Once they have reviewed and approved the information in the form they select a check box which has an associated date stamp (time/date field).  However, there will be instances where other users will need to edit some of the fields after the approval.  I set up a rule for both the form and notifications that trigger if the last modification date time is later than the approval date stamp.  Works fine.

But there is a problem.  In the rule when the modification is after the approval it will remove the check in the checkbox indicating that the lawyer must re-approve once they have looked at what ever was modified in the record.  BUT because the rule says uncheck when the modification date is newer than the approval date (and it remains that way) when they click on the approval box again it will not take it.

Any wonderful ideas out there?
Photo of Scott


  • 348 Points 250 badge 2x thumb

Posted 2 years ago

  • 0
  • 1
Should I fully understand your conundrum, but it seems to have to do with the fact that the very last update to the date update it is one you would rather not have.

A solution is to have the approval happening a child table to Float up the most recent approval status up to the parent record.

So the approve button but actually be a button that adds that child record.