Create Sub Databases
It would be greatly beneficial to be able to create additional databases within Wild Apricot for use by our Members. For example, as a writers organization, we would like to create a database our members could access to post the rights information for any stories they've written without having to use an outside service.
Karen Gottlieb commented
Any movement on this? I have about 8 orgs in Wild Apricot that are all academic groups and need a resource database option to hold member-only files and content. It needs to be fully searchable. Any tips on how to do this - or how to do a workaround??
Harvey Croze commented
Our Community Forest Association has a need that I believe falls under this sub-database table rubric. Contacts comprise both Members and Non-Members. Some Contacts from both subsets are dog-owners owning from 1 to n dogs. Each dog needs to be recorded with regard to several unique particulars: tag number, name, sex, breed/description, and date of expiry of rabies certificate. The date needs to be able to trigger an email reminder. The options for assigning common fields currently doesn’t allow structured entry of the dog-related-to-contact particulars.
I think a single solution could address both this idea and the classifieds idea (and many others!):
Support for a generic list that allows for:
- custom fields (like the contact/member fields, and a rich-text type field like blog post content)
- configurable permissions (who can submit, who can view, and if admin-approval is needed)
- display widget with search/sort/filter functionality and configurable fields
This is not unlike the base functionality behind Sharepoint lists.
Cathleen Blood commented
I would also like to create a resource database, that would be searchable like a member directory. We are a woman owned business networking group but there are many local resources that we want to point members to. Rather than a static page, it would be great to categorize and have a database. e.g. funding resources, classes, incubators, startup mentors, SBA centers etc... Because of the first name last name and email requirements, it is difficult to provide this using a membership level.
Stephanie Deschenes commented
I would like to add a database of potential resources for members that can be searched. For us specifically, I'd like to provide a database of potential science speakers that could be filtered by province, or by topic or by funding agency (for example)
For reference on my comment see:
We could use a separate database to track our publications. Since the essays that make up our issue are produced by one of our membertypes (Authors), relating them would be ideal as well. (Member record would show essays published, and which issue they appear in.)
But even a standalone db would be helpful, so that people looking to find an essay or issue could search by several fields (date, author, title, general subject, historical period, geographic or political region, etc.)
AdminEvgeny Zaritovskiy (VP Technology of Wild Apricot by Personify, Wild Apricot by Personify) commented
Hm, interesting. Can you then describe the whole setup in your mind? Are these 2 different websites, or one website where members login and have special access to create new content, like pages, etc.?