I have a many to many relationship between “AOS_Invoices” and “Opportunites”. With this connection, I have a new subpanel, in each module, to show the related information. Problem: I don’t find a way to connect this two.
P.S.: I’m using suiteCrm 6.0 and c# as programming language.
First, thank you for your answer.
Second, my bad about the version, I meant “Version 7.10.7”.
I’m using c# to connect an external app to suiteCrm, if I have to use another language inside de suiteCrm, that’s not a problem.
My issue is: I have an “Opportunity” which will contain an “Invoice”. I create a relationship (many-to-many) between this two. This creates two sub-panels in each one. Now, I want to show, for example, the information of an “Invoice” in the respective sub-panel inside an “Opportunity”.
If you are in the Detail view of an Opportunity, you have a subpanel with Invoice data, right?
If you are in the Detail view of an Invoice, you have a subpanel with Opportunity data, right?
Or do you mean that, inside a subpanel, you want to look up a field from the related module and show it there?
I can understand why this is useful in some places, but not when you are alaready in the Detail view of that related record… because that information is already there on the top, and it would repeat the same value in every row of the subpanel…
Again, I sense a certain cognitive dissonance here because I don’t see the point of seeing Opportunity information in a subpanel, when you are already in the record for the Opportunity. Information will be the same as on the header above, and will be the same across all rows in the subpanel…
But in Studio / Opportunities / Subpanels, do you see an entry for “Invoices”? Can you edit it, save and deploy, and see the changed subpanel?
I don’t want to see the information about the “Opportunity” inside the Opportunity", when I’m inside an “Opportunity” I want to see information, in a sub-panel, about an “Invoice”!
Yes in studio I can edit the sub-panel and the edits have repercussion, but I have to create some kind of connector to interconnect this two modules, right ?
I think what you’re looking for needs to be done from PHP, editing the subpaneldefs.php file.
Try looking for examples online, or even for an existing subpanel in SuiteCRM that does an equivalent thing. Something that shows a field from a related module.
For example, in Contacts detail view, the Cases subpanel references an Account name.
This comes from the file modules/Contacts/metadata/subpanels/ForCases.php, in this part: