Arcade Find Function not working like I wish it would

GISUser74305830 — Mon, 02 Oct 2023 22:29:41 GMT

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:

Re: Arcade Find Function not working like I wish it would

GISUser74305830 — Tue, 10 Oct 2023 14:14:49 GMT