You can expand your reporting capabilities by using text mode in reports and report elements. You can also use a version of text mode to build more complex calculated custom fields. For more information about text mode, see Text Mode overview.
This article outlines just a few common examples of where you would most likely need to use text mode to expand reporting or calculated custom fields capabilities in Adobe Workfront. For a more expansive list of examples, see:
For additional real-life text mode examples that other Workfront customers might have identified, visit the Text Mode Reporting Discussions tab in Adobe Workfront One or join the Workfront Community (requires logging in).
We recommend that you use the report and list builder to build your views, filters and groupings. However, there are some instances where you can use text mode to enhance your reports and lists.
You can use text mode when you want to achieve the following in Workfront:
Build custom calculated custom fields in a custom form.
For more information about calculated custom fields, see the Use Text Mode in calculated custom fields section in this article.
Enhance filters, views, and groupings beyond what is possible in the report builder. For information about using text mode for filters, views, and groupings, see the following sections in this article:
Create custom prompts. You can only create custom prompts using Text Mode.
For information about building custom prompts, see Add a prompt to a report.
You can use text mode to add a calculated custom field to a Custom Form.
For more information about adding a calculated custom field to a Custom Form, see Create or edit a custom form.
For more information about creating a calculated custom field in text mode, see Add calculated data to a custom form.
For example, you can add a calculated custom field that shows a time and date stamp of the moment when an item was marked as In Progress. You can use this calculation for other statuses.
For information, see Calculated custom field example: display a Status timestamp in a Custom Form.
You can use text mode in views to expand on the fields and objects you can display in the view.
For examples of the most common reasons for using text mode in a view, see the following articles:
You can use text mode when building filters to expand on the fields and objects you can filter by.
For examples of the most common reasons for using text mode in a filter, see the following articles:
You can use text mode when building groupings to expand on the fields and objects you can group by in lists and reports.
For examples of the most common reasons for using text mode in a grouping, see the following articles: