I want to crowd-source the creation of a database of chocolate companies.
I have a bunch of lists that I can upload to seed the database, and I am looking to enable my members to add to it and to suggest updates.
I know I can use Aparna to create a new database table for a module and then use the form designer to create the "Create" and "Update" forms, but I not a good enough programmer to be able to write the code to display and manipulate the contents.
The page would be visible to visitors (not logged in).
The table needs to be searchable (search scoped to this one table).
The table needs to be sortable.
Not all columns would be displayed.
Hidden content would be shown by expanding and collapsing the DOM.
Some companies will have multiple locations.
Only members who are logged in would be allowed to enter a new company.
All new entries would be flagged for review before being visible.
Anyone (visitor or member) would be able to suggest an update to an entry. The update suggestions are only available to admins.
Content would be downloadable only to members of specific quotas.
It would be nice to be able to interface to a mapping API to display the company on a map.
It would be nice to link this to Rating, Like-It, ShareThis, and Comments modules.
It would be nice if people could upload photos.
It would be nice if we could create a separate table of products each company makes.
Thoughts?
Has anyone already done something like this? I do have a modest budget to pay someone to adapt what they have already done the basics or I would be happy to partner with someone to do this and then rev-share selling it through the Marketplace.
TIA.
updated by @claygordon: 07/06/16 12:20:45AM