Email data types are custom Mathesar data types used to store email addresses.
This prototype might be outdated due to global component updates. Please refer to the link under ‘Setting Options’ for an updated version of the shared components.
The user can set the column data type to ‘Email’ by accessing the ‘Data Type Options’ in the columns header menu.
Depending on whether there are existing values or not, and if they are valid email values, the outcomes will vary:
If there are valid email values, the system will convert them to email types. A valid email will have a username and domain name joined by a ‘@’ symbol.
If there are no valid email values, the system will discard the existing values and default to an empty cell.
The following is an interactive representation of the various options that users can set for this type:
Email Type Options
The user might enter a new email value with a valid format. If the value is not a valid email, an error should be displayed, preventing the row from being saved.
Users can filter ‘email’ data type columns by regular ‘Text’ type filters (except for length filters which are exclusive to text types) as well as ‘Email’ specific filters such as domain name.
Users can group ‘email’ data types columns by first letter or domain.
The new record row, originally designed to sit at the bottom of the table, will now be on top. Change is due to confusing placement within groups and compensating for the pagination change impact on the usability of adding new records.