nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Create a unique field

HiteshJilka

Hello, I want to create a unique field which will have concatenated value of "OBJECTID" & "AREA_CODE" (user defined field). Using field calculator I can calculate the field for existing records but I want the same formula to be applied for new features getting created. We are using ArcGIS Desktop 10.3, Oracle : 12.1.0.2 and storage type: SDE.ST_GEOMETRY. Any help would be appreciated!

Najděte více příspěvků označených jako

Accepted answers

XanderBakker

Sounds like you want to implement a trigger in your database to fill the values of the field: Using Triggers

For now in ArcGIS you could use a script that will run periodically to fill the field with the concatenation. Expect later this year to be able to use "Calculation expressions" based on ArcGIS Arcade | ArcGIS for Developers which is being implemented for the new Esri Utility Network Pro, and which will allow you to define an expression to fill the content of a field dynamically.

All comments

XanderBakker

Sounds like you want to implement a trigger in your database to fill the values of the field: Using Triggers

XanderBakker

In addition to the options mentioned above, you might want to have a look at the field-trigger in the Attribute Assistant: All methods - Attribute Assistant | ArcGIS Solutions

HiteshJilka

Xander, thanks for sharing your knowledge on Attribute Assistant, it has great functions. Only drawback I feel is that it has to be installed on each arcgis desktop machine and users have control to turn on or off. Henceforth, I will work on database triggers... thanks!

Připojte se ke konverzaci

Přihlášení členové mohou přispívat, sledovat aktualizace a další. Jste tu noví? Zaregistrujte si bezplatný účet.

Rychlé odkazy

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.