Skip to main content
Question

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

  • April 15, 2014
  • 0 replies
  • 349 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.
  • ArchiveUser
  • Quickbase Alumni
  • November 15, 2014
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.
  • TerryEvers1
  • Quickbase Alumni
  • January 1, 2015
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],"]"),"["))
  • ArchiveUser
  • Quickbase Alumni
  • February 18, 2015
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"
  • MM29114
  • Quickbase Alumni
  • April 6, 2015
has something changed with this in the last 5 months? i'm getting the oldest entry at the bottom of my comments field...
  • MM29114
  • Quickbase Alumni
  • April 6, 2015
figured it out.
If([Comments]<>"",
Left(NotLeft([Comments],"["),"["))
  • ArchiveUser
  • Quickbase Alumni
  • October 8, 2015
thanks
I used it and it worked for me also.

thank you!
Terms & ConditionsAccessibility statement