My favorite Attribute Assistant project is this: I loaded a table of 4,000 non-georeferenced engineering plans into a point file with a pretend x,y. I have editors identify a record one at a time to open the hyperlink of the plan, find its location in GIS, use the Advanced Editing Replace Geometry tool and click on the map to georeference it. Then, upon updated geometry rules it runs many methods to insert information into the record's attribute like watershed, parcel id, subdivision and other local jurisdictional information on the site our engineers like to lookup plans by. My only issue is that I cannot use expression value method with intersecting feature value method. I am not sure it anyone has ideas... I want to only run the intersecting feature method if that field is null? How do I do that? As the field may have already been populated (I inherited inconsistently edited data) or a point may be placed on a parcel where the information in the underlying parcel may be missing and thus my possibly good data will be overwritten to bad/empty data.
My favorite Attribute Assitant rule is this:
I have stormwater assets that have the name of the plan they are on in. To automate copying of the plan hyperlink in, example for a pipe, it checks that the plan id field is formatted correctly, 2 letters, then some numbers, and if that is the case it populates. However, the expression was not the simplest. Some plans were entered wrong without the letters or are from another jurisdiction thus we do not have values for the plan id. I tested if the plan id was null, if it was true it leaves the field null, if false it tests if the first two digits are numeric (there is no is alpha test) and if true it leaves the field null, if false it populates the hyperlink.
IIF(isNull([PLAN_ID]),NULL,IIF(isNumeric(Left([PLAN_ID],2)),NULL, "\\server\planfolder\publicworksfolder\" + Mid([PLAN_ID],1,2) + "\" + Mid([PLAN_ID],3,10) + ".pdf"))