The Chart element is used to enable visibility of graphic representations of records in other tables concurrently with views of the fields of a selected record in the selected table. Consider the Chart element to be a “window” into the contents of other tables in a Ninox database. The Chart element does not require any link or relationship to exist between the table that contains the View element and the table that is the target of the view. The Chart element properties screen is displayed in the image below.
For additional information regarding the Chart Type, Data Series, Stacked, Smooth Lines and Legend options displayed in the image above, please refer to the Visualizing Data section of this users manual
FORMULA – The formula in this field must result in the selection of records, or a sub-set of records, from the target table. To view a graphic visualization of all records in a particular table, one uses the Select function. To limit the selection of records in the target table based on the value of parameters, one uses the Select function with the “where” qualifier appended thereto. The “where” qualifier is used to specify the conditions that must be met in order for a record to be included in the sub-set presented in the Chart element.
An example of the Select statement where all records in the table are presented in the Chart element is:select ‘Table 1’
An example of a parameterized select statement that limits the view to only those records that meet certain conditions, as defined in a series of parameters is:select ‘Table 1’ where ‘Field 1’ = parameter 1 and ‘Field 2’ = parameter 2
In the example above, there may be any number of parameters and any of them may be defined in the negative using the “not” operand. Consider an example where two Date fields exist on a screen where users can enter a beginning and ending date. A View element is place on the form below the two Date fields where all transactions that have occurred during the period between the beginning and ending date are to be displayed. The formula for the Chart element would be as follows:
select ‘Transactions’ where ‘Trans Date’ >= ‘Begin Date’ and ‘Trans Date’ <= ‘End Date’
In the example above, the two date fields are assumed to be named “Begin Date” and “End Date” and the field in the Transactions table where the transaction date is stored is named “Trans Date”, the “>= and <=” conditions are read to mean “the transaction must have occurred on or after the beginning date and on or before the end date”. This select statement will result in the presentation of all transactions that have occurred within the specified time frame in the Chart element.
Once a table has been identified as the target of the Chart element, administrators may use the [Edit Columns] button to specify the fields in the selected table (Target Table) to be visualized in the Chart. For information regarding the Edit Columns Process for additional information regarding this operation in Ninox.
TOOLTIP – Often referred to as “hover help”, this is content that will appear in a small balloon at the point where the cursor is when that cursor is left to hover over the field for a few seconds. Tooltips are used to assist the user in understanding what is expected to be entered into the field.
DISPLAY FIELD ONLY IF – This field accesses the Ninox formula editor where the user may define the condition under which this field, and its contents and name, remain visible in the form view of records in this table. A field will only remain visible if the DISPLAY FIELD ONLY IF is left blank or if the formula that appears in the field distills down to a “True” state. For example, to ensure that a field remain invisible at all times and in all situations, a user may enter the formula 1=2 or null. To ensure that a field remains visible at all times, leave this field blank. To enable the field to appear or disappear based on the state of another field (or fields) in the table, use a formula that will ultimately evaluate to either true of false. A true evaluation will result in the field appearing while a false evaluation will result in the field remaining hidden.
[DELETE FIELD] – The red button that appears in the bottom, left-hand corner of the screen, if clicked, will give you the option to delete this field from the table. If you confirm the wish to delete the field, the field, and all content in this field in all records of the table will be eliminated. The Delete Field operation can not be undone, so make sure you have made a backup or archive of your Ninox database application prior to deleting any fields.