topic Re: Update Previous Inspection Date in ArcGIS Field Maps Questions

Update Previous Inspection Date

DMH_Hobart — Mon, 07 Aug 2023 04:48:55 GMT

We have a field map that has a number of date / time attributes.

Current Inspection Date
Current Inspection Time
Previous Inspection Date
Previous Inspection Time

If I change the current inspection date / time, how do I get the previous date / time to be the replaced by the old current date / time automatically?

Re: Update Previous Inspection Date

AndreasHall — Mon, 07 Aug 2023 06:49:34 GMT

I guess it might be possible to achieve what you want with Arcade but a better option would be to use a related table to store the inspections. Then you can easily keep the whole history of inspections in that table. Here is the first in a series of six videos outlining how to achieve this: Inspection Workflows Part 1: Building & Publishing Related Tables - YouTube

Re: Update Previous Inspection Date

JustinReynolds — Mon, 07 Aug 2023 15:39:54 GMT

Assuming you're creating and updating the same feature (not related records) you can you $originalFeature on Update. $originalFeature contains the attribute values as they were last submitted to the database.

In this example I created two fields and added a form calculation to the the_previous_date field.

the_current_date
the_previous_date

Example: Using $originalFeature to access attributes from the previous form submission

// check the editType becuase $originalFeature isn't applicable on INSERT if ($editcontext.editType == 'UPDATE') { if (!IsEmpty($originalFeature.the_current_date)) { return $originalFeature.the_current_date; }; // no previous inspection if current inspection date is null }; // no previous inspection date on INSERT (new inspection)

And here is what it looks like:

Re: Update Previous Inspection Date

DMH_Hobart — Tue, 08 Aug 2023 01:47:38 GMT

Thanks @JustinReynolds , I appreciate you taking the time to assist with this 🙂