Mental Health Forms

system · January 16, 2017, 12:57am

jboyd13 wrote on Monday, January 16, 2017:

Hi Harley,

Here is the SQL and a CSV version of the PHQ9 and PHQ4 forms. I exported the layout_options table and removed non-relevant rows. Let me know if it works for you.

Thanks,

Joyce

system · January 18, 2017, 7:50pm

juggernautsei wrote on Wednesday, January 18, 2017:

Joyce,
It is good to see you working so dilegently on this form and it can become a real asset to the community project.
Harley,
do you plan on getting this form into the code base?

system · January 19, 2017, 2:51am

jboyd13 wrote on Thursday, January 19, 2017:

Hi Sherwin,

Thanks for the compliment. It means a lot.

Hi Harley, do you have everything you need from me?

Thanks,
Joyce

system · January 19, 2017, 6:36am

htuckjr wrote on Thursday, January 19, 2017:

Hi Folks-
Joyce- I just now got to look at the sql fiiles you uploaded above. I see the layout_options table contents but I believe the dump should also include some entries from lists.

I wonder if you saw the instructions by Rod Roark from long ago, which would produce sql files containing everything needed to reproduce the LBFs?

"In Administration -> Globals -> Features make sure “Configuration Export/Import " is enabled. Then you can go to Administration -> Backup -> Export Configuration and export just layouts and lists. You’ll then need to edit the output to include only the layouts and lists that you want to transfer. Also be sure to get rid of the DROP TABLE and CREATE TABLE statements.”

You’d select your LBF forms names, PHQ4 and PHQ9, and also get all the lists you created to be used in those forms. I’ll do the file editing and ‘DROP/CREATE TABLE’ stuff.

Sherwin-
“I’m not a developer…” so I won’t be contributing php code, just a chunk of sql code that’d calculate and update the ‘score’ fields. I realize that’s kind of ghetto… maybe somebody who is php enabled could work the SQL into some more elegant solution? But I certainly do intend to release it to the community, for what it’s worth.

Rgds- Harley

system · January 19, 2017, 9:36am

jboyd13 wrote on Thursday, January 19, 2017:

Harley,

Sorry, I forgot about the lists. I’ll try to get to it. I forgot about the instructions. I used phpMyAdmin to get the stuff I sent you.

Thanks,
Joyce

From: harley tuck htuckjr@users.sf.net
Sent: Thursday, January 19, 2017 1:36:06 AM
To: [openemr:discussion]
Subject: [openemr:discussion] Mental Health Forms

Hi Folks-
Joyce- I just now got to look at the sql fiiles you uploaded above. I see the layout_options table contents but I believe the dump should also include some entries from lists.

I wonder if you saw the instructions by Rod Roark from long ago, which would produce sql files containing everything needed to reproduce the LBFs?

"In Administration -> Globals -> Features make sure “Configuration Export/Import " is enabled. Then you can go to Administration -> Backup -> Export Configuration and export just layouts and lists. You’ll then need to edit the output to include only the layouts and lists that you want to transfer. Also be sure to get rid of the DROP TABLE and CREATE TABLE statements.”

You’d select your LBF forms names, PHQ4 and PHQ9, and also get all the lists you created to be used in those forms. I’ll do the file editing and ‘DROP/CREATE TABLE’ stuff.

Sherwin-
“I’m not a developer…” so I won’t be contributing php code, just a chunk of sql code that’d calculate and update the ‘score’ fields. I realize that’s kind of ghetto… maybe somebody who is php enabled could work the SQL into some more elegant solution? But I certainly do intend to release it to the community, for what it’s worth.

Rgds- Harley

Mental Health Formshttps://sourceforge.net/p/openemr/discussion/202504/thread/0db2469f/?limit=25#24e0

Sent from sourceforge.net because you indicated interest in https://sourceforge.net/p/openemr/discussion/202504/

To unsubscribe from further messages, please visit https://sourceforge.net/auth/subscriptions/

system · January 19, 2017, 10:12am

