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

-WE
-WE
Online

Badges

Badges
32

Accepted Solutions

Accepted Solutions
19

Likes Received

Likes Received
237

Posts

Posts
254

Discussions

Discussions
45

Questions

Questions
209

Ideas

Ideas
28

Blog Posts

Blog Posts
1
Top badges earned by -WE
Customize the badges you want to showcase on your profile
Re: How can I transform a list of items (or a collection) in a single bundle to an array that can be iterated through?
-WE
- Workfront Fusion 2.0 16-08-2021
Thanks Darin. I'm definitely interested in a convert Collection to Array function. This can simplify scenarios that need to perform logic that is conditionally driven by the name of list items; and subsequently their value. Glad to know my workaround is as good as it gets and I wasn't overlooking the obvious answer, like I might have done when I was 21...

Views

13

Likes

0

Replies

0
Re: How can I transform a list of items (or a collection) in a single bundle to an array that can be iterated through?
-WE
- Workfront Fusion 2.0 16-08-2021
That is a handy trick, Doug; but not exactly what I'm after here. I was looking to convert the collection of parameterValues in an http response to an array so it could be processed more efficiently.

Views

13

Likes

0

Replies

0
How can I transform a list of items (or a collection) in a single bundle to an array that can be iterated through?
-WE
- Workfront Fusion 2.0 16-08-2021
I have a working solution that I am looking to simplify or make more efficient. There are times that a module will return a single record (Project) either through a Search Record module or a Custom API call module. In this example, I'm using both: a Custom API call so I can include parameterValues in the fields list; followed by a Search Record (for the same project) where I map the parameterValues collection that was returned in the response of the API call to the Outputs field of the Search Re...

Views

13

Likes

0

Replies

4
Re: In some of our projects, the same task is assigned to multiple users and we would like to run task reports that display the actual hours each individual spent on the task.
-WE
- Workfront 16-08-2021
Kundan, it's not possible to do for a project view. This is a collections column. Assignments are a collection in tasks or issues, so you can have this column in a task or issue report. Assignments are not a collection in projects, so this view is not possible in a project report. To understand when you can or can't do this, go to the API Explorer and look for the kind of object that matches your report (in this case, you would look at "Project" in the API Explorer because you are building a pro...

Views

13

Likes

0

Replies

0
Re: Create Chart/Report for Average Requests Completed by Resource by Week and Month
-WE
- Workfront 11-08-2021
Hi David, sorry I didn't see this the first time! I think you want a matrix report. In your request report, switch to matrix grouping for a tabular view that shows record counts by month and week. You can export the matrix to Excel if you need to perform additional calculations. In some cases (multiple users assigned to the same request, or wanting a combination of completed tasks and requests), you might consider doing this on an Assignment report instead of a Request report.

Views

11

Likes

0

Replies

0
Re: In some of our projects, the same task is assigned to multiple users and we would like to run task reports that display the actual hours each individual spent on the task.
-WE
- Workfront 11-08-2021
On a task report, add a text mode column: displayname=Actuals by Userlistdelimiter=listmethod=nested(assignments).liststextmode=truetype=iteratevalueexpression=CONCAT({assignedTo}.{name}," - ",({actualWorkCompleted}/60)," Hours")valueformat=HTML

Views

13

Likes

0

Replies

3
Re: We need a report that can tell us which custom forms have logic-driven fields within them and possibly a count of logic driven fields within each form?
-WE
- Workfront 11-08-2021
You're not going to get the exact report you want, because Workfront's backend code doesn't store display logic rules on the custom field. Instead, it stores display logic rules on the form. The closest you can get to what you are describing is, "show me forms that use display logic, and how many display logic rules exist on each form." So you may have one field on the form that has three different rules applied to it, and this report will show "three rules" instead of "one field" because Workfr...

Views

10

Likes

0

Replies

1
Re: Company typeahead field not pulling company form data like it would if native company field were used
-WE
- Workfront 22-07-2021
Hi Randy, My understanding of Typeaheads is that the object's custom parameters cannot be referenced. Referencing the full collection of object parameters does appear to be on the roadmap: https://one.workfront.com/s/idea/0870z000000XhPJAA0/detail First two temporary solves that come to mind for your situation are: Fusion: In a project hygiene scenario, check if Company (project custom form) == Company (project setup), and if not, update Company (project setup). Non Fusion: In a project hygiene ...

Views

11

Like

1

Replies

1
Re: Is there a quicker and easier way to input data into a Fusion Data Store? I've got quite a lot of data (strings and arrays) and entering field-by-field is very time consuming. Was wondering if there was a way to get those updated with a CSV or something
-WE
- Workfront 16-07-2021
Oh nice, I didn't know the binary data output of the Download Document module could be parsed. That's useful. I had gotten my hopes up that it could somehow read and pass text values from any type of document, like .docx, .xlsx, .pptx, or .pdf, (which maybe it could for some types, if you use "parse xml" on the data output and have the right data structure to map it to?) Our use case for that is a little different. Because Workfront doesn't search the contents of documents, we've been looking in...

Views

21

Likes

0

Replies

0
Re: report filtering for my subscriptions?
-WE
- Workfront 15-07-2021
add this to your text mode filter: subscribes:subscriberID=$$USER.IDsubscribes:subscriberID_Mod=in should work on all object types to which one can subscribe

Views

19

Likes

3

Replies

0