Orgzit Tables allow you to store, organize, and analyze organizational data. Every workspace can have multiple tables. With Tables, you can track every activity that constitutes a workspace.
Orgzit lets you create as many tables as you need so that every aspect of your information workflow is neatly organized and tracked. You can create a new table from scratch or create one by a CSV upload. Like any other database application, Orgzit Tables are made up of fields and records.
To set up table-specific configurations and perform different operations, many options are available on the Table Manage page.
You can click on the gear icon at the top right of your workspace screen to go to the Table Manage page.
The very first section on the Table Manage page is that of Table Details, where you can set the basic information and settings for a table.
List of Table Details
Here you can set the name of your table. It's best to keep a name that well defines the purpose and content of that table. It makes it easy to understand for all users.
Here you can set the table description and enter relevant information that describes the table.
You can also set a name for your record.
You can now see the button with the name you have set instead of the +Record button. You can set a relevant name that matches with the table data. For eg,
You can also set a record title, which can be customized on the basis of requirements. You can format it to show specific information and details of a record.
(Note: The Title Formula is written in Python language.)
For instance, in case you want to view a record's key details as the Title when you open the expanded view of a record, you can do so by setting the Title Formula in the Table Settings.
To see the value of some specific fields in the Title, you can specify its Normalized Name in the formula.
For instance, the Normalized Name for the field Customer Name will be customer_name. You can find the normalized names in the Table Fields section in the Table Settings.
This is used to specify the order in which you want to view your records. You can sort your orders on the basis of any of your table fields. For eg, if you want to see the records in ascending order of ID you can choose the ID field. To view in the descending order, you can choose -ID.
In a related table, you can search for the field value by using Search Fields.
For instance, if you have a Leads table and an Interactions table to store the information about all lead interactions:
You can set the Search Field as Lead Name in the Interactions Table, which is related to the Leads table.
You can then use this to search for Leads in the Leads table and get the name you searched for.
Here, you can set the default view for your table. Each time you open a table, it opens to the default view. You can set any saved view as the default view of your table.
You can set the table details as per your requirement.
Note: Only users with Administrator Access Level can set and edit the table details.
You can watch this video to understand Table Details: