Hey folks,
Stumbled into a little mess — hoping I’m not the first. I’ve got a feature layer in ArcGIS Online related to several tables using the assetid field. Looked fine on the surface… until I started pushing data into the related tables via script and realized the assetid in the main layer is an integer, while in the related tables, it’s a string.
So the relationship it is not recognized. The problem is I’ve already put a lot of work into this setup: web maps, pop-ups, symbology, editing forms and templates, plus Survey123 forms that launch depending on asset type with text URL in the pop up. The whole system’s live and being used by operational teams during the day, so taking it apart and rebuilding it just to fix this mismatch would be a pretty big (and painful) job. We’re talking 1–2 days minimum and probably after hours if I don't republish everything as a second version.
So, before I dive into all that: Is there any way to point the relationship to a new field in the main layer — for example assetid_string field that matches the related tables’ type? Or even a way to tweak the definition query to make it work without tearing everything down?
I’d love to hear if anyone’s found a workaround that doesn’t involve blowing up the whole config, last time i had this headache i tried to find answer but i couldn't, and it was not this bad in terms of config.
Thanks in advance — really appreciate any advice!
