[Koha] Alerts for every Nth check out

Cab Vinton bibliwho at gmail.com
Tue Sep 10 02:27:31 NZST 2019

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,

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 at 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

More information about the Koha mailing list