This demo showcases editable cells with custom validation rules. Double click cells to edit the content and to see the validation in action.
To learn more read our documentation article on predefined and custom validation rules.
String Validation
• Product Name: Must contain only letters, numbers, and spaces — special characters are not allowed.
• SKU: Must be unique and follow the format `AAA-123` (3 uppercase letters, a hyphen, and 3 digits).
Number Validation
• Price: Must be at least 10.
• Discount: Must be within valid ranges depending on the selected category.
Cross-Field Validation
• Category & Discount: If the category is Electronics, the discount must be between 1% and 30%. For other categories, the discount must be between 1% and 60%.
• Discount & Category: When editing the category to Electronics, ensure the current discount is not above 30%, or validation will fail.