I am trying to create a report showing who actually approved a project, so we can track if and when someone edits the approval process on a template to add a different approver.
I can get the correct user ID number to show but using regular text mode edits to change that to the username is proving fruitless. Below is my original text which returns the user ID number. Changing ID to :name is not working; it returns a blank value in that column. Thanks in advance for any help you can provide.
displayname=Approved By
linkedname=approvalProcess
namekey=view.relatedcolumn
namekeyargkey.0=approvalProcess
namekeyargkey.1=enteredByID
querysort=approvalProcess:enteredByID
textmode=true
tile.name=component-approvalprocess-field
valuefield=approvalProcess:enteredByID
valueformat=HTML
viewalias=approvalProcess:enteredByID
Solved! Go to Solution.
Views
Replies
Total Likes
Hi @TaraPearl11 - this is what I use
displayname=Approved By
listdelimiter=<br>
listmethod=nested(approverStatuses).lists
textmode=true
type=iterate
valueexpression=CONCAT({approvedBy}.{name}, " ")
valueformat=HTML
Is it a project report? If so, what about using the Project > Approvers and Status column instead. This way you can see all approvers added and the status. Maybe I'm reading your approach incorrectly.
Views
Replies
Total Likes
Not quite. I need to show who actually clicked the green checkmark to approve the project. I can get the user ID but need to see the user name instead. The standard tricks to change ID to name are not working. Thanks though.
Views
Replies
Total Likes
Hi @TaraPearl11 - this is what I use
displayname=Approved By
listdelimiter=<br>
listmethod=nested(approverStatuses).lists
textmode=true
type=iterate
valueexpression=CONCAT({approvedBy}.{name}, " ")
valueformat=HTML
@KellieGardner This worked. Thank you so much!
Views
Replies
Total Likes