Comments field growing too large for reports and form tables.

  • 0
  • 1
  • Question
  • Updated 10 months ago
  • Answered
The text is getting to long. Want to create new field that will auto populate with the most recent comment from Comments field? I would then show the new field in reports and leave the full length Comments in the drill down page. I have logging turned on for the Comments field.
Photo of William Latimer

William Latimer

  • 396 Points 250 badge 2x thumb

Posted 10 months ago

  • 0
  • 1
Can you post an example of your comments field?  Is it a  text field set to "Log Changes" with new comments at the bottom?
Photo of William Latimer

William Latimer

  • 396 Points 250 badge 2x thumb
Hi - thank you for the reply and sorry for delay getting back.  Out sick yesterday.

Yes, I have it set to log changes, and have most current comments at the top (I deselected option for having them at the bottom).
OK, try this crazy looking formula
substitute your field name into the first line where my field name for testing was 
[Log changes append only at the top]


var text LogField = [Log changes append only at the top];

If(Trim($logField)<>"", 
"[" & Left(NotLeft($LogField,"["),"["))


Photo of William Latimer

William Latimer

  • 396 Points 250 badge 2x thumb
Is this formula for the target Comments field? ("Current Comments").  I am trying to grab the most recent comment (which is appearing at the top of the long running "Comments" field), and display it as the current comment in a different Comments Field ("Current Comments"). 

In the "Current Comments" field, I only want to display the last comment made from the other Comments field. I plan to include this current comments field in reporting, tables, etc.

Does that make sense?
Did you try my formula? 
Yes, it is the formula for the formula text field called [Current Comments]
Photo of William Latimer

William Latimer

  • 396 Points 250 badge 2x thumb
Oh, ok.  I didn't see reference to the other Comments field in the formula.  thats what threw me off.
Photo of William Latimer

William Latimer

  • 396 Points 250 badge 2x thumb
You are the man!!  It works!!   Thank you very much for the help!!
Great, thx for letting me know. 
I don't often put the new entries at the top so my parsing formula collection is a bit weak in that area.
Photo of William Latimer

William Latimer

  • 396 Points 250 badge 2x thumb
but it works :-)