This guide will teach you how to create a table and add a couple of fields to your Vortex DBI.
The List field type is special. The list contains a set of pre-defined values to choose from. To create a List field, create the field as any other field with the type List. After saving the field, left-click the i-symbol to the far left on the row for the List field to enter the fields Details view.
Near the bottom of the page there is a tab called Strings. Here you enter the pre-defined strings to be chosen from in this list.
When entering the Details view for a record by left clicking the leftmost i-symbol all information for the record is shown.
The way the information is shown can be customized using a couple of information elements in the table.
To create a category, which is a closeable pane containing data fields, simply create a new field and give it the Category type. The pane is open by default when entering the Details view, if you want it to be closed add the closed keyword to the extra information field.
All fields are shown ordered by their sort order. A lower sort order value is shown before a higher value. Categorys shown before a field will contain that field, ie if there is one category with sort order 100 and one category with sort order 200, all fields with a sort order between 101 and 199 will be contained in the first category, and fields with a sort order of 201 or higher will be contained in the second category.
All system fields by default have a sort order of 9000 and above. To contain them in a pane, add a category field with sort order 9000. If you want to hide it, check the Hidden flag for the category field, and the category and none of its fields will be visible in the Details view.
An HTML overview can be added per table to the Details view. This is done using scripts and closely described in the Scripting section.