SOLICITAR DECLARACIONES ARCADE PARA EVITAR LA DUPLICACIÓN DEL NÚMERO DE MEDIDOR ELÉCTRICO EN EL SERVICIO LV

Question

Hemos añadido un campo llamado Número de medidor (tipo de dato cadena/caracter) en el Servicio LV y el Servicio MV. Hemos recopilado datos; hemos entregado el trabajo al cliente. Y queremos evitar la duplicación cuando se capture información incremental desde el sitio. Necesito que alguien proporcione una declaración arcade en Field map app o ArcGIS pro o Portal for ArcGIS que impida la duplicación del número de medidor.<\/P>

AarynPersson · Answer

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

RomuldKiobya · Answer

Is working,thanks

GIS_Spellblade · Answer

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