The follow describes how to use an expression for a hotlink and how to add the expression as a column to a Browser window and persist it.
To add an expression as a column to a geographic table:
-
Open the table in both a Map and Browser window.
-
In the Layer Control (on the HOME tab, in the Windows group, click Tool Windows, and click Layers from the list.), select your layer.
-
On the MAP tab, in the Options group, click Hotlink Options .
-
In the Hotlink Options dialog box:
- Click Add to add a new filename expression to the list.
- From the Filename Expression drop-down list, select the column to add a hotlink expression for, such as for country name or capital name.
- From the Alias Expression drop-down list, select Expression.
-
In the Expression dialog box:
- Before the column name, add the hotlink URL followed by the plus sign (+). The URL must be within quotation marks (" "). The following example replace the URL with the one you want to use and replace ColumnName with the column name selected in the previous step: "http://www.myurl.com"+ColumnName
- Click Verify to check that the expression works.
- Copy the expression to the clipboard by selecting it and pressing Ctrl+C.
- Click OK to close the dialog box.
-
In the Hotlink Options dialog box, check the Save options to table metadata check box and click OK.
-
Right-click on the Browser window and in the pop-up menu that displays, select Pick Fields.
-
In the Pick Fields dialog box, from the Fields in Table list, select Expression.
-
In the Expression dialog box, paste your expression field by pressing Ctrl+V. Click OK to close the dialog box.
-
In the Pick Fields dialog box:
- In the Name field, type a descriptive name, such as URLlinks.
- Check the Save as Default Browser view check box and click OK.
In the Browser window, there is a new column at the end of your table (you may need to scroll to see it) containing a list of hotlinks.