My first thought was to run a daily report using the MOD function on the total number of checkouts, i.e., MOD(30,10) = 0, MOD(120,10) = 0, etc. Unfortunately, patrons often don't check out just one item at a time, so you'd miss many cases if you only flagged patrons whose issues count was an exact multiple of 10. The count may have increased from 117 to 126, for example. But I think the DIV (quotient) function should work. I believe DIV(n, 10) increases by one with every multiple of 10, so the report would simply have to find cases where DIV([total checkouts], 10) increased over the previous day. Don't have time to test this, but perhaps you or someone else can test some code to see if this is on the right track. We have a 1000 Books Before Kindergarten program here & would like to honor other heavy borrowers as well, so this type of report would certainly be of interest to us. Best of luck, Cab Vinton, Director Plaistow Public Library Plaistow, NH On Tue, Sep 3, 2019 at 1:27 AM sriharsha <srimaiya@gmail.com> wrote:
Hi,
I am trying to set up Koha for local kid's library in my town. I would like to know if it is possible for Koha to alert staff members when a patron checks out every 10th book?
ie, someway for staff to know that John Smith is checking out 10th/20th/30th ... book? We would like to reward such patron.
Thank you, Sri