recording when a status changes and date stamping it

Question

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 formula [BM STATUS]& " " & Now()
which results in this, SPUD 02-24-2022 01:21 PM, but they don't want the text in a date field. understandably. So how can I date stamp when only that field changes without a pipeline?
------------------------------Renee Hansen------------------------------

PaulPeterson1 · Answer

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

Sign up

Login to the community