Reference a custom form in a report
You can reference the custom forms of an object in the Views, Filters, and Groupings of a report for that object.
You can reference the content of custom forms to include in a report, or you can reference information about the custom forms themselves to include in a report.
Access requirements
You must have the following access to perform the steps in this article:
*To find out what plan, license type, or access you have, contact your Workfront administrator.
Prerequisites
The custom form must exist before you can reference it in a report.
For more information on creating custom forms, see Create a custom form.
Reference the content of custom forms
You can reference fields within custom forms. After a custom form is applied to an object, all of the fields associated with that custom form are available to be referenced in a report as any other field on the object would be.
For more information about hiding choices from a custom field with multiple options, see the article Create a custom form.
When creating the report, simply use the object type of the form as the field source, and use the name of the custom field as the field name.
For example, you might have a custom form applied to all projects that includes the custom field Consultant. To create a report that lists all of the projects where Olivia Kim is the consultant, use the Project object type as the field source, and use Consultant as the field name. Set the filter qualifier to Equal, then type Olivia Kim.
For more information about creating a report, see the article Create a custom report.
Reference information about custom forms
You can reference information about custom forms, such as the name of any custom forms associated with an object.
Depending on the element (View, Filter, or Grouping), you can reference either:
-
The primary custom form applied to an object:
This is the form that appears first on the Details page of the object.
-
All custom forms (if more than one custom form is applied to an object)
You can reference custom forms on Views, Filters, and Groupings:
Reference custom forms in a report View (Column) reference-custom-forms-in-a-report-view-column
To display all custom forms associated with an object:
- Begin creating a report as described in the article Create a custom report.
- On the Columns tab, expand the object type that the custom form that you want to reference is applied to, then click Category Name.
For example, to display all custom forms associated with a task, expand the Task field source, then click the Category Name field name.
To display only the primary custom form associated with the object:
- Begin creating a report as described in the article Create a custom report.
- On the Columns tab, expand the Category field source, then click the Name field name.
Reference custom forms in a report Filter reference-custom-forms-in-a-report-filter
To filter on all custom forms associated with the object type:
-
Begin creating a report as described in the article Create a custom report.
-
On the Filters tab, expand Categories, then click Name.
-
Select the condition qualifier that you want to use:
- Is Blank
- Is Not Blank
- Contains
- Does Not Contain
- Equal
- Not Equal
For more information about each qualifier, see the article Filter and condition modifiers.
note note NOTE If the field you are filtering for has multiple options and you use the Not Equal or Does Not Contain qualifiers, this filters out the results that contain only the choice you specify. If the field contains additional options including the one specified, those results are not filtered from the report. This includes filtering for multiple Custom Forms if they are attached to the same object. -
Begin typing the name of the custom form that you want to filter on, then click the name when it appears in the drop-down list.
-
(Optional) Click Add another Filter Rule, then repeat steps 2-4 to create additional filter rules.
-
Click Save+Close.
To filter only on the primary custom form associated with the object type:
-
Begin creating a report as described in the article Create a custom report.
-
On the Filters tab, expand the Category field source, then click the Name field name.
-
Select the condition qualifier that you want to use:
- Is Blank
- Is Not Blank
- Contains
- Does Not Contain
- Equal
- Not Equal
For more information about each qualifier, see the article Filter and condition modifiers.
-
Begin typing the name of the custom form that you want to filter on, then click the name when it appears in the drop-down list.
-
(Optional) Click Add another Filter Rule, then repeat steps 2-4 to create additional filter rules.
-
Click Save+Close.
Reference custom forms in a report Grouping reference-custom-forms-in-a-report-grouping
- Begin creating a report as described in the article Create a custom report.
- On the Groupings tab, expand Category, then click Name.