MattMakris
6 years agoQrew Assistant Captain
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...
- 6 years agoIt'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
------------------------------