English Flag English Español Flag Español Deutsch Flag Deutsch Italiano Flag Italiano Polski Flag Polski Nederlands Flag Nederlands Português Flag Português Français Flag Français 中文 Flag 中文 日本語 Flag 日本語 हिन्दी Flag हिन्दी اللغة العربية Flag اللغة العربية Русский Flag Русский Українська Flag Українська עִברִית Flag עִברִית Ελληνικά Flag Ελληνικά Türk Flag Türk Latvietis Flag Latvietis Dansk Flag Dansk Norsk Flag Norsk Íslenska Flag Íslenska 한국어 Flag 한국어 Suomen Flag Suomen Gaeilge Flag Gaeilge Bahasa Melayu Flag Bahasa Melayu Svenska Flag Svenska Čeština Flag Čeština
User IconLog In
English Flag English

Log In

 

Linked records count (field type)

Using this field type, you can show the number of records in related tables

Using this type of field, you can show the number of related records from other tables.

This field becomes available in the Form Builder if you have a relationship between the tables, with Relationship or Subform field.


Example of using.

Here is the "Branch structure" table.

We have "Employees" form with (many-to-one) Relationship field. It linked with "Branch structure" table.

We added records to “Employees” table. Thus linked the employee to his department. Associated an employee with his department.

Now we need to go to the "Branch structure" Form Builder and add a new field to the form.

In the "Advanced" tab, the "Linked records count" field will become available. (You can enable the option "Make the field visible in the form").

As a result, we have a column with the number of employees in the department. Similarly, you can count the products quantity in stock, customer orders, etc.

On the field editing page, "Total and Average" tab, you can enable option to show total in the table.

For example, we can see the total number of employees in our table.

We hope you'll find many ways to use this field in your projects.