I have built a fairly basic site for an academic research group, including a collection of projects, a team page, a calendar, blog etc. The Projects page is constructed with dynamic pages (organised by boolean fields as Categories) and items (organised by a Project Number field). In the connected dataset, contributors are listed in a single Author(s) field as 'John Doe, Jane Doe' etc, and this information is in turn displayed on each related item page as simple text.
For some extra flair, I would love it if the Team page (constructed with a repeater, linked to a separate dataset) could somehow allow for the visitor to click a name and come to a dynamic page collecting all projects this person is involved with. Another cool thing would be to be able to make the names on the item pages clickable, meaning you can jump back and forth between project item pages and Team page.
This would be an easy enough task if there was only one contributor listed in the Author(s) field for each item of the first dataset, but since this is rarely the case I wonder if there is a clever way to accomplish what I just described? I would like to avoid a hundred boolean fields if possible.
Let me know if my description is unclear and I'll try to do better :)
Thank you so much!!