Forum Discussion
Try this set of three formulas
parse out the latest entry if newest are being put first.
Most Recent Entry
Trim(Right(Part(NotLeft([append at top],1),1, "["),"]"))
Date of Most Recent Entry
ToDate(NotLeft(Left([append at top], " "),1))
Name who did the most recent entry
NotLeft(Left([append at top], "]"),11)
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
- AmyGosz12 years agoQrew Trainee
Thanks for your reply Mark, but none of these include all the information in one field. I would like to display the last entry to include the date and name of the person so the field can be used in a report. If QB allows for showing the last entry if it appears at the bottom, I would think there is a way to show the last entry if it appears at the top.
------------------------------
Amy Gosz
------------------------------- MarkShnier__You2 years ago
Qrew Legend
OK, np,
This tested OK. Just replace my field on the first line with yours.
var text RemoveLeadingBracket = NotLeft([Append only at top],1);
var text MostRecent = Trim(Left($RemoveLeadingBracket,"["));
If($MostRecent<>"", "[" & $MostRecent)
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------- AmyGosz12 years agoQrew Trainee
Mark....this worked perfect! Thank you so much for your help.
------------------------------
Amy Gosz
------------------------------