Asana

Promptfree, for everyone, and the only version there is

Open the prompt in Claude CodeOpen the prompt in CodexOpen the prompt in Cursor

Copy

Build me a task tracker for one team, with the two views people actually use.

STACK
- Astro with a Node adapter, SQLite via better-sqlite3, server-rendered
- Small JavaScript islands for drag and drop only

THE MODEL
- Project, section, task, subtask; a task has assignee, due date, status and a description
- Custom fields per project: text, number, select, date — stored typed, never as strings
- Every change appended to an activity table: who, when, field, before, after

VIEWS
- List grouped by section, and board grouped by any select field
- Filters belong to the view and are shareable as a URL

DATES
- Due dates are calendar dates without times; store them as text, not as timestamps, and say why in the README
- A start date and a due date give a timeline bar; render the timeline as inline SVG

RULES, KEPT SMALL
- One trigger, one action: when status becomes X, set field Y or assign to Z
- Rules run server-side after the write, and their effects are logged as activity by the rule, not the user

NOTIFICATIONS
- A daily digest per person of what changed on tasks they own or follow
- No instant emails; the README should explain that this is deliberate

WHAT IS OUT OF SCOPE
- Portfolios, goals, workload, mobile apps

Include a README on the activity table, the rule engine's limits, and CSV export.