Calculate field with line breaks

Question

Hi, I'm trying to create a calculated/concatenated field that pulls fields from related records and would like to have line breaks between the field values, not spaces? As an example, I'm trying to pull the contacts company address fields and the contacts phone numbers into a text area field, I'd like line breaks between each line of the address and the phone numbers to be on seperate lines I have tried using 
 and \n\r in my calculated concat field but it treats them as a string. If it is not possible in a TextArea field, is it possible in an HTML field and last resort I suppose would be an aftersave logichook Thanks for any assistance you can give me

Rob Douglas · Accepted Answer

Hi Rob, You can check out our documentation on Fetching Relationships with SugarBean objects. For your example, I would do something like this: if($bean->load_relationship('contacts_mba_mba_detail_1_c')) {
 $relatedBeans = $bean->$link->getBeans();
 foreach($relatedBeans as $relatedBean) {
 $c_id = $relatedBean->id;
 // The rest of your code can go here
 }
}
 The exact name of the relationship may vary, so you will have to verify that in order for this to work. Let me know if you have any questions! -Alan