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

SOLVED

Limit characters in a report

Avatar

Level 1

Is it possible to have the project description only show the first 100 (or so) characters in a task report? The purpose is to have a quicker overall view with smaller rows.

Topics

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

1 Accepted Solution

Avatar

Correct answer by
Level 4

Yes, it's possible. This would be the code for a task report:

-----------

valueexpression=CONCAT(LEFT({project}.{description},100),"...")

valueformat=HTML

displayname=Project Description

-----------

You can omit the CONCAT() portion if you choose, so it would just be valueexpression=LEFT({description},100). The CONCAT is just there to add "..." to the end of the description, that way a user knows that there may be more text that they're just not seeing in the report.

If you want to get REALLY fancy and only add the "..." when the description is > 100 characters, you'd use this formula:

-----------

valueexpression=IF(LEN({project}.{description})>100,CONCAT(LEFT({project}.{description},100),"..."),LEFT({project}.{description},100))

valueformat=HTML

displayname=Project Description

View solution in original post

2 Replies

Avatar

Correct answer by
Level 4

Yes, it's possible. This would be the code for a task report:

-----------

valueexpression=CONCAT(LEFT({project}.{description},100),"...")

valueformat=HTML

displayname=Project Description

-----------

You can omit the CONCAT() portion if you choose, so it would just be valueexpression=LEFT({description},100). The CONCAT is just there to add "..." to the end of the description, that way a user knows that there may be more text that they're just not seeing in the report.

If you want to get REALLY fancy and only add the "..." when the description is > 100 characters, you'd use this formula:

-----------

valueexpression=IF(LEN({project}.{description})>100,CONCAT(LEFT({project}.{description},100),"..."),LEFT({project}.{description},100))

valueformat=HTML

displayname=Project Description

Avatar

Level 1

I have tried so many different variations, THIS WORKED. thank you so much!