I am trying to calculate a field based on whether another field is filled or null using python. I'm open to Arcade or SQL too. What I want to do is "If the Inspector field is filled, then calculate the Completed field as 'Flushed'. If the Inspector field is <Null>, then calculate the Completed field as 'Not Flushed'." Here is my code so far. The issue is that it is calculating everything as 'Flushed'.
def reclass(Inspector):
if(Inspector=="Alan Covington" or "Braxton Lawrence" or "Dave Besler"):
return "Flushed"
else:
return "Not Flushed"