Forum Discussion

GV's avatar
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
------------------------------
Formulas and functions

2 Replies

Sort By
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    3 years ago
    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
    ------------------------------
    • GV's avatar
      GV
      Qrew Member
      3 years ago
      Many thanks Mark. That worked just fine.