Standardize Category Labels (e.g., "Food" vs "food") #2
Description
Description:
Currently, categories are case-sensitive and inconsistent, resulting in duplicates like "Food" and "food".
Proposed Solution:
Normalize category inputs by capitalizing or lowercasing them.
On form submission, check and merge similar entries.
Benefits:
Cleaner data.
Prevents duplicate categories.
Enhances chart grouping and reporting.