Forum Discussion

Qrew Captain

2 years ago

View all Parent records and related Child records in single table view

I am looking for a way to view, in table format, all Parent records AND any related Child records. I understand that some of the data displayed will be repetitive, but that is okay. If I create the...

EmberKrumwied
2 years ago
All works now. The formula I was using was modified as I assumed that the formula shown below (which you previously provided) that the var text CombinedText = was a placeholder and didn't need to be inserted into the formula field. When I left that part out, the editor didn't like the semicolon after the first line so I modified it till it "liked" my formula. Thus getting a partial result. I used your formula as is and only replaced the "My Text Concatenation Field" for my actual field name.

var text CombinedText = ToText([My Text Concatenation Field]);

// substitute new line for semicolon
SearchAndReplace($CombinedText," ; ","\n")

Thank you for your assistance.

------------------------------
Ember
------------------------------

MarkShnier__You

Qrew Legend

2 years ago

One option is to create a field on the Child table called [Roll Up Fields]. Make a formula on the trail table to concatenate together a few different fields from the child record which would serve as identification.

Then you can go to the relationship and create a combined text summary field of that roll up field.

That rolled up field will have an unusual appearance and if you want to convert it to a more normal looking text field you could then use the formula like this have them appear as a vertical list. Or you can choose a different separator if you want them say comma separated.

var text CombinedText = ToText([My Text Concatenation Field]);

// substitute new line for semicolon
SearchAndReplace($CombinedText," ; ","\n")

------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------

EmberKrumwied
Qrew Captain
2 years ago
Was able to use this suggestion, doesn't display like I had hoped it would, but this gets me the information I was seeking.

This is the formula I ended up using on the Parent table (to display the rollup field created at the Child level).

SearchAndReplace(ToText([PTrans Rollup]),";","\n")

What displays is a list of all the related Child records, one record on a separate line, but lines 2+ are slightly indented. Any way to modify the formula so that all lines are aligned along the left side of the field?

------------------------------
Ember
------------------------------
- MarkShnier__You
  Qrew Legend
  2 years ago
  :) Yes, change the formula to the one I provided. The actual separator comes through as space semi space when converted ToText, so that is what the SearchAndReplace needs to scan for.
  
  SearchAndReplace($CombinedText," ; ","\n")
  
  ------------------------------
  Mark Shnier (Your Quickbase Coach)
  mark.shnier@gmail.com
  ------------------------------
  - EmberKrumwied
    Qrew Captain
    2 years ago
    All works now. The formula I was using was modified as I assumed that the formula shown below (which you previously provided) that the var text CombinedText = was a placeholder and didn't need to be inserted into the formula field. When I left that part out, the editor didn't like the semicolon after the first line so I modified it till it "liked" my formula. Thus getting a partial result. I used your formula as is and only replaced the "My Text Concatenation Field" for my actual field name.
    
    var text CombinedText = ToText([My Text Concatenation Field]);
    
    // substitute new line for semicolon
    SearchAndReplace($CombinedText," ; ","\n")
    
    Thank you for your assistance.
    
    ------------------------------
    Ember
    ------------------------------