RELATED IDEAS
Provide visibility into which automated fields have been manually overridden
What is the challenge? |
When automated formula fields are manually overridden, there is no way for administrators to identify which fields have lost their automation. The field appears normal but the formula stops recalculating based on source values. Administrators must manually unlock and inspect each field individually across potentially hundreds of records to diagnose which fields are affected. Additionally, it's unclear how or why locked automated fields can become overridden in the first place. |
|---|---|
What is the impact? |
This creates significant data integrity and troubleshooting challenges, especially for teams using complex formula-based workflows for prioritization, scoring, or integration mapping. |
Describe your idea |
Add administrative tools to identify and manage overridden automated fields:
|
© 2025 Aha! Labs Inc.•All rights reserved
This is exactly the scenario we have. Our final Product score field is entirely calculated with Automated values, and we keep it locked as Read Only. Sometimes (and somehow), the Automated values are getting overridden and the calculation stops working. When this happens I have to take off the Read Only flag in the layout to troubleshoot the problem feature by feature. It is tedious. It would be extremely helpful to have improved tools for identifying and correcting these problems without having to change the Read Only status in the layout.
If I could write a report to identify when Automated scorecard fields have been overridden, and if I could perform a bulk operation to reset the overridden fields back to the automatically calculated values, that would be ideal.