nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Create an if or iif statement for Details or List

RobertBorchert

I am wondering if it is possible to create an "if" or "iif" statement in a dashboard.

More specifically in Details or List.

I have tried a variety of options.

var cracking = $feature.FOUNDATIONCRACKING:
iif(cracking = 'Yes', 'Var1','Var2')

iif($feature.FOUNDATIONCRACKING = 'Yes', 'Var1','Var2')

We are using Enterprise and Portal

The information is coming from a Survey and is stored as part of a feature.

My intent for the results of this is when a answer is an aberration that I can make the font red.

In this example FOUNDATIONCRACKING is a question as to whether or not the foundation is cracking. If the answer is Yes I want to do something like this for the results of the "if" statement

<font color='red'>FOUNDATIONCRACKING</FONT>,FOUNDATIONCRACKING

Find more posts tagged with

ArcGIS Enterprise

Accepted answers

jcarlson

What version of Enterprise? In more recent versions where Arcade is available in Dashboards, this is fairly simple. In the Advanced formatting area, just use the expression you've given to create a "font color" variable, and pass that into the returned dictionary.

If you are on an earlier version, there's no way to accomplish this without a static field value, unfortunately.

All comments

RobertBorchert

Now what I need to do this for multiple answers. The FOUNDATONCRACKING is the first question.

The second question is FOUNDATIONSPALLING. What this currently doing is keeping everything RED until the next No answer then back to red when there is a Yes

RobertBorchert

Thank you very much. exactly what I was looking for

RobertBorchert

And specifically where in the List or Details should I be pasting it?

RobertBorchert

var cracking = $datapoint.['FOUNDATIONCRACKING']:
var f_col = iif(cracking == 'Yes','Red', '')
return {
textColor: f_col
}

RobertBorchert

Version: 10.9.1 (build 28388) is our server version

jcarlson

Can you share the Arcade expression you're using? That text shouldn't appear unless it's somehow within the main return statement.

RobertBorchert

We are at the newest version.

Maybe I am entering it in the wrong place. I wrote it just like your example and this is what I get.

jcarlson

If you are on an earlier version, there's no way to accomplish this without a static field value, unfortunately.

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.