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
You can use this feature if you want to inform the user, what is this item good for, or you can use it as a guide to accurately enter data 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.
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
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
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.
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.
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
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 settings of the linked 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 as the object description in the record audit.
Object description in the record audit
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.
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.
In order to avoid any duplicates in the column, select this option.
Once you link data between tables, this feature can help you to set up which fields should display in the lookup of the link to table field. This can only be set in the field settings of the linked table.
Feature Show in a lookup
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.
If you link two tables in Tabidoo and use the One to Many binding type, selecting this function ensures that this field appears in the grid of the linked sub-table.
Feature to Show in sub-table grid
Entering Category separates the selected field from the other fields on the edit form. To split multiple fields under the same category, simply copy the category name into the "Category" field of the selected fields.
Divided fields into categories
The default value is useful if you want to make things easier for users and automatically pre-fill some values in edit form fields. It can also be used when you want certain values to be filled in a certain way. For example - phone number with area code.
The default value in Tabidoo
There is one extra feature for these field types:
Feature to Use color stickers for the calendar
The default color for all the stickers in the calendar is blue. However, if you set specific background color for each dropdown/radio/multi-choice in the settings and select this advanced feature, the color will change accordingly.
Color stickers for the calendar
These field types have two additional functions compared to the Text field type:
Extra features for the field type Date
These two options are used when you have two Date fields in your table. You can set them as a date from and date to to specify the duration of, for example, a project.
The following image shows how the dates will subsequently appear in the calendar view in Tabidoo.
The Calendar view in Tabidoo
By selecting this option, the date field will display in the calendar view as the date from.
By selecting this option, the date field will display in the calendar view as the date to.
There is an extra feature compared to field type Text:
This feature automatically determines the order in which records were added to the table and numbers them from 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 date field, it can number each new month's records from 1 to x. If you select a text field (e.g. Name), it can number the records from 1 to x that are associated with a particular name.
You can select any number of fields and group records by them.