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:
Example record:
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
------------------------------
- Products (contains product types)
- Product Selections (assignment of a product to a client record)
- Product Allocations (more specific product selection attributes related to Product Selections table records)
- Product Selections (assignment of a product to a client record)
Example record:
- Client: Acme Anvils
- Product Selection: Advertising
- Product Allocation: Google Search Network
- Product Allocation: Bing Search Network
- Product Allocation: Waze Advertising
- Product Selection: 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
------------------------------
- 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
------------------------------
