51ºÚÁϲ»´òìÈ

Manage the table view

The information highlighted on this page refers to functionality not yet generally available. It is available only in the Preview environment for all customers. After the monthly releases to Production, the same features are also available in the Production environment for customers who enabled fast releases.

For information about fast releases, see Enable or disable fast releases for your organization.

IMPORTANT
The information in this article refers to 51ºÚÁϲ»´òìÈ Workfront Planning, an additional capability from 51ºÚÁϲ»´òìÈ Workfront.
You must have the following to access Workfront Planning:
  • A new Workfront package and license. Workfront Planning is not available for legacy Workfront packages or licenses.
  • A Workfront Planning package.
  • Your organization’s instance of Workfront must be onboarded to the 51ºÚÁϲ»´òìÈ Unified Experience.
For a complete list of requirements to access Workfront Planning, see Access overview.
For more information about Workfront Planning, see 51ºÚÁϲ»´òìÈ Workfront Planning overview.

You can display records and their fields in a table view, when accessing the record type page in 51ºÚÁϲ»´òìÈ Workfront Planning.

For information about record views and how to manage them, see Manage record views.

This article describes the following information:

Access requirements

Expand to view access requirements.

You must have the following access to perform the steps in this article:

table 0-row-0 1-row-2 2-row-2 3-row-2 4-row-2 5-row-2 6-row-2 7-row-2 8-row-2 layout-auto html-authored no-header
Products
  • 51ºÚÁϲ»´òìÈ Workfront

  • 51ºÚÁϲ»´òìÈ Workfront Planning

51ºÚÁϲ»´òìÈ Workfront plan*

Any of the following Workfront plans:

  • Select
  • Prime
  • Ultimate

Workfront Planning is not available for legacy Workfront plans

51ºÚÁϲ»´òìÈ Workfront Planning package*

Any

For more information about what is included in each Workfront Planning plan, contact your Workfront account manager.

51ºÚÁϲ»´òìÈ Workfront platform

Your organization's instance of Workfront must be onboarded to the 51ºÚÁϲ»´òìÈ Unified Experience to be able to access Workfront Planning.

For more information, see 51ºÚÁϲ»´òìÈ Unified Experience for Workfront.

51ºÚÁϲ»´òìÈ Workfront license*

Standard

Workfront Planning is not available for legacy Workfront licenses

Access level configuration There are no access level controls for 51ºÚÁϲ»´òìÈ Workfront Planning
Object permissions

Manage permissions to a view

View permissions to a view to temporarily change the view settings, duplicate, or to export it

Layout template

In the Production environment, all users including the System Administrators must be assigned to a layout template that includes the Planning areas.

In the Preview environment, Standard users and System Administrators have the Planning area enabled by default.

*For more information about Workfront access requirements, see Access requirements in Workfront documentation.

Edit records using the table view

You can edit record information only in the table view.

For more information about editing records in the table view, see Edit records.

Manage a table view manage-a-table-view

When creating a table view, all records of the selected type display in a table. Each row is a unique record and each column is a record field. All fields and all records display by default.

To manage a table view:

  1. Create a table view, as described in the article Manage record views.

    Table view example

  2. (Optional) Click Row height, then select from the following options to modify the height of the table rows:

    • Short
    • Medium
    • Tall
  3. Update the following view elements as described in the subsections below:

Add columns (or fields) add-columns

The column headers of a table view display fields associated with the records in the view. Fields displayed in the table view also display in the Details section of a record.

For more information, see Edit records.

Adding columns to a view is identical to adding fields to a record type.

