Field values shown in labels are formatted according to the field style specified in the table window.
GEOMWKB values can show type, coordinate count and branch count data if requested by style.
The collation picker shows invalid collations in red.
The language combos in the Style dialogs for field values are replaced with language pickers. A language picker shows a menu with favorite languages plus a command to select a different language using a dialog plus a command to edit favorite languages. By default, the only favorite language is 'neutral'.
The list of supported languages is extended to cover all languages supported by Windows 10. (This increased the number of languages supported in such a way from 200+ to 600+.)
Field values shown in the Info pane are formatted according to the field style.
There is a Style dialog for text fields and a new style for text values: 'u' = URL. If a text field is formatted as a URL, valid URL values are shown as hyperlinks, both in a table window and in the Info pane. The context menu for a URL value includes the 'Open URL' command which opens the URL in a web browser.
There is a new style for numeric values: 'a'/'A' = angle. The style is specified as 'a' <subformat> <side> <decimals>. The subformat can be either 'd'/'D' = decimal degrees, 'm'/'M' = degrees and decimal minutes, or 's'/'S' = degrees, minutes and decimal seconds. If the subformat is empty or unrecognized, it is mapped to 's'. The side can be one of 'n', 'N', 'e', 'E', 's', 'S', 'w', 'W'. If the side is unrecognized, it is mapped to empty. If the side is specified, negative angles are converted to positive ones with the side switched (so, '-130 E' becomes '130 W'). The number of decimals is applied to the smallest term. If the number of decimals is not specified, the system uses the default number of decimals for the language. The Style dialog lists the 'ad', 'am', 'as' style variants and allows specifying the number of decimals and the side.
Vector values formatted using the 'a'/'A' style alternate the side between individual values, if it is specified. If the specified side is 'e' (easting), the first value is formatted as 'e' and the second as 'n' (northing). For 'n', the first value is formatted as 'n' and the second as 'e'. For 'w', the first value is formatted as 'w' and the second as 's'. For 's', the first value is formatted as 's' and the second as 'w'. If there are three values in total, the third value is formatted as plain floating-point (not an angle), to show Z. If there are four values in total, the third value is formatted similarly to the first and the fourth similarly to the second.
There is a new style for numeric values: '#' = choices. The choices are specified as a list of 'key=value' pairs separated by ';'. Keys are integer (not floating-point). The Style dialog includes a separate Choice tab and allows composing the list of choices: you can add a new choice by editing the key of the last choice, you can edit the key or value for any of the existing choices, you can delete one or more of the existing choices by selecting them and pressing Delete. If a numeric value stored in a table does not correspond to any of the choices, it is shown as '# nnnn'. (We are planning to extend this feature to support text fields and support choices stored in tables.)
Editing a boolean value in a table window or in the Info pane shows a menu with choices for 'true' and 'false'.
Editing a numeric value formatted as a choice in a table window or in the Info pane shows a menu with available choices.
Editing a vector value formatted as a choice in a table window or in the Info pane shows a menu with available choices, with a separate submenu for each vector component.
There is a new dataport for KOBO toolbox. The dataport supports the following servers:
- Kobo Everyone - the default,
- Kobo Humanitarian - a special server for humanitarian organizations where such organizations can store big data sets for free,
- Custom - your own server.
To connect, create a user account and enter your API key in the dialog. The dataport allows accessing all assets stored for the account, in read-only mode. (We will allow writes in the future.)
The URL for a KOBO data source can be set to that for a specific asset. This is convenient when the number of assets on the account is large.
The KOBO data source can be refreshed, to pick up changes to the list of assets.
The table on a KOBO data source can be refreshed, to pick up changes to records or fields of a specific asset.
The KOBO dataport translates image / audio / video / file sentinels to URLs.
(Fix) The PostgreSQL dataport no longer fails to determine the schema for a materialized view on PostgreSQL 12+.
End of list.