Get more information about a user from a typeahead custom field.
I do NOT have fusion, so I'm trying to find a solution that does not utilize fusion.
I have a team of three people that oversee evaluations/observations for another team of trainers in my department. I want them to be able to see a report of which trainers need to be observed, the trainer's manager, when they were last observed, etc.
I've tried a few different things. I had custom fields for "Assigned Observer," "Observation Date" that were attached to the user. I was able to edit the report that I created freely, but the three observers were not. I assume this is because I was technically editing the user which is part of my access as a subgroup admin.
So my next attempt, which I liked a little more, but ran into issues was to create a project "2024 Observations." I created a custom field for tasks that was "Trainer" and it was a USER typeahead field. I then added it to the view for the tasks. So then the task list on the project is a list of the trainers that need to be evaluated. My issue is that I want to pull a bit more information about that user and I would prefer it to be automatic. I thought about adding a column, and then in that column having it pull information about the user that was put in the typeahead field. This is where I'm running into issues. The only information I can see is the Name and ID of the user that was put into that typeahead field. Is there any way, WITHOUT fusion, that I can get the user's manager and home team?