script for emailing user if their loan items expire
I am trying to create an asset management system and want to setup a script that can email user if their loan items expire. what i had think of is creating a few field called return date and proposed return date and do this calculation:
check each field and if the return date = 'null', check if proposed return date < current date, and email the user with the details of the items that are expire.
I do not know how to write that script Do anyone have experience of creating something similar?