You can add up to 500 fields (or columns) in a table view.

  1. Go to a record type page and click a table view tab, or click + View to add a new view, then choose Table.

  2. Start adding fields (or columns), as described in the article Create fields.

    The columns you add are visible to all users who access the record type and are added as new fields on the record’s page.

  3. Do one of the following to reorder columns in the table:

    • Grab the column header and drag and drop it in the desired position. The column you moved briefly displays with a blue background until you make other adjustments to the table.

    • Click Fields in the table’s toolbar, then drag and drop the fields in the desired order, then click outside the Fields visibility and order box to close it.

      Fields setting table view toolbar expanded

      note tip
      TIP
      • The Name field is always the first field in the table view, by default. This is considered a primary field.

      • You cannot move the Name field to another position, unless you designate another field as the primary field. For more information, continue with Step 4.

    • Replace the field in the first column with another field by changing the primary field. For more information, continue to step 4.

  4. (Optional) Hover over a field name in the column header of any field that does not display in the first column of the table, click the downward-pointing arrow to the right of the field name, then click Set as primary field.

    Set as primary field option in table view

  5. Click Set field to confirm.

    The field becomes a primary field which means it displays as the first column of the table view. The previous primary field moves to the second column.

    Primary fields become the record’s title and display in the header area of the record’s page, and everywhere where the records display. For example, the record title displays in connected fields and all views. For more information about primary fields, see Primary field overview.

  6. Click and drag the column separation lines and drop them in the desired spot to increase the width of the columns.

    note tip
    TIP
    The changes you make to the column width and order are permanent and visible to all users who access the record type.
  7. Hover over the column header, then click the downward-pointing arrow, then click Hide field

    Or

    Click Fields in the table toolbar and disable the toggle associated with the fields (or columns) you want to hide. The Fields visibility and order box displays.

    note tip
    TIP
    The number of hidden fields displays to the left of the Fields icon in the toolbar.
  8. Click the Fields icon and enable the toggle associated with the fields you want to display in the columns of the table. All fields display by default.

  9. Do the following to quickly find records that match a keyword:

    1. Click the Search icon Search icon and start typing a keyword associated with any field of a record that displays on the screen. The number of correct matches displays next to the search item and the field with the correct match is highlighted.

      Search box with results blue outline in table view

      You can use any word or special character that is visible on the screen.

      You cannot use keywords that are associated with fields that are hidden in the table view.

    2. Press Enter on your keyboard to go to the next found field.

    3. (Optional) If there is more than one match, click the up and down arrows to the right of the search keyword to find all the matches in the table.

    4. Click the x icon in the search box to clear the search keyword.

Add rows (or records) add-rows

The rows of a table view display individual records of the selected record type.

You can have up to 50,000 records (or rows) for a record typeS.

  1. Go to a record type page and click a table view tab, or click + View to add a new view, then choose Table.

  2. Start adding records (or rows), as described in the article Create records.

    The records you add in the table view are saved immediately and are visible to all users who have View or higher permissions to the workspace.

  3. (Optional) Add a thumbnail to each record, and click Fields in the upper-right corner of the table, then select the toggle for the Thumbnail field to display it to the left of the primary field. It is deselected by default.

    For information, see Add a thumbnail to a record.

  4. (Optional) Select one or multiple records in a row, then drag and drop the handle icon Handle icon to the left of the record to reorder the rows.

    note note
    NOTE
    You cannot reorder rows if you apply at least one sort to the table view.
    The changes you make to the row order are visible to all users who access the record type

Add filters add-filters

Filters help you reduce the amount of information displayed on the screen.

Consider the following when working with filters in the table view:

  • The filters you create for the table view work independently from the filters in the timeline view when applied to the same record type.

  • The filters are unique to the view that you select. Two table views of the same record type can have different filters applied to them. Two users looking at the same table view see the same filter that is currently applied.

  • You cannot name the filters you build and apply to a table view.

  • Removing filters removes them from anyone accessing the same record type as you and uses the same view as you use.

  • Adding filters to the table view is identical to adding filters to the timeline view.

  • You can filter by connected record fields or lookup fields.

  • You can filter by lookup fields that display multiple values.

  • You can reference a field that is up to 4 levels away from the current record type. For example, if you are creating a filter for an Activity record type, and the Activity is connected to the Product record type which is connected to the Campaign record type which is connected to a Workfront Project, you can reference the project’s Budget in the filter you are creating for the Activity record type.

