Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Convert LastLpdateByID to LastUpdatedByName using Text Mode

Avatar

Level 3

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

Topics

Topics help categorize Community content and increase your ability to discover relevant content.

2 Replies

Avatar

Level 2

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

Avatar

Community Advisor

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.