Show on a report whether a field has been updated within the last week | Community
Skip to main content
Level 2
November 27, 2023
Question

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

  • November 27, 2023
  • 1 reply
  • 741 views

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. 

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

1 reply

skyehansen
Community Advisor and Adobe Champion
November 27, 2023
Katie-CAuthor
Level 2
November 28, 2023

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? 

skyehansen
Community Advisor and Adobe Champion
November 28, 2023

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.