So in my handout I have it so that the appt status on the handout will not populate if it has been cancelled using this
{apptschd = APPTS_BY_STATUS("scheduled","FULL")
apptpfrAC =APPTS_BY_STATUS("PFR (A-C)","FULL")
apptpfrDG =APPTS_BY_STATUS("PFR (D-G)","FULL")
apptpfrHK =APPTS_BY_STATUS("PFR (H-K)","FULL")
apptpfrLM =APPTS_BY_STATUS("PFR (L-M)","FULL")
apptpfrNR =APPTS_BY_STATUS("PFR (N-R)","FULL")
apptpfrSZ =APPTS_BY_STATUS("PFR (S-Z)","FULL")
apptCNaetna =APPTS_BY_STATUS("Case Needed-Aetna","FULL")
apptCNauto =APPTS_BY_STATUS("Case Needed-Auto Accident","FULL")
apptCNIMR =APPTS_BY_STATUS("Case Needed-IMR","FULL")
apptCNLia =APPTS_BY_STATUS("Case Needed-Liability","FULL")
apptCNMDA =APPTS_BY_STATUS("Case Needed-MDA","FULL")
apptCNmcaid =APPTS_BY_STATUS("Case Needed-Medicaid","FULL")
apptCNwcomp =APPTS_BY_STATUS("Case Needed-Workers Comp","FULL")
apptCNOther =APPTS_BY_STATUS("Case Needed-Other","FULL")
apptmcaidIDneed =APPTS_BY_STATUS("Medicaid Plan _PCP ID Needed","FULL")
appts = ""
if apptschd = "<None>" then
else
appts = appts + apptschd
endif
if apptpfrAC = "<None>" then
else
appts = appts + apptpfrAC
endif
if apptpfrDG = "<None>" then
else
appts = appts + apptpfrDG
endif
if apptpfrHK = "<None>" then
else
appts = appts + apptpfrHK
endif
if apptpfrLM = "<None>" then
else
appts = appts + apptpfrLM
endif
if apptpfrNR = "<None>" then
else
appts = appts + apptpfrNR
endif
if apptpfrSZ = "<None>" then
else
appts = appts + apptpfrSZ
endif
if apptCNaetna = "<None>" then
else
appts = appts + apptCNaetna
endif
if apptCNauto = "<None>" then
else
appts = appts + apptCNauto
endif
if apptCNIMR = "<None>" then
else
appts = appts + apptCNIMR
endif
if apptCNLia = "<None>" then
else
appts = appts + apptCNLia
endif
if apptCNMDA = "<None>" then
else
appts = appts + apptCNMDA
endif
if apptCNmcaid = "<None>" then
else
appts = appts + apptCNmcaid
endif
if apptCNwcomp = "<None>" then
else
appts = appts + apptCNwcomp
endif
if apptCNOther = "<None>" then
else
appts = appts + apptCNOther
endif
if apptmcaidIDneed = "<None>" then
else
appts = appts + apptmcaidIDneed
endif
tody = str(._todaysdate)
if appts <> "" then
apptslist = getfield(appts, "\n", "")
sz = size(apptslist)
list = ""
for i = 1, i <= sz, i = i + 1 do
dt = ""
dur = ""
appt = apptslist[i]
apptsize = size(appt)
if apptsize > 0 then
dt = sub(appt, 1, 10)
dur = durationdays(tody, dt)
if dur > 0 then
list = list + appt + "\n\r"
endif
endif
endfor
if list <> "" then list else "No appointments scheduled." endif
else
"No appointments."
endif}
But I cannot get the cancelled appt's to stop showing because they are not considered appt by status they are appt cancel. Does anyone know how to do the same for them?