Open Dental Forum

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...

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...

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 ...

Now it works .....

I went here:

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

It is well-explained.

Regards,


Joel M. Eichen

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

Never mind ......

Too simple ......

I did it ........

Thanks,

Joel M. Eichen

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, ...

Thank you so much!

*

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:





Thank you!

Joel M. Eichen

Simple enough, Dr. Bonilla!

Thank you so much for your help, Jorge.

Regards,


Joel M. Eichen

Hello Open Dental gurus!

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

Thanks!

Joel M. Eichen

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. ...

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...

Never mind .....

This was already addressed.

The LUNCHTIME JOIN is still an option.

See y'all later.

Regards,

Joel

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 ...

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 ...

Thank you so much David, for your clear and concise reply.
You are a gentleman and a scholar. Thanks again ..... Joel

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...