Arcade Find Function not working like I wish it would

Question

Situation:

* I have an AGO point layer of assets.
* User adds new assets and edits existing assets
* User only edits the asset category field (DTP_Cat2)
* Arcade script auto-calcs a Counter field (DTP_Counter) to uniquely number each asset by category
* Arcade script auto-calcs DTP_Asset_ID = DTP_Cat2 + "-" + DTP_Counter

Objective:

* SCENARIO #1: If user adds a new feature and selects a category, DTP_Counter gets the next sequential number and calcs in DTP_Asset_ID. This is done and works fine.
* SCENARIO #2: If user edits an existing feature but doesn't change the category, the script doesn't modify the Asset ID.
* SCENARIO #3: If user edits an existing feature but does change the category, the script gets the next sequential number for that category and calcs in DTP_Asset_ID.

Issue:

* Scenarios 2 and 3 are not working for me. The script just doesn't want to fire off. I seem to have pinpointed the issue to the Find function. I'm trying to use the Find function to say: if "STP-CO" is in "STP-CO-14" (it is), then don't change the ID; however, if "STP-AR" is not in "STP-CO-14" (it's not), then change the ID. I don't know what I'm doing wrong but the Find function is not working for me.

Data structure:

DTP_CounterDTP_Cat2DTP_Asset_ID14STP-COSTP-CO-1414STP-ARSTP-AR-1415STP-COSTP-CO-15

@jcarlson

Updating Asset IDs.txt

cfox.jpg

GISUser74305830 · Answer

@XanderBakker  or @jcarlson  - any ideas?