To add a filter to a table view:

  1. Create a table view for a record type page, as described in the article Manage record views.

  2. Select a table view, then click Filters in the upper-right corner of the table.

  3. Click Add condition and add the following information:

    • Select a field that you want to filter by

    • Select an option (or a filter modifier) to define what kind of condition the field must meet

      The table below displays the available modifiers for each type of field.

      table 0-row-2 1-row-2 2-row-2 3-row-2 4-row-2 5-row-2 6-row-2
      Field type Modifiers
      Single-line, Paragraph, Formula

      Contains

      Does not contain

      Is

      Is not

      Is empty

      Is not empty

      Single-select

      Is

      Is not

      Is any of

      Is none of

      Is empty

      Is not empty

      Multi-select, People

      Has any of

      Has all of

      Is exactly

      Has none of

      Is empty

      Is not empty

      Number, Percentage, Currency

      =

      ≠

      <

      >

      ≤

      ≥

      Is empty

      Is not empty

      Date

      Is

      Is not

      Is after

      Is before

      Is between

      Is not between

      Is empty

      Is not empty

      Checkbox Is
    • Select a value for the field selected.

    Filter UI table view

    There is no limit to how many filtering conditions you can add.

  4. (Optional) Click Add condition to add another filtering option and repeat the above steps. The number of filters applied displays to the left of the Filters icon.

  5. Click the following operators to indicate how the filter conditions are joined and should be applied:

    • AND: All specified conditions must be met.

    • OR: Any of the specified conditions must be met. This is the default option.

    1. (Optional) Add additional AND or OR operators between multiple condition groupings.

      Multi-tiered filters in views

    The list of records is filtered automatically.

  6. (Optional) Click the x icon to remove a filter condition.

  7. (Optional) Click Filters to close the filters box.

Add a sort sort-information

By applying a sort, you can organize information in a given order.

You can sort the following information:

  • All records in a table view.

Consider the following when sorting records in the table view:

  • Sorting is unique to the view that you select. Two table views of the same record type can have different sorting criteria applied to them. Two users looking at the same table view see the same sorting that is currently applied.

  • You cannot name the sortings you build and apply to a table view.

  • The sorting you create is preserved when you navigate away.

  • You can sort by as many fields as you see displayed in the table view of a record type.

  • You cannot sort by connected record fields, but you can sort by lookup fields from connected record types.

  • When you sort by lookup fields with multiple values (that have not been summarized by an aggregator), the first value is used for sorting.

  • Removing sorting criteria removes them from anyone accessing the same record type as you and uses the same view as you use.

  • You can reference a field that is up to 4 levels away from the current record type. For example, if you are creating a sort for an Activity record type, and the Activity is connected to the Product record type which is connected to the Campaign record type which is connected to a Workfront Project, you can reference the project’s Status in the sort you are creating for the Activity record type.

To sort records, do the following:

  1. Create a table view, as described in the article Manage record views.

  2. Click the Sort icon Sort icon in the upper-right corner of the table

    Or

    Hover over the name of a column in the table view, click the downward-pointing arrow to the right of the column header name, then click Sort by this field. The field is added as a sorting selection in the Sort icon in the upper-right corner of the table view.

  3. (Conditional) In the Sort records by box, click one of the suggested fields, or click Choose a different field and search for a different field, then click it when it displays in the list.

    The sorting is applied automatically to the table view and records display sorted by your selected criteria.

  4. (Optional) Click Add condition, and repeat the above steps to sort by additional fields.

    The number of fields that you are sorting by displays to the left of the Sort icon in the upper-right corner of the toolbar. You can choose only fields that display in the columns of the table view.

  5. (Optional) In the Sort records by box, click the x icon to the right of a sorting field to remove the sort

    Or

    Click Clear all to remove all fields from the sort.

  6. Click outside the Sort records by box to close it.

    Sorting in table view

    The information displayed in the table is sorted according to your selected criteria.

    The fields selected for the sort display a sorting icon followed by a number that indicates the order in which the sorting is applied.

Add groupings add-groupings

You can group records by similar information when applying a grouping to a view.

Adding groupings in the table view is similar to adding groupings to the timeline view.

Consider the following:

  • You can apply groupings both in the table and timeline views. The groupings of the table view are independent from those in the timeline view of the same record type.
  • You can apply 3 levels of grouping in a view. The records are grouped in the order of groupings that you select.
  • The groupings are unique to the view that you select. Two table views of the same record type can have different groupings applied to them. Two users looking at the same table view see the same grouping that is currently applied.
  • You cannot name the groupings you build for a table view.
  • Removing groupings removes them from anyone accessing the same record type as you and who displays the same view as you do.
  • You can edit records listed under a grouping.
  • You can group by connected record fields or lookup fields.
  • When you group by lookup fields with multiple values (that have not been summarized by an aggregator), records are grouped by each unique combination of field values.
  • You can reference a field that is up to 4 levels away from the current record type. For example, if you are creating a grouping for an Activity record type, and the Activity is connected to the Product record type which is connected to the Campaign record type which is connected to a Workfront Project, you can reference the project’s Status in the grouping you are creating for the Activity record type.

