Sending new and old value in a notification?

[Mike Newman]

I am looking for a way to notify users when a field is changed on the Location table.

Is it possible for the notification to include the previous value as well as the new value?  I know there is a history of changes made in the system but is there a way to get that data onto the notification?

For example:
The manager of a Location1 is Manager1.  I change the manager of Location1 to Manager2 and hit save.

On my notification, I want it to say something like:

---

Manager of Location1 has been changed from Manager1 to Manager2

---

Any help is appreciated. Thanks!  -Mike

[Nitesh Balusu]

It should probably work from a business rule, where you can put the condition Location changes.

and you can use gs.eventqueue() where you can pass current.location and previous.location as parameters and then put them in the notification.

[Mike Newman]

Sorry but I don't understand.  Can you give a little more detail?

Thanks!

[SaiRaviKiran Ak]

Do you have any field on the table to store the previous value (like to store the manager1) ?

[Mike Newman]

I do not.  I have 20 or so fields that I need to do this with and all are the current.