Basic Fields

Basic fields are the most commonly used field types in Tabidoo. They are simple to configure, easy to understand, and suitable for everyday data entry without advanced logic or scripting.

These fields cover standard data types such as text, numbers, dates, and files. They are ideal for building straightforward applications quickly, while keeping the setup intuitive for all users.

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

The data type "Text" has a Custom Regex for Field Validation option at the Developer level.

To validate a phone number in the format "777 777 777," use the following regular expression:

\d{3} \d{3} \d{3}

 

  • \d{3} matches three digits.
  • Spaces are literal.

This regex ensures the phone number has three groups of three digits separated by spaces, e.g., "777 777 777".

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 the 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

Dropdown

This is a checklist with a single option in a different graphic design. If you need to have multiple checkboxes, it will help you differentiate between them and they will be presented in a more organized manner.

The dropdown field for checking one of the options

Multichoice

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

Multichoice field for checking one or more options

Checklist

It is a checklist that 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

Displays values according to the format defined in the application’s localization settings (date format, time zone, first day of the week). This format can also be further customized in the user profile settings (e.g., language, date/time format, 12h/24h clock).

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 the automatic money conversion

Firstly, you have to add the currencies you want to work with by clicking on the "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 the 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. To turn off the Show in table option, use the Currencies setup.

Decimal

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

The 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 that you do not need to compare (e.g., EAN codes or telephone numbers).

Number field for working with numeric records

Percentage

The field is designed to make working with percentages easier.

Stored value = displayed value /100. So if you enter a value of 10%, the system will internally store the number 0.1 So it can easily be used in multiplication when calculating.
 

All calculations are done in JavaScript. When using in calculations, please familiarize yourself with the behaviors and rounding issues in JavaScript (0.1+0.2 ≠0.3).

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
Images of the following formats can be uploaded to Tabidoo: avif, jpg, png, jfif, bmp, ico, svg, webp, heic.

If files are attached via services such as Dropbox, Google Drive, or OneDrive, image thumbnails will not be displayed. These services provide only a link to the file, which typically requires logging into the respective service.

Files

It is a field for attaching one or more files each up to 50 MB in size. In case you want to attach more than one file, select the option "Allow multiple files" under the field type. To download attachments you need to save the form.

Files field for inserting files up to 1 MB. If files are attached via services such as Dropbox, Google Drive, or OneDrive, image thumbnails will not be displayed. These services provide only a link to the file, which typically requires logging into the respective service.

URL/ MailtoLink

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

System Records

The System Records field provides key metadata about a record—such as who created or last modified it, the version number, or whether it contains GDPR-sensitive information. This data is useful for auditing, tracking changes, and ensuring compliance with privacy regulations.

System Records field for important records about work with the table

For more details about the available system fields, see the System Fields article.

If you later need relationships between tables, automated calculations, or custom scripts, take a look at the Advanced Fields section.

 

Was this article helpful?