Forum Discussion

JaimeStrawderma's avatar
JaimeStrawderma
Qrew Cadet
5 years ago

Re: Combining multiple Pages to One for a Single Report

Sorry Mark, I'm off to a rocky start already...the [Phase Summary] field will be a formula text field with List("-",[Implementation Phase Name],[Status]) as the formula? Each project I enter returns ??? in that field.


------------------------------
Jaime Jaime
------------------------------

10 Replies

Sort By
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    5 years ago
    Let's go step by step.
    On the Phase record make a formula field 

    List("-",[Implementation Phase Name],[Status]) 

    Have you done that and when you do that does it show up correctly on the Phase record.

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------
    • JaimeStrawderma's avatar
      JaimeStrawderma
      Qrew Cadet
      5 years ago
      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
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew Legend
        5 years ago
        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
        ------------------------------