Good day,
I am trying to create a company "library" of training material (ie: books, CD's, Periodicals, etc) with the ability for the user to request borrowing the training resources. My basic idea would be to have several columns including "Media Type" (book, CD, etc), "Title", "Borrowed" (True/False), and "Request Resource". I would like the "Request Resource" column to have a button (or similar) for each resource that would do two things; the first thing would be to check to see if the "Borrowed" status is yes, and if so, to display a message that the resource is unavailable. If the resource is currently available it should enable the "Borrowed" status. The second function is if the resource is available (the borrowed status is false) it should send an email (to a set email address) with the name of the training resource requested and also include the username of the requestor.
If the "borrowed" check is looking for a bit too much out of this module, then I'd be satisfied with just an email to a specified address with the name of the requested training resource.
Is any of this possible with this module, and if not, any suggestions? I have been looking for months for something like this and can't find anything suitable.
Thanks for any help/assistance you can provide!
- Joe