Limiting Characters in Reports | Community
Skip to main content
J
justjill853
Level 2
June 1, 2018
Question

Limiting Characters in Reports

  • June 1, 2018
  • 1 reply
  • 552 views
I just wanted to share this because it helped us so much! We share Status Updates in some reports and it made the reports appear much longer than they were due to long comments. Tony helped us by providing this text edit to limit characters in a column to 200. Thanks Tony !! displayname= linkedname=direct namekey=description querysort=description textmode=true valueexpression=LEFT({description},200) valueformat=HTML Jill Blum Stanley Black & Decker, Inc.
This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

1 reply

N
NRYNR
Level 10
June 1, 2018
Here's a similar "summary" I use for updates: displayname=Latest Update namekey=latest update textmode=true valueexpression=IF(LEN({lastNote}.{noteText})>140, CONCAT(SUBSTR({lastNote}.{noteText},0,139),"...(open for more) -- ", {lastNote}.{owner}.{name}," on ", {lastNote}.{entryDate}), IF(LEN({lastNote}.{noteText})>0, CONCAT({lastNote}.{noteText}," -- ", {lastNote}.{owner}.{name}," on ", {lastNote}.{entryDate}))) valueformat=HTML
Terms & ConditionsAccessibility statement

Loading footer...