I have a practical module setup question because after reading all of the docs I could find, I am still not sure about the best way to achieve something that feels fairly simple to me.
I am setting up a system for a sports organization. I would like to manage a number of events and, for each of them, there is an outside contact who is in charge (not an employee of the organization).
I have created a module called assignment that contains information about the contact’s role in the events.
I have set up the following module relationships:
- assignments <-- “many to one” --> contacts
- assignments <-- “many to many” --> events
I have also created a workflow to confirm the assignment to the contact once it is approved. It works well.
However, I would like to list in the confirmation email all the events the contact is assigned to. I seem to find no way of doing this - even through calculated fields.
An option I can think of would be to create 10 relate fields in the assignment module (this is the max number of events for one contact) but it seems to be a fairly clumsy way of doing it:
- I like the relationships because the panel views are invaluable to manage contacts / events / reports, so I don’t want to remove them
- adding relate fields requires to provide the same information twice (events managed by the contact) so it will lead to unnecessary mistakes and a waste of time.
Am I missing something really obvious?
Thanks a lot in advance if you have pointers