How to validate emails in a grid column
To validate emails in a grid column, please follow these steps:
Open your grid configuration, click “Add new column”
Click “String” as Column type
Only apply for String column
Fill in Identifier and Title, check the checkbox “Cell is validated as an email”
Click “Add” to add column
Click “Save” to save the grid configuration
Result
If user enters invalid emails, they will be marked by a red outline.
If user continue to save the grid, an error message will appear and user can’t save the grid.
Email Validation Rules
Rules | |
|---|---|
| 1 | Have non-empty local part (before |
| 2 | Contain exactly one |
| 3 | Use only allowed characters in each part (see regex explanation below) ^[a-zA-Z0-9._%+-]+@[a-zA-Z0-9.-]+\.[a-zA-Z]{2,}$ |
| 4 | Not include whitespace, commas( |
| 5 | Only one email address is allowed per cell |
| 6 | If the field is marked "required", empty input is invalid |