View: external URL using custom data field

You can display a link to an internal custom URL by using a Calculated Custom Field named “Custom URL” in a Task View.

This helps you quickly link from certain objects in a view to certain areas of the application directly from your reports.

When creating a calculated custom field, you must first create the field, then create the View.

The following sections are an example of a calculated custom field for tasks. The custom field is called Custom URL. The custom view displays the field’s value as well as the URL field for tasks.

Using the same steps, you can create similar calculated custom fields and custom views for all the objects in the system that have a Custom Form.

Access requirements

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

Adobe Workfront plan*
Any
Adobe Workfront license*

Request to modify a view

Plan to modify a report

Access level configurations*

Edit access to Reports, Dashboards, Calendars to modify a report

Edit access to Filters, Views, Groupings to modify a view

NOTE

If you still don’t have access, ask your Workfront administrator if they set additional restrictions in your access level. For information on how a Workfront administrator can modify your access level, see Create or modify custom access levels.

Object permissions

Manage permissions to a report

For information on requesting additional access, see Request access to objects.

*To find out what plan, license type, or access you have, contact your Workfront administrator.

Create the “Custom URL” calculated custom field

For information about creating a calculated custom field, see the article Add calculated data to a custom form.

If you have access to create a custom form, you can create a calculated custom field for tasks called “Custom URL.” This field links directly to the Overview subtab within the Task Details tab.

  1. Create a calculated custom field.

  2. In the Calculation field, enter the following code:

    CONCAT(‘‘https://<domain>.my.workfront.com",“/”,“task/”,ID,"/overview’’)

  3. Replace “<domain>” with your actual domain name, without the brackets.

    The

    code language-none
    /overview
    

    portion of this URL directs the link to the Overview section in the left panel of the task.

  4. After creating your Calculated Custom Field, attach the Custom Form with this field to several tasks in Adobe Workfront that you want display in your new view.

Create the view which displays the “Custom URL” and “URL” fields of the task

The task View in the example below displays the Calculated Custom Field called “Custom URL” as a direct link to the Overview subtab within the task Details tab, as well as the URL field of the task.

To customize this view:

  1. Go to a list of tasks.

  2. Expand the View drop-down at the top of your task list.

  3. Click Customize View.

  4. Remove all the columns inside the view, except for the first column.

  5. Click the header of the first column.

  6. Click Switch to Text Mode in the upper-right corner of the interface.

  7. Click Click to edit text.

  8. Paste the text mode below into your one column.
    In this example the ‘column.1.’ displays the value in the ‘Custom URL’ field as a link into the task’s Overview. ‘Column.2.’ displays the value stored in the URL Field of the task.

    column.0.descriptionkey=name
    column.0.link.linkproperty.0.name=ID
    column.0.link.linkproperty.0.valuefield=ID
    column.0.link.linkproperty.0.valueformat= int
    column.0.link.lookup=link.view
    column.0.link.valuefield= objCode
    column.0.link.valueformat= val
    column.0.linkedname=direct
    column.0.listsort=string(name)
    column.0.namekey=name.abbr
    column.0.querysort=name
    column.0.shortview=false
    column.0.stretch=100
    column.0.valuefield=name
    column.0.valueformat=HTML
    column.0.width=150
    column.1.description=Custom URL
    column.1.link.isnewwindow=true
    column.1.link.url=customDataLabelsAsString(Custom URL)
    column.1.linkedname=direct
    column.1.listsort=customDataLabelsAsString(Custom URL)
    column.1.name=Custom URL
    column.1.querysort=URL
    column.1.shortview=false
    column.1.stretch=0
    column.1.valuefield=Custom URL
    column.1.valueformat=customDataLabelsAsString
    column.1.width=150
    column.2.descriptionkey=url
    column.2.linkedname=direct
    column.2.listsort=string(URL)
    column.2.namekey=url.abbr
    column.2.querysort=URL
    column.2.shortview=false
    column.2.stretch=0
    column.2.valuefield=URL
    column.2.valueformat=HTML
    column.2.width=150
    
  9. Click Save View.

recommendation-more-help
5f00cc6b-2202-40d6-bcd0-3ee0c2316b43