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
Views
Replies
Total Likes
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
Views
Replies
Total Likes
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.
Views
Replies
Total Likes
I just tried it out myself and that is weird - I am getting the same thing as you...a bullet point with blank space.
Views
Replies
Total Likes
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.
Views
Replies
Total Likes
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.
Views
Replies
Total Likes
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.
Views
Replies
Total Likes