Adding fields to tables
Each Field has a Label and a Type. See the File types page for a detailed explanation.
The label can include uppercase and lowercase letters, spaces and punctuation. See examples of the labels below.
Each new field is a column in your table. Every field has:
- a Label : a name for the field.
- a Type :
- String - text.
- Integer - a number.
- Bool - a Boolean value, that is a value that can be true or false.
- Date - Date and time
- Float - a floating-point number. For example, the numbers 5.5, 0.001, and -2,345.6789 are floating point numbers.
- Color - a colour value in RGB colour space. Stored internally as a hexadecimal number, e.g. "#00ff88".
- HTML - an HTML field for editing in HTML.
- Markdown - a Markdown field for writing in markdown.
- File - Any file, including an image.
- Key to a different table, a user, or a file. A key here means that your field will hold a reference to a row in a different table. For instance, in a database describing a company, you may have a table for employees and a table for departments. The Employee table could then include a field that is a key to the Department table, denoting in which department the employee works. Also, the Department table may hold a field with a key to the Employee table showing the head of the given department.
Every field may also be:
- The expression must result in a string type.
- Use ID and Color fields as variables.
- Required - the field cannot be empty. You may also be asked to enter a default value. This is asked if you are adding a required field to a table that already has data. Because a value must be present for the existing fields, you supply one as the default value when creating the field. This value will be assigned as the new field value in all the existing rows.
- Unique - the field must have a unique value not be repeated in other rows. For instance, an ISBN number in a Table about books, must be unique to each book.
Examples of Labels
For a blog, this could be: Post title, Post date, Post text, Post author
For a Wiki, this could be: Wiki title, Wiki text, notes, references
For a database of Vinyl LPs, this could be: Artist, Album name, Track listing, Date, Record label, Cover art, Year, Review, and Key to a Songs table.
For a database of songs: Artist, Song title, Album, Writer, Date