How can I alert a user if their name is removed from a user field?

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

I want the user to receive an email if their name is removed from a user field and the record is saved. Any help would be greatly appreciated, thanks.

Photo of Kipp

Kipp

  • 258 Points 250 badge 2x thumb

Posted 4 years ago

  • 0
  • 1
If the edits are done on a form and not grid edit, then this should work.

You have a field called say [Assigned User]

Make a field called [Assigned User before edits]

Also make a field called [Previous Assigned User]

Then make a form riules that says

When the record is Saved

and the [Assigned User has changed]

Change [Previous Assigned User to the value in the field [Assigned user before edits]

Change [Assigned User before edits] to the value in the field [Assigned User]



Set the notification to fire to the User in the field [Previous Assigned user] when the [Assigned User] field is changed.

I only tested with the field exposed on the form.  I suggest testing first with the fields editable, then put the 2nd two fields set to read only and lastly test with the 2 extra field not on the form.  I think it will work even if the extra fields are not on the form.. Or they can be put on the form but hidden by a form rule.
Photo of Kipp

Kipp

  • 258 Points 250 badge 2x thumb
Thank you, that's a great idea and I think it will do what we need.