Display related entities in One to Many relationship as a list field

[rabii]

Does anyone know how to display related entities in a One To Many relationship as list field. I have account Has Many competitors (Account One to Many Competitor) and i would like to list all competitors that belong to an account in a list field within the account view. same as opportunity and opportunityItem list.

Many thanks

telecastg item emillod please help if you know how to achieve this.

[item]

Hi,
if you have Advanced Pack.. look ReportPanel in admin section.
you can create report list or grid

and then create report panel as side or bottom..

not undertand all but perfect

[rabii]

Thanks for your reply, i don’t want to use reports hence i need to apply custom row actions to the list. I am interested to add a field like itemList which display data in a list format in a parent view. As explained something like opprtunityItem on opportunity.

[dimyy]

Try check "Link Multiple Field" and add field to detail view

[rabii]

that would only allow to add one field. my purpose if to show whole list of field of related entities.

[lazovic]

Hi rabii,

Through the UI, you can make two display options: as in the first picture, just a list of related Competitors under the red panel, or as in the second picture, on the Bottom Panel, where you can select the fields of your Competitors records you need to display. Please take a look:



If these options do not suit you, try to make a small drawing of how it should look like, and then the EspoCRM community will be able to help you faster.

[rabii]

I am aware of relationship panels but it is not what i am looking for, as mentioned before if you have sales pack you can see that opportunity has a list item field which list all opportunityItems and that is what exactly i want a field which list a list of field of related entity. see attached screenshot for your reference.

[item]

feature request

[telecastg]

Maybe consider this extension ?: https://www.eblasoft.com.tr/espocrm-...le-inline-form

[rabii]

i have the extension but i wanted to build this my way hence it has lore then just listing, some calculations will be done based on certain conditions. with the extension i can't extend such functionality.

[shalmaxb]

rabii, hello. Did you ever solve that? I have a similar problem, where I need the links as a string (list).

[rabii]

rabii, hello. Did you ever solve that? I have a similar problem, where I need the links as a string (list).

Yes managed to do it but was not perfect so still trying to improve it. there is a lot that goes into that.

[shalmaxb]

One thing, I do not understand: I can read the Ids from the multiple link and display in a textbox. But not the names (what would be, what I need).
Is there a way to get the names by having the Id?

[rabii]

Yes managed to do it but was not perfect so still trying to improve it. there is a lot that goes into that.

can you share your code. you should be able to read names too.

[shalmaxb]

Here a screenshot of the situation:

[rabii]

I see the technikListenwerteNames will return null, here is a fix you can use the code below instead:

if (technikListenwerteIds) {
    
    $names = list();
    
    $i = 0;
    
    while ($i < array\length(technikListenwerteIds)) {
        
        $o = record\fetch('TechnikListenwerte', array\at(technikListenwerteIds, $i));
    
        if ($o) {
            $name = object\get($o, 'name');
        }
        
        $names = array\push($names, $name);
        
        $i = $i + 1;
    }
    
    technik2 =  array\join($names, ',');
}​ 

I hope this helps

[shalmaxb]

rabii, great (again and again). This code works. Thank you very much!

[rabii]

you are welcome