This is the structuring element of TimeTonic.
A workspace gathers all your essential business data. It can be personal or collaborative by inviting other people.
It allows you to store and retrieve all your business data.
It is composed of several elements:
- Your tables on the left band
- Your database on the central part
- Views of your tables on the top banner
- Options on the central strip above your database
You can set up access to your data in a completely personalized way.
A workspace can contain several tables.
A table (or database) is a set of data in table form, which you can manipulate much like a sheet in an Excel spreadsheet.
Each table contains rows - also called records - and columns - also called fields.
Each row is a record (for example a contact) containing all the fields describing this customer (for example Name, Address, Phone, Photo, etc).
Each table can contain different types of columns (Text, Number, Date, Checkbox, List, Link between tables, Attachments, Comments, etc. in all more than 20 different types).
Link your tables together to create a powerful collaborative management tool.
A link is a bridge between 2 tables. It allows you to make your data communicate between them.
Let's take a simple example:
I have contacts to whom I assign positions.
A single contact can have only one position.
There are therefore 2 tables:
By linking these two tables, I can retrieve information from one table to the other and navigate between them with a single click.
Thus, on the "Jobs" table, I can find all the contacts related to each job and vice versa.
Organize your data according to views to optimize your business process.
A view is an organization of table data.
Essential to your business process, it allows you to filter, sort and organize your data in order to make the best use of them and to mark out the path of your collaborators or simply the access to certain data.
All your views can be used on your links. For example, if you want to display only vacant positions when you create a link from your contact, create the view filtering on the records in question and apply this view to the link in question.
Filters and sorting
Filters and sorting are essential elements for the proper management of your data.
Based on existing columns, filters allow you to display only the records that are useful for your business process. Each column type has its own set of filters. (You have a whole range of filters for dates for example).
Sorting works on the same principle of existing columns and allows you to order your data. Very useful to get the information to the right level.
Combined with the views mentioned above, you can build mirror books dedicated to a specific process or type of data.
Mirrored workspaces have the specificity of having only views from other workspaces.
They allow you to create a tool that is free of anything "superfluous" for your employees and to give them access only to the process you have established.
Combined with views, filters and sorting, this is the ideal way to provide your employees with the data they need to run your business without giving them the power to modify the structure or touch sensitive or unchangeable data.