Patient Info Custom Fields

For users or potential users.
Post Reply
boboffice
Posts: 89
Joined: Sun Mar 29, 2009 7:11 am
Location: Poway, San Diego County, CA

Patient Info Custom Fields

Post by boboffice » Tue Mar 22, 2016 1:26 pm

Probably an obvious answer but my brain can't figure it out! After creating a custom field (Setup > Family & Insurance > Patient field defs) how and where do I then get the new field I've created to show up? Thanks
Robert Marcus DMD
Univ. of CT '93
Poway, CA

bpcomp
Posts: 304
Joined: Mon Feb 27, 2012 7:30 am
Location: Tucson, AZ
Contact:

Re: Patient Info Custom Fields

Post by bpcomp » Tue Mar 22, 2016 2:39 pm

If you go to the family module and look in the patient information area, your new feilds should show up there. If they don't, go to (Setup/Display Fields/ChartPatientInformation) and move "patfields" from the available column into the showing column. You can now do custom queries.

Code: Select all

SELECT * FROM patfields
will show you all your patfields that have any data in them.

We have a custom field that is a check box for our patients that have requested to be on a short call list. When I run this report, it shows the patients name and their phone numbers.

Code: Select all

SELECT  p.PatNum, LEFT(WkPhone,16) AS WkPhone, LEFT(HmPhone,16) AS HmPhone, LEFT(WirelessPhone,16) AS CellPhone
FROM  patient p 
INNER JOIN patfield pf ON pf.PatNum=p.PatNum
WHERE 
pf.fieldname like '%Short Call List%'
and pf.fieldvalue like '1'
GROUP BY pf.PatNum;

User avatar
jsalmon
Posts: 1551
Joined: Tue Nov 30, 2010 12:33 pm
Contact:

Re: Patient Info Custom Fields

Post by jsalmon » Tue Mar 22, 2016 3:12 pm

bpcomp wrote:If you go to the family module and look in the patient information area, your new feilds should show up there. If they don't, go to (Setup/Display Fields/ChartPatientInformation) and move "patfields" from the available column into the showing column
Correct, they first need to be part of your Display Fields which is where you'll want to go in order to hide, add, or reorder fields that you care about throughout various places in the program. I'm having our website specialists enhance the Custom Patient Fields page to include this information.
You can read more about display fields here: http://www.opendental.com/manual/displayfields.html
The best thing about a boolean is even if you are wrong, you are only off by a bit.

Jason Salmon
Open Dental Software
http://www.opendental.com

boboffice
Posts: 89
Joined: Sun Mar 29, 2009 7:11 am
Location: Poway, San Diego County, CA

Re: Patient Info Custom Fields

Post by boboffice » Tue Mar 22, 2016 7:12 pm

Thank you for the excellent answers. All set!
Robert Marcus DMD
Univ. of CT '93
Poway, CA

Tom Zaccaria
Posts: 353
Joined: Mon Feb 25, 2008 3:09 am

Re: Patient Info Custom Fields

Post by Tom Zaccaria » Wed Mar 23, 2016 11:33 am

Nice little query. Very useful.

drtmz

Post Reply