PMS Task Addition (Bug & Feature)
Streamlined workflow for logging PMS bugs AND features to GitHub and Google Sheets.
Trigger
User message contains:
- - "PMS Bug addition" → Creates a BUG report
- "PMS Feature addition" → Creates a FEATURE request
Workflow
1. Determine Task Type
Based on trigger phrase:
| Trigger | Type | GitHub Label | Sheet Task Type |
|---|
| "PMS Bug addition" | Bug | INLINECODE0 | INLINECODE1 |
| "PMS Feature addition" |
Feature |
enhancement |
Feature |
2. Collect Task Information
Ask the user for (if not provided):
- - Title: Brief summary
- Description: What's happening (bug) or what's needed (feature)
- Reproduction Steps: (Bugs only) How to reproduce
- Expected Outcome: What should happen
- Priority: P0 (Critical) / P1 (High) / P2 (Medium) / P3 (Low)
3. Create GitHub Issue
For BUGS:
CODEBLOCK0
For FEATURES:
CODEBLOCK1
Capture the issue URL from output for the sheet.
4. Update PMS Task Tracker Sheet
Sheet ID: 1O07SzGzQa2FwpkBE7h2SUDWZlxsUpz8DxCpyxKjRi8U
Tab: INLINECODE5
Column Mapping (A-K)
| Col | Name | Value |
|---|
| A | Task ID | INLINECODE6 (increment from last entry) |
| B |
Description | Issue title |
| C | Reporter |
Tara Singh Kharwad |
| D | Date Submitted |
DD/MM/YYYY (issue creation date) |
| E | Status |
New |
| F | Task type |
Issue (bug) /
Feature (enhancement) /
Testing |
| G | Priority |
Critical (P0) /
High (P1) /
Medium (P2) /
Low (P3) |
| H | Assigned To |
tarasinghrajput7261@gmail.com |
| I | Resolution Notes | GitHub issue URL |
| J | Resolution Date | (empty until closed) |
| K | Took Help from Roshan | (leave empty - Tara fills manually) |
Label to Sheet Mapping
| GitHub Label | Task Type | Priority |
|---|
| bug | Issue | - |
| enhancement |
Feature | - |
| P0 | - | Critical |
| P1 | - | High |
| P2 | - | Medium |
| P3 | - | Low |
Get Next Task ID
gog sheets get 1O07SzGzQa2FwpkBE7h2SUDWZlxsUpz8DxCpyxKjRi8U "Production!A:A" --json | jq '.values | .[-1][0]'
Then increment the number.
Append to Sheet (BUG)
CODEBLOCK3
Append to Sheet (FEATURE)
CODEBLOCK4
5. Update Team Daily Update Sheet
Sheet ID: INLINECODE18
Find row with today's date, append to Column B with format:
CODEBLOCK5
Format for Daily Tasks
Each day's tasks are in a single cell with headings and bullet points:
CODEBLOCK6
Get Today's Row
CODEBLOCK7
Update Cell
CODEBLOCK8
Priority Guide
| Priority | Label | When to Use |
|---|
| P0 | Critical | System down, data loss, security issue |
| P1 |
High | Major feature broken/needed, many users affected |
| P2 | Medium | Feature partially working/needed, workaround exists |
| P3 | Low | Minor issue, cosmetic, low impact |
Example Usage
Bug Example
User: "PMS Bug addition - Login page crashes on mobile"
Response:
- 1. Detect: BUG → GitHub label:
bug, Sheet type: INLINECODE20 - Ask for details (steps, expected outcome, priority)
- Create GitHub issue with bug template → get URL
- Get next Task ID from sheet
- Append to PMS Task Tracker with Task type = "Issue"
- Update Team Daily Update sheet with new entry
Feature Example
User: "PMS Feature addition - Add dark mode support"
Response:
- 1. Detect: FEATURE → GitHub label:
enhancement, Sheet type: INLINECODE22 - Ask for details (description, expected behavior, use case, priority)
- Create GitHub issue with feature template → get URL
- Get next Task ID from sheet
- Append to PMS Task Tracker with Task type = "Feature"
- Update Team Daily Update sheet with new entry
Quick Reference
| Trigger | GitHub Label | Sheet Task Type | Issue Template |
|---|
| PMS Bug addition | INLINECODE23 | INLINECODE24 | Bug report with reproduction steps |
| PMS Feature addition |
enhancement |
Feature | Feature request with use case |
Notes
- - Reporter is ALWAYS "Tara Singh Kharwad"
- Assigned To is ALWAYS "tarasinghrajput7261@gmail.com"
- Resolution Notes = GitHub issue URL
- "Took Help from Roshan" is left empty (Tara fills manually)
- Date format: DD/MM/YYYY only
- Status starts as "New"
PMS 任务添加(缺陷与功能)
用于将 PMS 缺陷和功能记录到 GitHub 和 Google Sheets 的简化工作流程。
触发条件
用户消息包含:
- - PMS Bug addition → 创建缺陷报告
- PMS Feature addition → 创建功能请求
工作流程
1. 确定任务类型
根据触发短语确定:
| 触发条件 | 类型 | GitHub 标签 | 表格任务类型 |
|---|
| PMS Bug addition | 缺陷 | bug | Issue |
| PMS Feature addition |
功能 | enhancement | Feature |
2. 收集任务信息
向用户询问(如果未提供):
- - 标题:简要概述
- 描述:发生了什么问题(缺陷)或需要什么功能(功能)
- 复现步骤:(仅限缺陷)如何复现
- 预期结果:应该发生什么
- 优先级:P0(严重)/ P1(高)/ P2(中)/ P3(低)
3. 创建 GitHub Issue
对于缺陷:
bash
gh issue create --repo roshanasingh4/apni-pathshala-pms \
--title <标题> \
--body $(cat <
描述
<描述>
复现步骤
- 1. <步骤1>
- <步骤2>
- <步骤3>
预期结果
<预期结果>
实际结果
<实际发生的情况>
EOF
) \
--label bug,<优先级> \
--assignee roshanasingh4
对于功能:
bash
gh issue create --repo roshanasingh4/apni-pathshala-pms \
--title <标题> \
--body $(cat <功能请求
<描述>
预期行为
<预期结果>
使用场景
为什么需要此功能?
EOF
) \
--label enhancement,<优先级> \
--assignee roshanasingh4
从输出中捕获 Issue URL 用于表格。
4. 更新 PMS 任务跟踪表
表格 ID: 1O07SzGzQa2FwpkBE7h2SUDWZlxsUpz8DxCpyxKjRi8U
标签页: Production
列映射(A-K)
| 列 | 名称 | 值 |
|---|
| A | 任务 ID | PMS-TSKXXX(从上一条记录递增) |
| B |
描述 | Issue 标题 |
| C | 报告人 | Tara Singh Kharwad |
| D | 提交日期 | DD/MM/YYYY(Issue 创建日期) |
| E | 状态 | New |
| F | 任务类型 | Issue(缺陷)/ Feature(功能增强)/ Testing |
| G | 优先级 | Critical(P0)/ High(P1)/ Medium(P2)/ Low(P3) |
| H | 分配给 | tarasinghrajput7261@gmail.com |
| I | 解决方案备注 | GitHub Issue URL |
| J | 解决日期 | (空,直到关闭) |
| K | 是否向 Roshan 寻求帮助 | (留空 - Tara 手动填写) |
标签到表格的映射
| GitHub 标签 | 任务类型 | 优先级 |
|---|
| bug | Issue | - |
| enhancement |
Feature | - |
| P0 | - | Critical |
| P1 | - | High |
| P2 | - | Medium |
| P3 | - | Low |
获取下一个任务 ID
bash
gog sheets get 1O07SzGzQa2FwpkBE7h2SUDWZlxsUpz8DxCpyxKjRi8U Production!A:A --json | jq .values | .[-1][0]
然后递增数字。
追加到表格(缺陷)
bash
gog sheets append 1O07SzGzQa2FwpkBE7h2SUDWZlxsUpz8DxCpyxKjRi8U Production!A:K \
--values-json [[PMS-TSK-XXX,<标题>,Tara Singh Kharwad,DD/MM/YYYY,New,Issue,Low,tarasinghrajput7261@gmail.com,,,]] \
--insert INSERT_ROWS
追加到表格(功能)
bash
gog sheets append 1O07SzGzQa2FwpkBE7h2SUDWZlxsUpz8DxCpyxKjRi8U Production!A:K \
--values-json [[PMS-TSK-XXX,<标题>,Tara Singh Kharwad,DD/MM/YYYY,New,Feature,Low,tarasinghrajput7261@gmail.com,,,]] \
--insert INSERT_ROWS
5. 更新团队每日更新表
表格 ID: 1GgRgfVBrF-ReGPRmntT6Cm2BjiLzJ3JiBaC4lMfrMQs
找到包含今天日期的行,追加到 B 列,格式如下:
每日任务格式
每天的任务放在一个单元格中,包含标题和要点:
- - PMS - 修复了登录按钮问题 - https://github.com/...
- PMS - 添加了导出功能 - https://github.com/...
获取今天的行
bash
找到包含今天日期的行
gog sheets get 1GgRgfVBrF-ReGPRmntT6Cm2BjiLzJ3JiBaC4lMfrMQs Sheet1!A:B --json
在 A 列中查找今天的日期(DD/MM/YYYY)
更新单元格
bash
追加到 B 列的现有内容
gog sheets update 1GgRgfVBrF-ReGPRmntT6Cm2BjiLzJ3JiBaC4lMfrMQs Sheet1!B<行号> \
--values-json [[<现有内容>\n- PMS - <标题> - ]]
优先级指南
| 优先级 | 标签 | 使用时机 |
|---|
| P0 | Critical | 系统宕机、数据丢失、安全问题 |
| P1 |
High | 主要功能损坏/需要,影响大量用户 |
| P2 | Medium | 功能部分工作/需要,存在变通方案 |
| P3 | Low | 小问题、外观问题、影响较小 |
使用示例
缺陷示例
用户:PMS Bug addition - 移动端登录页面崩溃
响应:
- 1. 检测:缺陷 → GitHub 标签:bug,表格类型:Issue
- 询问详情(步骤、预期结果、优先级)
- 使用缺陷模板创建 GitHub Issue → 获取 URL
- 从表格获取下一个任务 ID
- 追加到 PMS 任务跟踪表,任务类型 = Issue
- 更新团队每日更新表,添加新条目
功能示例
用户:PMS Feature addition - 添加深色模式支持
响应:
- 1. 检测:功能 → GitHub 标签:enhancement,表格类型:Feature
- 询问详情(描述、预期行为、使用场景、优先级)
- 使用功能模板创建 GitHub Issue → 获取 URL
- 从表格获取下一个任务 ID
- 追加到 PMS 任务跟踪表,任务类型 = Feature
- 更新团队每日更新表,添加新条目
快速参考
| 触发条件 | GitHub 标签 | 表格任务类型 | Issue 模板 |
|---|
| PMS Bug addition | bug | Issue | 包含复现步骤的缺陷报告 |
| PMS Feature addition |
enhancement | Feature | 包含使用场景的功能请求 |
备注
- - 报告人始终为 Tara Singh Kharwad
- 分配给始终为 tarasinghrajput7261@gmail.com
- 解决方案备注 = GitHub Issue URL
- 是否向 Roshan 寻求帮助 留空(Tara 手动填写)
- 日期格式:仅限 DD/MM/YYYY
- 状态初始为 New