My organization has a library that we allow members to check out from every month. With that said I was hoping for 2 things.
1) an inventory database to keep track of our media (I can see this also being useful for other things such as equipment we own or donation items we get and then give)
2) the capability to connect members to an item. this would allow us to track who checked something out and automatically send out reminder emails to members and what they have checked out (currently this is all done my hand each month and the library has a separate excel doc with emails and information which is already in WA)
If these 2 things aren't possible I'm hoping for at least a connection to a MySQL database possible.
Ken Wallewein commented
This general concept could be used in a lot of ways!
I have an application for pet (dog) rescue, wherein people could adopt dogs or put them up for adoption.
All sorts of things would be possible if there were an independent object database with its own primary key and attributes, that could be linked to members 1-to-1 and searched.
John Collins commented
We would like a way to list an inventory of books and tools. Functionality of loaning (check out/in books) could come later.
Jeanne Huber commented
We, too, would love a way to link membership to an inventory system of books and tools.
We have a book library and an equipment/tool library. It would be nice to be able to have these assets online and to be able to track them with WA
Could an inventory database serve the purpose of class tracking? Set up classes as product and product type with description, hours, CEU, and then run reports by member, date, etc to see what they have "purchased" then use that to create reports, or transcripts.
We also need database functionality. We are a publisher and have 800 essays that we would like to post in a searchable index. They are currently displayed as tables (1992-style).
Evgeny Zaritovskiy commented
We haven't considered this request yet. I do not see any workaround with WA functionality now, you will have to track it manually somehow.
I am with EAA Chapter 582 in Toledo, Ohio. We are implementing Wild Apricot soon.
The next thing I would like to attempt is an inventory list. Let me explain. In our club we have numerous assets to lend ranging from hand tools, tables and chairs, to a rather large mobile gas grill. Most of this stuff is available for the members to borrow and some of it is not. What we would like to do is build an inventory list of what we have and then have a “form,” to fill out if a person wants to borrow it. The fields required would be rather simple. Whom borrowed what, and when, and then when it would be returned.
My question to you is have you thought of this type of requirement for inventory and can you provide me with guidance with how to go about setting something like this up?
Paul L. Kush commented
This approach could be useful for my M&A Professionals Association if we could utilize it for business listings that are available for sale. Listings information are businesses for sale, a description, revenue, EBITDA, year founded, location, who to contact, etc.
Nice if I could link the listing to the members record.
Jarren Kinch commented
My organization has the same need!
I don't know if this would be the proper thread for my wishlist item. We currently have an online store, and were wondering if there was a way that we could automatically keep track of inventory so that we would know how many items we still have remaining. I know there is a program out there, like virtuemart and others that you can download but they all use php.
Evgeny Zaritovskiy commented
I'm sure this is not something we are going to get into soon. This is very specific request so I want to collect more comments in this thread before going into analysis.
And, unfortunately, there is no way to provide a connection to external MySQL database.