Forum Discussion

MattMakris's avatar
MattMakris
Qrew Assistant Captain
6 years ago
Solved

How do I move values from rows in a report to a formula-multi select text field?

I'd like to show values from a field in a child table that is related to its parent table (Product Selections) as a multi select text field (formula). Here is the database topology: Products (c...
  • MarkShnier__You's avatar
    6 years ago
    It's your lucky day

    You can use the new feature called Combined a text Summary on the left side of the relationship. 

    If if you want yo then convert that to a cleaner looking vertical list, you can use this formula. 

    var text value = [my combined text summary field];

    List("\n",
    Trim(Part($value,1,";")),
    Trim(Part($value,2,";")),
    Trim(Part($value,3,";")),
    Trim(Part($value,4,";")),
    Trim(Part($value,5,";")),
    Trim(Part($value,6,";")),
    Trim(Part($value,7,";")),
    Trim(Part($value,8,";")),
    Trim(Part($value,9,";")),
    Trim(Part($value,10,";")),
    Trim(Part($value,11,";")),
    Trim(Part($value,12,";")),
    Trim(Part($value,13,";")),
    Trim(Part($value,14,";")),
    Trim(Part($value,15,";")),
    Trim(Part($value,16,";")),
    Trim(Part($value,17,";")),
    Trim(Part($value,18,";")),
    Trim(Part($value,19,";")),
    Trim(Part($value,20,";")),
    Trim(Part($value,21,";")),
    Trim(Part($value,22,";")),
    Trim(Part($value,23,";")),
    Trim(Part($value,24,";")),
    Trim(Part($value,25,";"))
    )

    That combined text summary field  will give you the first 25 Unique Children 


    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    markshnier2@gmail.com
    ------------------------------