Logging edit history for Numeric Field
I want to log the edit history for a Numeric field. I tried creating FORMULA-TEXT field. But using that i can log only last edit details. But i want to log all the edit history for that Numeric Field....
Forum Discussion
Murali,
If all data entry is done on a form, you can have a text field with logging enables and have a form rule
When he record is saved
and
[My field] has changed
Change [My logging] field
to the value in the field [field to be logged]
You may need to have a new field called [My field to be logged in text format]
with a formula of ToText([My field to be logged]])
and use that to be written to the logged field.
If all data entry is done on a form, you can have a text field with logging enables and have a form rule
When he record is saved
and
[My field] has changed
Change [My logging] field
to the value in the field [field to be logged]
You may need to have a new field called [My field to be logged in text format]
with a formula of ToText([My field to be logged]])
and use that to be written to the logged field.
- It Worked by using Dynamic Form Rule.
Thank You... - Mark,
I used your suggested above to use a form rule to populate a log edits field. This works great in most cases, but I have a scenario where there is a button on a form that updates the status with one click. When using this button, the form rule + log edits field does not update. Presumably this is because when using a button to update the status the editing isn't truly done on the form. I tried using an automation to update the log edits field, but the owner of the automation is entered as the user in the log edits field, so no dice. Any thoughts on getting around this issue? - I suggest that adjust the button to also update the logged field.
- Duh, we seem to always over-complicate things don't we. One line of code was the solution. Thanks!
