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.

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.

• Actions: You can take the actions same as explained above in 'Managing System Tables'

• 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.

Back to Top