Skip to main content
Question

How do I only show the last entry in a notes field (log entries)?

  • Apr 15, 2014 8:15 PM UTC
  • 0 replies
  • 410 views

I only want to display in the report the last entry:

[MAY-09-13 Toni R] Internal meetings held on Monday, May 6th and Thursday, May 9th to review the customer requirements. Sales will provide the required follow-up information. Michael B will be managing this project and will reach out to the team if there are any additional questions as the project moves forward.

[MAY-02-13 Toni R] Customer has provided traffic routing information. Meeting scheduled for Monday, May 6th to review with internal project team.

This topic has been closed for replies.

var text LatestMissingSquareBracket = Trim(Right([append prepend],"["));

If($LatestMissingSquareBracket <>"", "[" & $LatestMissingSquareBracket )



Note that this formula only wiorks if the newest entries are at the top. "Prepending" in old-speak QuickBase terms.

  • Observing
  • Nov 15, 2014 12:23 AM UTC
where do you put this formula

It would be a formula text field and the formula goes in the formula box.  Then you put the field on your report or form.

  • Observing
  • Jan 1, 2015 3:07 AM UTC
I attempted this but I am getting the first entry in the Notes field instead (in the example above, I am showing the May 2nd entry).  The field I am using in the formulat is a prepend field (or latest notes on top).  Any idea?

Try this

Trim(Left(NotLeft([Notes],"]"),"["))

  • Observing
  • Feb 18, 2015 4:58 AM UTC
How do I set up the notes field to have it display like the persons above (date, person, text?)

edit the field properties to enable "Log the edits to this field, and show them on forms"

  • Observing
  • Apr 6, 2015 9:44 PM UTC
has something changed with this in the last 5 months? i'm getting the oldest entry at the bottom of my comments field...

  • Observing
  • Apr 6, 2015 10:08 PM UTC
figured it out.
If([Comments]<>"",
Left(NotLeft([Comments],"["),"["))

  • Observing
  • Oct 8, 2015 12:12 PM UTC
thanks

I used it and it worked for me also.

thank you!