I have create a map to use in Collector for ArcGIS for the fire department. After using it they have a request: Once they input values for Field A and Field B, they want Field C to calculate a solution using Fields A and B. I have used the calculate field function in AGOL (ex. Field C = Field A + Field B) . However, the field will not 'remember' this calculation. I want the field calculation to stay in that field so that each time I or another user opens the map and inputs the data for A and B, it will auto-populate the value for C. Is there a way to NOT have to run a field calculation each time I open the map?

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; } } }

How do I create a permanent field calculation in an AGOL feature layer?

AshleyThornton

I have create a map to use in Collector for ArcGIS for the fire department. After using it they have a request: Once they input values for Field A and Field B, they want Field C to calculate a solution using Fields A and B.

I have used the calculate field function in AGOL (ex. Field C = Field A + Field . However, the field will not 'remember' this calculation. I want the field calculation to stay in that field so that each time I or another user opens the map and inputs the data for A and B, it will auto-populate the value for C. Is there a way to NOT have to run a field calculation each time I open the map?

Find more posts tagged with

Accepted answers

All comments

Michael_Stead

This is an old post, but I do not understand why it doesn't have the answer, so I will add it... maybe I am misreading the question.

1. Add the field you want to populate to your layer (if it doesnt exist)

2. Open the layer in the webmap being used to add new features and select the layer from the layers panel on the left

3. go to Configure Editing on the right and then to Forms

4. convert popup or add whatever fields you would like

5. Configure each field you have added, for the field you would like to autopopulate make it read-only and at the bottom in Calculated Expression hit the little gear and New Expression

6. rename the expression what you want and write it. I often generate a unique ID based on the user and time stamp using the expression:

Replace(( Concatenate([ GetUser($layer).fullName, Day(Now()), Month(Now()),Year(Now()),Hour(Now()),Minute(Now()),Second(Now())],'_')),' ', '_')

You can also do geoprocessing operations, like pull a field from the nearest associated layer or populate with a distance to a certain type of feature.. lots of possibilities

PayneTodd

In dashboards I was able to hack the table view and display a calculated expression. The key was to add a field that was not being displayed in the table (like OBJECTID) Then update the label in the Header section for me it was updated to STATUS. Then in the Values section return a calculation for the status as the display text. DEFINATELY A HACK. It would be nice to add a calculated field to the hosted feature layer directly, kinda like a computed column in SQL. or perhaps in a view of the layer.

OBJECTID: {

displayText : alarmStatus,

textColor: 'Red',

backgroundColor: alarmColor,

textAlign: 'right',

iconName: '',

iconAlign: '',

iconColor: '',

iconOutlineColor: ''

tablehack.png

MattTarkington1

I have been able to get this to work in notebooks. It runs faster than in a model builder. And you have access to more Python modules.

DavidForbuss1

I use an acrade script to create a popup that calcs two dates against each other. Seems like you could do the same for other fields. I got this template from a forum on here (sorry, I forgot where or I'd give them credit). Anyway, here's mine. Must be used in the new map viewer, so add this as one of your expressions, then in the popup add {expr/1} or whatever number it is:

// Access 'Inspections' table as a FeatureSet
var portal = Portal("PORTAL ADDRESS HERE")
var inspections = FeatureSetByPortalItem(portal,
"ITEM NUMBER HERE", <layer # in service here>, ['field1', 'field2',
'field3'])

// Filter related features by using a common attribute
var facilityid = $feature.parentID
var filterStatement = 'childID = @parentID'

// Related features as a variable
var relatedData = Filter(inspections, filterStatement)

// Sort related features by oldest to newest
var relatedDataSorted = Top(OrderBy(relatedData, 'field3 DESC'),1)

// Build the pop-up string by iterating through all related features
var popupString = 'Last Flushed Date: '
for (var f in relatedDataSorted){

popupString += Text(f.field3, 'MM/DD/YYYY')

}

DefaultValue(popupString, 'No measurements to show')

MattTarkington1

I believe so. It's something that I'm experimenting now. Having issue's with the arcpy.management CalculateField module though.

timshapiro

would it be possible to do this using Notebooks?

DavidForbuss1

This worked! Thanks @SallyGalewski ! Can't wait to implement this in some of my maps. The only thing I noticed that didn't seem to work was labeling off of this expression field. That'd be a nice addition so the field crews see the calc'd value right away.

JoshSender2

I just tested this out on some scrap data and this works brilliantly. It is in no way shape or form the ideal solution to this issue, but hey, any solution is better than no solution.

Thanks for sharing!

MattTarkington1

I too have been struggling with this for quite a while and have found a bit of a solution! (if you have access to ArcPro).

I pull my feature layer out of the portal into ArcPro and put the Calculate Field into a Model scheduled to run periodically.

Only downside I see to this is that the machine with the Scheduled Tool has to be on in order for this to work. As I understand it, ArcPro doesn't even have to be open.

Screenshot 2021-12-30 175632.jpg

Hope this helps!

davidlam123

Hi, I am also struggling for this question and haven't figured out a solution to fix it. dashboard doesn't inherit AGOL expression. it doesn't add to the feature layer itself, but only the pop-up. is there any way to fix this issue. I have a lot of calculated field in attribute table. I need the attribute table to automatically calculate and remember the calculated field when i append new row of data. Eventually, the information is captured automatically in dashboard configured list of element

JoshSender2

It seems like we should be able to accomplish this - making a calculated column usable in a dashboard indicator or list - by writing an advanced formatting arcade expression. For the life of me though, I cannot seem to figure it out the correct code. In my head, here's the way it would work

Define a feature set from the existing item (FeatureSetByPortalItem)
Define a new feature set by defining a dictionary which has all the same fields as the original feature set plus the additional yet to be calculated field
Write a for loop that would iterate over the number of features in the original feature set and would assign attribute values to the new feature set - with the values of the not-calculated fields simply being equal to the i(th) [the iteration number] value in the original feature set of the corresponding original attribute, and the calculated column references some combination of the original feature set i(th) attribute values.
Return the new feature set and make a list or indicator from the new values.

Great in theory, but I cannot seem to make it actually work. This sort of thing is super simple in Power BI - making a calculated column. But all of the Googling and trying I've done so far say it's either difficult or impossible in ArcGIS Dashboards.

I'm happy to share my nonfunctioning code if anyone thinks they can actually make this work.

CVHCMaster

Hi Sally,
It seems that “Attribute Expressions” created this way on maps cannot be used/referenced in dashboard displays. So I would not be able to pick "ATP Calc" or {expression/expr0} when I make a dashboard indicator or list.
Or am I missing how to use/reference them in dashboard displays?
Any help would be appreciated!

AnuSawant

Thanks Sally.

SallyGalewski

Hi Anu,

When in AGOL, I clicked on my related table and went to the “Attribute Expressions” and clicked “Add”. I added my expression:

Return ($feature.RLUcATP / $feature.RLUATP1) * 200 Clicked “Test” and it looked like this:

This video shows how to do it. (about the 4 minute mark)

https://www.bing.com/videos/search?q=using+html+formatting+in+a+pop-up+using+arcade&&view=detail&mid=310D06E17F05BD516F90310D06E17F05BD516F90&&FORM=VRDGAR&ru=%2Fvideos%2Fsearch%3Fq%3Dusing%2Bhtml%2Bformatting%2Bin%2Ba%2Bpop-up%2Busing%2Barcade%26%26FORM%3DVDVVXX

Hope it helps!

Sally

AnuSawant

Can you please explain where to add this expression? In my case feature service has got Sync and editor tracking enabled so I can't use the Arcade expression. And as mentioned by other SQL or other calculations are just once off.

Thanks,

Anu

AnuSawant

Any workaround for this? I also have the same question.

SallyGalewski

I also have this question. Very similar situation except my calculation is done on a related table for a hydrant feature and not the hydrant feature itself.

(Field A \ Field *200 = Field C. Depending on the results of the calculation, I want the text to change to red, if the test needs to be redone.

SayenaFarid_Marandi

Hi Glenn,

Where did you create an expression ? in Pop-up? then we cannot populate any field . Is there any way that we can have an expression to update a field "C" every time we change fields "A" and "B"?

glennhazelton2

if you want the values to be calculated as data is entered then you need to create an expression in field. using the calc tool will only work manually. what i have done is create a field and then in the mapviewer create an expression. this can be a combination of other fields. below is what one looks like that i built to do labeling- it does concatenation and rounding.

"Ave. Salinity: "+Round(Average($feature["Salinity_1"],$feature["Salinity_2"],$feature["Salinity_3"]),0)

JW_GIS77

If your data is being hosted as a Feature Layer, you should be able to add a field and perform calculation on it.

If you go to your Feature Layer -> Data -> Context Menu on the top right of the data -> Add Field -> Click on the new fields header -> Field Calculator.

You should be able to populate the new field with the data you want with this method.

Here is a picture of what it looks like when you have the Context Menu open.

I hope this helps!

- Jacob Watson

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

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