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

Does anyone know if there is a way to create a report to limit characters of a column? Lets say I want to see the last update comments but they ar elong, is there a way to limit what I see on the report like 20 characters?

Avatar

Level 2

Does anyone know if there is a way to create a report to limit characters of a column? Lets say I want to see the last updated comments but they are really long, is there a way to limit what I see on the report like 20 characters? I can't seem to find text edits to include in the report itself. I tried to use the count to unique or distinct items but it didn't work.

Topics

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

1 Reply

Avatar

Level 10

Hi Courtney - Do you know about WF-Pro.com? @NRYN R - inactive‚ built it and it is a must-save-to-your-favorites. He actually has something that might be perfect for you. He limited it to 140 characters but you could adjust that if you need it to truly be 20.

displayname=Last Note

querysort=lastNote:entryDate

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

Direct URL to his text mode examples: https://wf-pro.com/home/training/text-mode-examples/