My idea of a public database,
stated in another thread I made is an extension of this idea. We don't necessarily need a programmer, as something like Google Drive can be used as a public database, but we do need to do a little bit of work to secure it, i.e., we can't just let everyone be able to delete and move files, for obvious reasons. I asked ChatGPT about possible solutions:
i want to use a cloud file mgr like google drive to gather info collaboratively with others in a community, ie. everyone will be able to contribute data, but the only way i can see doing this in a secure way is if everyone has create priveleges only, but no delete or move priveleges. Because if everyone has full access a troll can just come in and delete a bunhc of things or disorganize them
You're absolutely right to think about this kind of protection ahead of time—open collaboration is awesome, but it does need guardrails to avoid chaos or trolling.
Unfortunately, most mainstream cloud file managers (like Google Drive, Dropbox, OneDrive) don’t natively offer granular permissions like
“create-only, no delete or move”. It’s usually
view,
comment, or
edit—and “edit” includes rename, delete, move, etc.
However, here are some approaches and workarounds you can consider:
---
Option 1: Google Drive + Upload Form (Best for structured contribution)
Use a
Google Form linked to a
Google Sheet, and/or allow file uploads via the form.
-
Pros: No one can delete or see others' uploads. You can review and sort contributions yourself.
-
Cons: Not a real-time file manager; more of a submission system.
Steps:
1. Create a Google Form with an upload field.
2. In settings, allow only uploads from people within the org (or public if needed).
3. Set a Google Drive folder to collect those uploads.
---
Option 2: Shared Upload Folder + Automation
Use a shared Google Drive folder with
"Anyone with link can upload" using
upload[/i]forms/868402172503]file request tools or third-party apps like:
-
File Request Pro
-
Fileinbox
-
UploadDrop
These can route uploads into a folder
you control. Users can upload, but can't delete or rename.
---
Option 3: Use a real-time collaborative database or CMS
If you're collecting structured information (text, links, etc.), consider:
-
Airtable – Create forms for submission; you control view/edit/delete rights.
-
Notion – With granular permissions (but still limited in restricting deletion).
-
Fission / IPFS – More advanced, decentralized control.
---
Option 4: Git-based system with Pull Requests
If you're working with data or files where version control matters (e.g. a community knowledge base):
- Use
GitHub or
GitLab, where people can submit files via pull requests.
- You or trusted moderators merge them.
- Zero risk of deletion or disorganization.
---
What doesn’t work well (based on your needs):
-
Direct Google Drive shared folders: Even if people just upload, they can delete or move unless you only give "viewer" or "commenter" access.
-
Dropbox shared folders: Same issue with full access leading to trolling potential.
---
Would you like help setting up one of these systems, or tailoring one for a specific kind of data (e.g. photos, PDFs, URLs, etc.)?
Haven't analyzed its ideas yet, but I wanted to get this out ehre cuz I think it's a top priority.