Map

The section displays the location of the data based on GPS values on a geographical map. If a row of data does not have a valid GPS point, it will still be displayed within the grid, but not on the map.

Section Parameters

Date Field

It is used to execute the first sum of the values of a field.

Total Field

The field to be sum.

Total Field Title

The label to be displayed above the sum box.

SQL filter

Any SQL string to further filter the sum of the values.

Except for the first box, the remaining three boxes vary based on the filter of values on the grid. All boxes need the field to be added, the title and any SQL string.

Parameters

Status List

Allows you to select a field type "status list" that will be used on the cells of the mobile versions Ios and Android, to display a color marker associated with the selected state

SQL filter

Allows you to filter the values displayed in the section. for example "country = 'Italy'" will show only the records that match that criterion

Tree choice

If the table has a tree field, you can indicate it. The program will display it in the right part of the grid to allow you to filter the data based on the selected node.

Field

Identifies the field that will be used as the value to be displayed on the map placeholder.

GPS Field

The field from where the program will read the GPS location.

Labels field

It is the list type field that is used to mark the state and color of the placeholder.

All map definition fields are required, while the others are optional. By not setting one of the required fields it will be impossible to save the section.

Latitude/Longitude

If set they will be used for reading the coordinates of the point. They are used when there is no gps field containing the georeferenced address.