topic Re: Arcade Generate new Unique ID for new record but not updating existing UID in ArcGIS Online Questions

Arcade Generate new Unique ID for new record but not updating existing UID

DominicRobergeIADOT — Tue, 22 Nov 2022 20:10:41 GMT

Hello

I have the following Arcade code to create a new Unique ID on a feature layer (hosted on ArcGIS Server). It's working fine for a NEW record, but if I try to select an existing record, it will update the UID field with the next available number.

How can I avoid to overwrite an existing value? Thanks for any help you could provide.

var fs=FeatureSetByName($datastore,'dr_testPts',['FUID'],false); var cCurrentFUID = $feature.FUID var fFilter = Filter(fs, 'FUID IS NOT NULL'); var fMax = 0 var tMax = 0 for (var k in fFilter){ fMax = Max(Right(k.FUID, Count(k.FUID)-3)) tMax = When(fMax>tMax,fMax, tMax) } tMax +=1 var vNewFUID = "EOC" + text(tMax, "00000") if (IsEmpty(cCurrentFUID)){ return vNewFUID } else { return cCurrentFUID }

Re: Arcade Generate new Unique ID for new record but not updating existing UID

JohannesLindner — Wed, 23 Nov 2022 08:37:11 GMT

You have to check if the field is already filled at the start. If yes, just return that value.

Also, your rule can be simplified a bit:

// if this feature already has a fuid, return that if(!IsEmpty($feature.FUID)) { return $feature.FUID } // get the feature with the greatest fuid in the featureset var fuid_features = Filter($featureset, "FUID IS NOT NULL") var max_fuid_feature = First(OrderBy(fuid_features, "FUID DESC")) // for an empty featureset, this will be null, so return the first fuid if(max_fuid_feature == null) { return "EOC00001" } // calculate and return the next fuid var max_fuid = max_fuid_feature.FUID var next_fuid_number = Number(Replace(max_fuid, "EOC", "")) + 1 return "EOC" + Text(next_fuid_number, "00000")

Re: Arcade Generate new Unique ID for new record but not updating existing UID

DominicRobergeIADOT — Wed, 23 Nov 2022 15:24:07 GMT

Hi Johannes

thanks for helping me on this. I modified my expression accordingly and when I tried it in the web map.... nothing.... Then I decided to try it in the Field Maps app and it was working just fine (new record and updating existing record). I then tried to create and Experience Builder app to see how it would behave... same as web map, Empty FUID field.

Any idea why it's not working properly in the web map? For this project, my users will enter/modify data either through a web map or experience builder app.

Thanks!

Re: Arcade Generate new Unique ID for new record but not updating existing UID

JohannesLindner — Thu, 24 Nov 2022 07:50:26 GMT

This looks as if you have not actually created the feature yet. The attribute rule doesn't trigger when you put the point in, only when you finish the feature creation.

In the feature creation window: The FUID isn't there, because the rule didn't trigger yet.

After I clicked on "Hinzufügen" ("Add"): Now the rule did trigger, and the FUID is calculated.

Re: Arcade Generate new Unique ID for new record but not updating existing UID

DominicRobergeIADOT — Thu, 24 Nov 2022 14:08:55 GMT

Thanks for the info. However when the expressio is enabled, I can't click the Create Feature button.

when I test the expression it seems to be working

if I disable the expresssion, then I can Create feature

What am I missing? I also tested the process on a different HFL and different web map and same result.

Re: Arcade Generate new Unique ID for new record but not updating existing UID

JohannesLindner — Thu, 24 Nov 2022 14:23:45 GMT

I'm sorry to say that I have no idea what could be the case.

Maybe @HusseinNasser2 can help?

Re: Arcade Generate new Unique ID for new record but not updating existing UID

DominicRobergeIADOT — Tue, 13 Dec 2022 20:22:17 GMT

hello everyone

sorry it took so long, I had open a ticket with ESRI Support regarding this issue and they finally created a BUG as they were able to replicate the issue:

Bug Number: BUG-000154427
Synopsis: The Arcade expression configured in a form within a web map does not get honored in Map Viewer

Any ideas how I could generate a unique ID automatically?

Thanks!

Re: Arcade Generate new Unique ID for new record but not updating existing UID

DonSjoboen — Wed, 05 Apr 2023 19:33:40 GMT

@DominicRobergeIADOT any updates on whether the bug was fixed? I'm having the same issue in the form in the new map viewer.

Re: Arcade Generate new Unique ID for new record but not updating existing UID

DominicRobergeIADOT — Wed, 05 Apr 2023 19:40:21 GMT

this is all I got

Looks like is under review

Re: Arcade Generate new Unique ID for new record but not updating existing UID

VanessaSimps — Mon, 10 Apr 2023 18:08:31 GMT

We are seeing a similar issue in one of our apps/maps. is there a way to +1 to your bug?!

Re: Arcade Generate new Unique ID for new record but not updating existing UID

DominicRobergeIADOT — Wed, 12 Apr 2023 19:09:40 GMT

I am not sure... I don't see a link to "share" that bug and when I search for that specific BUG on ESRI Support site, I get nothing....

Sorry. Perhaps you will have to open a ticket with support, mention this BUG number and that will help promote the issue? 🤞

Re: Arcade Generate new Unique ID for new record but not updating existing UID

DominicRobergeIADOT — Thu, 04 May 2023 20:40:10 GMT

I believe this issue has been resolved with the latest update (https://www.esri.com/arcgis-blog/products/arcgis-online/mapping/go-beyond-the-smart-editor-using-smart-forms/)

below is my revised code and not it's working as expected

// Define the edit context so the value is only calculated when the feature is created if ($editContext.editType == "INSERT") { // Lookup the value for the last created feature var last_feature = First(OrderBy($layer, 'FUID DESC')); // If the last value was empty write 1, otherwise add 1 to the value // calculate and return the next fuid var max_fuid = last_feature.FUID var next_fuid_number = Number(Replace(max_fuid, "EOC", "")) + 1 return "EOC" + Text(next_fuid_number, "00000") } else { // When the feature is updated, return the existing value in this field // and do not calculate a new value $feature.FUID }

Re: Arcade Generate new Unique ID for new record but not updating existing UID

Laura — Fri, 16 Feb 2024 19:26:01 GMT

I tried to set that code and edit but it won't let me create a new feature still either.

Re: Arcade Generate new Unique ID for new record but not updating existing UID

BRENNEJM — Wed, 14 Jan 2026 11:13:46 GMT

Any update on this bug? It's a bit concerning that Esri hasn't officially published this bug (or I just haven't been able to find it anywhere) and that they don't seem to be prioritizing this. I've tried the $editContext.editType version that someone else posted in this thread and that doesn't work either.

Re: Arcade Generate new Unique ID for new record but not updating existing UID

BRENNEJM — Wed, 14 Jan 2026 11:13:29 GMT

It appears that Arcade is working as expected now (i.e. only creating the new Unique ID if that field is blank). Up until now we've been utilizing two maps (one for adding features and one for updating them) and it would be great to only need one map. Does anyone know if Esri acknowledged this as a bug and fixed it? If not, it seems like we'll need to stay with two maps just in case Arcade stops working as expected again.