Forum Discussion

hheckert's avatar
hheckert
Qrew Member
2 days ago
Solved

Can I create a single field that displays record owners from a child table

Hi,

The use case for my application is for users to track their testing results - there is a parent table for requests and a child table for activities (i.e., test results). I am wanting to create a field within the Parent table that lists all of the people who have submitted an activity for the parent request. Any ideas?

Relationships
  • MarkShnier__You's avatar
    MarkShnier__You
    2 days ago

    np,

    Just make a new formula text field on the child table called [Record Owner Name]

     

    UserToName([Reciord Owner])

     

    Then make a combined text summary of that field on the left side of the relationship.

    You can use that field on the Parent, but I always then make a new formula text field on the Parent like this to it shows more attractively.

    SearchAndReplace(ToText([Combined text Summary Record Owner Name]), " ; ", "\n")

    .

     

     

  • MariaPeralta's avatar
    MariaPeralta
    Community Manager
    2 days ago

    Please let me know if this answers your question, I'm not 100% sure I fully understand what your goal is. 

    But as I understand it, if you make the user field the key field on a Users table, you can then make the user field [Record Owner] on the child table, Activities, the reference in a relationship and that should allow you to report all of those activities back to the Users table. 

  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    2 days ago

    np,

    Just make a new formula text field on the child table called [Record Owner Name]

     

    UserToName([Reciord Owner])

     

    Then make a combined text summary of that field on the left side of the relationship.

    You can use that field on the Parent, but I always then make a new formula text field on the Parent like this to it shows more attractively.

    SearchAndReplace(ToText([Combined text Summary Record Owner Name]), " ; ", "\n")

    .