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:

*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

   /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 taskDetails 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.