How to show Who approved this project in a report using text mode

Question

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

KellieGardner · Accepted Answer

Hi @tarapearl11 - this is what I use displayname=Approved Bylistdelimiter=
listmethod=nested(approverStatuses).liststextmode=truetype=iteratevalueexpression=CONCAT({approvedBy}.{name}, " ")valueformat=HTML

VicSellers · Answer

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.

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded