Does anyone know the syntax to combine multiple custom form fields into a single column on a project report? | Community
Skip to main content
June 9, 2021
Question

Does anyone know the syntax to combine multiple custom form fields into a single column on a project report?

  • June 9, 2021
  • 2 replies
  • 637 views
No text available
This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

2 replies

Level 3
June 9, 2021

I use this one for last note: note text, date, and owner of note.

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