Convert LastLpdateByID to LastUpdatedByName using Text Mode | Community
Skip to main content
Level 2
March 30, 2021
Question

Convert LastLpdateByID to LastUpdatedByName using Text Mode

  • March 30, 2021
  • 2 replies
  • 726 views

Is there a quick way to convert LastLpdateByID to LastUpdatedByName on a Task report using Text Mode?

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

2 replies

Level 2
March 30, 2021

Hi Amanda.

In most cases, I've been able to change "ID" to ":name". I tested this in a personal "testing" view I have created and, in this case, I was able to display the name by changing "lastUpdatedByID" to "lastUpdatedBy:name".

valuefield=lastUpdatedBy:name

querysort=lastUpdatedBy:name

valueformat=HTML

displayname=Last Updated By

linkedname=direct

namekey=lastUpdatedBy:name

I've found a couple of instances where I was not successful in this change, but I think there may have been other conditions that were causing it to fail (for instance, trying to capture a requester name when the original request had been deleted).

Good luck,

Harold

skyehansen
Community Advisor
March 30, 2021

Is this for a single field column? You shouldn't have to use text mode. Simply type in Last Updated By Name (or L U B N), and scroll down to the Last Updated By section and select the name field.