Text data types allow users to add letters, symbols, or numbers as field values. The text data type is also the default type for new columns within Mathesar.
Text data type lets users enter almost any character (letter, symbol, or number).
Text Data Type Figma Prototype
Each data type contains options that are specific to the selected type. Users can click on the data type dropdown and access them on the data type menu to access these options.
From the data type menu, users can also choose to change the data type. Clicking on change data type will open a menu with the complete list of data types.
Users can filter text data type columns based on the alphanumeric values of each field. When a text type column is filtered, the specific options for text will show under the filter parameters.
Users can sort records based on the values of text data type fields. The available options allow users to sort in alphabetical order in both ascending and descending orders.
Users can group records based on the values of text data type fields. The available options allow users to group by first letter or word of field values.
The design for filter, sort and group actions might require some updates to make the status of applied configurations more visible. Originally, these configurations were shown in a consolidated panel, but the solution is not optimal for some use cases. For example, when providing troubleshooting options, we might enable a filter to show affected rows, but the User, might not know how to return to the filter. A proposed solution is to iterate on the design for the filter, sort, and group features to optimize for discoverability and visibility of status.
Some changes like column constraints or data type configurations might produce errors if the content in the columns is invalid. Rather than allowing the change and triggering error warnings in all affected records, we want to prevent the change and guide users towards modifying the column content until it’s valid.