How do I require a user to update a specific field if other fields are changed?

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered

We have a form that we use in my department for my Company's controls.  I am trying to modify the form to require a change log comment to be added when certain fields on the form have been changed.  I began creating a dynamic rule but have gotten stuck on the action section. 

Thus far the rule is; When the record is saved and any of 26 identified fields have been changed. 

I would like the action to require that the Change Log field be populated and this is where I am stuck.  Please help

Photo of Linny

Linny

  • 0 Points

Posted 3 years ago

  • 0
  • 1
Photo of Jack

Jack, Champion

  • 50 Points
Hi Linny,

One way to do it is to replicate all your fields .i.e. if you field is called date then the replicated field is called date audit and set your form to copy the value of date into date audit when the record is saved. Do this for all your fields. You can do this as one rule.

Then setup one formula check box field which looks at whether the field date = date audit and so on. If the values are different its checked. Then using a form rule set it so when the checkbox is equal to true show and require change log audit field.

Jack
Photo of Jack

Jack, Champion

  • 50 Points
Forgot to mention hide the audit fields from your users using a form rule also (i guess you got that though).