jboyd13 wrote on Thursday, January 19, 2017:

Harley,

Thanks for the instructions. I’ll try to get tge lists to you later today.

Thanks,
Joyce

From: Joyce Boyd jboyd13@users.sf.net
Sent: Thursday, January 19, 2017 4:36:24 AM
To: [openemr:discussion]
Subject: [openemr:discussion] Re: Mental Health Forms

Harley,

Sorry, I forgot about the lists. I’ll try to get to it. I forgot about the instructions. I used phpMyAdmin to get the stuff I sent you.

Thanks,
Joyce

From: harley tuck htuckjr@users.sf.net mailto:htuckjr@users.sf.net
Sent: Thursday, January 19, 2017 1:36:06 AM
To: [openemr:discussion]
Subject: [openemr:discussion] Mental Health Forms

Hi Folks-
Joyce- I just now got to look at the sql fiiles you uploaded above. I see the layout_options table contents but I believe the dump should also include some entries from lists.

I wonder if you saw the instructions by Rod Roark from long ago, which would produce sql files containing everything needed to reproduce the LBFs?

"In Administration -> Globals -> Features make sure “Configuration Export/Import " is enabled. Then you can go to Administration -> Backup -> Export Configuration and export just layouts and lists. You’ll then need to edit the output to include only the layouts and lists that you want to transfer. Also be sure to get rid of the DROP TABLE and CREATE TABLE statements.”

You’d select your LBF forms names, PHQ4 and PHQ9, and also get all the lists you created to be used in those forms. I’ll do the file editing and ‘DROP/CREATE TABLE’ stuff.

Sherwin-
“I’m not a developer…” so I won’t be contributing php code, just a chunk of sql code that’d calculate and update the ‘score’ fields. I realize that’s kind of ghetto… maybe somebody who is php enabled could work the SQL into some more elegant solution? But I certainly do intend to release it to the community, for what it’s worth.

Rgds- Harley

Mental Health Formshttps://sourceforge.net/p/openemr/discussion/202504/thread/0db2469f/?limit=25#24e0

Sent from sourceforge.net because you indicated interest in https://sourceforge.net/p/openemr/discussion/202504/

To unsubscribe from further messages, please visit https://sourceforge.net/auth/subscriptions/

Mental Health Formshttps://sourceforge.net/p/openemr/discussion/202504/thread/0db2469f/?limit=25#24e0/f8c1

Sent from sourceforge.net because you indicated interest in https://sourceforge.net/p/openemr/discussion/202504/

To unsubscribe from further messages, please visit https://sourceforge.net/auth/subscriptions/

system · January 20, 2017, 12:20am

jboyd13 wrote on Friday, January 20, 2017:

@Sherwin, can I contact you outside of the forum? You’re working with one of my classmates and I have some questions for you.

Thanks,

Joyce

system · January 20, 2017, 12:20am

jboyd13 wrote on Friday, January 20, 2017:

@Sherwin, can I contact you outside of the forum? You’re working with one of my classmates and I have some questions for you.

Thanks,

Joyce

system · January 26, 2017, 5:26pm

jboyd13 wrote on Thursday, January 26, 2017:

Hi Harley,

I just wanted reach out to see how things were going. I’m getting some help and didn’t want to miss any work you’re doing. Or have them work and you’re almost done

Thanks,
Joyce

From: Harley Tuck harleytuck@users.sf.net
Sent: Saturday, January 14, 2017 11:07:11 PM
To: [openemr:discussion]
Subject: [openemr:discussion] Re: Mental Health Forms

yes thanks that would be helpful.

HT

Mental Health Formshttps://sourceforge.net/p/openemr/discussion/202504/thread/0db2469f/?limit=25#1e86/61f1

Sent from sourceforge.net because you indicated interest in https://sourceforge.net/p/openemr/discussion/202504/

To unsubscribe from further messages, please visit https://sourceforge.net/auth/subscriptions/

system · January 31, 2017, 5:40pm

