Database for things that members own
I have been tasked with adding a special database to our Wild Apricot site.
We need to list details of the boats that our members own and I would dearly
like them to be able to update the info on their boat themselves (it will
save me a lot of work!).
I would like to have quite a large number (around 30) customisable fields,
some with free text entry and some with drop down menu choices.
I need to add at least one photo, preferably more, to each record.
It needs to be searchable on any field.
There would ideally be a link between the boat and its current owner but there must
be provision for transferring a boat to another person : new, existing or non
member. I think this would need to be an administrator only job.
According to WA tech support (Jim Sympathy) this could be achieved by adding 'boat' related fields to a members profile but this would create problems when a boat is sold.
I can't believe that there are not other organisations that use WA that don't have a similar requirement (far too many negatives in that sentence!)
Cheers ... Kevin
Rick Etsell commented
I should mention that WA does have the capability to implement single sign-on service. See https://gethelp.wildapricot.com/en/articles/200-single-sign-on-service.
We may do that eventually, but the fact is most of our members have no desire to edit their own boat information and photos. We are small enough that they can just email me their particulars and I configure their "Yacht Register" page for them. So very few actually have a login ID for our Drupal site.
Thanks for your comments Rick Estell! We were thinking of utilizing two separate sites, but maintaining two separate member logins was a “no go”. WIX now allows for membership sites and their WISWIG editor is pretty impressive and you can’t beat the cost. Unfortunately there is currently no way to import our member info so we’re keeping an eye out to see if/when it will be implemented.
Rick Etsell commented
We maintain a separate Drupal website with boat information, and then provide a url field in the WA database to link each member to a boat on the website. That way owners can change boats, etc. As Evgeny says, its seems like this would be like adding a whole separate membership database. I’d be surprised if it would be worthwhile for WA to do. The biggest limitation with our system is that members need separate login credentials for each site. Our next step is probably to abandon the WA side and incorporate membership into our Drupal site. See https:classicyacht.org
I have a very similar need. We would like to create a database where a single contact could register informaiton about the dogs they own. This would be a one-to-many relationship since one member might own several dogs they own. We would also like to track show information about each dog, so again this would be a one-to-many relationship since any given dog could have many show records.
This may be also related to http://forums.wildapricot.com/error-notfound
Thanks for the suggestion - we've been thinking about this for some time but haven't come to any conclusion yet. From your points above I can see one scenario - keeping database of boats (or, generally speaking - any type of item) that members themselves can update, add new items, delete old ones, etc.
This is somewhat similar to membership database itself
* form with fields need to be defined (= membership fields)
* users need to be able to add new boats (= membership application)
* users need to be able to update boat profile (= login and update own profile)
* users need to be able to search (= membership directory)
This is quite a change in the system but I like the general idea of having that - not just for boats but for any kind of items.
Any other has comments on this? Any real life examples except boats that can benefit this kind of change in the system?
Richard Clayton commented
Just in the process of moving our UK Sailing Club onto WA, and have exactly the same need, so would be most interested in following this thread.
Richard Clayton, Commodore, Ardleigh Sailing Club