HTML isn't actually returning HTML | Community
Skip to main content
Lila_Whitney
Lila_Whitney
March 4, 2022
Question

HTML isn't actually returning HTML

  • March 4, 2022
  • 2 replies
  • 1431 views

Could someone check my text mode? Thanks in advance

displayname=Last Note

querysort=lastNote:entryDate

textmode=true

usewidths=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

width=300

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

2 replies

skyehansen
Community Advisor
skyehansenCommunity Advisor
Community Advisor
March 7, 2022

this is working for my instance. Can you share what your errors actually are? (also helpful is what kind of report you are putting this on. For example if you put it in a project report this will pull updates posted to the project but not any of the tasks or issues inside the project... so if you're expecting anything like that, this would be the wrong code to use.)

Lila_Whitney
Lila_WhitneyAuthor
March 7, 2022

Thanks, Skye. This for a project report. It's pulling in the last note, but the text is not clickable.

T
TealeMcCleaf
March 7, 2022

@Lila Whitney‚

It looks like you want to create a link but you haven't indicated where the URL is for that link. Do you have a field that is generating the URL or what are you expecting the URL to point to?

Heather_Kulbacki
Community Advisor
Heather_KulbackiCommunity Advisor
Community Advisor
March 14, 2022

This is what we use the create a link in a report to a note - we put the note and the link in separate columns:

displayname=Comment Link

textmode=true

valueexpression=IF(ISBLANK({taskID}),CONCAT("https://yourdomain.my.workfront.com/project/",{projectID},"/updates?commentID=",{ID}),CONCAT("https://yourdomain.my.workfront.com/task/",{taskID},"/updates?commentID=",{ID}))

valueformat=HTML

    Terms & ConditionsAccessibility statement

    Loading footer...