Notifications
Clear all
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
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
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
