Attribute rules on update field: "The field type is not supported by arcade script."

Question

I am trying to apply an attribute rule that would update the parent table of two related tables when the child table is edited. In this case I only want to write the number of related records into the parent table but I am getting this error:

Initiall the field I am trying to write to was of the type short, now I created fields in long, float and double format but none of them are accepted. How can I find out which field type would be supported for my script?

DrNicsi · Answer

Only returning cnt in the popup still gives the correct value. No idea why it would return value+1 when updating the parent table 😞

DrNicsi · Answer

Update:

var select="upi='"+$feature["upi"] +"'";
var fs = FeatureSetbyName($datastore, "bpmis.sde.bpmis_data");
var parent=FeatureSetbyName($datastore, "bpmis.sde.bpmis_distinct",["globalid"],false);
var upi_filtered=Filter(fs,select);
var parent_filtered=Filter(parent,select);
for (var id in parent_filtered){
   var parentid=id.globalid;
}
var cnt=Count(upi_filtered)

if (cnt>0){
return {
    "edit": [
         {
          "className":"bpmis.sde.bpmis_distinct",
          "updates":[
              {
              "globalid":  parentid,
              "attributes": {
                  "permit_cnt": cnt
                  }
              }
            ]
         }  
       ]
}
}

I am getting closer... At least I don't get an error message any longer but the number is always +1 to what it should be.

kenbuja · Answer

I'm not an expert on attribute rules, but from the documentation, it looks like you're missing the required object ID or global ID parameter in the updates object