Re: Need to pull the date of the last version from the revision history of a file attachment field

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
------------------------------