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

Listbox Provider list

Trading Post

Last Post by mikeseale 12 years ago

3 Posts

3 Users

0 Reactions

100 Views

RSS

Anonymous

(@Anonymous)

Posts: 0

New Member Guest

Topic starter

In every office note we use we have a CC line (Carbon Copy) so our Receptionists know who to send a copy of the note to

Right now it's just a text line they can type into and it pulls forward on each visit but I'm being asked to have a dropdown or listbox style function with MD names in it so they don't misspell them

My old EMR allowed me to create a list box / unlimited characters but GE only allows the 2000 character limit and we have LOTS of referring MDs

I'm looking for maybe a way to pull in the "Referring Provider" list of names from PM or even maybe the "Service Providers" list of name

Posted : March 13, 2013 12:06 am

jfitzmd

(@jfitzmd)

Posts: 419

Reputable Member

Not a simple problem. I have solved it by extracting the referring MD list from the DoctorFacility table with a SQL query into a text file using VB Script which runs every N minutes. I extract from names from this file limiting the size of the text by having a filter on the initial characters in the physician name and listing only 25 physicians. If you are interested in the details, contact me, [email protected].

Posted : May 3, 2013 9:20 am

mikeseale

(@mikeseale)

Posts: 344

Reputable Member

I use getrow() to get the Service Providers. There is a Object in mldefs3.txt that has _ServiceProviders that you can use to pull all service providers listed in your database. Here is the function I'm currently using:

{fn ServProvs()
{
 	local a = getrowcount("_ServiceProviders")
 	local temp = ""
	local ret = ""
 	for i = 0, i < a, i = i + 1
	do
 		temp = getrow("_ServiceProviders",i,"ProvLastName","ProvFirstName")
		if ((temp[1] == "") AND (temp[2] == "")) then
			continue
		endif
		if (ret <> "") then
 		  ret = ret + ","
 		endif
		cond
			case ((temp[1] <> "") AND (temp[2] <> ""))
				ret = ret + replacestr(temp[1], ",", ";") + " " + replacestr(temp[2], ",", ";")
			case (temp[1] <> "")
				ret = ret + replacestr(temp[1], ",", ";")
			case (temp[2] <> "")
				ret = ret + replacestr(temp[2], ",", ";")
			else
				//not sure how we got here
				continue
		endcond
 	endfor
 	return ret
}}

And you just make your drop down dynamic and put ServProvs() as the function at the bottom. If you want to be specific on which types of service providers you pull (i.e. only active ones), you'll need to modify the function a bit. I also strip out all the commas from the names and replace them with ";".

My database only had about 405 listed in the service providers table, so if you are running into a character limit for your drop down, you may need to check size(ret) and make sure it still has room before switching to another variable. I didn't have that problem.

Posted : May 5, 2013 11:42 pm

Share:

24 Forums
9,940 Topics
39.9 K Posts
7 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