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; } } }

Replace values with text using Arcade in a list

dwold

How would I convert values (0,1) with yes/no in a list?

This is what I tried but not right

Data Table:

Finde mehr Beiträge mit dem Tag

Accepted answers

kenbuja

You should use the When function. Is the field numeric or a string?

//if it's a number
var over = When($datapoint['IsOverriden'] == 0, 'No',
                $datapoint['IsOverriden'] == 1, 'Yes',
                '');
//if it's a string
var over = When($datapoint['IsOverriden'] == '0', 'No',
                $datapoint['IsOverriden'] == '1', 'Yes',
                '');

All comments

kenbuja

You should use the When function. Is the field numeric or a string?

//if it's a number
var over = When($datapoint['IsOverriden'] == 0, 'No',
                $datapoint['IsOverriden'] == 1, 'Yes',
                '');
//if it's a string
var over = When($datapoint['IsOverriden'] == '0', 'No',
                $datapoint['IsOverriden'] == '1', 'Yes',
                '');

dwold

@KenBuja Thank you!

dwold

@KenBuja If I wanted to hide the Override line if the value is 0 would that be done through an if statement? Or can that still be done using the when statement?

Showing only records that have 1/yes

kenbuja

How are you constructing the text block?

dwold

@KenBuja I removed the == 0, 'No', line thinking the list would remove/hide the 0 values, but it still read Score override: (because that is part of the text block)

(didn't think it would be that easy but gave it a shot)

Doing this:

and then:

{expression/icon}

{AssesmentName}

Created on {expression/create}

Created by {Creator}

Score override: {expression/over}

kenbuja

Instead of putting "Score override: " in the text block, add that in the expression only if the value is "Yes"

If ($datapoint['IsOverriden'] == 1) return 'Score override: Yes';

dwold

@KenBuja I'm new to arcade so I don't think I am doing something right. When I remove the text block that line is deleted (even values with 1/yes). Does the return call look in the right spot? See anything that I am doing wrong?

kenbuja

I'm sorry, I was incorrect. That should be

If ($datapoint['IsOverriden'] == 1) var over = 'Score override: Yes';

Keep 'over' in the attributes and {expression/over} in the template

dwold

Great, worked perfectly! Thank you!

Nimm an der Diskussion teil

Angemeldete Mitglieder können Beiträge verfassen, Updates folgen und mehr. Neu hier? Registriere ein kostenloses Konto.

Schnellzugriffe

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