To add a grouping:

  1. Create a timeline view for a record type, as described in the article Manage record views.

  2. Click Grouping in the upper-right corner of the table view.

    Grouping UI table view with linked fields

  3. Click one of the suggested fields, or click Choose a different field, search for a different field, then click it when it displays in the list.

    The grouping is applied automatically to the table and records display under the grouping separation line.

  4. (Optional) Click Add condition and repeat the above steps to add up to 3 groupings.

    The number of fields selected for the grouping displays next to the Grouping icon.

    Grouping applied in table view

  5. (Optional) Inside the Group records by box, click the x icon to the right of a field selected for the grouping to remove the grouping

    Or

    Click Clear all to remove all fields.

  6. Click outside the Group records by box to close it.

  7. (Optional) Click + New record at the end of any grouping to add new records, then refresh your page to add the new record to the appropriate grouping.

recommendation-more-help

Add row colors

  1. (Optional) Click Row colors to define conditions and choose configure diferent colors for table rows.

  2. Click Add color, then Select a field whose value you want to determine the color of a row.

    For example, to display campaigns with a status of Active in green, select Status, then choose a modifier and a value for the field.

    Row colors box with Active status selected and default color choice

  3. Click the drop-down menu for the color picker in the upper-left corner of the condition you selected, to pick the color for the condition, then click outside the color picker box to close it.

    Drop-down color picker menu in Row colors box highlighted

  4. (Optional) Click Add condition to add more fields and values to the first set of conditions

    Or

    Click Add color to add a new set of conditions and identify a new color.

    For example, you can display campaigns in a Planning status in yellow by defining a new set of conditions.

    Row colors box with Active and Planning status cusrom colors

  5. (Optional) Turn on the Apply to the entire row setting in the upper-right corner of the Row colors box. The entire row where the condition is met automatically displays in the selected color.

    note note
    NOTE
    • If the Apply to the entire row setting is turned off, only the left side of the Primary field displays a narrow color indicator with the selected color. The setting is turned off by default.

    • You cannot apply row colors to an entire row when you have at least one grouping selected in the table view.

  6. Click outside the Row colors box to close it. The colors are applied automatically.

Enable the real-time presence indicator

The avatars of other users who are editing record information at the same time as you display in the upper-right corner of all record views, by default.

When you display the table view, you can also view which field another user is editing at the time you are viewing the record.

  1. Go to a record type page and open any view.

  2. (Conditional) If there are other users editing the records of the selected type at the same time, their avatars display in the upper-right corner of the view.

  3. Click the drop-down menu next to the avatars, the select the Show collaborators toggle. The toggle is selected by default.

    Show collaborators toggle selected

  4. (Conditional) Open a table view, and the field which another person is actively editing is highlighted in the color corresponding to the outline of their avatar in the table view.

    If the highlight color of the avatar is gray, the user stopped actively editing the record more than 30 seconds ago.

    Real-time indicator table field and avatar connection

    note tip
    TIP
    You can select the Show collaborators toggle from any view. The field currently edited by others is outlined only in the table view.

Export the table view

You can export information in the table view to a CSV or an Excel file.

Consider the following when exporting the table view:

  • The information exported to an Excel file preserves the filters, groupings, and sorts applied to the table view in Workfront Planning. Groupings are not visible in the CSV file.

  • Thumbnails and custom row colors are not supported in exported files.

  • Only fields made visible in the Workfront interface are exported. Hidden fields are not exported.

To export information from the table view or a record type:

  1. Go to a record type page and click a table view tab.

  2. Hover over the table view tab’s name, then click the More menu More menu .

    More menu on a view

  3. Click Export, then select one of the following formats:

    • Excel
    • CSV
    note important
    IMPORTANT
    You cannot export information from the table view when you display a different view on the screen. You must display the table view that you want to export in order to access the Export option in the More menu.

    The file is downloaded to your computer.

  4. (Optional) Go to the downloads folder on your computer and find the downloaded file.

    The name of the exported file follows the following format:

    Name of the view - name of the record type

    For example, a table view for the Campaigns record type generates a file named Table view - Campaigns.

    The file displays the following information:

    • The column headers are highlighted in black, in the Excel file
    • All the fields visible in the Workfront interface, sorted and filtered by the same criteria
    • Groupings are preserved in the Excel file

    You can now share the exported files with others, or attach them to any communication.

5f00cc6b-2202-40d6-bcd0-3ee0c2316b43