Text Mode I Use

[NRYNR]

Just thought I'd put this here in hopes that you find it useful. Narayan Raum SunTrust Banks (Data Governance BIO)

[DagmaraGa]

That's brilliant! :) thanks. I will try to dig out my spreadsheet with some collected codes. Dagmara Garwell BAKKAVOR LTD

[OndinaSt]

This is fantastic information, thank you for posting! Ondina Sturges Everyday Health Inc

[AdinaPi1]

Thanks! I copied each tip individually into a page in OneNote to make it easy to search. Adina Pierce Cisco

[Sbhuta]

I TRIED USING THIS :

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

on a project report but its not showing up do i need to do anything different?

[Sbhuta]

displayname=Project Users

listdelimiter=<br>

listmethod=nested(projectUsers).lists

textmode=true

type=iterate

valuefield=user:name

valueformat=HTML

how can i exclude project creator from this list?

[NRYNR]

Hi Souvir, please make sure that the valueexpression is all on one line without line breaks.

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

[Sbhuta]

Sweet it worked. Souvir Bhuta - CapabilitySource CapabilityBlox

[tracy_fox]

Just wanted to say thank you!

I had previously used your (projectusers) to create a custom column on a Project View, but then seeing a reference to templateuser in the PDF, I was also able to create a similar custom column on a Template View.

[JaredMauch]

Thanks for posting this. It will make text mode a lot less daunting to me. Jared Mauch Crown Equipment Corporation

[MoniqueEvans]

This is fabulous! I had started compiling my own list of helpful text modes and then my coworker sent me this today. Thanks so much for sharing! Have you updated these notes since last year? Monique Evans Stanley Black & Decker, Inc.

[BrianMa2]

This is amazing, thank you for sharing! I have been wishing for a centralized repository of all things for text mode since I became an admin. Hopefully, WF takes this & everyone else's and posts in some searchable format. Brian C. Mauger Bloomberg L.P.