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
------------------------------
Original Message:
Sent: 11-05-2019 11:33
From: Pablo D.
Subject: Need to pull the date of the last version from the revision history of a file attachment field
Hi,
I would need to pull the date of the last revision of a file attachment (as included in the revision story) so to display in the record.
Is there any native formula to do it?
Pablo
------------------------------
Pablo D.
------------------------------