AnsweredAssumed Answered

Loop through related records in Calculation field

Question asked by jonasg on Sep 27, 2010
Latest reply on Sep 27, 2010 by jonasg

Title

Loop through related records in Calculation field

Post

Hi,

Using FM11, I have 2 tables:

contacts(ID, first_name, last_name, c_combined_name)

contactDetails(contactID, content_type, content)

which allows to add arbitrary contact information, such as phone numbers, email, address, birthday, ... without cluttering the screen with lots of unused, pre-defined fields. The problem:

I have a portal showing only the names of contacts (c_combined_name). I would like to display all the contact details within the field's tooltip, separated by linebreaks.

Is there a way to loop through all the contact's related records within a calculation ( aside from using a custom function + recursion) ?

Outcomes