Forum Discussion

BarbaraBarbara's avatar
BarbaraBarbara
Qrew Member
11 years ago

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

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 r...
reports and charts
Tables and fields
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
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.
GV's avatar
GV
Qrew Member
3 years ago
Hello -
I realize this is an old thread and many thanks for the response. Instead of displaying only the newest (latest) entry is it possible to display a finite number of the latest? I am interested in seeing the two latest entries.

FYI - my reference append field is prepending, and in my new formula text field I am using Part([appendfieldname],2,"[") which gets me only the newest entry.

Is there a way to edit this formula and get the two latest entries instead? Or does it have to be an entirely different approach?

------------------------------
Gerald Vartanian
------------------------------