topic Re: ASK FOR ARCADE STATEMENTS TO AVOID DUPLICATION OF ELECTRIC METER NUMBER IN LV SERVICE in Electric Questions

ASK FOR ARCADE STATEMENTS TO AVOID DUPLICATION OF ELECTRIC METER NUMBER IN LV SERVICE

RomuldKiobya — Thu, 22 Feb 2024 16:04:45 GMT

We have added field called Meter number (data type string/char) at LV Service and MV Service. we have collected data; we have handover job to client. and we want to avoid duplication when incremental data from the site will be captured. I need either someone to give arcade statement on Field map app or ArcGIS pro or Portal for ArcGIS that will disallow duplication of meter number.

Re: ASK FOR ARCADE STATEMENTS TO AVOID DUPLICATION OF ELECTRIC METER NUMBER IN LV SERVICE

GIS_Spellblade — Thu, 22 Feb 2024 19:13:59 GMT

You could use some logic similar to this:

var search_duplicate = $feature.FACILITYID var features = FEATURESETBYNAME($datastore, "Featureclass Name Here") var sqlExpression = "A_FIELD_NAME_HERE = @search_duplicate" var result = FILTER(features, sqlExpression) WHEN( COUNT(result) > 1, `Duplicate Value, choose another ID`, $feature.FACILITYID )

Or you could use a sequence:

https://support.esri.com/en-us/knowledge-base/how-to-add-auto-sequential-values-using-attribute-rules-000024533

Also, this post has a great solution to what you're asking for:

https://community.esri.com/t5/arcgis-field-maps-questions/arcgis-fieldmaps-form-calculate-expression-to/m-p/1159183

Re: ASK FOR ARCADE STATEMENTS TO AVOID DUPLICATION OF ELECTRIC METER NUMBER IN LV SERVICE

RomuldKiobya — Thu, 04 Jul 2024 09:10:14 GMT

Is working,thanks

Re: ASK FOR ARCADE STATEMENTS TO AVOID DUPLICATION OF ELECTRIC METER NUMBER IN LV SERVICE

AarynPersson — Tue, 10 Dec 2024 22:49:57 GMT

Here are some additional resources about configuring your data with Arcade. Check out this session from IMGIS 2024. We go over topics like duplications of attributes, barcode scan to attribution, text and pop up formatting in ArcGIS Dashboards and form calculations. https://imgis2024.esri.com/flow/esri/24imgis/eventportal/page/detailed-agenda/session/1724086224010001T6Fi