Create Sub Databases
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.
-
No changes, and unlikely they will be anytime soon, it's pretty unique usecase and not very common. Sorry about that.
-
Kyl Watson commented
Has there been any changes to this? I would like to be able to store a table of data for our members. We are a dog club and members have dogs with information that needs to be pulled into forms. A sub table options would be ideal. My next best option is to setup an api call to another 3rd party database and look rows up by member id. It would be nice to not need this. Alternatively, I am considering just storing the data in a multiline field as a json but I am concerned with the 3000 character limit.
-
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.
-
Tara commented
I think a single solution could address both this idea and the classifieds idea (and many others!):
https://forums.wildapricot.com/forums/308932-wishlist/suggestions/8825566-classifieds-gadget-i-e-job-board?page=1&per_page=20Support 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 fieldsThis 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)
-
groovamatic commented
For reference on my comment see:
-
groovamatic commented
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.)
-
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.?