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

Function to pull in all of a patient's Pharmacies

Trading Post

Last Post by Anonymous 1 second ago

7 Posts

5 Users

0 Reactions

105 Views

RSS

DavidShower

(@davidshower)

Posts: 1255

Noble Member

Topic starter

Has anyone seen or created a function to return all the patient's pharmacies? REGPHARMACY() only pulls back the first pharmacy alphabetically from the patient's contacts. I'd like to use this on the Clinical Visit Summary handout.

Thanks,

David

OU-Tulsa

Posted : June 13, 2012 8:03 am

Anonymous

(@Anonymous)

Posts: 0

New Member Guest

David,

I think I've done this but don't have time to find the mel just now, but I recall that you can get it from the Businees object or table. there's a 'Pharmacies' object in the Business table (mldefs8) and you may be able to get started with something like this. I'll try to find the code and post later.

if getrow("Business",n, "ISPHARMACY") == "Y"

Posted : June 13, 2012 11:19 pm

DavidShower

(@davidshower)

Posts: 1255

Noble Member

Topic starter

Came up with this and it seems to work - thanks for the idea! I'd still like to see what you have if you find it.

{fn get_pharmacies()

{local a,c

local i = getRowCount('Business')

// Loop thru patients meds

while i > 0 do

i = i-1

a = getRow('Business',i,'searchName','Address1','Address2','City','State','Zip','primPhone','ISPHARMACY')

if a[1] <> "" and a[8] ="Y" then c=c+"|" + a[1] + " - " + a[2] + "" + a[3] + " " + a[4] + ", " + a[5] + " " + a[6] + " " + a[7] + HRET else "" endif

endwhile

if c=="" then return "None entered" else "" endif

local result=sort(getfield(c,"|",""))

local arr_size=size(result)

for a=1, a<arr_size, a=a+1

do

if result[a]==result[a+1] then remove(result,a+1) arr_size=arr_size-1 else "" endif

endfor

local result1 = str(result)

result1 = replacestr(result1,","," ")

return str(result1)

}}

{get_pharmacies()}

Posted : June 14, 2012 7:18 am

verlinep

(@verlinep)

Posts: 12

Eminent Member

Does this work in the Data display of a form?

If so can you send me a screen shot or the .dlg file

I am building a phone note and would love to display the patients pharmacies and addresses so that the phone staff can verifiy.

thanks

Verline Price RN BSN

[email protected]

Posted : March 18, 2013 5:11 am

Anonymous

(@Anonymous)

Posts: 0

New Member Guest

Have the same question about trying to pull a complete pharmacy list.

I've tried this function but results are always "none entered" even when there are pharmacies saved to the patients chart. Is there anything special needed to access the table 'business'?

Any suggestions would be appreciated.

Posted : August 10, 2013 11:31 am

lashca1

(@lashca1)

Posts: 13

Active Member

I would be interested in this as well so we could pull it in as a data display on the phone note. If you could send the mel or dlg file it would be greatly appreciated!!

Thanks

Christal

[email protected]

Posted : September 11, 2013 6:39 am

DavidShower

(@davidshower)

Posts: 1255

Noble Member

Topic starter

There seems to be a bug in that you have to go to the patient's registration tab before this will work in some instances. I believe it is a known issue with GE.

Posted : September 11, 2013 11:22 pm

Share:

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