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

Conditional Formatting Table to Highlight Null Values

JustinH

Hello-

I am currently creating a project management tool using dashboards. The goal is to highlight cells that have no data (null) so we can see who is not entering information in the fields.

It seems somewhat simple but I am pretty new to arcade. I was thinking that I could go into the text and background formatting for the field and use the IIF function to format this. I do want to apply this for ALL fields so I am guessing there is an easier way to do this.

Thanks in advance.

Vind meer berichten getagd met

ArcGIS Online

Accepted answers

JA7

The expression you're looking for is

When(IsEmpty($datapoint.Company), '#F5DDD4', '')

But you would need do this for every cell/field. To simplify this you can instead create a function:

function colorGrade(nulls){
  return (
    When(IsEmpty(nulls), '#DB9497', '')
                )
}

And then plug in the function in every cell return statement with that specific field in the function.

All comments

clt_cabq

You might look into use the Advanced Formatting available - this article has a section specifically about formatting tables:

Advanced Formatting - tables

JustinH

Thank you for your reply. I am only seeing Advanced Formatting for lists in this article. I am wondering if there is a function that will search for null values in the table and highlight them no matter what data point I define in the expression.

JustinH

Update: I have used

// Highlight descriptions with a keyword

var keyword = '';

// Use Find() to determine the index of the word

var hasKeyword = Find(keyword, $datapoint)>=0;

// Update text and background colors if it has the keyword

var txtColorDescription = IIF(hasKeyword, 'red', '');

var bgColorDescription = IIF(hasKeyword, '#F5DDD4', '');

Which will atleast apply some sort of conditional formatting to the cells but it will not find only null values. I have also tried null as the keyword.

Still no solution.

JA7

The expression you're looking for is

When(IsEmpty($datapoint.Company), '#F5DDD4', '')

But you would need do this for every cell/field. To simplify this you can instead create a function:

function colorGrade(nulls){
  return (
    When(IsEmpty(nulls), '#DB9497', '')
                )
}

And then plug in the function in every cell return statement with that specific field in the function.

JustinH

Wow, thank you so much! This is so helpful.

Doe mee aan het gesprek

Aangemelde leden kunnen berichten plaatsen, updates volgen en meer. Nieuw hier? Registreer een gratis account.

Snelle Links

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