Latest Contributions by TL2

I figure they must be some soft of trigger or sp but I cant find them. Thanks. ... View more

This script adds sequential values based on the last value.  My problem is I have to have at least one value already in place for First() to work, else it errors out. Also when I try to add a Count() I get Array type expected error. How do you properly code for:  AKA how do you check for empty table and if empty give it a value? if count == 0 {return something} else do this else do that ‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ This code below works great as long as there one record in the table with an assignednum.  If not it errors on line 3.  I tried to code with IIf & IsNaN/IsEmpty with no avail.  (Attribute Calculation Rule on Insert) Thanks. Xander Bakker‌ var sql = Concatenate("assignednum like", "'%", Year(Now()), "%'") var fs = first(OrderBy(Filter(FeatureSetbyName($datastore, table), sql), 'assignednum DESC')) var lastnum = Number(mid(fs.assignednum,11,4),'0000' ) var int = ++lastnum if (number(mid(fs.assignednum,6,4)) == Year(Now())) { return Concatenate("SUDOE ",Year(Now()),"-",text(int,'0000'),"RCI") } else if (number(mid(fs.assignednum,6,4)) != Year(Now())) { return Concatenate("SUDOE ",Year(Now()),"-0001","RCI") } ‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ ... View more

While Null now works in arcade field calculations on Pro 2.5, it still does not work in Attribute Rules while using the edit keyword and update. Attribute rule dictionary keywords—Geodatabases | Documentation  return { "result": $feature.assetid, "edit": [{ "className": "electricdistributionassembly", "updates": [{ "objectID": feature_objectid, "associationType": Null }] }] }‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ The above code will not work.  It returns a what I am guessing is an empty field.  It does not work on strings or dates. I need a simple attribute rule that updates a field to "Something" on insert/update and to <Null> on insert/update on "Something Else" My code works except that there is no way to return Null using Attribute Rules & Arcade.  You can return a string, date or 0 (in the case of dates 12/30/1899). I have set to Null and tried to set it to a field that is Null. ... View more