Follow
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.

Creating the 'Custom URL' Calculated Custom Field

To learn how to create a Calculated custom field, refer to Using Calculated Custom Data.

A user with the ability to create a custom form can create a Calculated custom field for tasks called 'Custom URL.' This field links directly to the Overview sub-tab within the Task Details tab. 

The value for your Calculation will be: 

CONCAT("https://<your domain>.my.workfront.com","/","task/view?ID=",ID,"&activeTab=tabs-task-details-forms")

Replace '<your domain>' with your actual domain name, without the brackets.

The 'activeTab=tabs-task-details-forms' portion of this URL directs the link to the Overview sub-tab of the task. This information can be found in the source code of this page. 

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

Creating 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 sub-tab within the task Details tab, as well as the URL field of the task.

task_view_with_custom_url_field.png

To customize this view: 

  1. Navigate 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. 
    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
    In this example the 'column.1.' displays the value in the 'Custom URL' field as a link into the task's Overview sub-tab. 'Column.2.' displays the value stored in the URL Field of the task.
  9. Click Save View.