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

Question

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?

MarkShnierYou · Accepted Answer

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]), " ; ", "
").

Maria · Answer

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.

Sign up

Login to the community