Update Previous Inspection Date

DMH_Hobart

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?

JustinReynolds

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.

1. the_current_date
2. 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: