topic Re: Create Street Name Validation in Attribute Rules Questions

Create Street Name Validation

SarahWright — Thu, 07 May 2026 14:32:26 GMT

I am trying to create an attribute rule that validates if a street name is in a master street table when being created. Here is the code I have so far, I am not sure where my syntax is wrong.

The expression needs to be case in-sensitive, the source data in the master table is mixed casing.

Thanks in advance!

// 1. Access the reference table by name
// This must match the name of the layer in your database/service
var masterStreetName = Upper(FeatureSetByName($datastore, 'vwAddresserData_v2', ["FULLADDRESS"], false));

// 2. Get the address being entered/edited
var addresserStreetName = Upper($feature.FullStreetName);

// 3. Handle empty values (optional: allow or block nulls)
if (IsEmpty(addresserStreetName)) { return true; }

// 4. Filter the other table for matching addresses
// Use Upper() to ensure the comparison isn't case-sensitive
var filterSQL = "FULLADDRESS = '" + addresserStreetName + "'";
var matches = Filter(masterStreetName, '@filterSQL');

// 5. Logic: Return true if a match is found, false (with message) if not
if (Count(matches) > 0) {
return true;
} else {
return {
"errorMessage": "The address " + addresserStreetName + " does not exist in the master Street table."
};
}

Re: Create Street Name Validation

MikeMillerGIS — Thu, 07 May 2026 15:15:54 GMT

Try this. Also, when posting code, please use a code samples(Javascript works good for arcade). Makes it much easier to read

if (IsEmpty($feature.FullStreetName)) { return true; } var addresserStreetName = Upper($feature.FullStreetName); var masterStreetName = FeatureSetByName($datastore, 'vwAddresserData_v2', ["FULLADDRESS"], false); var matches = Filter(masterStreetName, "UPPER(FULLADDRESS) = @addresserStreetName"); if (Count(matches) > 0) { return true; } return {"errorMessage": "The address " + addresserStreetName + " does not exist in the master Street table."};

Re: Create Street Name Validation

SarahWright — Thu, 07 May 2026 16:45:03 GMT

Thanks for the suggestion, I am now getting the below error.

Edit operation failed.
Failed to evaluate Arcade expression. [
Rule name: Invalid Street Name,
Triggering event: Update,
Class name: L0addresserData,
GlobalID: {1986C779-DA03-40F1-9FF9-60E436BF5926},
Error number: 1001,
Error message: Street Name is not in the master Street Name table.,
Arcade error: Table not found {F373DE5C-427D-466E-92A5-5988CFD4D5CA},
Script line: 7]

Re: Create Street Name Validation

MikeMillerGIS — Thu, 07 May 2026 16:52:41 GMT

I do not know, I do not have access to the data so very hard to tell. Can you verify the name of the master street name table? Does you street have a street name of "Street Name"

Re: Create Street Name Validation

SarahWright — Thu, 07 May 2026 17:07:14 GMT

This part of the error is returned from the error statement I created for the error number.

Error number: 1001,
Error message: Street Name is not in the master Street Name table

It should not be looking for street name. That is not in the code.

It is very hard to tell. Do you know of a better way to troubleshoot the arcade expression? I have tried so many code variations at this point.

Re: Create Street Name Validation

MikeMillerGIS — Thu, 07 May 2026 17:23:13 GMT

Do you happen to have any other attribute rules? The error message does not match the code above.

Re: Create Street Name Validation

SarahWright — Thu, 07 May 2026 17:53:05 GMT

Here is the configuration to my rule. There are no other rules with this error message.

Re: Create Street Name Validation

SarahWright — Thu, 07 May 2026 17:54:16 GMT

The table name is slightly different in my picture. Another variation I tried to see if it would connect to another table.

Re: Create Street Name Validation

MikeMillerGIS — Thu, 07 May 2026 18:02:36 GMT

Ok, That helps. The error is that the FeatureSetByName cannot find table. Can you move it all to a file geodatabase for testing to ensure the rule works? That would help eliminate variables with enterprise databases and permissions.

Re: Create Street Name Validation

SarahWright — Thu, 07 May 2026 19:04:12 GMT

Hi, thanks for your help on this. Moving the data into GDB and editing returned the expected results. My goal is to be able to use this in a editing web application. I am not sure what I was doing wrong. Any insight on getting this into our web application is greatly appreciated.

I am working on this in our dev ArcGIS Enterprise environment 11.5. Using enterprise gdb version 11.5 and ArcGIS pro 3.5.

Thanks

Re: Create Street Name Validation

SarahWright — Thu, 07 May 2026 19:04:31 GMT

Tool that worked

Re: Create Street Name Validation

MikeMillerGIS — Thu, 07 May 2026 19:09:07 GMT

How was the master street name table created? Is it registered with the GDB? Who is the owner of the table?

Re: Create Street Name Validation

SarahWright — Thu, 07 May 2026 19:14:10 GMT

The master street table is a view. It is registered with the GDB and same owner as the addressData layer. I tried loading it as a standalone table in the GDB and sharing with the other layer in the service but that also did not work.

Re: Create Street Name Validation

MikeMillerGIS — Thu, 07 May 2026 19:18:43 GMT

The table does not have to be in the service. I wonder if it has to deal with you do not have Exclude from Client Application checked. Try checking that so the rule is only run the database.

Re: Create Street Name Validation

SarahWright — Thu, 07 May 2026 19:44:26 GMT

That worked! Thank you! I will try adding to a web application and see how that goes.

Thank you so much for you prompt replies I really appreciate it.