Expand my Community achievements bar.

Help with Scheduled Report-Entered by ID to show Entered By Name

Avatar

Level 3

I have a report to show scheduled report details. I’m trying to convert the text mode from Scheduled Report-Entered by ID to show the user name, rather than ID. The original text mode is below. I’ve tried various combinations and haven’t been successful yet. I looked through the API for Scheduled Report field details, but didn’t see or missed anything that I could use to connect to User to get the ID to name connection. Any help with this is greatly appreciated. Thanks

 

linkedname=scheduledReport

namekey=view.relatedcolumn

namekeyargkey.0=scheduledReport

namekeyargkey.1=enteredByID

tile.name=component.scheduledreports

valuefield=scheduledReportsEnteredByID

valueformat=HTML

viewalias=scheduledReport:enteredByID

 

6 Replies

Avatar

Level 7

Have you tried this…? In the places where enteredByID is indicated, switch the “ID” portion to :name

 

linkedname=scheduledReport

namekey=view.relatedcolumn

namekeyargkey.0=scheduledReport

namekeyargkey.1=enteredBy:name

tile.name=component.scheduledreports

valuefield=scheduledReportsEnteredBy:name

valueformat=HTML

viewalias=scheduledReport:enteredBy:name

 

Avatar

Level 3

Thanks. I tried that and I only see bullet points that would appear in front of the user ID and blank space instead of user name. 

Avatar

Level 7

I just tried it out myself and that is weird - I am getting the same thing as you...a bullet point with blank space. 

Avatar

Community Advisor

hi, 

 

I'll give you a few more details on using the API:

* Go to the section of the API for REPORT.

* Look in the COLLECTIONS tab.

* Note that "scheduled reports" is one of the collections -- this should make sense, since you can set up more than one scheduled delivery of a report.

* Therefore, even though you're able to access SOME information just through the standard view, you should know or understand that you can't necessarily dive deeper into the information through "normal channels" -- you'd need to use a collections statement. If you click on the scheduled reports listing, you'll go to that section and be able to see what you can tap into from there, but below is some sample code you might be able to use to get what you need.

 

displayname=Scheduled Report Info
listdelimiter=<p>
listmethod=nested(scheduledReports).lists
textmode=true
type=iterate
valueexpression={enteredBy}.{name}
valueformat=HTML

 

* additional bonus bulletpoint: every time I see a "tile.name" in a blob of text, I automatically give up editing it any further. Those tiles are usually shortcuts that workfront has provided in the past, and aren't satisfyingly editable.

Avatar

Level 3

Thanks for the suggestions and collections statement information. I didn't have any luck with the sample code you provided or with any of my variations. As you mentioned, due to the the tile.name text, there may not be a solution for this. 

Avatar

Community Advisor

That's a bit weird, as it definitely worked on my side. You might consider sharing your code and variations so other users can help you troubleshoot, or contact Support if you are an authorized service contact, as they can also help.