Forum Discussion

IvanWeiss's avatar
IvanWeiss
Qrew Captain
7 years ago

Log Date a file attachment changes for expiration

I have a file attachment under a company record for Certificate of Insurance.  I need to log a Certificate of Insurance for each of my installers.  I need an expiration date which I want to be 1 year ...
Forms
Formulas and functions
Quickbase Automations
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
7 years ago
You can make a formula text field called File Name with the formula

ToText([My file attachment field])

But if the actual name of the file attachment does not change when a new file is uploaded, I don�t think that the form rule would fire.
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
7 years ago
I understand that you are trying to modify a date field. 

But you were saying that the file attachment field does not seem to be an option to use on form rules.  

So I suggested making a formula text field and using that formula text field in the form rule.