Is there any way (using conditional formatting or otherwise) to compare a file upload date to the record’s last modified date? Basically I would like a way to check if a file was uploaded the last time a record was saved or not.
Hi there,
There are a couple of approaches you can combine to track upload timestamps and compare them against the record’s last modified date.
Capturing the upload timestamp
You can use the Ragic AI Agent’s “fill out forms” capability to set a rule: when the file upload field is updated, fill in the current timestamp to a designated time field. Alternatively, if you’re comfortable with JavaScript, the Last Modification Date of a Specific Field guide walks through adding a workflow script that watches a specific field and writes the timestamp to a date field whenever that field changes — this gives you more precise control over the trigger.
Capturing the record’s last modified time
For the record’s overall last modified time, the default value variable `#DATETIME can auto-populate a field with the current datetime on every save — you may already have something like this in place.
Note: AI Agents can occasionally make errors or miss triggers, so we’d recommend testing the behavior thoroughly before relying on it in production.
Hope that helps!