Forum Discussion

Qrew Assistant Captain

11 months 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
11 months 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

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 Assistant Captain

11 months 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
11 months 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 Assistant Captain
  11 months 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
  ------------------------------