Tables, Fields, Forms and Views



The Table tab allows you to add and modify tables and their associated fields, forms, and views.


  • Tables: Lists of information stored within the system database
  • Fields: Columns within the list that store information using a particular data type
  • Forms: Layout of fields grouped within sections and groups, that allow you to add and edit records within a table
  • Views: Lists that display table information based on filters and columns contained within the view
  • Relationship: Lists that display the relationship of table information with data linked to it.


Table management section will allow you as an Admin to manage the Tables to be used in the application. 

Clicking on the sub-menu - ‘Table’ from the main navigation menu - ‘Manage’, you will be able to view the landing page for the Table Management.

These are the topics on this page:



Managing System Tables

There are several functional buttons that lets you manipulate the data being shown and stored by the system tables:

- The 'Add Table' Button lets you create a new table to show information in the system. For an in depth guide, please visit Adding / Editing Tables

- The 'Edit' Button lets you edit the details of the corresponding table. For an in depth guide, please visit Adding / Editing Tables

- The 'Publish' Button let you publish the table. For an in depth guide, please visit Publishing a Table 

- The 'Fields' Button shows the table field screen that lets you add, edit, or delete the field information being shown in the corresponding table. For an in depth guide, please visit Table Fields

- The 'Forms' Button shows the table form screen that lets you add, edit, or delete what data is being fetched by the table. For an in depth guide, please visit Table Forms

- The 'Views' Button shows the table view screen that lets you add, edit, delete or replicate the table column's view name. For an in depth guide, please visit Table Views

- The 'Relationships' Button shows the table relationship screen that lets you add, edit, or delete a relationship information to the data being fetched. For an in depth guide, please visit Table Relationships

 - The 'Delete' button lets you delete the corresponding table. For an in depth guide, please visit Deleting a Table


Back to Top


Adding / Editing Tables

The following screen will show when adding and editing system tables. 

  • Table Name: The actual name of the table created on the database, and can't be changed once created. Please use the unique name for the table.
  • Display Name: Name shown to users within the system and can be changed at any time.

Click on ‘Save’ button to add the new table. The newly created table will be added to the tables list.


Back to Top


Publishing a Table

When adding a new table to the system, it will need to be published before it can be used by users. Publishing a table creates the actual table structure within the database. Any subsequent changes are immediately applied to the table.

After publishing a Table, the ‘Publish’ button will be removed from the Action buttons. You won't be able to revert the changes once published. 


Back to Top


System Tables

Displays the listing of all the tables created by you with following details:

  • Table Name: Displays the name given to the table.
  • Display Name: Shows the ‘Display Name’ given to the table.
  • Is Published: Displays the Boolean value as either ‘True’ or ‘False’
    • True: Represents that the Table has been published. It means the table has been created in the database with the defined structure.
    • False: Represents that the Table has not yet published.
  • Number of Entries per page: Select the number of entries for the tables to be shown on the ‘Tables Listing’ page. Select any of the following to select no. of entries per page:
    • 10: If selected, 10 Tables per page will be displayed.
    • 25: If selected, 25 Tables per page will be displayed.
    • 50: If selected, 50 Tables per page will be displayed.
    • 100: If selected, 100 Tables per page will be displayed.

At the bottom of the list, you will be able to see the slot of the entries you are currently viewing.

  • Sort: Clicking on any of the column headers from the grid, you will be able to sort the listing in Ascending or Descending order.

  • Pagination: Pagination feature allows you to view the entries from all the pages if present. Clicking on the ‘Next’ button, the entries from the next page will be loaded and clicking on the ‘Previous’ button, the entries from the previous page will be loaded. You can view the entries of a specific page by clicking on the respective Page Number.

  • Back: You will be taken to the last page visited by clicking on ‘’ button


Back to Top


Searching a Table

Search feature lets you search for specify table already created into the system.

You need to enter the search keywords in the below Search Input box and instantly the Tables list will be filtered as per the keywords and shows you the required table(s).


Back to Top


Deleting a Table

You can delete the existing table by clicking on the ‘Delete’ button present across the table. Clicking on the ‘Delete’ button, you will be prompt for the Table delete confirmation. Once you select ‘Continue’ option, the selected Table will be deleted from the system.

Deleted Table(s) cannot be retrieved again. Be sure before deleting.

Back to Top


Copyright © 2019 Brevity. All Rights Reserved