Announcement

Collapse
No announcement yet.

Many-to-Many relationships with metadata

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Many-to-Many relationships with metadata

    Hi everyone,

    I'm hoping to create a many-to-many relationship between an entity and itself, with metadata added.

    Example:

    I have an entity: Organization.
    An Organization can support another organization, or receive support from another organization.

    When I create a many-to-many relationship on the entity Organization, with the same entity Organization, and call the left label: 'Provides support to' and the right label: 'Receives support from', then this works perfectly.

    But now I would like to add two dates to this relationship: 1. when the support relationship started, and when it ended.
    This is not possible in the many-to-many relationship.

    In each organization I would like to have a two bottom panel showing:

    Supports:
    Organization name - from date - to date

    Receives support from:
    Organization name - from date - to date

    Any ideas how to achieve this?

  • #2
    Hi Maarten,

    I'd consider creating a separate entity with two many-to-one relationships.

    While there's the ability to have relationship middle table fields, there's no support for date/time fields in the front-end. Hence, would require coding.

    Comment


    • rabii
      rabii commented
      Editing a comment
      any chance in the future to have such ability (allow middle table to have more fields)? seems complex but would really enhance the user experience.

  • #3
    If you don't want to code, I believe that eymen-elkum extension will allow you to do that

    Comment


    • #4
      This extension would help you do the trick https://www.eblasoft.com.tr/espocrm-...le-inline-form

      Comment

      Working...
      X