Would like to create an SMS/email appointment reminder application that sends a notice 2 days prior. Reminder list would come from a SQL query of upcoming appointments and the message would include Patient first name, Doctor, Facility location, and time for office appointments. Would also like the ability to respond through a button and update the appointment status to confirm. If appointment was not confirmed, would like to send a second reminder the next day.
Additionally would like to send out instructions for upcoming surgeries, and also send follow-up instructions after surgery.
• Exclude sending by doctor and or appointment type.
• SQL Query and write back into database
• Default messages for office and surgery with the ability to override with a custom message based on doctor and or appointment type.
This does not need a complicated management GUI, opt out feature can be done by looking at the “contact by” database field stored in the patients demographics table. The appointment type and doctor exclusion can be based on the database ID. Custom message override can also be based on database ID.
36 freelancers are bidding on average $2224 for this job
Hello I am willing to help you with this appointment project. I have worked on such email sending and Cron Jobs. I will surely give a quality work using my experience of 7 years. I am happy to start soon Regards