Views allow you to assort, group, filter and analyze your data in different ways.
Working with Views
a) When a table is opened, the first row of the navigation bar shows the table name. There can be several open tables at the same time. Tap on the table name to show the table. Tap on the white X to close the table.
b) With + you can create a new record, i.e. a new row in the table.
c) For each table Ninox creates a standard view called ‘(all)’. Switch between views by tapping on the view name. The active view is shown in blue with a white arrow.
d) Tap on the name of the active view to open the view menu (see below).
e) Create a new view.
f) Refreshes the active view. This is sometimes necessary when data is updated.
g) The icons next to the column labels show, if the column
- if a filter is applied,,
- determines the table order assorting the values in ascending or descending order,
- is used to group the table.
The table in the example above has been grouped by Status; for more information see below.
h) Sorting: Assorted columns are marked by an up-arrow (ascending order) or a down-arrow (descending), respectively.
i) You can vary the column width by moving the right border of the column header.
j) You can also re-arrange the order of the columns. Drag the column label to the left or right, until another column label is highlighted in red.
k) Tap once on a column header to open the column menu (see below).
l) Grey rows indicate groups. Tap on the row to show or hide the group members. The number in the gray row represents the column sum of that group (or count, average or others, as explained below).
m) In this example, the group header of the column ‘Street’ has been set to ‘count’.
n) Click on the ID row header on the very left to select single entries. This will be indicated with a tick mark (o).
p) By tapping on a row the entry form opens. Also, you can right click to open the context view menu and modify your selection:
Clear selection or select all (r), toggle (reverse) selection, i.e. all the visible records not selected before become selected now. (s), or select all (t). When you save the view, that includes the current selection. (u) Show selection will hide all entries that are not ticked. That operation can be useful for research, for example, if you want to select certain customers for a marketing campaign (like a newsletter). (v) You can delete the selected rows, as well.
q) Opens the view search. With this search you can look for entries only within this specific view. You can also open the search by just typing.
The View Menu
a) Views are shown as a table by default.
b) Tap on ‘chart’ to display the view as a chart.
c) The print preview optimizes the view for printing.
d) Find, also opens the view search. You can also just start typing.
e) As described above, you can select several data records. Here you can clear the selection.
f) If you toggle the selection, the selection is reversed, i.e. all the visible records not selected before become selected now.
g) Selects all visible records.
h) Expands all grouped items.
i) Collapses all grouped items to only show the groups.
j) Reduces the view to the selected data records. Press again to show all the records again.
k) Deletes all selected rows from the database.
l) Use mass data updates to modify the selected records at once.
m) Exports the selected records to another program / app.
n) Create a new view. This is the same as clicking the plus sign on the right side of the tabs.
o) Rename the view.
p) Deletes the current view. This does not delete any data.
q) Opens the dialogue to modify the table, that is, the actual data fields.
r) Opens the dialogue to configure the columns of this view (see below). Here you will find even more options to modify the view to your liking.
The Column Menu
If you tap on a column header, the column menu opens and provides quick access to the most important settings. ‘Edit columns…’ allows for more detailed settings.
a) Change the name of the column.
b) You can apply formulas to the column.
c) Defines a filter. Only records that match the filter are shown.
d) For Choice and Yes/No fields you can select from a drop menu as, well. For other fields you can type to filter. Use != to exclude values from the view.
e) Uses this column to put the data in ascending order.
f) Uses this column to put the data in descending order.
g) Groups or ungroups by this column.
h) Count the number of entries. The number will appear on the bottom line.
i/j) Show the value of the first or last entry. This also appears on the bottom line.
k) Concatenate gives out a list of all values.
Depending on the the data type there might be different group values available:
- Sum – the sum of all values
- Average – the average / mean of non-empty values
- Minimum – the minimum non-empty value
- Maximum – the maximum non-empty value
The column values or group values are displayed in the column footer or the group header (grey), respectively.
l/m) Hide or shows columns.
Get to the view menu by tapping on the view header to find the operation ‘edit columns…’.
On the left side all shown columns are listed. Use drag & drop to change the order.
a) Tap on an entry to open the column settings (see below). The icons next to the column name indicate, if filters, sortings or groupings are used, and if a column value is defined.
b) On the right side, there is a list of the available data fields.
c) Drag an element from the right side to the left to include it as a table column.
d) Data from linked tables is also available. Tap on the reference field to list the data fields of the linked table. You can drag those fields onto the left side the same way.
e) Adopts the changes.
f) Cancels the operation.
a) The column name is set by Ninox by default to the field name (grey font). However, you are free to choose another name.
b) For each column there is a formula. If you created the column by dragging a field (see above), the formula equals the field name. You can change the formula by tapping on it. The Formula editor opens.
c) Sets the filter for the selected column.
d) Sets sorting and grouping.
e) Defines the column value or group value.
f) Hides the selected column (eliminates it from the list on the left).
g) Closes the dialogue.