Forum Discussion

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

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.

IvanWeiss

Qrew Captain

7 years ago

I am trying to modify a date field, not text.

Forum Discussion

Log Date a file attachment changes for expiration

Related Content

Auto change record to 'Expired' when copied.

When the Expiration Date is On or Before Today, Change the Contract Status to Expired

Attachment - file name

Trigger RULE is there is a change in an attachment field

PDF Document Generator, automatically attached to a record