Discussions

Expand all | Collapse all

Comments field growing too large for reports and form tables.

  • 1.  Comments field growing too large for reports and form tables.

    Posted 08-20-2018 15:19
    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.


  • 2.  RE: Comments field growing too large for reports and form tables.

    Posted 08-20-2018 21:10
    Can you post an example of your comments field?  Is it a  text field set to "Log Changes" with new comments at the bottom?


  • 3.  RE: Comments field growing too large for reports and form tables.

    Posted 08-22-2018 13:45
    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).


  • 4.  RE: Comments field growing too large for reports and form tables.

    Posted 08-22-2018 13:52
    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,"["),"["))




  • 5.  RE: Comments field growing too large for reports and form tables.

    Posted 08-22-2018 14:00
    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?


  • 6.  RE: Comments field growing too large for reports and form tables.

    Posted 08-22-2018 14:22
    Did you try my formula? 
    Yes, it is the formula for the formula text field called [Current Comments]


  • 7.  RE: Comments field growing too large for reports and form tables.

    Posted 08-22-2018 14:39
    Oh, ok.  I didn't see reference to the other Comments field in the formula.  thats what threw me off.


  • 8.  RE: Comments field growing too large for reports and form tables.

    Posted 08-22-2018 14:43
    You are the man!!  It works!!   Thank you very much for the help!!


  • 9.  RE: Comments field growing too large for reports and form tables.

    Posted 08-22-2018 14:45
    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.


  • 10.  RE: Comments field growing too large for reports and form tables.

    Posted 08-22-2018 14:54
    but it works :-)