How do I show a finite number of entries from a reference append field?

Question

In a field on my report I would like to show a finite number of entries (more than one) from an append field.

I have created a formula text field that uses a formula from QuickBase help Part([appendfieldname],2,"[") to grab content from my prepending append field.
This half works, because it gets me only the last (one) entry.

Is there a way to edit this formula and get the TWO or THREE latest entries instead? Or do I need use an entirely different approach?

------------------------------
GV
------------------------------

MarkShnierYou · Answer

Try this. It tested OK.var text One = Trim(Part([My Prepend text field],2,"["));var text Two = Trim(Part([My Prepend text field],3,"["));var text Three = Trim(Part([My Prepend text field],4,"["));List (" ", If($One<>"", "[" & $One),If($Two<>"", "[" & $Two),If($Three<>"", "[" & $Three))Original data in field.[JAN-26-22 Mark Shnier (YQC)] Shep[JAN-26-22 Mark Shnier (YQC)] Moe[JAN-26-22 Mark Shnier (YQC)] Larry[JAN-26-22 Mark Shnier (YQC)] CurleyFormula generates this result.[JAN-26-22 Mark Shnier (YQC)] Shep[JAN-26-22 Mark Shnier (YQC)] Moe[JAN-26-22 Mark Shnier (YQC)] Larry------------------------------Mark Shnier (YQC)mark.shnier@gmail.com------------------------------

Sign up

Login to the community