Apply Arcade conditional functions to NULL or NOT NULL values in ArcGIS Online

Summary

Arcade conditional functions are useful in field calculations to generate attribute values based on specific conditions. A field can be populated based on the attributes of other fields that hold either NULL or NOT NULL values to organize and prevent invalid records.

This article describes the workflow to apply Arcade conditional functions to NULL or NOT NULL values in ArcGIS Online by performing a field calculation. In this example, the attributes are populated in the Compile field by referencing field values from Type, SchoolID, District, and City (if the type is Public).

Procedure

1. In ArcGIS Online, navigate to Content > My Content.
2. Click the hosted feature layer. On the item details page, click the Data tab.

3. In the Table view, click the field header to populate and select Calculate. Alternatively, create a new field.

4. In the Calculate Field dialog box, click Arcade.

5. In the Arcade Calculator dialog box, specify the following Arcade expression in the Expression section.

var <variable1> = $feature.<fieldName1>
var <variable2> = $feature.<fieldName2>
var <variable3> = $feature.<fieldName3>
var <variable4> = $feature.<fieldName4>

if (<variable1> == '<fieldValue>') {
    if (!isEmpty(<variable4>) && !isEmpty(<variable3>)) {
        return <variable4> + ' - ' + <variable3> }
    else if (!isEmpty(<variable4>)) {
        return <variable4> }
    else if (!isEmpty(<variable3>)) {
        return <variable2> + ', ' + <variable3> }
else {
    return null }
}

6. Click Test to verify the expression.
7. Click OK.