Recall list tracking

[noestervemb]

I just had my front desk call a ton of patients on the reclal list to clean it up. Is there a query or way to actually see how many people scheduled without keeping track manually? To see how effective we are at reactivationg.

Dr. O

[jsalmon]

I'm only aware of using the Appointments report for seeing how many users used the Web Sched online scheduler to make their appointment. This doesn't give you a break down of "you sent X reminders and Y patients acted on them" though. You would have to manually keep track of the X as of right now which doesn't sound fun.
http://www.opendental.com/manual/reportappts.html

[JasonL]

We do have two queries on our Query Examples page that my prove useful to you:
* Query Examples: http://opendentalsoft.com:1942/ODQueryL ... yList.aspx
* Query #456 "Make list and count of patients with scheduled recalls, and what recall procs are in apts"
* Query #513 "Recall Reminders Sent in a specified date range"

If you would like to have a custom query written you can fill out our Query Request form here: http://opendentalsoft.com:1942/ODQueryR ... tForm.aspx

Hope this helps!

[rhaber123]

I do not write queries but if someone can write this query: " on a certain date, a list of appointments made in the future"
The audit trail of each appointment can be used to create the query.
***Query 850 cover a different subject, but has this info that might be useful for someone who knows how to write a query

SET @FromDate='2017-03-14', @ToDate='2017-03-15';
SELECT A.Patient,
A.TreatingDentist,
DATE_FORMAT(A.FutureApptDate,'%m/%d/%Y') AS 'FutureApptDate',
etc............