Skip to content

Add 'category' field to feedback form #1

@AlahmadiQ8

Description

@AlahmadiQ8

Summary

We want to categorize incoming feedback so the support team can route it correctly.

Motivation

Right now all feedback lands in one bucket. Sales wants to filter by topic to triage faster.

Proposed change

  • Database: add a category column to cf_feedback with values: General, Product, Support, Billing, Other.
  • APEX app: add the new column to the form and the interactive report.

Acceptance criteria

  • New rows can specify a category
  • Default is "General"
  • Existing rows are migrated to "General"
  • Interactive report shows the new column
  • Pipeline applies the change to DEV automatically, PROD after release+approval

Demo / verification steps

  1. Migration 003_add_category.sql adds the column with a check constraint
  2. APEX page Create/Edit Feedback shows a Category dropdown
  3. Interactive report has Category column visible/filterable
  4. scripts/verify.sql confirms cf_feedback.category exists

Metadata

Metadata

Assignees

No one assigned

    Labels

    demoUsed in customer demoenhancementNew feature or request

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions