Middle field type "link" in additionalColumns

[sltctom]

Thank you for your answer,

My problem isn't how data is diplayed but how it can be managed in back-end. Futhermore, I don't want to buy an extension to solve my problem.

[shalmaxb]

Here is a solution by Eymen Elkum from Eblasoft: https://www.eblasoft.com.tr/post/lin...o-many-to-many
I guess it is possible only by using his extension for Multiple Links, which is a great Extension by the way.

[sltctom]

Hello there,

I have 2 entities Contact and Oportunity, I create a "many to many" link between them.
Then I want to add middle fields so I use additionalColumns.

I create a field called active (boolean) but I also want to create a field called "call" which is a belongsTo link type to another entity.

In entityDefs/Contact.json :

"opportunities": {
"type": "hasMany",
"relationName": "linkContactOpportunity",
"foreign": "contacts",
"entity": "Opportunity",
"additionalColumns": {
"active": {
"type": "bool"
},
"call": {
"type": "link", <- belongsTo
"entity": "Call"
}
}
}​

I haven't figured out how to create this type of field in the middle view, is it possible or/and what's the best way to do it?


Thank you for your support and looking forward to your response.