Can I control or limit the number of lines appearing in a field where I have turned on ""log edits to this field""?
Can I control or limit the number of lines appearing in a field where I have turned on "log edits to this field"?
Forum Discussion
Kathy, yes, you can make a formula field to show just the more recent updates. That would show in view mode. I that what you want.
But my better suggestion is to use some formula i can provide which will parse out the most recent value, and who and when it was done. Then if the user need to see"who done it when" they can edit the record, which will then allow access to the full history of the changes.
Is that what you really want?
But my better suggestion is to use some formula i can provide which will parse out the most recent value, and who and when it was done. Then if the user need to see"who done it when" they can edit the record, which will then allow access to the full history of the changes.
Is that what you really want?
- This would be helpful for me as well, Mark.
- Yes, that's what I would like. Thanks!
- Ok, here are my cheat notes. These formulas assume that you have set the logging the default way which is newest entries at the bottom.
Parsing Append Only Fields
so... if you have a text field set to Log Changes where the new entries act in the default manner which is to be at the bottom of the updates, here are some formuals to use to parse out the values from the most recent entry. I am also assuming that you are logging the date and not the date and time.
Most recent value (formula text field type)
Trim(Right([my update field],"]"))
Date of most recent update (this needs to be a formula date field)
ToDate(Left(Right([my update field],"["),9))
Who did the most recent update (formula text field type)
Trim(NotLeft(Left(Right([my update field],"["),"]"),9))
Parse out the date and time of the update (this needs to be a formula date time field, and you need to set the logging to also log the time.)
var text DateAndTime = Left(Right([append only with date /time],"["),18);
var date TheDate = ToDate(Left($DateAndTime," "));
var timeofday TheTime = ToTimeOfDay(NotLeft($DateAndTime,9));
ToTimestamp ($TheDate, $TheTime)
