Forum Discussion
BethanyHudson
6 years agoQrew Trainee
So re you saying that 1 Activity has many Statuses and that you simply want to float up the content of some Text fields up to the parent? Yes
Have you tried using the Combined text summary fields on the relationship to summarize the text fields? can you explain this? I'm not sure it's what I need
Have you tried using the Combined text summary fields on the relationship to summarize the text fields? can you explain this? I'm not sure it's what I need
If that is all you need and you don't like the bubble appearance of the result, you can create a formula text field like this to make them look better.
SearchAndReplace([My Text Concatenation Field]," ; ","\n")
Bethany Dickey
Program Administrator
Mobile Bay National Estuary Program
118 N. Royal St., Suite 601
Mobile, AL 36602
251-459-8870
------Original Message------
So re you saying that 1 Activity has many Statuses and that you simply want to float up the content of some Text fields up to the parent?
Have you tried using the Combined text summary fields on the relationship to summarize the text fields?
If that is all you need and you don't like the bubble appearance of the result, you can create a formula text field like this to make them look better.
SearchAndReplace([My Text Concatenation Field]," ; ","\n")
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
MarkShnier__You
Qrew Legend
6 years agore:Have you tried using the Combined text summary fields on the relationship to summarize the text fields?
Can you try making a summary of the field for [Status Report Narrative] and see what happens? The type of summary field will be combined text. Just make a normal summary field on the relationship but select combined text.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
Can you try making a summary of the field for [Status Report Narrative] and see what happens? The type of summary field will be combined text. Just make a normal summary field on the relationship but select combined text.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
- BethanyHudson6 years agoQrew TraineeI'm still having trouble. Could you maybe help me one step at a time? First, I need to do the combined field for documents links. Some will have multiple final documents. Here is the current formula:--Bethany DickeyProgram AdministratorMobile Bay National Estuary Program118 N. Royal St., Suite 601Mobile, AL 36602251-459-8870
------Original Message------
re:Have you tried using the Combined text summary fields on the relationship to summarize the text fields?
Can you try making a summary of the field for [Status Report Narrative] and see what happens? The type of summary field will be combined text. Just make a normal summary field on the relationship but select combined text.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------- MarkShnier__You6 years ago
Qrew Legend
Go to the Relationship where 1 Activity has Many Statuses and make a Summary of that field using the type summary being a Combined Text Summary.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------- BethanyHudson6 years agoQrew TraineeI did that already. It doesn't combine anything though. When I click the link in the report it opens the main page of that particular activity.--Bethany DickeyProgram AdministratorMobile Bay National Estuary Program118 N. Royal St., Suite 601Mobile, AL 36602251-459-8870
------Original Message------
Go to the Relationship where 1 Activity has Many Statuses and make a Summary of that field using the type summary being a Combined Text Summary.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------