Expand my Community achievements bar.

Got questions about Workfront Governance? Join our upcoming Ask Me Anything session on February 12th!
SOLVED

is there any way to set or pass in a variable that will persist through text mode columns in a report?

Avatar

Level 2

I would love to be able to set a variable value once in text mode in the first column of a report and then repeatedly use that variable throughout the subsequent columns. Is there any way to do this?

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

@VynetaRy - if you are using a value expression in your text mode the short answer is no, this is not possible. The results of your value expression aren't stored anywhere in the database of Workfront and it only exists in your column in your report. Kind of like using a basic calculator without the memory buttons. 

 

The workaround is to create calculated fields that live on your custom forms tied to the objects you are reporting on that way the data is "stored" somewhere for reference. 




View solution in original post

1 Reply

Avatar

Correct answer by
Community Advisor

@VynetaRy - if you are using a value expression in your text mode the short answer is no, this is not possible. The results of your value expression aren't stored anywhere in the database of Workfront and it only exists in your column in your report. Kind of like using a basic calculator without the memory buttons. 

 

The workaround is to create calculated fields that live on your custom forms tied to the objects you are reporting on that way the data is "stored" somewhere for reference.