Arcade logic to populate a field if anouther field has any value

[AndrewHankinson]

Morning, 

I was wondering if there is wildcard in arcade so that I can write a simple expression that would populate a field if another field was populated with anything at all. 

I have a field survey data which used to be collected on a 100x100m grid and has since changed to a 50x50m grid. What I did to calculate the number of hectares completed to display on a HUB was simply count the number of survey points.

This now won't work as there a 4 survey points per hectare surveyed. 

A species list is taken on a 100x100m grid but not on the 50x50m, so I was hoping to be able to select the features that had any value in the species list field and then populate anouther field with Y then I can count this in the HUB. 

I've had a look at the logic functions here https://developers.arcgis.com/arcade/function-reference/logical_functions/ but can't see anything that suggests a use of a wildcard. 

[RPGIS · Accepted solution]

Hi @AndrewHankinson,

So the easiest way to go about this is to use the IsEmpty() function to see if there are any values in the field. This would check to see if a field has no values.

I don't know if you are asking if the entire field has some value or if it is per hectare but if you want to know if which ones are empty, or vice versa, then you can use the filter function to write a short sql query to filter by.

Ex: '<fieldname> IS NULL' or '<fieldname> IS NOT NULL'

If you want to go further and filter by the grid then you simply add AND plus the other field and value to filter by.