Expand my Community achievements bar.

Join us for our Coffee Break Sweepstakes on July 16th! Come ask your questions or share your use cases on Creative Briefs for a chance to win a piece of Workfront swag!
SOLVED

Is there a way to add text formatting in a valueexpression.

Avatar

Level 6

For example in a column for a late task report I'm showing the task successor as a valueexpression. 

 

displayname=Next Task
listdelimiter=<br><hr>
listmethod=nested(successors).lists
textmode=true
type=iterate
valueexpression=CONCAT('Task: ',{successor}.{name},' // Task#: ',{successor}.{taskNumber},' //Due Date: ',{successor}.{plannedCompletionDate},' //Task Owner: ',{successor}.{assignedTo}.{name},' //Task Constraint: ',{successor}.{taskConstraint})
valueformat=HTML

 

This results in the following:

 

Task: Test late Task 4 // Task#: 4 //Start Date: 2/8/24 //Due Date: 2/14/24 //Task Owner: Stephen Jonas //Task Constraint: FIXT


Task: Test late Task // Task#: 6 //Start Date: 2/1/24 //Due Date: 2/1/24 //Task Owner: Stephen Jonas //Task Constraint: MSO

 

What Id like to see is something like this. I know I can remove the // but they're currently used to break the content apart.

Task: Test late Task 4 

Task#:

Start Date: 2/8/24 

Due Date: 2/14/24 

Task Owner: Stephen Jonas 

Task Constraint: FIXT


Task: Test late Task //

Task#: 6 //Start Date: 2/1/24 //

Due Date: 2/1/24 //

Task Owner: Stephen Jonas //

Task Constraint: MSO

 

Any thoughts?

Topics

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

1 Accepted Solution

Avatar

Correct answer by
Level 6

Thank you, you sent me in the right direction. This is what I ended up with:
column.46.displayname=Successor Task
column.46.sharecol=true
column.46.textmode=true
column.46.value=<strong>Task Name : </strong>
column.46.valueformat=HTML
column.47.displayname=Next Task Start
column.47.listdelimiter=<div>
column.47.listmethod=nested(successors).lists
column.47.sharecol=true
column.47.textmode=true
column.47.type=iterate
column.47.valueexpression=CONCAT({successor}.{name})
column.47.valueformat=HTML
column.48.sharecol=true
column.48.textmode=true
column.48.value=<br><strong>Task #: </strong>
column.48.valueformat=HTML
column.49.displayname=Task #
column.49.listdelimiter=<div>
column.49.listmethod=nested(successors).lists
column.49.sharecol=true
column.49.textmode=true
column.49.type=iterate
column.49.valueexpression=CONCAT({successor}.{taskNumber})
column.49.valueformat=HTML
column.50.sharecol=true
column.50.textmode=true
column.50.value=<br><strong>Planned Start Date: </strong>
column.50.valueformat=HTML
column.51.displayname=Planned Start Date
column.51.listdelimiter=<div>
column.51.listmethod=nested(successors).lists
column.51.sharecol=true
column.51.textmode=true
column.51.type=iterate
column.51.valueexpression=CONCAT({successor}.{plannedStartDate})
column.51.valueformat=HTML
column.52.sharecol=true
column.52.textmode=true
column.52.value=<br><strong>Planned Completion Date: </strong>
column.52.valueformat=HTML
column.53.displayname=Planned Completion Date
column.53.listdelimiter=<div>
column.53.listmethod=nested(successors).lists
column.53.sharecol=true
column.53.textmode=true
column.53.type=iterate
column.53.valueexpression=CONCAT({successor}.{plannedCompletionDate})
column.53.valueformat=HTML
column.54.sharecol=true
column.54.textmode=true
column.54.value=<br><strong>Assigned to: </strong>
column.54.valueformat=HTML
column.55.displayname=Assigned To
column.55.listdelimiter=<div>
column.55.listmethod=nested(successors).lists
column.55.sharecol=true
column.55.textmode=true
column.55.type=iterate
column.55.valueexpression=CONCAT({successor}.{assignedTo}.{name})
column.55.valueformat=HTML
column.56.sharecol=true
column.56.textmode=true
column.56.value=<br><strong>Task Constraint: </strong>
column.56.valueformat=HTML
column.57.displayname=Task Constraint
column.57.listdelimiter=<div>
column.57.listmethod=nested(successors).lists
column.57.textmode=true
column.57.type=iterate
column.57.valueexpression=CONCAT({successor}.{taskConstraint})
column.57.valueformat=HTML

 

