Skip to main content
New Participant
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

skyehansen
New Participant
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.

New Participant
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