URL data types are custom Mathesar data types used to store URLs.
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 ‘URL’ 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 URL values, the outcomes will vary:
If there are valid URL values, the system will convert them to URL types. For example, a valid URL could be:
If there are no valid URL 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:
URL Type Options
The user might enter a new ‘URL’ value with a valid format. If the value is not a valid URL, an error should be displayed, preventing the row from being saved.
Users can filter ‘URL’ data type columns by regular ‘Text’ type filters (except for length filters which are exclusive to text types) as well as ‘URL’ specific filters such as hostname.
Users can group ‘URL’ data types columns by first letter, URI scheme, or URI host.