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:

Find more posts tagged with

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}

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.