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

List number of no show appointments in banner

CPS, C-EMR, PM

Last Post by Anonymous 1 second ago

10 Posts

2 Users

0 Reactions

76 Views

RSS

chicks

(@chicks)

Posts: 31

Eminent Member

Topic starter

Hello.
I can use the following to list the number of no shows for a patient in the banner if they have a no show:
{global alist = getfield(APPTS_BY_STATUS("no show","FULL"),"\r","")
global asz = size(alist)
global tempa
global rslt=""
for count = 1, count < 4, count = count + 1
do
tempa = getfield(alist[count],",","")
days = DURATIONDAYS(str(._TODAYSDATE),tempa[1])
if days<0 then
rslt = count + "-NS"
else " " endif
endfor
rslt
}

The issue is when the patient has 0 no shows, I receive Bad Value or Bad Index error message in the banner. I believe the error message is because the value it is looking for is not there. Thoughts??

Posted : January 10, 2020 8:48 am

DavidShower

(@davidshower)

Posts: 1255

Noble Member

Just wrap everything after your first line in an if/then and if the first variable is empty, return a string indicating no no-shows, otherwise execute your code.

Posted : January 10, 2020 12:11 pm

chicks

(@chicks)

Posts: 31

Eminent Member

Topic starter

{global alist = getfield(APPTS_BY_STATUS("NO SHOW","FULL"),"\r","")
if APPTS_BY_STATUS("NO SHOW","FULL")"" then
global asz = size(alist)
global tempa
global rslt=""
for count = 1, count < 4, count = count + 1
do
tempa = getfield(alist[count],",","")
days = DURATIONDAYS(str(._TODAYSDATE),tempa[1])
if days<0 then
rslt = count + "-NS"
else "" endif
endfor
endif
rslt
}

Still not working. Do you see what I am missing?

Posted : January 13, 2020 7:50 am

DavidShower

(@davidshower)

Posts: 1255

Noble Member

Looks like this line should be:

if APPTS_BY_STATUS("NO SHOW","FULL") <> "" then

rather than

if APPTS_BY_STATUS("NO SHOW","FULL")"" then

Posted : January 13, 2020 9:00 am

chicks

(@chicks)

Posts: 31

Eminent Member

Topic starter

{global alist = getfield(APPTS_BY_STATUS("no show","FULL"),"\r","")
global asz = size(alist)if APPTS_BY_STATUS("no show","FULL")<1 then
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 = count + "-NS"
else "" endif
endfor
rslt
else "" endif
}

This code works, I just need it to look at the previous 18 months (approx 540 days) instead of every no show the patient has ever had.

Posted : January 16, 2020 4:01 am

DavidShower

(@davidshower)

Posts: 1255

Noble Member

You could do this:

if days< 0 and days > -540 then

Or you could swap the items in DURANTIONDAYS if you wanted to work with positive numbers.

Posted : January 16, 2020 4:58 am

chicks

(@chicks)

Posts: 31

Eminent Member

Topic starter

{global alist = getfield(APPTS_BY_STATUS("no show","FULL"),"\r","")
global asz = size(alist)if APPTS_BY_STATUS("no show","FULL")<1 then
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 -540 then
rslt = count + "-NS"
else "" endif
endfor
rslt
else "" endif
}
the above gives me all no shows

{global alist = getfield(APPTS_BY_STATUS("no show","FULL"),"\r","")
global asz = size(alist)if APPTS_BY_STATUS("no show","FULL")<1 then
global tempa
global rslt=""
for count = 1, count < asz, count = count + 1
do
tempa = getfield(alist[count],",","")
days = DURATIONDAYS(tempa[1],str(._TODAYSDATE))
if days 540 then
rslt = count + "-NS"
else "" endif
endfor
rslt
else "" endif
}

The above shows 0 no shows

Posted : January 16, 2020 10:48 am

DavidShower

(@davidshower)

Posts: 1255

Noble Member

This code:

days = DURATIONDAYS(tempa[1],str(._TODAYSDATE))

Sets the variable "days" to the difference between the date of the appointment from APPTS_BY_STATUS and today's date. If the appointment date is less than today's date, you get a positive number.

This code:

if days 540 then

doesn't do anything. It MIGHT evaluate to TRUE is the appointment was 540 days earlier than today's date. The code needs to say that if the number returned is greater than 0 and less than or equal to 540 do something with it:

if days <= 540 and days > 0 then

This catches all your no show appointments that are within 540 days prior to today's date.

Also, your counting logic only works if the appointments are returned newest to oldest. You might want to verify that.

Posted : January 16, 2020 12:52 pm

chicks

(@chicks)

Posts: 31

Eminent Member

Topic starter

You are absolutely correct David. I want to look at my appts newest to oldest but it is looking at the oldest to newest. How do I change the way it is counting? I appreciate you staying with me and helping me. Have a great one.

Posted : January 17, 2020 10:50 am

DavidShower

(@davidshower)

Posts: 1255

Noble Member

So try this for the end of your code:

if days <= 540 and days > 0 then
rslt = rslt + 1
else "" endif
endfor
return rslt + "-NS"

That should increment rslt every time it finds one of the appointments you want to count, then at the end returns that total and appends the -NS string. Also, it looks like you have a stray else "" endif at the end of your code. I don't see an if that pairs with it.

Good Luck!

Posted : January 17, 2020 11:41 am

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