I need to run a Calculate on a field in a hosted feature layer

AllanLambert — Wed, 29 Jun 2016 17:43:30 GMT

I have a Damage Assessment feature layer hosted on AGOL with a web map. Along with Domain controlled fields are Estimated % of Damage, Estimated $ Amt of Damage and a prepopulated Dwelling Value field. Field type is Double on these 3 fields. 50k points filtered down to only those edited with Est % Damage. I need to either

1. Calc (Est $ Damage = DwellingVal * Est % Damage) on the fly as the user enters data for each point.

2. Create a URL to Calc (Est $ Damage = DwellingVal * Est % Damage) where (Est % Damage is >0). AGOL times out calc-ing the 50k records so I think the Where clause is necessary to only capture the 500 or 5000 that are damaged.

3. I'm open to ANY suggestion! Thanks. Allan

I can't get the REST API grid to work. The error says that the calcexpression is invalid and Object reference not set....:

Where: PercentDamage > 0

"calcExpression":[{"field" : "EstDollarDamage", "sqlExpression" : "DwellingVal*PercentDamage*.01"}]

http://services5.arcgis.com/cA4ofagPaJJ7qhEz/arcgis/rest/services/DamageAssessment_O_only/FeatureServer/0/calculate(where=”PercentDamage > 10 2”,calcExpression={“field”: “EstDollarDamage”,“sqlexpression” : "DwellingVal*PercentDamage*.01"})

Re: I need to run a Calculate on a field in a hosted feature layer

RandyBurton — Thu, 30 Jun 2016 04:34:02 GMT

Since you are using an HTML form for the calculation, you do not need to put "calcExpression:" in the box.

Just put the portion between the square brackets in the box (including the square brackets). This would go in the box:

[{"field" : "EstDollarDamage", "sqlExpression" : "DwellingVal*PercentDamage*.01"}]

Re: I need to run a Calculate on a field in a hosted feature layer

AllanLambert — Thu, 30 Jun 2016 16:56:10 GMT

Worked. Thanks very much!!

topic Re: I need to run a Calculate on a field in a hosted feature layer in ArcGIS REST APIs and Services Questions

I need to run a Calculate on a field in a hosted feature layer

Re: I need to run a Calculate on a field in a hosted feature layer

Re: I need to run a Calculate on a field in a hosted feature layer