Time and Date for If a Field was Changed?
Hi Folks,
I'm not sure this is the best way to put this together, but here is my scenario.
I have 1 table (Intersections) that includes fields for "Name" (Text), 5 different "Route" Checkboxes, 5...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendNo problem,
Create a date field called [Status Change Date].
If 100% of your data entry is done one by one on a form then you can set up a Dynamic Form Rule that says
When the record is saved
and
The Status has Changed
Action
Change the value if the field [Status Change Date] to "the current date".
Or, if any of your edits are done by grid edit or by some kind of data import than form rules will not work. Forum rules only work when the data entries on forms. In that case you will need to set up an automation or a pipeline to do this. It is probably easiest to set up a automation even though they're being phased out and then use the migration tool to change it into a pipeline.
Feel free to post back if you have any questions.
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
Hi Mark,
I tried using the above and for some reason it is not working for me. The 'Status' field in my app is a rich text formula field. I've had issues with formulae being able to read the final value of a rich text field and so created another dummy field that has a value of the rich text Status field.
Using either, the Status change date is not getting populated.
What could be the issue?
Thanks
Deepa
------------------------------
Deepa Prashant
------------------------------
