Forum Discussion
QuickBaseCoachD
12 years agoQrew 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.
If($LatestMissingSquareBracket <>"", "[" & $LatestMissingSquareBracket )
Note that this formula only wiorks if the newest entries are at the top. "Prepending" in old-speak QuickBase terms.
Data_SystemAnal
7 years agoQrew Cadet
Hello, I am using your formula for the same purpose only that I would like to see only the first entry, can you help me with that