Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

Anchor
Top
Top



Section
bordertrue


Column
width70%

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

Image Modified


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

Image Modified

Image Modified


Column
width30%

These are the topics on this page:

Table of Contents



...

Anchor
ManageSystemTable
ManageSystemTable
Managing System Tables

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

Image Modified- 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

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

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

Image Modified- 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

Image Modified- 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

Image Modified- 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

Image Modified- 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

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


Back to Top

...

Anchor
AddEditTable
AddEditTable
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.

Image Modified

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


Back to Top

...

Anchor
PublishTable
PublishTable
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.

Image Modified

Note

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.

Image Modified

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

Image Modified

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

Image Modified

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

Image Modified

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


Back to Top

...

Anchor
SearchTable
SearchTable
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).

Image Modified

Image Modified


Back to Top

...

Anchor
DeleteTable
DeleteTable
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.

Image Modified

Image Modified

Warning

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

Table of Contents:


...

Back to Top

...