Forum Discussion

Qrew Member

3 years ago

recording when a status changes and date stamping it

Hello, We have a status for each of our wells. Our GIS person has a connected table to our Wells table. He wants to see a date stamp for when a status changes. I made a field that has this fo...

Qrew Assistant Captain

If they are using the form to update the data, you could use a form rule.

------------------------------
Paul Peterson
------------------------------

Qrew Member

3 years ago

How would a form rule work here? I don't see an option to do an action when a field changes.

------------------------------
Renee Hansen
------------------------------

DonLarson
Qrew Commander
3 years ago
Renee,

Try this structure

By having a Status Change Table, you now know the lifecycle of the well. The current status of the Well is the very last record added to the Well Status Change table. You can get that value with a Reverse Relationship or a Formula Query.

The Date Time Stamp that your person wants is the Date Created FID #1 from the table.

------------------------------
Don Larson
------------------------------
- PaulPeterson1
  Qrew Assistant Captain
  3 years ago
  The way I have used form rules to time stamp status changes is to create a New Status field and set the form rule to fire when the status does not equal the new status and in the form rule change the New Status to the Status.
  
  ------------------------------
  Paul Peterson
  ------------------------------