idea Allow Default Value to be removed or changed in Hosted Feature Service Field View in ArcGIS Online Ideas

Allow Default Value to be removed or changed in Hosted Feature Service Field View

Anonymous User — Fri, 01 Nov 2019 17:09:32 GMT

At this time, if you set up a Default Value for a field upon creation of a Hosted Feature Service, you have to delete and re-create the field to remove the default value.

Please allow the functionality to re-configure the Default Value of a field post hoc.

Re: Allow Default Value to be removed or changed in Hosted Feature Service Field View

RichSikon — Tue, 09 Feb 2021 21:20:22 GMT

I agree. The default field value should be editable.

I'd classify this as a bug and not a feature enhancement.

Is there any workaround that can be used now?

Re: Allow Default Value to be removed or changed in Hosted Feature Service Field View

BrittanyBurson — Fri, 26 Feb 2021 20:35:18 GMT

Hi @RichSikon were you able to find a workaround?

Re: Allow Default Value to be removed or changed in Hosted Feature Service Field View

RichSiko — Mon, 01 Mar 2021 13:27:27 GMT

Hi @BrittanyBurson my Case #02736976 has ben classified as a defect and is attached to the enhancement ENH-000137389

The workaround is to access the REST interface as the admin. I haven't tried this yet but examining the json code I can see that there are multiple places where the default appears and it would need to be changed everywhere it appears.

Here is the workaround I was given:

This capability is not present in ArcGIS Online and to an extent, in Desktop Application. Unless we use a tool (Alter Field/Assign Default to Field)
In ArcGIS Online to achieve this, alternatively, we can use REST as outlined in the URL below:

How to Update Your Hosted Feature Service Schemas in ArcGIS Online

In case you are unable to update a nullable property, you can refer to the below URL:

Problem: Unable to modify the nullable property of a hosted feature service from the REST endpoint

Re: Allow Default Value to be removed or changed in Hosted Feature Service Field View

Trippetoe — Thu, 21 Oct 2021 22:08:42 GMT

As a follow-up on the proposed work arounds, the approach to use the REST admin endpoint did not work for me.

When i added a new field to my hosted feature layer, I set the field as nullable with a default value of 1. Unfortunately, there is a bug in Arcade so that Arcade uses the default value when trying to set the field value to null (agreed that this is an edge case, but its the situation we are in with adding a new field to a many-year-old data set). Anyway, i tried to use the REST Admin endpoint to Update the Definition to remove the default value. Despite the REST response reporting 'success', implying to me that the change to default value worked, the default value remained unchanged.

My 'workaround' at this point is to add another new field, DO NOT set a default value, and then calc the values for the new field.

Re: Allow Default Value to be removed or changed in Hosted Feature Service Field View

MiltonSolano — Mon, 20 Jun 2022 22:35:06 GMT

Definitely a necessary functionality for published layers. I tried the REST Admin endpoint workaround and doesn't work. ArcGIS Pro already have this tool: Assign Default to Field but it doesn't work with hosted feature layers.

It's incredible the amount of work one have to do to fix this behavior:

1. Arcade is showing the default value on records with null value

2. We have to create another field, do a field calculation, delete the previous field.

3. Reorder the new field on the popup window and FieldMaps form. Create calculated field from the new added field.

4. Edit labels on the map to show the new created field.

All of this for one single wrong default value. Please, implement this on the next AGOL release.

Re: Allow Default Value to be removed or changed in Hosted Feature Service Field View

LyonMNGIS — Mon, 13 Feb 2023 21:12:38 GMT

Has there been any luck on this enhancement request? The directions to access the rest endpoint gives me an invalid token error.

Re: Allow Default Value to be removed or changed in Hosted Feature Service Field View

RichSiko — Tue, 14 Feb 2023 13:25:21 GMT

The current status of enhancement request ENH-000137389 is "In Product Plan".

This is defined as an enhancement planned in a near-term release.

Hopefully that means months and not years.

Re: Allow Default Value to be removed or changed in Hosted Feature Service Field View

Nadia33 — Tue, 21 Feb 2023 22:00:57 GMT

I also want to change a default value on a Hosted Feature Service Field easly and waiting for a near-term release !

However, I changed the value on the REST interface : it works but if the field is empty before.. and the default value on the AOL interface is still the previous one..

Re: Allow Default Value to be removed or changed in Hosted Feature Service Field View

TracySArchibald — Fri, 12 May 2023 06:09:30 GMT

Yes please, make this happen. I shouldn't need to hit the rest interface to change a value.

Re: Allow Default Value to be removed or changed in Hosted Feature Service Field View

Louis-PhilippeRodier — Fri, 02 Jun 2023 14:38:29 GMT

There is a workaround, if you go in ArcGIS Online, in Map Classic and Edit the data you need, you can access the Manage New Feature menu where you can access the properties of every item. There, you can add a default value or change it.

I Just don't know how to force the date into a today() formula...

Re: Allow Default Value to be removed or changed in Hosted Feature Service Field View

tiztrain — Thu, 03 Aug 2023 13:07:07 GMT

@Louis-PhilippeRodier you're a legend! It worked

Re: Allow Default Value to be removed or changed in Hosted Feature Service Field View

Louis-PhilippeRodier — Tue, 23 Jan 2024 23:38:56 GMT

@tiztrain, I know! It's nice when things work out!

Re: Allow Default Value to be removed or changed in Hosted Feature Service Field View

ColinKelly97 — Wed, 09 Aug 2023 19:58:42 GMT

@Louis-PhilippeRodier How did you achieve this in map viewer classic? I want to make NC the default value of this layer called scan layer, specifically the Status field of the layer. I followed your instruction via map viewer classic and went into the properties but do not see an option to assign NC as a default value.

Re: Allow Default Value to be removed or changed in Hosted Feature Service Field View

JosephAlberts — Thu, 21 Sep 2023 16:09:29 GMT

The easiest way I've found to update the default value (or coded domains) is using the arcgis Python API. Something like this, exported from an ArcGIS hosted notebook (split into cells as you see fit).

This is a generic/pared-down example where I was setting the default value for a specific field with a string-type coded value in a table. You could do this for one or more fields in a layer too.

Note on coded domains: If you created the domain ("list") through ArcGIS Online, the name will have a GUID in it. To find the full name, take a look at the JSON for the service URL of the layer/table you're using.

Edit: I forgot to account for updating the template as well. This addition will also loop through any views of the hosted feature layer and update their templates for the field.

Edit 2: Corrected missing update_dict declaration. Thanks @AndyFairbairn!

# Import required libraries from arcgis.gis import * from arcgis.features import FeatureLayer, FeatureLayerCollection from IPython.display import display # Set GIS and display current user gis = GIS("home") user = gis.users.me print("Current User: \n") user ## Get Data Collection Layer item_collection_layer = gis.content.get('your_item_ID') flc_data_collection = FeatureLayerCollection(item_collection_layer.url, gis) flc_data_collection ### Review layers print('Layers: \n') for index_val, lyr in enumerate(flc_data_collection.layers): name = lyr.properties.name print(index_val, '-', name) ### Review tables print('Tables: \n') for index_val, tbl in enumerate(flc_data_collection.tables): print(index_val, '-', tbl.properties.name) ### Assign table of interest tbl_to_update = flc_data_collection.tables[0] print('tbl_to_update set to:', tbl_to_update.properties.name) ## Field definition(s) for updating ## Make sure your type and other parameters are correct for your field. field_to_update = { "name" : "field_name", "type" : "esriFieldTypeString", "alias" : "Field Alias", "sqlType" : "sqlTypeOther", "length" : 256, "nullable" : True, "editable" : True, "domain" : { "type" : "codedValue", "name" : "domain_name_from_json_view_of_table", "codedValues" : [ { "name" : "Coded Value 1", "code" : "coded_value_1" }, { "name" : "Coded Value 2", "code" : "coded_value_2" } ] }, "defaultValue" : "coded_value_1" } ## Update field(s) ## If you need to update multiple fields at once, define them all above and pass them all into the list for `update_dict` update_dict = {"fields": [field_to_update]} tbl_to_update.manager.update_definition(update_dict) ## Template definition(s) for updating template_tbl_to_update = { "name" : "Table Name", "description" : "", "drawingTool" : "esriFeatureEditToolNone", "prototype" : { "attributes" : { "field_name" : "coded_value_1", "notes" : None } } } ## Update template(s) source_item = item_collection_layer view_items = source_item.related_items(rel_type="Service2Service", direction="forward") list_tbl_to_update = [tbl_to_update] for view_item in view_items: list_tbl_to_update.append(FeatureLayerCollection(view_item.url, gis).tables[0]) print('Tables to update:') for tbl in list_tbl_to_update: print(tbl, '(' + tbl.properties.name + ')') ### Update update_dict = {"templates": [template_tbl_to_update]} for tbl in tbl_to_update: update = tbl.manager.update_definition(update_dict) display(tbl) print('Status:', update) print('===' * 10)

Re: Allow Default Value to be removed or changed in Hosted Feature Service Field View

AndyFairbairn — Thu, 21 Sep 2023 05:51:48 GMT

Hi Joseph, thanks for this approach it's a really useful suggestion for me.

I think you might be missing a line after your template dictionary? Something like:

update_dict = {"templates": [template_tbl_to_update]}

Or something like

## Template definition(s) for updating template_to_update = { "name" : "Template Name", "description" : "", "drawingTool" : "esriFeatureEditToolNone", "prototype" : { "attributes" : { "field_name" : "coded_value_1", "notes" : None } } } update_dict = {"templates": [template_to_update]}

Re: Allow Default Value to be removed or changed in Hosted Feature Service Field View

JosephAlberts — Thu, 21 Sep 2023 16:11:16 GMT

Yup, you're absolutely right @AndyFairbairn! Thanks for the catch.

That's what I get for trying to slice up a larger notebook with just the relevant pieces. 🙃

Re: Allow Default Value to be removed or changed in Hosted Feature Service Field View

L77 — Tue, 23 Jan 2024 15:51:22 GMT

I would also like to be able to change the default value just by clicking on a drop down menu in ArcGIS Online.

For my use case the default value is the current year, so it was 2023 and I needed to make it 2024.

As a work around I created a new year column in ArcGIS Online, pulled the hosted feature layer into ArcPro, field calculated over the values from the old year column to the new year column, then deleted the old year column. Next I set the default value to 2024.

Then I had to go into map viewer, web app builder and field maps and reconfigure the pop-up windows and filters to all use the new year column.

This took about an hour to make all of these changes and to check that everything was working. I also had our field staff remove their offline areas in field maps and re download them, so it took their time too.

It would be nice in 2025 to be able to just change the default value to 2025 using a drop down menu in the field settings screen. Then I wouldn't have to reconfigure all of my apps.

Re: Allow Default Value to be removed or changed in Hosted Feature Service Field View

Louis-PhilippeRodier — Tue, 23 Jan 2024 23:42:07 GMT

@ColinKelly97 , it seems that you are using the default value for you symbology, hence the non availability to change the default value. If you use display location only, you won't have that problem.

Re: Allow Default Value to be removed or changed in Hosted Feature Service Field View

Louis-PhilippeRodier — Tue, 23 Jan 2024 23:45:38 GMT

@L77, do you mean that the default is also the symbology? Cause if you have drop down menus in the feature layer, you should see the drop down menu in the default option.