Text Mode Help | Community
Skip to main content
BrandonNW
BrandonNW
Level 6
July 17, 2019
Question

Text Mode Help

  • July 17, 2019
  • 2 replies
  • 693 views

Okay - so I found the shortened description text on WF-pro.com, easy peasy. A great site btw if any of you are unfamiliar with it. I am trying to pull the shortened project description into a task report. This seems like it should be possible by referencing the object type in the text, but as usual, I am missing something here.

The original code looks like this and works great in the project report:

valueexpression=IF(LEN({description})>150, CONCAT(SUBSTR({description},0,149),"...(open for more) -- "), IF(LEN({description})>0, {description}))

I have modified the text to include the project object rather than the task object. Can you guys see the error in my ways??

valueexpression=IF(LEN({project:description})>150, CONCAT(SUBSTR({project:description},0,149),"...(open for more) -- "), IF(LEN({project:description})>0, {project:description}))

As always, one thousand thank yous...

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

2 replies

T
TerryHy
Level 8
July 17, 2019

Hi Brandon, try this:

valueexpression=IF(LEN({project}.{description})>150, CONCAT(SUBSTR({project}.{description},0,149),"...(open for more) -- "), IF(LEN({project}.{description})>0, {project}.{description}))

BrandonNW
BrandonNWAuthor
Level 6
July 17, 2019
what a silly goose. All over it Terry - thank you! Brandon Pritchard System Administrator iNHouse Marketing - Nationwide pritcb1@nationwide.com
Terms & ConditionsAccessibility statement

Loading footer...