Skip to main content
Solved

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

  • October 11, 2019
  • 0 replies
  • 34 views
MattMakris
Forum|alt.badge.img+7
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:

  1. Products (contains product types)
    1. Product Selections (assignment of a product to a client record)
      1. Product Allocations (more specific product selection attributes related to Product Selections table records)


Example record:
  • Client: Acme Anvils
    • Product Selection: Advertising
      • Product Allocation: Google Search Network
      • Product Allocation: Bing Search Network
      • Product Allocation: Waze Advertising

I'd ultimately like to display the list of Product Allocations in a Product Selection report, but as a single multi-select text field.

Is this possible? Thank you!!!


------------------------------
Matt
------------------------------

Best answer by MarkShnierYou

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
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+22
  • MarkShnierYou
  • Quickbase Alumni
  • Answer
  • October 11, 2019
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
------------------------------
Mark Shnier. Your Quickbase Coach
Terms & ConditionsAccessibility statement