Automation request tracker and idea repository
Build a tenant-gated web app where people submit ideas for automations and track them on a kanban board, from raw idea through to fully automated. It's for members of a 3B space to crowdsource and prioritize automation work, and every write should be attributed to the caller's authenticated account. Trigger it as a browser-opened webpage at a route like /automation-ideas, gated so only authenticated members can reach it (tenant/space auth). No cron, email, or upstream trigger. Build two steps: A React web app that renders the whole UI instantly and talks to the API over fetch. It has two views: a submission form (title, description, submitter, team, priority, estimated time saved) and a four-column kanban board (Idea Submitted → Needs Builder → In Progress → Automated). Support moving cards between columns, one-vote-per-person upvoting (toggleable), sorting by votes or newest, and a card detail view showing all fields plus who last moved it. Give it a distinctive, polished aesthetic. A JSON API step at a route like /automation-ideas/api that handles GET (list all ideas with vote counts) and POST (create / move / upvote). Persist everything to a SQLite database on a named volume, mounted read-write and exclusive so concurrent submissions, moves, and votes never clash. Read the actor's identity from the spoof-proof authenticated-email header. Include an API contract file. No external services or notifications — it's read-write only to its own storage. If you later want alerts when a new idea lands, you could post to Slack (or your team's chat tool), but that's optional.
What this prompt builds
A tenant-gated web app that lets teams submit, track, and vote on automation ideas through a kanban board, from raw idea to fully automated. Submissions are attributed to authenticated users, and all data persists to SQLite on a named volume. The workflow prevents duplicate automation efforts, encourages collaboration, and provides visibility into what is being automated across the organization.
The problem
Teams building automations in a decentralized environment often duplicate efforts or build in isolation, creating shadow AI and wasted work. This workflow creates a centralized repository where anyone can submit automation ideas, see what's already been requested, and track progress from idea through to completion. Users can vote on requests, assign themselves as builders, and move items through a kanban board, giving both builders and stakeholders full visibility into the automation backlog and preventing redundant work.
Solution and impact
The workflow delivers a polished, tenant-gated web app with a submission form and four-column kanban board that supports upvoting, sorting, and real-time progress tracking. Because every submission and action is attributed to an authenticated user and persisted to SQLite, teams gain a single source of truth for automation work. This eliminates duplicate efforts, encourages cross-team collaboration, and stops shadow AI from proliferating untracked across the organization.