Hello,
We create a custom module (Invitees) in SuiteCRM. The fields needed are four:
- Invitee: which is related to contacts
- Event: which is related to events
- Invited: which is a checkbox
- Attended: which is a checkbox
The problem is the following:
a. When we create 1 & 2 as related fields by adding fields (adminïƒ studioïƒ fieldsïƒ add field), e.g. https://drive.google.com/file/d/1V5-NSlU14_2-1zi6Clov8zJjuox-wj_W/view?usp=sharing , the export of the new module’s records contains only the contact’s id instead of its name and event’s id instead of its name as well.
b. When we create 1 & 2 with one-to-one relationship e.g. https://drive.google.com/file/d/12DJOMnqAqpG4MoAsIcf3BQytU-8vTOLC/view?usp=sharing , each contact and each event correspond to one invitee which is not desired because each event should have more than one invitees and each invitee could be invited to more than one events.
c. When we create 1 & 2 with one-to-many relationship, subpanels are created and the view of the module is not how we would like it to be (desired list view: https://drive.google.com/file/d/1h2TogNKHr4YGTIFVUbY-8KXfwI34DPoJ/view?usp=sharing ). Also, as far as we know, the export of the subpanels is not possible.
Could you please help me?
Waiting for your response. Thank you for your time.
With regards,
Pagibe.