Auto Email to notify customer

[xchicox]

i really need a help on this , I have a custom field in Customer Module where it shows the expiry date of the license of my customer, and i want to send an auto email to notify the customer.

Anybody can help me please

[Krishn]

Hello @xchicox ,
In the Server script Create a Scheduler Event

[xchicox]

do you have any sample script for me to review and follow?

[Suresh_Thakor]

@xchicox , Server script for Auto ToDo task then set Notification according to it.

Custom fields expiry dates of Licenses

Hi @Frz: Notification just … notifies But automate ToDo is pretty simple. Create a server script, type “Scheduler Event” with Daily frequency. customers = frappe.db.sql("""select name, custom_license_expiry_date from `Customer` where DATEDIFF(custom_license_expiry_date,CURRENT_DATE)=7""", as_list=1) for customer in customers: task = frappe.get_doc({ "doctype": "ToDo", "due_date": customer.custom_license_expiry_date, "description": "…

Thanks