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

Pull all future appointments

CPS, C-EMR, PM

Last Post by Anonymous 1 second ago

5 Posts

5 Users

0 Reactions

68 Views

RSS

t_murphy

(@t_murphy)

Posts: 6

Active Member

Topic starter

I am on CPS 12.0.13. I am looking for a formula that I can put in a letter that will pull all future scheduled appointments for a patient.

Does anyone have anything like that or have suggestions?

Thank You

TM

Posted : April 17, 2018 7:13 am

hermes

(@hermes)

Posts: 32

Eminent Member

Try using the function:

APPTS_BY_STATUS(status,[FULL]) where status can be "scheduled", "no show", "canceled", "arrived". If there is too much information, remove the "FULL"

Example: APPTS_BY_STATUS("scheduled", "FULL") will show all scheduled appointments.

Posted : April 17, 2018 7:41 am

tcross

(@tcross)

Posts: 165

Estimable Member

That is what we use as well and it works great although sometimes it will show past appointments for some reason regardless of the appointment status.

Posted : April 17, 2018 8:28 am

joeg1962

(@joeg1962)

Posts: 843

Noble Member

I have used something like this:

{global alist = getfield(APPTS_BY_STATUS("scheduled","FULL"),"\r","")
global asz = size(alist)
global tempa
global rslt=""
for count = 1, count < asz, count = count + 1
do
tempa = getfield(alist[count],",","")
days = DURATIONDAYS(str(._TODAYSDATE),tempa[1])
if days>0 then
rslt = rslt + tempa[1] + " at" + tempa[2] + " Type:" + tempa[3] + " with" + tempa[5]
else "" endif
endfor
rslt
}

which creates:

10/18/2018 at 10:00 AM Type: EF with Doctor X
04/04/2019 at 10:00 AM Type: PE with Doctor Y

By the way, my coding does a date check to only get future appointments. I too sometimes saw past appointments.

Posted : April 17, 2018 11:50 pm

rwilliams

(@rwilliams)

Posts: 454

Honorable Member

I have the below function that I wrote which is used to display the information in a form.
fn futureAppts(){ local apptList local i local date


	apptList = getfield(APPTS_BY_STATUS("scheduled", "FULL"), HRET, HRET)
	for i = 1, i 0) then

			//Remove past appointments that are still in "Scheduled" status

			apptList = remove(apptList, i)

			i = i - 1

		endif

	endfor

return str(apptList, HRET) }

Posted : April 18, 2018 4:07 am

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