Tables

Change table settings to meet your requirement

Summary

Use the table settings to customize how do you want to store the data. Please be very careful, each of change will affect your data dramatically. These changes can not be restored. Only Administrators has permission to make changes.

The settings of tables can be viewed by selecting at Sidebar -> Settings -> Tables

Settings of Tables

Attributions

All tables are customizable, the following attributes can be updated for a table:

Filed/Attribution

Description

Icon

The icon of the table. The icon will be used to display in the sidebar. Use a name from https://material.io/tools/icons/?style=baseline

Name singular

The name of the table as singular, for example sample

Name plural

The name of the table as plural, for example samples

Name system

System reserved table, for example file.

Unique code

A few up-case letters that append to id of record

Table type

Choose of Document or Substance

Show in menu

Should the table attached in the sidebar

Is archived

If checked, the table is not available to use.

Add a table

Use a new table to store new type of data. Click the "+" icon on the nav bar to add a table, fill in the value as described in the attributions. Only the administrators can do so.

Form to add a table
  • Table Name (Singular) - Table name, in singular format. Letters and Numbers only, no blanks.

  • Table Name (Plural) - Table name, in plural format. Letters and Numbers only, no blanks. These names are reserved by Labii and not allowed: organizations, organizationmembers, teams, organizationwidgets, widgets, organizationselect, organizationnew, statements, backups, projects, projectmembers, projectteams, tables, activities, columns, filters, rows, sections, versions, templates, fileupload, searchresults, cells, signatures

  • Unique Code - The abbreviation term of table name. The code must be at least 2 characters long and contain only uppercase letters. The unique code will be used to reference an object. The Unique Code is used to reference an object and shall not be changed once provided.

  • Show in Menu - Should display this table in sidebar one-click navigation. We recommend you to set this to true for the most often used tables.

Columns

Use columns to store one specific type of data for a record. Columns can be customized under Settings -> Tables -> Columns

Column list of a table

Add a column

Click the "+" icon to add a new column.

Form to add column
  • Description - The description of column. Include the definition, special formatting, and all other necessary information to help your coworker to fill.

  • Widget - The widget to use, or the type of data. Default to Text. Check out Settings -> Widgets to install missing widgets. Check out here for a list of widgets.

  • Default Value - Default value of the field.

    • For Boolean field, the default value is 'false' if not provided. Use 1 for 'true' and 0 for 'false';

    • For Select/MultiSelect field, add one item per line as options. Use '_' to separate the value and label.

    • For ForeignKey, add the unique code of the table to match. Use ',' to separate multiple matches. If not provided, it will match everything.

    • For Date, use YYYY-MM-DD.

  • Is Required - If checked, the value of column is required in form submitting.

  • Is Hidden - If checked, the column will not display in the list view. But it still available for use. Use it to control which column to display in the list view.

Edit column

Mouse over a column and click the "edit" icon to update a column.

Note: Changes to a column might affect the existing data.

Note: A column can not be deleted. Archive it to hide the column.

Change order of columns

The order of column can be change via dragging a column to a different position.

Default Sections

Sections can be added for each record. Default section can be defined so that these sections can be added automatically when a new records is created.

List of default sections

Add a section

Click the "+" at Settings -> Tables -> Sections to add a section.

Form to add a new default section
  • Widget - The widget to use. Check out Settings -> Widgets for more details of each widget. Please try not to change the widget, data from one widget does not compatible to the other.

Edit section

Mouse over a section and click the "edit" icon to update a column.

Change the order of sections

The order of column can be change via dragging a column to a different position.

Filters

All added filters can be managed at the Filters section.

  • My Filters - All filters that related to you

  • All Filters - All filters that currently created for this table. Only the administrators are able to view this section.

List of Filters

Add a filter

Please refer to Filter at Search for more details.

Edit filter

Mouse over a section and click the "edit" icon to update a column.

Change name of field

The field "Name" and "Description" can be changed to a different value with the following metadata at the table level or organization level.

  • FIELD_NAME_RENAME, use this metadata label to change the name of the "Name" field.

  • FIELD_NAME_HELPTEXT, use the metadata label to provide additional help text to the "Name" field.

  • FIELD_DESCRIPTION_RENAME, use this metadata label to change the name of the "Description" field.

  • FIELD_DESCRIPTION_HELPTEXT, use the metadata label to provide additional help text to the "Description" field.