Listing related records in text calculation field
I have a one to many relationship with two tables:
I need to use a calculation field from events to list related contact information in text format:
E.g. the output should be something like:
where contact::name and contact::email might be repeated several times based on how many related records there are.
list() is close to what I need, but it outputs results with carraige returns. I need the outputted results to have ',' or ';' as field and record separators if possible.