Tables are used to define a collection of properties that belong to the same record, including what those properties are, who can access them, and other facets. Tables can be compared to a traditional SQL Tables or spreadsheets.
- Title: This is the friendly name of the table in the framework.
- Name: This is the official name of the table in the framework.
- UID: This is a globally unique ID used internally by the framework(Note: this can't be modified).
- ID: The numeric identifier of the table.
- Hint: Intended for supplemental information regarding what the table is for and how it should be used. This c an only be seen by the designer.
- Label: This is a label that you specify for the table for searching purposes.
- Icon: The selected icon will be used to represent this table throughout the database configuration.
- Include data in package export: If checked, this table will include the associated data when it is exported in a package.
- Tag: Add one or more tags to your table to allow for sorting and enhanced package creation.
Columns can be added to a table to hold specific information about the record. Columns can be compared to a traditional SQL column. To add a new column to the table, click the + icon on the left side of the columns list. To modify an existing column, double click on the column you would like to edit.
Every table must have at least one property know as the Record Code. (It can be easily identified by the Key icon.) This column is required for every record and should be unique. This is also the column that will be displayed in the drop down list if this Table is used as a Drop Down Source.
- Auto-Number Column: The table can be designed to supply a unique identifying number to each record. The auto number column must be of an Integer data type in order to be displayed in this list. To remove the auto-number column, click the - icon to the right of the field.
- Begin At: This is the currently selected last value for the auto-number column in this table. Click the "Set" button next to this field in order to update this value. This can be very helpful if you would like to start your auto-number generation at a number other than 1.
- Increment By: This is the numeric amount by which the selected auto-number column will advance for each newly added record in this table.
You can use an Auto-Number column, i.e. Serial#, to build a unique Record Code.
Combine Serial# with a string, or another value, in the Expression Builder for the Record Code. Here the string 'TRAIN' is used at the beginning of the Record Code. Then the PadLeft function is used to add zeros to the left of the Serial# value until there are four numbers to the right of the hyphen.
'TRAIN-'+PadLeft ([Serial#], 4, '0') = TRAIN-0001
In the grid displayed, a selectable list of security groups is available to allow specific security groups to be able to create and edit records from the table . If no security groups are selected, all users will have access to create and edit records.
In the grid displayed, a selectable list of security groups is available to allow specific security groups to be able to delete records from the table . If no security groups are selected, all users will be able to delete records.
The grid displays results of all references to this table throughout the framework.