Tracking Guest Pass Check-Ins
I was wondering if there is a way to track guest pass check-ins? Is there a report you can print off with the member who used them and the guest for which they were used?
Thanks,
Steven
I was wondering if there is a way to track guest pass check-ins? Is there a report you can print off with the member who used them and the guest for which they were used?
Thanks,
Steven
Comments
Funny, I could have sworn there was... but I just looked and there isn't!
Here is a custom report you can drop in... go to Data Entry -> View -> Reports -> Custom SQL Report. Create a new report, name it, and drop in this code. I'll add this as a general report in the future.
select postdate as Date, (select (concat(lastname, ", ", firstname, " ", middlename)) from customers where customers.customer_id=gp.for_customer_id) as Guest,
(select (concat(lastname, ", ", firstname, " ", middlename)) from customers where customers.customer_id=gp.from_customer_id) as Member,
(select (concat(lastname, ", ", firstname, " ", middlename)) from customers where customers.customer_id=gp.employee_id) as Employee
from guest_passes gp where gp.postdate>='{STARTDATE}' and gp.postdate<='{ENDDATE}';
Please sign in to leave a comment.