Hi Pablo, you can create an automation to do this. First, create a new table called Revision Dates, which just includes a date field called Revision Date. Then relate this new table as a child of the table where your file attachment field is located.
Finally, create an automation whose trigger looks something like this:
When a user modifies a record
in this table: (table where your file attachment field is)
Additional CRITERIA
---
Start the automation when
Any of the following fields change: (your file attachment field)
Then set up an action to add a record. When you do, select your new Revision Dates table so Quick Base keep a list of revision dates for each record.
The action will just fill in one field, like this:
(Revision Date) (Select from a calendar) (Today)
so it will fill in the date the file was updated.
Please note that this will set up tracking so, in the future, whenever a user updates the file attachment, you will record the dates. However, there is not a way to retroactively apply this to existing file attachment revisions.
------------------------------
Brian Cafferelli
------------------------------
