Tables

How-to guide on all things Tables.

On this Page


Create a Table

  1. From the administration home, go to Tables.
  2. Click Create in the top right corner of the table.
  3. Enter a name for your table, along with additional configuration.
  4. Click Save.

Table descriptions can be used as instructional text, as these are visible next to the table name for users.


Additional Configuration

There are some optional extras when it comes to creating tables. We'll run through them here so you can customise them to your liking!

Type

There are multiple types of table available, each suitable for different purposes. Click on each type to find out more about its specific configurations.

Adding/Deleting Fields

To add a field to a table, simply click the field you would like on the table. To remove this field, click on the trash icon delete_FILL0_wght400_GRAD0_opsz48 to the right of the field.

You can find a field quickly by typing in to the search bar within the left hand field menu.

 

All core functionality fields are added by default. See system fields for more information.

Table Views

Different views can be created for each table displaying different fields. For more information on this, check the View Settings article.

Personal Page Behavior

If a user is assigned as an owner within a table row, the fields on that row can be editable from a the assigned users personal page.  As an admin you can define the behavior of the fields within the personal page for users.  There are three states you can choose:

  • Editable (default behavior) - the fields can be edited and submitted for review.
  • Read Only - the fields cannot be edited.
  • Hidden - the field will not be shown or be edited.

 


Editing a Table

After you've created a table, you can edit them to change their name, descriptions, or any other table configuration options.

Changes to tables can be made at any time. The changes will affect your records and saved changes take effect immediately. 

A table's internal name cannot be updated once created. This value will have no impact on your users. It is used only by those using APIs.

To edit a Table, follow these steps:

  1. From the administration home, go to Tables.
  2. Select the row (checkbox on the left) of the table you wish to edit.
  3. Click Edit in the top right corner of the table.
  4. Modify the table configuration.
  5. Click Save.

You can only edit one table at a time.


Deleting a Table

Deleting an active table will stop users from being able to add this table to newly created records. All previously entered data will be unaffected and visible where in use.

You can delete a single table or multiple tables at the same time by selecting multiple rows.

To delete a Table, follow these steps:

  1. From the administration home, go to Tables.
  2. Select the row (checkbox on the left) of the table you wish to delete.
  3. Click Delete in the top right corner of the table.

 


Restoring a Table

Only Deleted tables can be restored.

You can restore a single or multiple deleted tables at a time.

To restore a Table, follow these steps:

  1. From the administration home, go to Tables.
  2. Click Deleted tab.
  3. Select the row (checkbox on left) of the table you wish to restore.
  4. Click the Restore button in the top right corner of the table.

 


Permanently Deleting a Table

Only Deleted tables can be permanently deleted.

Permanently Deleting a deleted table will remove the table completely from edison365 and delete all instances and data. Deleted tables can't be restored. 

You can permanently delete a single table, or multiple tables at the same time by selecting multiple rows.

To permanently delete a Table, follow these steps:

  1. From the administration home, go to Tables.
  2. Click Deleted tab.
  3. Select the checkbox in the row of the table you wish to edit.
  4. Click delete_FILL0_wght400_GRAD0_opsz48 delete icon in the top right corner of the table.


System Tables

Can't edit or delete a table? This is a System table.

System tables are permanent tables created by edison365 which enables core functionality across the system. They cannot be deleted or edited.