Knowledge Base

How to remove the hyperlinks from Cascaded Lookup column?

Sometimes, when create a Cascaded Lookup column to retrieve data from another list, we just need to show the Lookup value retrieved in the list, we don’t want end users to click the hyperlink of Cascaded Lookup value to access the lookup list.

This article will demonstrate how to remove the hyperlinks from Cascaded Lookup column.

WHAT YOU'LL GET

The hyperlinks are removed from Country column (a Cascaded Lookup column)

WHAT YOU'LL NEED

Cascaded Lookup

The sample data we use for this case

Then, create the other list named as Country from the custom list template with following columns and items on the same SharePoint site collection.

Remove the hyperlinks from Cascaded Lookup column

  1. Download the trial version of Cascaded Lookup, and install it to your SharePoint server.

  2. Navigate to the Customer list prepared above, click List tab. In the Manage Views group, click Create Column .

    Or go to the List Settings page and click the Create column link in Columns section.

    If you already created a Cascaded Lookup column, please skip to step 6.

  3. In the Name and Type section, enter a name in the Column Name field to give it a meaningful name such as Country, then select Cascaded Lookup as the type of information in this column.

  4. In the Additional Column Settings section, keep all settings as default.

  5. In the General Settings section, configure settings as following.

    In the Get information from this site box, select Marketing Center, because in our example the Country list is located in a SharePoint site named as Marketing Center. You need to select the corresponding SharePoint site in which your Country list is located.

    In the From this list box, select Country.

    In the In this column box, select Continent.

  6. In the Miscellaneous section, select the check box of Remove link in list view option.

  7. Keep other settings as default and click OK.

  8. Then, you will find that a Cascaded Lookup column named as Country has been added to Customer list as following.

  9. In the Customer list, select the item Diff Inc and click Edit Item.

  10. In Country column, select German and click Save.

  11. In the list view of Customer list, you will find out that there is no hyperlink for the Country column shown below.

    Click item Diff Inc to view the details, and you will find that the hyperlink is removed from the Country column as well as following.

Login