Field Maps Form - Using Null Values in When Statement

LindsayLewin

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

LindsayLewin

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,