topic Auto-increment with Attribute Rules in Geodatabase Questions https://community.esri.com/t5/geodatabase-questions/auto-increment-with-attribute-rules/m-p/852008#M5289 <HTML><HEAD></HEAD><BODY><P>Hi everyone,<BR />I'm experimenting with using of Attribute Rules on my Enterprise Geodatabase. I'd like to use this useful feature to auto-increment an ID code according to my specific scheme:<BR />I'd need that for each new entry in a table, the field with the id-code (a "long type" field) increments by 10 units with respect to the maximum value already existing in the table. I've tried this expression</P><BLOCKQUOTE class="jive_macro_quote jive-quote jive_text_macro"><P>Max ($ feature.name_of_the_field) + 10</P></BLOCKQUOTE><P>but without result. The RDBMS is Microsoft SQL Server.&nbsp;&nbsp;&nbsp;</P><P>Can someone help me?</P></BODY></HTML> Thu, 06 Jun 2019 11:06:05 GMT AlfonsoDodero 2019-06-06T11:06:05Z Auto-increment with Attribute Rules https://community.esri.com/t5/geodatabase-questions/auto-increment-with-attribute-rules/m-p/852008#M5289 <HTML><HEAD></HEAD><BODY><P>Hi everyone,<BR />I'm experimenting with using of Attribute Rules on my Enterprise Geodatabase. I'd like to use this useful feature to auto-increment an ID code according to my specific scheme:<BR />I'd need that for each new entry in a table, the field with the id-code (a "long type" field) increments by 10 units with respect to the maximum value already existing in the table. I've tried this expression</P><BLOCKQUOTE class="jive_macro_quote jive-quote jive_text_macro"><P>Max ($ feature.name_of_the_field) + 10</P></BLOCKQUOTE><P>but without result. The RDBMS is Microsoft SQL Server.&nbsp;&nbsp;&nbsp;</P><P>Can someone help me?</P></BODY></HTML> Thu, 06 Jun 2019 11:06:05 GMT https://community.esri.com/t5/geodatabase-questions/auto-increment-with-attribute-rules/m-p/852008#M5289 AlfonsoDodero 2019-06-06T11:06:05Z Re: Auto-increment with Attribute Rules https://community.esri.com/t5/geodatabase-questions/auto-increment-with-attribute-rules/m-p/852009#M5290 <HTML><HEAD></HEAD><BODY><P>Hi Alfonso,</P><P></P><P>I believe a related conversation is&nbsp;happening over at <A _jive_internal="true" href="https://community.esri.com/thread/103789">Auto-Increment Field within SDE</A>. There should be some information throughout that thread that you may find valuable to your workflow.</P><P></P><P>Colin</P></BODY></HTML> Thu, 06 Jun 2019 16:57:57 GMT https://community.esri.com/t5/geodatabase-questions/auto-increment-with-attribute-rules/m-p/852009#M5290 ColinWerle1 2019-06-06T16:57:57Z Re: Auto-increment with Attribute Rules https://community.esri.com/t5/geodatabase-questions/auto-increment-with-attribute-rules/m-p/852010#M5291 <HTML><HEAD></HEAD><BODY><P>Thanks Colin, so it's not possible to get the desired result through Attribute Rules and I have to act on the SQL Server, right?</P></BODY></HTML> Fri, 07 Jun 2019 07:28:31 GMT https://community.esri.com/t5/geodatabase-questions/auto-increment-with-attribute-rules/m-p/852010#M5291 AlfonsoDodero 2019-06-07T07:28:31Z