Custom Function to alert Owners of inactivity
We've created a custom module (CustomModule3) in our CRM and we need a way to have Zoho find any records with a last activity date of 2 weeks (or more) and send out an alert to the owner of that record to update it. I can create an email template for this, and I know I can create a schedule to run a custom function but I need a custom function to do the hard part of finding the record that has a last activity time older than 2 weeks and then sending the alert to the owner of the record to have them update the record. Any help would be greatly appreciated.
Thank you,