Forum Discussion

EmberKrumwied's avatar
EmberKrumwied
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's avatar
    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's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend

:) 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's avatar
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
------------------------------