Forum Discussion

BethanyHudson's avatar
BethanyHudson
Qrew Trainee
6 years ago

Can't Import field from Parent Table to Child Table

I have two tables with the relationship Activities->Statuses. There are several fields that are on the Statuses table that I need to import onto a report in the Activities table, but then there are fi...
Relationships
reports and charts
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
6 years ago
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
------------------------------
  • BethanyHudson's avatar
    BethanyHudson
    Qrew Trainee
    6 years ago
    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

    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's avatar
      MarkShnier__You
      Icon for Qrew Legend rankQrew Legend
      6 years ago
      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
      ------------------------------
      • BethanyHudson's avatar
        BethanyHudson
        Qrew Trainee
        6 years ago
        I'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 Dickey
        Program Administrator
        Mobile Bay National Estuary Program
        118 N. Royal St., Suite 601
        Mobile, AL 36602
        251-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
        ------------------------------