Expand my Community achievements bar.

Show on a report whether a field has been updated within the last week

Avatar

Level 2

Does anyone have an idea how we might be able to indicate on a report if a field has been updated within the last week? The idea is to add this functionality onto a variety of existing reports. 

3 Replies

Avatar

Level 2

The idea was for an existing report. So is there a solution for a variety of report types that could show particular fields updated on the existing report? 

Avatar

Community Advisor

I don't believe so. As a stopgap you could use a calculated field that records the date a change was made, or all the dates a change was made, but then there tend to be very specific ways you would be able to filter on this. I'm not familiar with the code, but the calculated field would basically be configured to record the latest field value and the date, and then every time the form is saved, it would recalculate to compare the field value to what it has stored, and update if the two values are different. Having a remote consultant walk you through such a calculation would be your best step, so that you're able to understand and utilize/ manage it in the future.