Hello, I am looking to make some fairly simple modifications to the way the calender displays. Primarily, I would like to modify the information displayed by each appointment to include an additional field I have created for appointment reminders. If someone could point me in the right direction as to the location of the script that generates the appointment descriptions on the calender it would be greatly appreciated. Thank you.
I modified the 2nd SQL statement in “function &postcalendar_userapi_pcQueryEvents($args)”
Change SQL
from: “concat(pd.lname,’, ‘,pd.fname) as patient_name, "
to: "concat(pd.lname,’, ',pd.fname, ’ ') as patient_name,”
My modification above displays the patient name with the “pubpid” (not always same as PID in my case) and the custom field (“genericname1”) on the calendar like so:
“White, Walter (New Patient)”
You can add any fields that you like from the table patient_data but “pubpid” and “genericname1” were my choice.