In Tabidoo’s applications, you can use several basic types of table fields.

Types of entering data into tables in Tabidoo

In this chapter, we will take a look at the meaning of the individual items and how to use them.

Short text

Short text can be used to enter a title, type of product, or name. It can have a maximum of 100 characters.

Short text field in Tabidoo

Long text

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.

Long and formatted text in Tabidoo

Radio

Checklist with only one option.

Radio field for checking one of the options

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.

Dropdown field for checking one of the options

Multichoice

It is a checklist which allows you to select one or more options.

Multichoice field for checking one or more options

Checklist

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.

Checklist field for creating lists

Yes/No

It is a single check box. It is ideal, for example, for recording whether an item has been completed or not.

Yes/No field for indicating completed items or validity of records

Date

It is a field for displaying the date in the selected format.

Date field in Tabidoo

Date and time

It is a field for displaying the date and time in the selected format.

Date and Time field in Tabidoo

Money

It is a field for entering numbers with a maximum of two decimal places (e.g., 3.14).

Money field for entering numbers with a maximum of two decimal places

Money With Currency

This field is used to enter and automatically convert money between currencies.

Field type Money With Currency for automatic money conversion

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.

Field type Money With Currency for automatic money 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.

Decimal

It is a field for entering a number with multiple decimal places (e.g., 3,14159265359).

Decimal field for numbers with multiple decimal places

Number

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).

Number field for working with numeric records

Calculated Field

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.

Calculated Field for arithmetic field operations

Chat

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.

Chat field for comments and discussions

Tags

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.

Tags field for tagging and filtering records

Picture

It is a field for inserting an image. 1 field = 1 image. If you need more pictures, insert more fields.

Picture field for insertion of pictures and illustrations

Files

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.

Files field for inserting files up to 1 MB

It is a field for insertion of a link at https:// or a link to an e-mail box.

URL / MailTo field for linking a field with a website or e-mail

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.

Link to Table field for linking other tables

System Records

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.

System Records field for important records about work with the table