Search found 15 matches

by agrasley
Fri Nov 25, 2022 1:31 pm
Forum: Advanced Topics
Topic: highlighting appointments of family members
Replies: 1
Views: 3305

Re: highlighting appointments of family members

That code should be located in ControlApptPanel.cs.
by agrasley
Fri Nov 25, 2022 1:28 pm
Forum: Advanced Topics
Topic: Marketing Reports - Marketing Section of Patient Profile
Replies: 1
Views: 3401

Re: Marketing Reports - Marketing Section of Patient Profile

Since there is not a standardized place to put this kind of marketing information in Open Dental, what you are probably going to be best served by is a custom query. You can get in contact with our query team to discuss this by filling out the form here: https://opendentalsoft.com:1943/ODQueryReques...
by agrasley
Fri Nov 25, 2022 1:21 pm
Forum: Advanced Topics
Topic: Calculating provider pay at two different rates
Replies: 1
Views: 3227

Re: Calculating provider pay at two different rates

From my experience with other offices that have tried to this, the "best" way to do it is ultimately what works best for your office. But what I have seen as the simplest option that tends to work very well is what you suggested: using a custom query separate out the production for the provider betw...
by agrasley
Fri Nov 25, 2022 1:05 pm
Forum: Main Forum
Topic: can't my connector service to work
Replies: 1
Views: 2668

Re: can't my connector service to work

Please contact support when you are able. We should be able to get that issue resolved for you!

(503)363-5432

Thanks!
by agrasley
Fri Nov 25, 2022 1:03 pm
Forum: Main Forum
Topic: Modifying Query# 1036
Replies: 2
Views: 3649

Re: Modifying Query# 1036

Hello, From a quick scan I can see you are missing a "UNION ALL" in this section: SELECT adj.AdjDate AS 'Date', 0 AS 'Fee', adj.AdjAmt AS 'Adj', 0 AS 'InsW' FROM adjustment adj WHERE adj.AdjDate BETWEEN @StartDate AND @EndDate ) prod GROUP BY DATE_FORMAT(prod.Date,'%M %Y') ORDER BY YEAR(prod.Date),M...
by agrasley
Fri Nov 25, 2022 1:01 pm
Forum: Main Forum
Topic: Keyword match in commlog query
Replies: 3
Views: 4210

Re: Keyword match in commlog query

I think this mod should work for you. What your query was doing was getting every patient that had a commlog that was not the one you wanted. Rather than only excluding those that had that commlog. That's what this line was doing : INNER JOIN commlog cl ON p.PatNum = cl.PatNum AND cl.CommType<>439 W...
by agrasley
Fri Nov 25, 2022 12:48 pm
Forum: Main Forum
Topic: 2 Offices, 1 Server
Replies: 3
Views: 3725

Re: 2 Offices, 1 Server

Hello, There are multiple ways that you could handle this with Open Dental. I will list them below with a few quick pros and cons. I would recommend contacting support to go through these options in more detail if you are interested! * Open Dental Cloud - we do offer a cloud solution, which could be...
by agrasley
Wed Jun 15, 2022 4:53 pm
Forum: Main Forum
Topic: Patient Pictures into system quickly
Replies: 13
Views: 11356

Re: Patient Pictures into system quickly

I will add to this as well, that if you are using our eClipboard app, for Patient Photos, you can have the patients take their own Patient Picture when they come in for their appointment using a mobile device. They can also fill out their forms using the app as well. This automatically imports the p...
by agrasley
Wed Jun 15, 2022 4:43 pm
Forum: Main Forum
Topic: growth of forms
Replies: 5
Views: 5188

Re: growth of forms

Having the fields below the item that grew move back up to their original location is not currently functionality that we have in the sheet window. This would be something that you could submit a feature request for. If you are interested, here is a link that discusses the feature request process: h...
by agrasley
Wed Jun 15, 2022 4:04 pm
Forum: Main Forum
Topic: Add Quick Buttons?
Replies: 3
Views: 4161

Re: Add Quick Buttons?

You can add new quick buttons through Setup > Chart > Procedure Buttons. In the Quick Button Category, if you double click on an blank area the right hand window where you want a new button to be, you can enter information for the new button. You cannot currently add quick buttons outside of the Qui...
by agrasley
Wed Jun 15, 2022 3:56 pm
Forum: Main Forum
Topic: GMAIL NOT WORKING ERROR 403
Replies: 1
Views: 1515

Re: GMAIL NOT WORKING ERROR 403

From what it looks like, there might be a setting for your google account that is blocking the use of tokens for authentication. You can contact our support at 503-363-5432 and we might be able to help troubleshoot this with you, if this is still an issue.

Hope this helps!
by agrasley
Thu Feb 24, 2022 6:11 am
Forum: Main Forum
Topic: Intergrated 2-way text service label wrong patient for received text
Replies: 2
Views: 1904

Re: Intergrated 2-way text service label wrong patient for received text

Hello,

That is understandably confusing. I would recommend contacting support at 503-363-5432 or support@opendental.com so that we can look into this issue with you. There is either going to be something we can help you set up differently to mitigate this, or find another solution.

Regards
by agrasley
Wed Feb 23, 2022 8:02 am
Forum: Main Forum
Topic: mysqladmin flush-hosts
Replies: 8
Views: 11078

Re: mysqladmin flush-hosts

MySQL has built in limits for connections and connection errors, when the number of concurrent connections matches the limit, or the number of connection errors matches the limit, then MySQL will refuse further connections. Using `flush hosts` will clear our those connections and connection errors. ...
by agrasley
Mon Feb 07, 2022 10:27 am
Forum: Main Forum
Topic: Canada - BCDA 2022 Fee Guides issue
Replies: 1
Views: 1754

Re: Canada - BCDA 2022 Fee Guides issue

Hello, this is something that we would probably need to look into with you over the phone. I would suggest that you contact support to discuss it. 503-363-5432.

Thanks!
by agrasley
Tue Jan 04, 2022 3:50 pm
Forum: Main Forum
Topic: Monthly Goal Report Q
Replies: 1
Views: 1914

Re: Monthly Goal Report Q

Hi Dr.RichM, You can get the estimated adjusted production for scheduled procedures in the standard report. All you need to do is go into the Report Setup window (Reports -> Standard -> Setup) under the Misc Settings tab. On there you can check "Monthly P&I scheduled production subtracts PPO write-o...