Include lists of related records (i.e. contacts) in a single column in Views and Reports
Instead of
|
Request ID |
Project Title |
PI |
Department/Division |
Track |
Type |
Contact |
Contact Title |
Role |
||||
|
15 |
Mindfulness-Based Health Enhancement |
Barrett,Jane |
Family Medicine and Community Health |
Tenure |
Clinical Research |
Barrett, Jane, MD, PhD |
Professor |
Primary Contact |
||||
|
15 |
Mindfulness-Based Health Enhancement |
Barrett, Jane |
Clinical Research |
Middle, C |
Professor |
Co-Principal Investigator |
||||||
|
15 |
Mindfulness-Based Health Enhancement |
Barrett, Jane |
Clinical Research |
Tor, E, PhD, RN |
Assistant Professor |
Co-Principal Investigator |
||||||
|
15 |
Mindfulness-Based Health Enhancement |
Barrett, Jane |
Clinical Research |
Brow, R, PhD |
Professor |
Collaborator |
||||||
|
15 |
Mindfulness-Based Health Enhancement |
Barrett, Jane |
Clinical Research |
Conv, Alex, PhD |
Associate Scientist |
Collaborator |
||||||
|
15 |
Mindfulness-Based Health Enhancement |
Barrett, Jane |
Family Medicine and Community Health |
Clinical Research |
Gra, M, PhD |
Postdoctoral Fellow |
Collaborator |
|||||
|
15 |
Mindfulness-Based Health Enhancement |
Barrett, Jane |
Clinical Research |
Moon, Ma, MPA |
Director |
Collaborator |
||||||
|
15 |
Mindfulness-Based Health Enhancement |
Barrett, Jane |
Clinical Research |
Topit, J, PhD |
Associate Professor |
Collaborator |
||||||
|
15 |
Mindfulness-Based Health Enhancement |
Barrett, Jane |
Clinical Research |
Yates, J, MSSW |
Clinical Social Worker |
Collaborator |
Make all the above rows for a single request into one per the user's specification, in this case instead of a Role column, combine Collaborators and Co-Principal Investigators into one column each, along with some of their related info:
|
Request ID |
Project Title |
PI |
Department/Division |
Track |
Type |
|
Co-Principal Investigators |
Collaborators |
Prior PERC Grants |
||||
|
15 |
Mindfulness-Based Health Enhancement |
Barrett,Jane |
Family Medicine and Community Health |
Tenure |
Clinical Research |
|
Middle, C; Tor, E, PhD, RN |
Brow, R, PhD,Professor; Conve, Alex, PhD,Associate Scientist; Grab, M, PhD,Postdoctoral Fellow; Moon, Ma, MPA,Director; Topit, J, PhD,Associate Professor; Yates, J, MSSW,Clinical Social Worker; |
NONE |
The benefit would be for reviewers and board members that need to look at these reports so that they don't have to constantly check every row to see that they're on the same request. This ability would also benefit evaluators.
-
Guest
- Apr 26 2017
- Reviewed: Voting Open
Related ideas
