Script for "Destroy by" date
I am creating a filing system where we enter the information for all the office documents into the FM database. Every file has a different shredding date. For every type of file I have assigned how many years to keep it for (1, 5, 10, permanent).
Based on the document date and how long to keep it for I want to create an automatic script in another field called "destroy by".
script function would be something like: Document Date + how many years (1/5,10) = shredding date
if how many years = "permanent"
then shredding date = "permanent"
how would i write such a script?