Welcome to the NEW CHUG— your ultimate destination for cutting-edge insights and discussions at the intersection of healthcare and technology.

Our platform is dedicated to exploring the dynamic landscape of healthcare technology, empowering professionals, enthusiasts, and innovators alike with the knowledge and resources to navigate the rapidly evolving field.

From telemedicine revolutionizing patient care to the transformative potential of artificial intelligence in diagnostics, we delve into a myriad of topics shaping the future of healthcare delivery. Whether you’re a seasoned healthcare IT professional, an aspiring entrepreneur in the digital health space, or simply curious about the latest innovations, our curated content, expert interviews, and thought-provoking articles provide a comprehensive exploration of healthcare technology’s most pressing issues.

Join us as we navigate the forefront of innovation, driving forward the transformation of healthcare for a healthier, more connected world.

Have questions or suggestions? Please use the contact button below.

Notifications

Clear all

Dynamic dropdown list function

MEL, SQL, Oracle

Last Post by Anonymous 1 second ago

5 Posts

5 Users

0 Reactions

88 Views

RSS

mvolkert

(@mvolkert)

Posts: 143

Reputable Member

Topic starter

We have dozens of forms that require the user to select a specific providers initials from a drop down list and that selection determines the results of a bunch of other functions. Anytime we add or drop a provider I have to go into each form and edit the drop down list manually. Could anyone tell me of a way to create the list once, maybe in the function library, and then have each form populate the correct drop down options. Thank you!

Posted : September 16, 2016 7:47 am

jfitzmd

(@jfitzmd)

Posts: 419

Reputable Member

I've used a text files that is read at the time of form load which populates the dropdown. The text file is on a shared drive. This requires the text file to be maintained only once. Be glad to share the code with you.

The second more elegant approach is to directly query the USRINFO table and retrieve all physicians. This is done by creating an appropriate SQL query and calling an exe via a RunTextProcess() the queries the database and returns the list. The advantage of the approach is that it can be used to retrieve any information from the Centricity database and it does not require any text file maintenance. The disadvantage is that you must be able to create the appropriate SQL statement. The other disadvantage is that it introduces one more element of complexity in maintaining Centricity versions in that the exe must be located in the Client directory. I would be glad to furnish the code to you or demonstrate it. Feel free to contact me directly.

Posted : September 16, 2016 8:06 am

jsander

(@jsander)

Posts: 108

Estimable Member

I do something similar in VFE that shows the user a list of login names for everyone who is a Provider. Our login names look like "asmith" so it's easy to see who is who. In this example, the Location of Care is NFWC.

I check the "Dynamic choice list" option in a dropdown list. The MEL expression is

{GET_USER_LIST("NFWC","Provider","comma")}

Posted : September 16, 2016 9:26 am

ken.takenaka

(@ken-takenaka)

Posts: 212

Reputable Member

I would love to see this code John. Would you mind sharing? My email is [email protected]

Posted : September 19, 2016 10:37 am

hintona

(@hintona)

Posts: 36

Trusted Member

I would love to see this code too, John. My email is [email protected]

Thank you in advance!

Posted : December 21, 2016 2:41 am

Share:

24 Forums
9,940 Topics
39.9 K Posts
5 Online
6,470 Members

Forum Icons: Forum contains no unread posts Forum contains unread posts

Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

Powered by wpForo Powered by wpForo version 2.4.0