Customer experience | Sales, Customer Insights,...

Showing only a Symbol if another column is not empty

(2) Share

Report

Posted on by DM-18021410-0

Hello everyone,

I am still relatively new to Dynamics.
I am facing the following problem.

I need to create a new column in which only a symbol without text is displayed if another column is not empty.

The image shows the Sequenze ZW column. If there is a number there,
as in the example, the symbol with the shopping cart should appear in the (new) column next to it.

I would be delighted if you could help me further.

Thank you very much in advance for your help.

Best regards,
Dirk

Categories:

Microsoft Dynamics CRM

All responses (4)

Answers (0)

Suggested answer

Tom_Gioielli on at

Like (0)

Report

Showing only a Symbol if another column is not empty

@DM-18021410-0 The AI crafted response is not correct. A field on a subgrid cannot be defined in a way to show a web resource/image through the field value itself. See my original response, as you can do this through a JavaScript function on the subgrid.
DM-18021410-0 on at

Like (0)

Report

Showing only a Symbol if another column is not empty

Hello Daivat,

i have only formula columns not calculated and this is my formula:

In the properties i dont have webresource...

Now, the column shows me the text:

Best regards,
Dirk
Suggested answer

Daivat Vartak (v-9d... Super User 2025 Season 1 on at

Like (1)

Report
Showing only a Symbol if another column is not empty

Hello Dirk,

Okay, let's break down how to get that shopping cart symbol to show up in your Dynamics 365 view, step-by-step, in simple terms:

What we're going to do:

Get the Shopping Cart Symbol: We'll either find a symbol online or use an image of a shopping cart.

Put the Symbol in Dynamics 365: We'll add this symbol (or image) to Dynamics 365 so it can be used in your column.

Create a Rule (Calculated Field): We'll make a rule that says "If the 'Sequenze ZW' column has something in it, show the shopping cart symbol."

Show the Symbol in the View: We'll add the rule to your view, so the symbol appears when needed.

Here's how:

1. Get the Shopping Cart Symbol:

Option 1: Use a Symbol (Unicode):

Search online for "shopping cart Unicode symbol."

Copy the symbol.

Option 2: Use an Image:

Find a small image of a shopping cart (like a PNG).

Save it to your computer.

2. Put the Symbol in Dynamics 365:

Go to Customizations:

In Dynamics 365, go to "Settings" (gear icon) -> "Customizations" -> "Customize the System."

Add the Symbol (Web Resource):

Expand "Web Resources" and click "New."

Name: Give it a name (e.g., "shopping_cart").

Type:

If you used a Unicode symbol, choose "String (RESX)."

If you used an image, choose "PNG" (or the image type).

Content:

If Unicode, paste the symbol.

If an image, upload the image file.

Click "Save" and then "Publish."

3. Create a Rule (Calculated Field):

Go to Your Table/Entity:

Find the table (entity) where your "Sequenze ZW" column is.

Add a New Column:

Click "New" to create a new column.

Data Type: Choose "Single Line of Text."

Field Type: Choose "Calculated."

Click "Edit."

Write the Rule:

In the formula box, write this (replace "sequenze_zw" and "shopping_cart" with the actual names):

What this means:

ISNULL(sequenze_zw): Checks if "Sequenze ZW" is empty.

NOT(...): Reverses the result (so it checks if it's not empty).

IF(..., "webresource_shopping_cart", ""): If "Sequenze ZW" is not empty, it shows the "shopping_cart" web resource. If it is empty it shows nothing

Click "Save" and "Close."

4. Show the Symbol in the View:

Go to Your View:

Find the view where you want the symbol to appear.

Add the New Column:

Add the new calculated column to the view.

Change the Column's Control:

Edit the properties of the column.

Change the control to web resource.

Select the web resource that has the shopping cart symbol

Click "Save" and "Publish."

If my answer was helpful, please click Like, and if it solved your problem, please mark it as verified to help other community members find more. If you have further questions, please feel free to contact me.

My response was crafted with AI assistance and tailored to provide detailed and actionable guidance for your Microsoft Dynamics 365 query.

Regards,

Daivat Vartak
Tom_Gioielli on at

Like (1)

Report
Showing only a Symbol if another column is not empty

This is definitely possible, though it's not the most common functionality out there for Dynamics CRM. Check out the following link for the full details, but basically you need to:

Create a web resource to store your icon

Create another web resource with some JavaScript that will define the criteria for the icon to appear

Add the web resource to the system view and call the proper function

Add custom icons to a list view in Dynamics 365 Customer Engagement (on-premises) | Microsoft Learn

The link says it is for on-premise, but I can confirm this works online as well. The assumption is that the icon will appear next to the field value (in this case Sequence ZW), but you should be able to modify it to appear in its own column if you really needed to. Let me know if this works for you or if you run into other issues!

If this answer helped, please consider marking as verified.