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 different "Route Sequence" (Numbered 1 - 50ish), "Status" (Dropdown choice).
Caveats: Each Intersection "Name" can have multiple "Route" Checkboxes checked.
My Questions are:
I would like to capture a Date Time, if the "Status" Dropdown was changed.
Create a report based on the last Status time. (If Row Item status was changed within the last Day, add to report). Is there any way to do that? Thank you for any assistance.Will
No 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 saysWhen the record is savedand The Status has ChangedAction
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.