Tables and Columns
All data stored in application database is presented with the help of tables.
A table serves as storage for the data of particular type, such as Contact, Activity or Task. The application may consist of single table as well as have many tables. Each table presented in TeamDesk as tab, allowing to switch between tables quickly. A data entry in a table is called a record.
A column represents specific attribute of the data. For example, a Contact is usually represented with first and last name, an address, a birthday, a list of phones, e-mails etc. Each of these in terms of TeamDesk is a column.
Columns in TeamDesk hold the data of one type. Names are text, birthday is date, e-mails are of special "email" type. The type defines validation procedure against user input: the user can not place the text, say "John Doe" in the column that expects the number, the date or e-mail. The type also defines the set of operations to perform: you may concatenate texts, calculate a total or an average on numbers, compute next date etc.
And in case you need to transform the data or calculate the value based on user input, TeamDesk provides you with powerful formula language.
