<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Calculated Expression is missing the ability to add sequence numbers in ArcGIS Field Maps Questions</title>
    <link>https://community.esri.com/t5/arcgis-field-maps-questions/calculated-expression-is-missing-the-ability-to/m-p/1252600#M5240</link>
    <description>&lt;P&gt;We have been trying to create a unique locality name when our field geologist are making a new feature point using the Calculated Expression in the ArcGIS Field Maps.&lt;/P&gt;&lt;P&gt;We have tried to combine the year of the feature creation with the user ID and and use either the OBJECTID or a sequence number from a created function in the geodatabase in&amp;nbsp; &lt;SPAN&gt;Concatenate Expression&lt;/SPAN&gt;, but neither of these are working properly.&lt;/P&gt;&lt;P&gt;The sequence in the gdb is not available and the OBJECTID is not committed to the concatenate expression before it is created in the gdb which requires the feature point the be updated afterwards.&lt;/P&gt;&lt;P&gt;Here are the two&amp;nbsp;calculated expressions:&lt;/P&gt;&lt;P&gt;//Create a unique concatenate Locality ID&lt;BR /&gt;var createuser = split(GetUser($layer).username,'_')&lt;BR /&gt;var createyear = Year(Now())&lt;BR /&gt;Concatenate(createyear, createuser[0], "Locality-",NextSequenceValue("LocalityNoSeq"))&lt;/P&gt;&lt;P&gt;or&lt;/P&gt;&lt;P&gt;//Create a unique concatenate Locality ID&lt;BR /&gt;var createuser = split(GetUser($layer).username,'_')&lt;BR /&gt;var createyear = Year(Now())&lt;/P&gt;&lt;P&gt;var oid = $feature.OBJECTID&lt;BR /&gt;Concatenate(createyear, createuser[0], "Locality-",oid))&lt;/P&gt;&lt;P&gt;Will there be an option to add sequence numbers to&amp;nbsp;a&amp;nbsp;Calculated Expression for the ArcGIS Field Maps in the future?&lt;/P&gt;</description>
    <pubDate>Fri, 03 Feb 2023 11:25:28 GMT</pubDate>
    <dc:creator>cbp-geus</dc:creator>
    <dc:date>2023-02-03T11:25:28Z</dc:date>
    <item>
      <title>Calculated Expression is missing the ability to add sequence numbers</title>
      <link>https://community.esri.com/t5/arcgis-field-maps-questions/calculated-expression-is-missing-the-ability-to/m-p/1252600#M5240</link>
      <description>&lt;P&gt;We have been trying to create a unique locality name when our field geologist are making a new feature point using the Calculated Expression in the ArcGIS Field Maps.&lt;/P&gt;&lt;P&gt;We have tried to combine the year of the feature creation with the user ID and and use either the OBJECTID or a sequence number from a created function in the geodatabase in&amp;nbsp; &lt;SPAN&gt;Concatenate Expression&lt;/SPAN&gt;, but neither of these are working properly.&lt;/P&gt;&lt;P&gt;The sequence in the gdb is not available and the OBJECTID is not committed to the concatenate expression before it is created in the gdb which requires the feature point the be updated afterwards.&lt;/P&gt;&lt;P&gt;Here are the two&amp;nbsp;calculated expressions:&lt;/P&gt;&lt;P&gt;//Create a unique concatenate Locality ID&lt;BR /&gt;var createuser = split(GetUser($layer).username,'_')&lt;BR /&gt;var createyear = Year(Now())&lt;BR /&gt;Concatenate(createyear, createuser[0], "Locality-",NextSequenceValue("LocalityNoSeq"))&lt;/P&gt;&lt;P&gt;or&lt;/P&gt;&lt;P&gt;//Create a unique concatenate Locality ID&lt;BR /&gt;var createuser = split(GetUser($layer).username,'_')&lt;BR /&gt;var createyear = Year(Now())&lt;/P&gt;&lt;P&gt;var oid = $feature.OBJECTID&lt;BR /&gt;Concatenate(createyear, createuser[0], "Locality-",oid))&lt;/P&gt;&lt;P&gt;Will there be an option to add sequence numbers to&amp;nbsp;a&amp;nbsp;Calculated Expression for the ArcGIS Field Maps in the future?&lt;/P&gt;</description>
      <pubDate>Fri, 03 Feb 2023 11:25:28 GMT</pubDate>
      <guid>https://community.esri.com/t5/arcgis-field-maps-questions/calculated-expression-is-missing-the-ability-to/m-p/1252600#M5240</guid>
      <dc:creator>cbp-geus</dc:creator>
      <dc:date>2023-02-03T11:25:28Z</dc:date>
    </item>
  </channel>
</rss>

