Knowledge Base

How to add icon in Cascaded Lookup column?

Adding icon in front of list fields can make fields more noticeable and readable, like adding a phone icon in front of a mobile phone field; or adding a pdf icon next to a document field to indicate the format of the document. Cascaded Lookup provides the feature to enable you to add icon in Cascaded Lookup columns.

This article will demonstrate how to do it.

WHAT YOU'LL GET

The pdf icon in Cascaded Lookup column “Contract”, indicating the format of the data stored in the column

WHAT YOU'LL NEED

The sample data we use for this case

Then create a list named as Orders from the custom list template with following columns and items on a SharePoint site.

Add icon in Cascaded Lookup column

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

  2. Navigate to the Orders 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 Contract, 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 Contracts list is located in a SharePoint site named as Marketing Center. You need to select the corresponding SharePoint site in which your Contracts list is located.

    In the From this list box, select Contracts.

    In the In this column box, select Name.

  6. In the Appearance section, select the Enter the image web address option.

    When the textbox is available, enter the image web address. (The recommended image size is 16 ×16)

    Click Click to test, you will see the icon in browser as following if the image web address is available. Otherwise, the web address is unavailable.

    Cascaded Lookup also provides preset icons. By selecting Choose an icon below option, and click Select icon… button, then in the Select an icon below dialog, choose the icon you preferred then click OK.

  7. Keep other settings as default and click OK.

  8. And then, you will find that a Cascaded Lookup column named as Contract in the Orders list has been created. Select item CA-0001 and click Edit Item.

  9. In Contract column, select the target contract name such as “CA-0001_Diff_20201231.pdf”, and click Save button.

  10. Click the item CA-0001 to view it, and you will see the pdf icon in Contract column as following.

Login