sljonas_0-1706917923688.png

 

View solution in original post

12 Replies

Avatar

Community Advisor

You would need to do multiple columns for each line you want with a coded line in between to signify the break and then combine into 1 column after they are setup.

 

this is what it will look like for the first 3 columns as an example in your scenario....

 

column.1.valueexpression=CONCAT('Task: ',{successor}.{name})
column.1.listdelimiter=<div>
column.1.listmethod=nested(successors).lists
column.1.valueformat=HTML
column.1.displayname=Next Task
column.1.textmode=true
column.1.sharecol=true
column.1.type=iterate
column.2.textmode=true
column.2.sharecol=true
column.2.valueformat=HTML
column.2.value=<div>
column.2.displayname=
column.3.displayname=Next Task
column.3.listdelimiter=<div>
column.3.listmethod=nested(successors).lists
column.3.textmode=true
column.3.type=iterate
column.3.valueexpression=CONCAT('Task#: ',{successor}.{taskNumber})
column.3.valueformat=HTML

 

 




Avatar

Correct answer by
Level 6

Thank you, you sent me in the right direction. This is what I ended up with:
column.46.displayname=Successor Task
column.46.sharecol=true
column.46.textmode=true
column.46.value=<strong>Task Name : </strong>
column.46.valueformat=HTML
column.47.displayname=Next Task Start
column.47.listdelimiter=<div>
column.47.listmethod=nested(successors).lists
column.47.sharecol=true
column.47.textmode=true
column.47.type=iterate
column.47.valueexpression=CONCAT({successor}.{name})
column.47.valueformat=HTML
column.48.sharecol=true
column.48.textmode=true
column.48.value=<br><strong>Task #: </strong>
column.48.valueformat=HTML
column.49.displayname=Task #
column.49.listdelimiter=<div>
column.49.listmethod=nested(successors).lists
column.49.sharecol=true
column.49.textmode=true
column.49.type=iterate
column.49.valueexpression=CONCAT({successor}.{taskNumber})
column.49.valueformat=HTML
column.50.sharecol=true
column.50.textmode=true
column.50.value=<br><strong>Planned Start Date: </strong>
column.50.valueformat=HTML
column.51.displayname=Planned Start Date
column.51.listdelimiter=<div>
column.51.listmethod=nested(successors).lists
column.51.sharecol=true
column.51.textmode=true
column.51.type=iterate
column.51.valueexpression=CONCAT({successor}.{plannedStartDate})
column.51.valueformat=HTML
column.52.sharecol=true
column.52.textmode=true
column.52.value=<br><strong>Planned Completion Date: </strong>
column.52.valueformat=HTML
column.53.displayname=Planned Completion Date
column.53.listdelimiter=<div>
column.53.listmethod=nested(successors).lists
column.53.sharecol=true
column.53.textmode=true
column.53.type=iterate
column.53.valueexpression=CONCAT({successor}.{plannedCompletionDate})
column.53.valueformat=HTML
column.54.sharecol=true
column.54.textmode=true
column.54.value=<br><strong>Assigned to: </strong>
column.54.valueformat=HTML
column.55.displayname=Assigned To
column.55.listdelimiter=<div>
column.55.listmethod=nested(successors).lists
column.55.sharecol=true
column.55.textmode=true
column.55.type=iterate
column.55.valueexpression=CONCAT({successor}.{assignedTo}.{name})
column.55.valueformat=HTML
column.56.sharecol=true
column.56.textmode=true
column.56.value=<br><strong>Task Constraint: </strong>
column.56.valueformat=HTML
column.57.displayname=Task Constraint
column.57.listdelimiter=<div>
column.57.listmethod=nested(successors).lists
column.57.textmode=true
column.57.type=iterate
column.57.valueexpression=CONCAT({successor}.{taskConstraint})
column.57.valueformat=HTML

 

sljonas_0-1706917923688.png

 

Avatar

Level 2

This whole report seems amazing and I'm wondering if you'd share its use case and the type of text mode you're using for the columns? Is it a collection report for a project? I'm looking for something similar... Thank you!

Avatar

Level 1

