Skip to main content

Settings

The Settings menu allows you to configure your connection preferences. These options are grouped into three categories: General settings, Table view options, and "Edit row" behavior.

General settings​

The General settings include the following options that you can customize: Displayed table name, Connection icon, Sensitive fields, Identity field, Allow importing rows from CSV, Allow table export to CSV, Allow row deletion:

Table name​

You can modify the table name in Rocketadmin without changing it in your database. Simply enter a new title in the Display table name field and save:

Table icon​

Тable icons are useful when you collapse the left side panel and you still want to quickly identify your tables, even if their names are hidden.

To add an icon:

  1. Click on Add icon:

  2. From the popup window, you can directly choose one of the available options:

  3. Alternatively, you can follow this link to pick from the entire Google material collection:

    Simply copy the needed name:

    then paste it in the icon field and apply:

    After you save the changes, you can review the new display:

Sensitive fields​

This option allows you to hide the information about specific table fields from the Audit records and ensure the related logs are not stored on our servers.

Select the needed fields from the list and save.

From this point forward, we will stop recording logs for the chosen database columns:

Allow importing rows from CSV​

By enabling this option you will be able to import data to your table from a CSV file.

The CSV file needs to have all the column names listed on the first line, separated by commas. On the next lines add the field values with commas in between them too.

For example:

To upload the file, click on and then on Import:

When prompted, select the file from your device and click on Import:

The new row will appear in the table:

Allow table export to CSV​

This option allows you to export a given numbers of rows (or up to 100 000 records) in a CSV file.

To download your data, click on and then on Export:

When prompted, select a number of records (or mark Export all for up to 100 000 records):

Click on Export and select the file destination. Your records have been downloaded.


Allow row deletion​

When you turn on this option, the icon appears on each row, giving you the ability to delete it.


Table view​

The Table view settings include the following options that you can customize: Columns visible by default, Columns order, Searchable columns, Order by (Ascending/Descending), Sortable columns, Columns to hide:

Columns visible by default​

With this option, you can choose the columns you want users to see when they open the table for the first time, for example:

Pease note, that users can override this initial list from the table’s Columns menu.

Columns order​

You may wish to organize the columns in a way that is different from the default layout. To do so, drag and drop them into your preferred order, for example:

The result will look as follows:

To revert the changes, click on and then save.

Searchable columns​

Use this option to specify which columns Rocketadmin should scan for information when users query data through the Search bar. For example:

Order by​

With the Order by option you can specify a column on which to sort all the database fields in ascending or descending order. For example:

Sortable columns​

The Sortable columns option allows you to select columns whose values users can sort in ascending or descending order (via the up and down arrows next to the column name). Columns outside this list are not available for manual sorting. For example:

Columns to hide​

Using this option you can select the columns to hide from the Table and Edit row views. Hidden columns cannot be edited. For example:

As a result, the column is no longer visible from both Table and Edit row views: