Forum Discussion
JaimeStrawderma
Qrew Cadet
Ah, I see where I was confused. I was looking on the form, populating the project name and getting the ??? Yes, I created the formula field with the exact formula you have. It appears on my Phase Report and lists the Phase names.
------------------------------
Jaime Jaime
------------------------------
------------------------------
Jaime Jaime
------------------------------
MarkShnier__You
5 years agoQrew Legend
OK, great, so step 2 is to float that up to the Project. So make a combined text summary field on the relationship where Oner Project has many Phases.
You should now see that field on a Project record in a "pill" appearance format.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
You should now see that field on a Project record in a "pill" appearance format.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
- JaimeStrawderma5 years agoQrew CadetExcellent. Works like a charm. Thank you so much for all of your help.
------------------------------
Jaime Jaime
------------------------------ - JaimeStrawderma5 years agoQrew CadetYes, I have the phases showing up in the "pill" on the project record
------------------------------
Jaime Jaime
------------------------------ - MarkShnier__You5 years agoQrew LegendSo, you can just look that up down to the Support Tickets, but my suggestion is to convert it to a vertical list.
You can make a formula text field I made a syntax correction in bold.
SerachAndReplace(ToText([Combined Text Summary Phase Summary]), " ; ", "\n")
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------ - JaimeStrawderma5 years agoQrew CadetHi Mark, sorry I have not been able to get back to the project. I'll keep working through it and let you know how it goes. Thanks!
------------------------------
Jaime Jaime
------------------------------ - JaimeStrawderma5 years agoQrew CadetHi Mark,
I've been pretty busy lately but just back to working on this. Everything works well as far as returning information into a single report. I just need help with the formatting a bit please. For example, I have a project with 6 Phases and thanks to your formula those show up in a vertical format. However, the Phase Status only shows the three statuses, Active, Completed, and Inactive. Is there a way to line up the correct status with the correct Phase? Thanks!
------------------------------
Jaime Jaime
------------------------------ - MarkShnier__You5 years agoQrew Legendnp,
easy solution.
make a field down at the child level which combines the Phase and the Status.
List(" - ", [Phase], [Status]) and change the target field for your Combined text summary field to look at that field instead. That way the two fields will stay together as they get rolled up.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------ - DonLarson5 years agoQrew CommanderJaime,
You said "Pill." Do you have a Tableau background?
Does moving the data to BI/BA make more sense for some grander reporting needs or does Mark have this 99% solved? If you are almost done, then stay the course. Otherwise we can discuss getting to SQL and BI.
------------------------------
Don Larson
Paasporter
Westlake OH
------------------------------