Field Maps Form - Using Null Values in When Statement

LindsayLewin — Sun, 28 Jul 2024 01:36:19 GMT

Hello.

I have an Arcade Expression that is used to auto populate another field based on the results of the user input.

The problem I'm coming into is that I need to specify null values in the expression and I don't know how to write it properly....

When($feature.Staked == "Yes" && $feature.DACComplete == <Null> && $feature.QCVerify == <Null>,"Staked",

$feature.Staked == "Yes" && $feature.DACComplete == "Yes" && $feature.QCVerify == <Null>,"DAC",

$feature.Staked == "Yes" && $feature.DACComplete == "Yes" && $feature.QCVerify == "Yes","QC", "Pending")

Can someone help with this?

Many Thanks

Re: Field Maps Form - Using Null Values in When Statement

LindsayLewin — Sun, 28 Jul 2024 03:35:28 GMT

I figured this out using all the great info on this technical blog. For any others here is my working code:

var DacVar = $feature.DACComplete

var QCVar = $feature.QCVerify

When($feature.Staked == "Yes" && IsEmpty(DacVar) && IsEmpty(QCVar),"Staked",

$feature.Staked == "Yes" && DacVar == "Yes" && IsEmpty(QCVar),"DAC",

$feature.Staked == "Yes" && DacVar == "Yes" && QCVar == "Yes","QC", "Pending")

Cheers,