topic Re: Calculated expression runs when updating existing field in ArcGIS Field Maps Questions

Calculated expression runs when updating existing field

MappyIan — Thu, 14 Sep 2023 09:23:20 GMT

I have a calculated expression that add the current date/time to a field when a record is captured in Field Maps. However, if I update any existing record via Field Maps the calculated expression runs again, which means the original date/time the record was captured is lost.

I expected that the calculated expression would only run when creating new records, not when updating existing records.

Does anyone know if there is a workaround to this?

Re: Calculated expression runs when updating existing field

RodellZorilla — Thu, 14 Sep 2023 12:58:01 GMT

Hello, this post may be helpftul. See the IsEmpty function here also. Thanks!

Re: Calculated expression runs when updating existing field

MappyIan — Fri, 15 Sep 2023 11:10:29 GMT

Thanks @RodellZorilla, I found another similar post after asking the question:

https://community.esri.com/t5/arcgis-field-maps-questions/is-there-an-expression-to-differentiate-select-vs/m-p/1325490

The solution in the above post uses the IsEmpty function in conjunction with $editcontext.editType to check if the record is being updated or inserted.