2

When creating a new field in any entity within Microsoft Dynamics Sales and other modules, introduce a checkbox labelled “Include Modified On.”

If this checkbox is selected, the system will automatically create an additional field named “[Field Name] Modified On.” This field will capture and update the timestamp whenever the original field is modified.


Behaviour Details (Proposed)

  • Checkbox: Include Modified On (available when creating or editing a field). Cannot Rollback once created
  • Generated field: [Field Name] Modified On (Data Type: Date and Time, read-only).
  • Population logic: Auto-updated by the platform whenever the source field’s value changes (including changes via UI, API, imports, and flows).
  • Optional: Setting to ignore updates when value is unchanged (e.g., same value submitted).
  • Security & Auditing: Respects entity and field-level security; stored in the same entity; appears in form designer, views, and Advanced Find.


Benefit:

This enhancement will significantly reduce manual effort in scenarios where tracking the modification date of specific fields is required (Not for Auditing but for other scenarios).

Currently, users often need to create custom workflows or scripts to achieve this functionality, which is time-consuming. Automating this process will improve efficiency and consistency across implementations.

So,

  • Faster implementation (no need to build/maintain flows or plugins).
  • More accurate and consistent timestamps across environments.
  • Cleaner solution design and easier reporting.
  • Does not replace full audit history; complements it by surfacing the latest change timestamp for a field.


Example Use Cases

  • Sales: Track when Opportunity Stage, Probability, or Discount % last changed for pipeline health and coaching.
  • Compliance: Timestamp the last change to KYC Completed, Consent Status, or Compliance Flag.


Category: General
STATUS DETAILS
New