In Tabidoo’s applications, you can use several basic types of table fields.
In this chapter, we will take a look at the meaning of the individual items and how to use them.
Short text can be used to enter a title, type of product, or name. It can have a maximum of 100 characters.
It is a field for longer texts the length of which you can specify in the settings. It is used to insert formatted texts (such as in italics or underlined). It is suitable for entry of long texts, such as product descriptions, procedures, or other records.
Checklist with only one option.
It is a checklist with only one option in a different graphic design. If you need to have multiple check boxes, it will help you differentiate between them and they will be presented in a more organized manner.
It is a checklist which allows you to select one or more options.
It is a checklist which allows you to select multiple fields. It is ideal for creating lists of tasks, lists of items, or for displaying the completion of important project items.
It is a single check box. It is ideal, for example, for recording whether an item has been completed or not.
It is a field for displaying the date in the selected format.
Date and time
It is a field for displaying the date and time in the selected format.
It is a field for entering numbers with a maximum of two decimal places (e.g., 3.14).
Money With Currency
This field is used to enter and automatically convert money between currencies.
Firstly, you have add the currencies you want to work with by clicking on "Add new field" button under the "Currencies for Money with currency" section. Secondly, you can choose to automatically load the exchange rate according to the internet provider or you can define your own rates in the Exchange Rates extension.
Exchange Rates extension can be extended with any additional columns. For example, the exchange rate type. For the input field, you can then restrict what type of rate is used for conversion.
Once everything is set up, in the edit form you can enter a price and select the currency which will be then converted to the other predefined currencies and will appear in the grid.
It is a field for entering a number with multiple decimal places (e.g., 3,14159265359).
It is a field for entering numbers with which you wish to work further (sort, compare, or evaluate them). You can also use the Short text item for numbers which you do not need to compare (e.g., EAN codes or telephone numbers).
It is a field which allows you to perform basic arithmetic operations with other fields. For instance, it can add a quantity field to a price field. Or it can assign a First Name field to another Last Name field.
In Table Item Settings, you specify the fields which you want to work with.
It is a discussion between the users of the given database. It is suitable for commenting on the content or for important remarks. You can use it for notes or revisions.
It is a field for creating labels (tags). You can use it to tag topics, products, departments, or other data by which you want to filter.
It is a field for inserting an image. 1 field = 1 image. If you need more pictures, insert more fields.
It is a field for attaching one or more files each up to 50 MB of size. In case you want to attach more than one file, select the option "Allow multiple files" under the field type.
It is a field for insertion of a link at https:// or a link to an e-mail box.
Link to Table
It is a field you can use to link to another table in your Tabidoo.
In Table Item Settings, you specify the tables with which you want to work. See more in chapter - Type of Binding.
It is a field in which you can indicate who worked with the record, what version it is, or whether the information is GDPR sensitive.