Subform Table

What is it? 

This widget is a table designed to display data from a Subform. Please note that only one Subform can serve as the Data Source at a time. In the Subform Table, you can perform basic statistical functions such as summing and averaging.

It's important to understand that a subform is not an independent form. You cannot utilize a regular form table to retrieve a subform list. Instead, you need to employ a dedicated Subform Table widget. Here's an example scenario where you might find the subform widget useful:

How and When to use it?

To add a new Subform Table to your page, simply drag and drop the “Subform Table” widget from the left-hand side of the page screen to the design area of your page.

The Name of the SubForm Table can be changed in the blue Quick Settings panel that pops out when you click on the placed Form Table widget.

How to configure?

Click on the widget once to open its Quick Settings panel.

Data Source Settings

The popup window Data Source Settings consists of four steps.

In the first step, Data Source, the user selects the subform that will serve as the Data Source. The selection process involves two dropdown menus.

The first dropdown menu allows you to choose the app where the desired subform is located. The second dropdown menu displays the names of the available subforms within the selected app.

There are two sets of data source filters available: one for the form and another for the subform. By applying these filters, you can control and customize the data retrieval process, ensuring that the form and subform data are appropriately joined together.

In the second step Display Filters, the user can apply display filters on the subform data by adding conditions.

The left side operator of these display filter conditions only accepts widgets that are in the subform that is the data source.

In the third step column settings, you can select the widgets to be displayed and modify their column name, sequence, alignment, sorting column, width, or display format. Once you have made the desired changes, simply click the "Continue" button located in the upper right-hand corner to proceed.

In Step 4, the user can create statistical values which perform a simple statistical function on a column of the subform table.

The values are available for use in the Calculation tab of other widgets as widget values.

Widget Property Setting

You have two options to access the "Widget Property Settings" window. You can either click the "Widget Property Settings" button or simply double-click the Form itself.

General

You can change the name of the Table widget and the Description (optional, used to explain the purpose of the Table).

You can set the Position, Size and Layout of the Table widget. In case you place the widget in a Container, you can change the size mode between “Absolute” and “Relative Size”. You can also set the position (X and Y coordinates) of the Form in the container

You can control how many records are to be displayed in the Table per page by choosing the “Default Record Limit” option.

With the “Display in” setting, you can control whether it is the widget display only in “Web and Mobile” platforms or only in “Mobile” devices platform only.

Visibility

With the visibility setting, you can control when should the Table become visible or invisible on the screen to the users.

Once you click on the "Visibility" tab, the condition settings display will be available. Here, you can set the default visibility of the widget. You have the option to make it visible or invisible, as well as define whether it should be read only to the users by default.

By clicking on the dimmed area “+ New Conditional Visibility”, you can add different conditions for the widget to become visible, invisible or read-only.

In this example, we have two conditions. The first condition sets the widget to be visible and read-only, while the second condition sets it to be invisible. The visibility of the widget is determined by the first condition that is met. Any subsequent conditions will be ignored once a condition has been met.

Once you have prepared all the conditions for different visibility requirements, simply click the "Submit" button located in the lower right-hand corner.

Function

With the “Function” setting, you can control how each “Run Time User Role” can access different Table functions. You do not need to change this setting if not for a strong reason. Click the “Submit” button to save after any changes.

Widget Permission Settings

With the “Widget Permission Settings”, you can control how different “Run Time User Role” can access the widget.

Copy Widget Settings

After you have finished preparing the settings of the widget, you have the option to copy its settings to other widgets that share the same requirements. To do this, click the "Copy Widget Settings" button.

From there, you can select the target properties and widgets for the copy operation. It is important to save all changes to the page before initiating the copy process.

Example

In this example, we choose to copy the “Height” and “Display In” properties from the “General” tab.

We can also copy the visibility rules/conditions.

Choose which Run Time User Role access right to copy

Choose which Run Time User Role Function to be copied

Once you have chosen all the properties you wish to copy, you can select the specific "Target Widgets" to apply the copied settings. If needed, you can use keywords to filter the target widgets. Simply enter the keywords and the relevant widgets will be displayed. Click on the target widgets, and they will be highlighted in blue to indicate selection.

Once you have selected all the desired widgets, you can initiate the copy process by clicking the "Apply" button.

Click the “OK’ button to confirm the copy.

Remove

If you click the delete button, a popup message will appear asking for confirmation before the widget is deleted. You can either click delete or cancel to leave without changing anything.

Use Cases for Subform

Step 1. Create a Page called Game Form. Add the following three widgets to this Page.

Step 2. Click on the subform to open the subform builder. Add the following widget to the subform.

Step 3. Click on the cross on the top right to exit the subform builder. In the Page Builder, click Save, and then click Preview to view the App.

When opened, each Game Form has a Table that lists all Subform entries, in the place where the Subform was placed in the Builder, with an “+Add” button, which is an Add Subform button, on the top left of the Subform table.

Unlike Form, there are no Button Settings, and it is not possible to hide or modify this Add Subform button at all. It is also not possible to add display filters for the Table of the Subform widget.

Step 4. Click on “+Add” to open a Game Subform. Enter “John” in Participant Name, then click “Save.” Then click “+Add” again. Enter “Tom” as a Participant, and save.

Step 5. Enter “Soccer” in Game Name and save the Game Form. Refresh the page, in order to load a new Game Form. Set “Basketball” as Game Name and add “Tim” as the sole Participant. Then, exit to the Page List.

Step 6. Create a New Page called “Game List”. Then in the Page Builder, add the following widgets to “Game List”.

Step 7. Click on Data Source Settings.

Click on the Subform Table to open its Quick Settings Panel.

In the first step, set “Game Form - Game Form”, “Game Subform” as Data Source. Enter the following filtering condition for the Form.

In the 2nd step Display Filters, enable “Fulfil Filter” and add the above filtering condition for the Subform.

In the 3rd step Column Settings, ensure that “Game Name” and “Participant Name’ are checked.

Step 8. Skip the 4th step, then click Finish to go back to the Page Builder. Click Save and Preview to open the app.

When opened, the “Game List” page consists of a Subform Table that shows the values of subforms and the forms they belong to, and two search fields for the Subform Table. Only the Subform Table is capable of using a Subform as a Data Source; none of the other Table widgets can do this.

Enter “T’ in the Participant Name search field. For matching results, the Subform Table can show similar subforms that belong to different Forms.

Enter “T’ in the Participant Name search field, and “B” in the Game Name search field. The Subform Table can filter for subforms that fulfil multiple search conditions.