Holly,
I think the simplest solution would be to run a script on a nightly cron
that updated the database as necessary. Flip the Juvenile flag, change
their profile, possibly remove the grouping/ident2_value, and add an
alert. I thought we might be running something like that ourselves, but
either I'm not finding it, or it's just something we'd also talked about
doing but never did.
Justin
On 6/10/15 3:00 PM, Holly Brennan wrote:
We’d like to be alerted when a patron who was marked as juvenile (the
checkbox based on their birth date) is now over 18. The goal would be
to catch those now-adults and change their library card type from
Juvenile to Adult, so they are now responsible for their library card
rather than their parent. We would also enter their ID information,
and remove the parent’s ID (typically their driver’s license).
The staff notification could be just a alert message. We’d like to
avoid having to look at an expired account and calculate whether that
patron is now an adult, so please no solutions involving math. J
We’ve run a report for patrons who have Juvenile accounts but are 18+,
and there are hundreds. I’m guessing we’re on our own fixing these
ones, but maybe there is a miracle out there for adding the alert to
these accounts too?
Thanks!
Holly Brennan
Library Technology Specialist
Homer Public Library, Alaska
[email protected]
907-235-3180 (main)
907-435-3154 (direct)
