The View element is used to enable visibility of records in other tables concurrently with views of the fields of a selected record in the selected table. Consider the View element to be a “window” into the contents of other tables in a Ninox database. The View 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. It is important to note that the View element produces the same result as a Child Table being displayed on the form view of the Parent Table. Using a View element to create this user experience however does not require a Parent/Child table relationship. The View element properties screen is displayed in the image below.
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 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 View element.
An example of the Select statement where all records in the table are presented in the View element is:select ‘Table 1’
An example of a parameterized select statement that limits the view to only those records that meet 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 View 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 View element.
Once a table has been identified as the target of the View element, administrators may use the [Edit Columns] button to specify the fields in the selected table (Target Table) to be included in the view along with any sort and filter parameters. 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.