<?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 What are the rules when setting default values for AGOL hosted feature layer fields? (Admin REST API) in ArcGIS Online Questions</title>
    <link>https://community.esri.com/t5/arcgis-online-questions/what-are-the-rules-when-setting-default-values-for/m-p/1700385#M68628</link>
    <description>&lt;P&gt;What are the rules when setting default values for AGOL hosted feature layer fields? (using the Admin REST API)&lt;/P&gt;&lt;P&gt;For example:&lt;/P&gt;&lt;OL&gt;&lt;LI&gt;Use SQL Server's SQL syntax/dialect.&lt;OL class="lia-list-style-type-lower-alpha"&gt;&lt;LI&gt;GIS Stack Exchange:&amp;nbsp;&lt;A href="https://gis.stackexchange.com/questions/500709/what-kind-of-database-does-arcgis-online-use-to-store-data" target="_blank" rel="noopener"&gt;What kind of database does ArcGIS Online use to store data?&lt;/A&gt;&lt;/LI&gt;&lt;/OL&gt;&lt;/LI&gt;&lt;LI&gt;GUID and number fields support expressions, but text fields don't.&lt;OL class="lia-list-style-type-lower-alpha"&gt;&lt;LI&gt;Idea:&amp;nbsp;&lt;A href="https://community.esri.com/t5/arcgis-online-ideas/allow-expressions-in-agol-string-field-gt-default/idi-p/1699876/highlight/true" target="_self"&gt;Allow expressions in AGOL string field &amp;gt; default value&lt;/A&gt;&lt;/LI&gt;&lt;/OL&gt;&lt;/LI&gt;&lt;LI&gt;Here's a useful error message I got when trying to use OBJECTID+1 as the default value for an integer field:&lt;BR /&gt;&lt;EM&gt;"Valid expressions are constants, constant expressions, and (in some contexts) variables. Column names are not permitted."&lt;/EM&gt; &lt;A href="https://share.google/aimode/tmot43yg8Iehd54KU" target="_self"&gt;Link&lt;/A&gt;&lt;/LI&gt;&lt;LI&gt;&lt;STRONG&gt;Are there any other known rules?&lt;/STRONG&gt; Or any other useful error messages that could be noted here?&lt;/LI&gt;&lt;/OL&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;(To Esri staff: Could the rules be added to the AGOL docs?)&lt;/P&gt;</description>
    <pubDate>Wed, 06 May 2026 16:05:34 GMT</pubDate>
    <dc:creator>Bud</dc:creator>
    <dc:date>2026-05-06T16:05:34Z</dc:date>
    <item>
      <title>What are the rules when setting default values for AGOL hosted feature layer fields? (Admin REST API)</title>
      <link>https://community.esri.com/t5/arcgis-online-questions/what-are-the-rules-when-setting-default-values-for/m-p/1700385#M68628</link>
      <description>&lt;P&gt;What are the rules when setting default values for AGOL hosted feature layer fields? (using the Admin REST API)&lt;/P&gt;&lt;P&gt;For example:&lt;/P&gt;&lt;OL&gt;&lt;LI&gt;Use SQL Server's SQL syntax/dialect.&lt;OL class="lia-list-style-type-lower-alpha"&gt;&lt;LI&gt;GIS Stack Exchange:&amp;nbsp;&lt;A href="https://gis.stackexchange.com/questions/500709/what-kind-of-database-does-arcgis-online-use-to-store-data" target="_blank" rel="noopener"&gt;What kind of database does ArcGIS Online use to store data?&lt;/A&gt;&lt;/LI&gt;&lt;/OL&gt;&lt;/LI&gt;&lt;LI&gt;GUID and number fields support expressions, but text fields don't.&lt;OL class="lia-list-style-type-lower-alpha"&gt;&lt;LI&gt;Idea:&amp;nbsp;&lt;A href="https://community.esri.com/t5/arcgis-online-ideas/allow-expressions-in-agol-string-field-gt-default/idi-p/1699876/highlight/true" target="_self"&gt;Allow expressions in AGOL string field &amp;gt; default value&lt;/A&gt;&lt;/LI&gt;&lt;/OL&gt;&lt;/LI&gt;&lt;LI&gt;Here's a useful error message I got when trying to use OBJECTID+1 as the default value for an integer field:&lt;BR /&gt;&lt;EM&gt;"Valid expressions are constants, constant expressions, and (in some contexts) variables. Column names are not permitted."&lt;/EM&gt; &lt;A href="https://share.google/aimode/tmot43yg8Iehd54KU" target="_self"&gt;Link&lt;/A&gt;&lt;/LI&gt;&lt;LI&gt;&lt;STRONG&gt;Are there any other known rules?&lt;/STRONG&gt; Or any other useful error messages that could be noted here?&lt;/LI&gt;&lt;/OL&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;(To Esri staff: Could the rules be added to the AGOL docs?)&lt;/P&gt;</description>
      <pubDate>Wed, 06 May 2026 16:05:34 GMT</pubDate>
      <guid>https://community.esri.com/t5/arcgis-online-questions/what-are-the-rules-when-setting-default-values-for/m-p/1700385#M68628</guid>
      <dc:creator>Bud</dc:creator>
      <dc:date>2026-05-06T16:05:34Z</dc:date>
    </item>
  </channel>
</rss>

