Forum Discussion

BethanyHudson's avatar
BethanyHudson
Qrew Trainee
5 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 fields I need to add to the Statuses table that I'll need to import into the report that I'm creating as well. See the attached screenshot of the Activities report with all the fields I need. The fields I need imported are Status Report Narrative, Final Report Narrative (both need to be added to the Statuses table first), Benefit/Outcome, and Clean Water Act Relevance (these 2 already in Statuses table). I've already got the 2 Link fields importing from a separate table- Documents. The Statuses report link is embedded in the Activities main form- this is where users will log edits to those fields.


------------------------------
Bethany Dickey
------------------------------
Relationships
reports and charts
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    5 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
      5 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
        5 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
        ------------------------------