Custom column Table Widget Hyperlink

In this document, you will learn how to add a hyperlink to the columns of table widgets using custom columns.

Custom Column Table Widget Hyperlink: This video explains how to create a hyperlink to apply a filter value to a new dashboard.

Steps to Create a Custom Column Table Widget Hyperlink:

Log in to AIV.
To create a dashboard, click on the Plus icon (+) in the Dashboard section, as shown below:
Insert a name for the dashboard and click on the CREATE button, as shown below:
You will be directed to an empty dashboard. Then, click on the Table Widget icon from the left vertical menu, as shown below.
Add the following details to the Table Widget:
- Name: sales
- Datasets (ds): Select Sales.ds
Select all fields from the Dataset Columns by clicking on the Select All Field icon. All available columns will then appear in the Selected Columns box.
To Customize the columns, click on the Custom Columns button.
Then, click on the Add New button in the Custom Columns dialog box.
As you click on the Add New button, a dialog box will appear with the controls, as shown in the figure below:
Enter custom column details:
- Name: country
- Display Name: country
- Map for Widget link Column: Select country
- All Column: Select country
- Condition: Equal to
- Value: Insert USA (This value will apply the hyperlink to USA fields only)
Click on the Open Code Layout icon to add the code, as shown below.
It will display the Code Panel and Type select dropdown, as shown in the figure below:
Now, change the Type to Hyperlink from the dropdown, and modify the target URL in the code panel by setting it to target=“aivhub.com”, as shown in the figure below.
Then, click on the SAVE button, followed by the ADD button to add the custom column to the table widget.
Click on the Publish button, then on the Preview icon. Finally, click on the SAVE AND EXIT button to view the custom column, which will indicate hyperlinks only in USA fields. Clicking on any field under the country column will navigate to the www.aivhub.com webpage.