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.
QuickBaseCoachD
7 years agoQrew Captain
Can you post an example of what the data looks like in that Append field.