Forum Discussion
AmyGosz1
2 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__You
Qrew Legend
2 years agoOK, 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
------------------------------