Search found 18 matches

by Joel344
Sat May 21, 2016 11:49 am
Forum: Main Forum
Topic: Custom Sheet Reportability
Replies: 3
Views: 7227

Re: Custom Sheet Reportability

Here is the query from http://www.opendental.com/manual/sheetsinputfield.html I added a few more fields from patient. /*Misc sheet field report for sheets created in date range*/ SET @SheetName='Keystone Beyond Your Smile'; /*Enter description of sheet here (sheet name)*/ SET @ReportableName='Has se...
by Joel344
Sat May 21, 2016 10:58 am
Forum: Main Forum
Topic: Custom Sheet Reportability
Replies: 3
Views: 7227

Re: Custom Sheet Reportability

Answering my own question, the ReportableName needs to be different for each radio button within the RadioButtonGroup. In my example, I indicated the "yes" on the fill in form to indicate, "Has seen the PCP," and "no" to indicate "Has not seen the PCP." Next, the FieldValue field contains an "x" sug...
by Joel344
Sat May 21, 2016 6:16 am
Forum: Main Forum
Topic: Custom Sheet Reportability
Replies: 3
Views: 7227

Custom Sheet Reportability

Hello gurus, I created a custom sheet where I would like reportability. There is a radio button group "PCP," which I believe is set-up properly. This refers to, "Have you visited your PCP (Primary Care Provider) during the past six months?" When I query the sheetfield table, I would like to be able ...
by Joel344
Fri May 06, 2016 12:40 pm
Forum: Main Forum
Topic: Sheets-Dental-Laboratory
Replies: 3
Views: 6952

Re: Sheets-Dental-Laboratory

Now it works .....

I went here:

http://opendental.com/manual/sheetsaddelements.html

It is well-explained.

Regards,


Joel M. Eichen
by Joel344
Fri May 06, 2016 9:14 am
Forum: Main Forum
Topic: Sheets-Dental-Laboratory
Replies: 3
Views: 6952

Re: Sheets-Dental-Laboratory

Nope, I didn't do it .....

A dental assistant informed me that she deleted the "words after the Due Date" and typed it in herself.

Therefore, I do not know how to do it.

Any ideas?


Regards,

Joel M. Eichen
by Joel344
Fri May 06, 2016 8:56 am
Forum: Main Forum
Topic: Sheets-Dental-Laboratory
Replies: 3
Views: 6952

Re: Sheets-Dental-Laboratory

Never mind ......

Too simple ......

I did it ........

Thanks,

Joel M. Eichen
by Joel344
Fri May 06, 2016 8:18 am
Forum: Main Forum
Topic: Sheets-Dental-Laboratory
Replies: 3
Views: 6952

Sheets-Dental-Laboratory

Hello everybody, I would like to include a field on our dental laboratory sheet. When filling out a Lab Case, there is an input field for Date Due. This is a field in the labcase table, e.g. labcase.DateTimeDue. We would like this to appear on our Lab Case Sheet. How do we accomplish this? Regards, ...
by Joel344
Wed Apr 20, 2016 4:28 am
Forum: Main Forum
Topic: How to move procedure code to a different category
Replies: 5
Views: 8494

Re: How to move procedure code to a different category

*

The procedure code is now in the right category. Thanks.

Is there a way to change the description? It currently reads, "Crown," however an accurate description would be, "Retainer."

Photo:


Image


Thank you!

Joel M. Eichen
by Joel344
Wed Apr 20, 2016 4:05 am
Forum: Main Forum
Topic: How to move procedure code to a different category
Replies: 5
Views: 8494

Re: How to move procedure code to a different category

Simple enough, Dr. Bonilla!

Thank you so much for your help, Jorge.

Regards,


Joel M. Eichen
by Joel344
Tue Apr 19, 2016 3:53 pm
Forum: Main Forum
Topic: How to move procedure code to a different category
Replies: 5
Views: 8494

How to move procedure code to a different category

Hello Open Dental gurus!

Can you help move my code for all ceramic crown to "crowns?"

Thanks!

Joel M. Eichen

Image
by Joel344
Tue Oct 13, 2015 4:25 am
Forum: Main Forum
Topic: Little Help from Query Gurus, please.
Replies: 3
Views: 6494

Re: Little Help from Query Gurus, please.

Thank you very much David and Travis. I had independently come to the same conclusions before I asked for your help, but I assumed my lack of knowledge was the problem. Our office is not attaching cash and credit card payments to procedures therefore it is our own GIGO approach that is limiting us. ...
by Joel344
Sat Oct 10, 2015 10:44 am
Forum: Main Forum
Topic: Little Help from Query Gurus, please.
Replies: 3
Views: 6494

Little Help from Query Gurus, please.

October 10, 2015 Hello to y'all query gurus. Every time I try something fancy, I get stuck. Well not every time but enough times to make it feel that way. Here's one of our standard queries that I have tweaked a bit to provide very useful information. Now I would like to add in information from 'pay...
by Joel344
Sun Sep 20, 2015 9:24 am
Forum: Advanced Topics
Topic: Help with "Securitylog Query"
Replies: 2
Views: 7107

Never mind <done> : Help with "Securitylog Query"

Never mind .....

This was already addressed.

The LUNCHTIME JOIN is still an option.

See y'all later.

Regards,

Joel
by Joel344
Sun Sep 20, 2015 9:00 am
Forum: Advanced Topics
Topic: Help with "Securitylog Query"
Replies: 2
Views: 7107

Help with "Securitylog Query"

Thanks for everyone who helped me with previous queries. This is a small query that we use to track how our billing personnel is spending their time. We outsource billing to an offsite location where various people connect through a Virtual Private Network. Query: select * from securitylog, patient ...
by Joel344
Sun Sep 13, 2015 6:21 am
Forum: Advanced Topics
Topic: Help with 'Time-Tracker Query'
Replies: 5
Views: 11067

Re: Help with 'Time-Tracker Query'

September 13, 2015 Hello Justin, David, and others, Good to touch base with you. Its been 10 plus years, Justin! We hope you are doing well and have great success with your work. Quick update for David Graffeo: I used your last explanation about INNER JOIN and LEFT JOIN and I further reviewed MySQL ...
by Joel344
Sun Aug 30, 2015 6:41 pm
Forum: Advanced Topics
Topic: Help with 'Time-Tracker Query'
Replies: 5
Views: 11067

Re: Help with 'Time-Tracker Query'

Thank you so much David, for your clear and concise reply.
You are a gentleman and a scholar. Thanks again ..... Joel
by Joel344
Sat Aug 22, 2015 5:35 am
Forum: Advanced Topics
Topic: Help with 'Time-Tracker Query'
Replies: 5
Views: 11067

Help with 'Time-Tracker Query'

Hello Everybody, I need a little help ..... with this Time-Tracker Query. What's Time Tracker? This query tells us what time a given patient was entered at the FD (Front Desk), how long they have been hanging around (sometimes hours), then the time span spent within any given operatory (CompName). E...