For some reason my simple if statement doesn't work, but almost does. If I change the order of criteria it also functions strange.
I want the code to work as such: If code contains "SNOWBIRD" return SnowBird, if code contains "REFUSE" return Unit, otherwise return Monday.
In the picture below, if code equals "SNOWBIRD" it returns correctly, but if code equals "SNOWBIRD/RENTAL" its returning "Monday" and everything else is returned "Unit"
If I change the order of the if statements it gives just as confusing results.
Solved! Go to Solution.
Oh my goodness, I figured it out. I had the input parameters backwards for the find function. Ugh.
You've got your inputs mixed up. should be
find('string you're searching for', feature.dumpster_code)
this explains why it returns SnowBird for only exact matches and no matches for refuse at all.
Oh my goodness, I figured it out. I had the input parameters backwards for the find function. Ugh.
You've got your inputs mixed up. should be
find('string you're searching for', feature.dumpster_code)
this explains why it returns SnowBird for only exact matches and no matches for refuse at all.