Comments field growing too large for reports and form tables.

  • 0
  • 1
  • Question
  • Updated 8 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 8 months ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 65,096 Points 50k badge 2x thumb
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).
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 65,096 Points 50k badge 2x thumb
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?
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 65,096 Points 50k badge 2x thumb
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!!
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 63,962 Points 50k badge 2x thumb
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 :-)