What is a Table?
In Orgzit, Workspaces are synonymous with Workbooks (like in any spreadsheet software such as MS Excel or Google Sheets). Each Workspace can have one or multiple Tables. Orgzit Tables are synonymous with Sheets - and this is where data is stored in Orgzit.
Orgzit Tables allow you to store, organize, and analyze data. With Tables, you can track every activity that constitutes a workspace. For a Human Resource team's recruitment workspace, for example, you could create separate tables for Job Descriptions and Pay Scales, Candidate Applications, and Candidate Interviews.
Orgzit lets you create as many Tables as you need so that every aspect of your information workflow is neatly organized and tracked. Like any other database application, Orgzit Tables are made up of fields and records:
Fields are the database equivalent of a spreadsheet column. Each Orgzit Table can have one or more fields. Unlike in spreadsheets, each Orgzit field can have a special field type for different kinds of rich content. The field types in Orgzit include date, decimal, document, image, integer, string, user, relationship, and more. They help you ensure your all your data is captured and stored systematically.
Each row of an Orgzit Table is a record. Every record holds your the information your want to keep track of. For example, in a Contacts Table, each record would be a contact of a person, and in Assets Table, each record would be an Asset that you are tracking.
Creating a Table
A new Table can be added to any Workspace in two ways.
- You can create a Table from scratch. To do so, select the appropriate option, create data fields, and set up your table.
- Via uploading a CSV
Note: You need administrator rights to be able to access the Manage Project page.