new report that can filter by a text field that has been modified within the past day

  • 0
  • 1
  • Question
  • Updated 4 years ago
  • Answered

new report that can filter by a text field that has been modified within the past day. that field is not allows filled and need a report that can run daily to report when that field is modified to avoid duplicats

Photo of Eric

Eric

  • 0 Points

Posted 4 years ago

  • 0
  • 1
Photo of Joseph

Joseph

  • 0 Points
Hi Eric,

This could possibly work by creating a Date/time field and using a form rule that will update that field when your text field is modified. An example for the form rule would be:

Condition:

When The Record is Saved AND

 [Text field] has been changed



Action:

Change [Date/time] field to the current date/time



Then you can use this date/time field as a filter on your report to show when the most recent change to that field was made.



Best,

Joe Y.

Quickbase Cares Team