juggernautsei wrote on Tuesday, January 31, 2017:

Thanks Harley,

I just sent the javascript to Joyce to try out. The javascript adds up the totals and sets the serverity in the browser before saving. If the user goes back and changes any one of the entries, a new total will be calculated.

I have it working here http://omp.openmedpractice.com/rolebase. admin pass

system · February 2, 2017, 4:16am

htuckjr wrote on Thursday, February 02, 2017:

Hi Sherwin-
Glad to see you’re doing it in Javascript- I don’t think a sql solution would have truly met their needs.

HT

system · February 7, 2017, 8:11pm

jboyd13 wrote on Tuesday, February 07, 2017:

Hello everyone,

I tried to attach the screen shot and post it. But it did not work. So, I’m trying again. This is the final PHQ9 I developed with help from Sherwin. It will display the Total Score, update the Severity, and the answer to whether the Provider or Referral is needed, when the user clicks/selects the Total Score text box. If you do not answer all of the questions and any remain unassigned the Total Score will be incorrect and may even be negative. The plugin file is attached as well that has the code with the functionality. You can still change the answers manually if you want but any time you click the Total Score textbox the fields will update based on the 9 selected answers.

I hope it helps someone.

Joyce

system · February 8, 2017, 2:12am

jboyd13 wrote on Wednesday, February 08, 2017:

just in case you didn’t know… LBFPHQ9.plugin.php has to be saved into the …/openemr/sites/default/LBF folder. Do not change the name otherwise the system won’t use it.

All feedback is appreciated. This is for my DNP project.

system · February 8, 2017, 10:40am

bradymiller wrote on Wednesday, February 08, 2017:

Hi,

Very cool to see the power of customized LBF forms. We should store these forms somewhere so other users can expand and use them(this format of a plugin php, sql code, and screenshot is nice). My advice to make the form more use friendly would be to run the calculation whenever select an item on 1 of the selectors (and place code in the algorithm to only give a total score when all the items have been completed; and not allow editing of the total score, severity, and Refer entries since these should be automated values when the score gets calculated).

-brady
OpenEMR

system · February 10, 2017, 10:21pm

mh-olsen wrote on Friday, February 10, 2017:

Hi Sherwin,

I am further into my project and although I have disabled auto creation of a new encounter, I still must create an encounter to enter in new information for a form (PHQ-9). Is there any way around this?

Thanks,
Marisa

system · February 11, 2017, 5:16am

jboyd13 wrote on Saturday, February 11, 2017:

Hi

Thanks for the compliment and feedback. Sherwin provided the plugin and let me add to it. He is a great resource and teacher. I’m very grateful for his help and everyone’s support and assistance as well.

I’m demo’g the customized interface to my professors next Friday and have a few forms and features to create and customize. Wish me luck!

Thanks again,
Joyce

system · February 13, 2017, 2:19pm

jboyd13 wrote on Monday, February 13, 2017:

Hi all,

Sherwin helped me fix the issues with the plugin. It no longer produces negative numbers when the Total Score field populates and it displays all values even 0 on the Enc Summary. It has to wait till all values are entered before totalling the score. If you use the LBF read only option, it will not populate the fields at all. Is there another way to not allow editing of the Total Score, Severity, and Refer fields?

Thanks,

Joyce

system · February 13, 2017, 2:57pm

jboyd13 wrote on Monday, February 13, 2017:

Here is the new sql and screenshot.

system · February 15, 2017, 9:43am

bradymiller wrote on Wednesday, February 15, 2017:

Hi,

Javascript should be able to modify the readonly fields:

The current javascript gets enabled when click on the #form_total_score element. Perhaps disabling it breaks the click listener??? Feel free to post what the js looked like when tried to make the fields readonly.

-brady
OpenEMR

hitechelp · December 1, 2017, 1:13pm

Hello,

We would really like to be able to use this PHQ-9 form in addition to adapting its functionality for developing a GAD-7 form. Will it run on 4.2.0? If so, where can we find this code and how to implement it?

Regards,
David