The report was to help the project managers view their late task and see the next task. This allowed the project managers to review and edit their task in one screen without having to open each project individually. The highlighted field allow the owner the ability to edit and log reasons for the date change.

Avatar

Level 2

This is honestly amazing and my company could totally benefit - is it too much to ask for all of the text modes please? Happy to chat over email as well if that's easier. I feel like I'd spin my wheels for days trying to recreate. Thank you!

Avatar

Level 1

No problem. Let me know if there are other types of reports your looking for, and I can see what I have.

Avatar

Level 3

@sljonashi 

I am grateful that you provided the zip file for the extensive code you use within that project report, but I was running into errors whenever I tried adding the text mode code for the 2nd column. Do you know why that might be? I fixed what I assumed was a typo in the first line, but I still had issues (column.12.colunm.7.sharecol=true). 

Thanks so much!

 

 

Avatar

Level 1

Delete from the second column the first line.

 

column.12.colunm.7.sharecol=true

Avatar

Level 1

andrewg50851537_0-1713893057701.png

I still get an error with that line removed for second column. Has anyone else tried this report out and had the same issue, or is it just me?


column.12.displayname=Project Status
column.12.sharecol=true
column.12.textmode=true
column.12.value=<strong>Project Condition: </strong>
column.12.valueformat=HTML
column.12.width=1
column.13.displayname=
column.13.enumclass=com.attask.common.constants.ProjectConditionEnum
column.13.enumtype=PROJ
column.13.linkedname=project
column.13.namekey=view.relatedcolumn
column.13.namekeyargkey.0=project
column.13.namekeyargkey.1=condition
column.13.querysort=project:condition
column.13.sharecol=true
column.13.textmode=true
column.13.tile.height=12
column.13.tile.name=component.conditionview
column.13.type=enum
column.13.valuefield=project:condition
column.13.valueformat=val
column.14.sharecol=true
column.14.textmode=true
column.14.value=<br><hr><strong>Progress Status: </strong></hr>
column.14.valueformat=HTML
column.15.displayname=
column.15.enumclass=com.attask.common.constants.ProjectStatusEnum
column.15.enumtype=PROJ
column.15.linkedname=project
column.15.namekey=view.relatedcolumn
column.15.namekeyargkey.0=project
column.15.namekeyargkey.1=status
column.15.querysort=project:status
column.15.sharecol=true
column.15.textmode=true
column.15.type=enum
column.15.valuefield=project:status
column.15.valueformat=val
column.16.sharecol=true
column.16.textmode=true
column.16.value=<hr><strong>Projected Start Date: </strong>
column.16.valueformat=HTML
column.17.displayname=
column.17.linkedname=project
column.17.namekey=view.relatedcolumn
column.17.namekeyargkey.0=project
column.17.namekeyargkey.1=projectedStartDate
column.17.querysort=project:projectedStartDate
column.17.sharecol=true
column.17.textmode=true
column.17.valuefield=project:projectedStartDate
column.17.valueformat=atDate
column.18.sharecol=true
column.18.textmode=true
column.18.value=<br><strong>Projected Completion Date: </strong>
column.18.valueformat=HTML
column.19.displayname=
column.19.linkedname=project
column.19.namekey=view.relatedcolumn
column.19.namekeyargkey.0=project
column.19.namekeyargkey.1=projectedCompletionDate
column.19.querysort=project:projectedCompletionDate
column.19.sharecol=true
column.19.textmode=true
column.19.valuefield=project:projectedCompletionDate
column.19.valueformat=atDate
column.20.sharecol=true
column.20.textmode=true
column.20.value=<hr><strong>Project % Completed: </strong>
column.20.valueformat=HTML
column.21.sharecol=true
column.21.textmode=true
column.21.valueformat=HTML
column.22.displayname=
column.22.linkedname=project
column.22.namekey=view.relatedcolumn
column.22.namekeyargkey.0=project
column.22.namekeyargkey.1=percentComplete
column.22.querysort=project:percentComplete
column.22.textmode=true
column.22.tile.name=component.percentcompletelistview
column.22.type=tile
column.22.valuefield=project:percentComplete
column.22.valueformat=doubleAsPercentRounded

Avatar

Level 1

Andrew,

I was able to copy the text mode for the column into a blank report and it worked. I can get on a call with you if you'd like. You can also email me  stephen_jonas@hmsa.com to discuss more.