Advanced Features In Table Fields

Do you want to hide some fields from the grid or edit the form? Do you want to display the field description next to the field header in the edit form? You can set up these and many more features in Tabidoo.

If you feel already enough confident about the basics of Tabidoo, it's time for you to become familiar with the advanced features which you can set up in Tabidoo.

In this chapter we will focus on the advanced features in Table Fields:

Where to find Advanced features in Tabidoo

You can find the advanced features under the Field type in the Table fields settings. Once you click on the Advanced features, you realize that it offers many possibilities in Tabidoo. These options differ depending on the field type.  

When you select field type Text, these options appear:

What can you set up in Advanced features in Tabidoo

Field Description

- You can use this feature if you want to inform the user, what is this item good for or you can use it as the manual on what exact data should be entered into the field.

Field description in edit form

Afterwards, when you open the edit form in Tabidoo, you can see next to the field header a question mark. In order to see the field description simply point to the question mark.

Show in grid

If you want this field to appear in the Table, select this option. This option is automatically preset once you add a new field.

Feature to Show in grid

Show in edit form

If you want to display this field in the edit form, select this option. This option is automatically preset once you add a new field.

Feature to Show in edit form

Use as a default sort

If you want all the records in your table to be sorted by this field, then select this option. In case you set up as a default sort any text, it will be sorted alphabetically. Moreover, you can also select if data will be sorted as ascending or descending.

GDPR sensitive - print

If you keep in Tabidoo any sensitive data, this feature helps you to keep them in one place in case you wanted to print them all. You can afterwards put these data in your report and print them when necessary.

GDPR sensitive - delete

This feature is also determined for your sensitive data in Tabidoo. This option helps you to keep them in one place and delete the data whenever needed.

However, for these two options, it is firstly essential to define your table as "GDPR root" see more in the chapter GDPR.

To see all the sensitive data you keep in our table, select this option from the main menu:

GDPR in Tabidoo

Show in the record description (link to a table, edit form header, record audit)

By selecting this option you setup three things:

1) Once you link data between tables, this feature can help you to set up which field should display in the table description in the edit form. This can be only set up in the field of the source table.

Feature to Show field in the table description

2) This field will also appear as the edit form header.

Feature to Show field as the edit form header

3) And finally, it will be set up as the object description in the record audit.

Object description in the record audit

Import key field

Import key field serves as the data identifier when you import data from Excel to Tabidoo. It identifies the data in order that there will not be any duplicates and the already existing data in your table will be updated by the Excel file. When you make a new table, the first field of the table is automatically preset as the import key field.

Frequently searched column (can increase search speed)

If you search and filter your data often in any of your columns in the table, this feature helps you to speed it up. However, be careful it enlarges databases that your table includes. Therefore, it is important to set it up only for the fields where it is really necessary.

Values in this column must be unique

In order to avoid any duplicates in the column, select this option.

Show in lookup

Once you link data between tables, this feature can help you to set up which field should display in the lookup of the linked table. This can be only set up in the field of the source table.

Feature Show in a lookup

Hide on public form

It is possible to make your form public in Tabidoo and share the link with anyone. By selecting this option you simply hide the selected field from the public form.

Show in sub-table grid

When you link two tables in Tabidoo and use the type of binding One to many, by selecting this feature you make this field display in the grid in the edit form of the linked table.

Feature to Show in sub-table grid

Category

By entering Category, the selected field will be divided from other fields in the edit form. To divide more fields under the same category, simply copy the name of the category into the field "Category" of the selected fields.

Divided fields into categories

Default value

The default value is useful once you want to easier the work for users and automatically pre-fill some values in the fields in the edit form. It can also be used when you want some values to be filled in a certain way. For example - a phone number with a phone number prefix.

The default value in Tabidoo


Extra feature for - Radio, Dropdown, MultiChoice

There is one extra feature for these field types:

Feature to Use color stickers for the calendar

Use color stickers for the calendar

The default color for all the stickers in the calendar is blue, however, if you give each dropdown specific background color in the settings and select this advanced feature, the color will afterwards change based on the specific color of the dropdown/radio/multi-choice.

Color stickers for the calendar

Extra features for - Date, Date & time

There are two extra features in these types of field types compared to field type Text:

Extra features for the field type Date

These two options are used when you have two fields Date in your table. You can set up that these two dates will be displayed in the calendar as a date from and date to. The following picture shows how will the dates afterwards displayed in the calendar view in Tabidoo.

The Calendar view in Tabidoo

Use as a date from in calendar view

By selecting this option, the field date will be seen in the calendar view as the date from.

Use as a date in the calendar view

By selecting this option, the field date will be seen in the calendar view as the date to.

Field type - Number

There is an extra feature compared to field type Text:

Automatic identifier 1...X

This feature automatically identifies the order of the records in which they were added to the table and numbers them from value 1 to x.

The option "Choose columns" provides you to group the records and number them depending on the selected field.

For example, if you select the field "Date" It can number the records every new month from 1 to x. If you for example select the field "Name" It can number those records from 1 to x that are connected to a certain name.

You can select as many fields as you wish and group your records under them.