GV
Qrew Member
3 years ago

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

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
------------------------------

### 2 Replies

• 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 ("\n",
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)] Curley

Formula 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
------------------------------