Skip to main content
Subform Filler
Updated this week

What is a Subform Filler?

Subform Filler contains the following two functions:

  • Through the "Auto Add Rows" function, you can input the required number of rows in a field and the subform will automatically add the rows for you. Then you can enter the data in the subform without having to add rows frequently, which improves your efficiency.

  • Through the "Split Multiple Options" function, you only need to select the required values from the Checkbox field, and they will be filled in the subform automatically. Therefore, you do not need to enter data repeatedly, which avoids errors during form-filling.


When to Use a Subform Filler?

You can use this plugin to input multiple data in the subform.

  • For example, in the case of inventory management, you can use this plugin to add the corresponding number of subform rows according to the total supply categories. You can also select items from Checkbox so the items will be filled in the subform automatically.

  • In the case of product management, you can input the number of product series, and the subform will add the corresponding rows automatically. You can also select the products from Checkbox, and the product names will be filled in the subform automatically.


What does it Look Like?

In the case of inventory management, you can use this plugin to add the corresponding number of subform rows according to the total supply categories. You can also select items from Checkbox so the items will be filled in the subform automatically.


Installing & Enabling the Plugin

Installing the Plugin

1. Install the plugin directly.

  • Click the link to install Subform Filler.

  • After installing the plugin, refer to the section "Enabling the Plugin" and go to Open Platform > Plugin to configure and enable the plugin.

2. Install the plugin in Market.

Go to Market and install the Subfom Filler plugin. For details about installing a plugin in Market, refer to the section "Installing Plugin(s)" in Plugin Market.

Enabling the Plugin

In Plugin, click the icon to enable the plugin.


Designing a Form

Take inventory management as an example: You need to create an Inventory Management form with the following fields:

Field Description

Field Name

Field Type

Item Category

Department

Department

Item Category

Number of Categories

Number

Item Category

Item Details

SubForm

Item Category

Number

Single Line

Item Category

Item Name

Single Line

Item Category

Unit Price

Single Line

Quantity

Number

Single Line

Select Items

Item Name

Checkbox

Select Items

Select Items

SubForm

Select Items

Item Name

Single Line

Select Items

Unit Price

Single Line

Select Items

Quantity

Number


Configuring Front-End Event(s)

Auto Add Rows

1. Add a front-end event.

Go to Form Properties > Front-End Event, and click Settings to add a front-end event.

2. Set the event name and description.

After adding a front-end event, you need to enter basic information about the event, such as the event name and description.

3. Set the trigger.

This plugin will add the corresponding number of rows to the subform according to the value entered in the Number of Categories field. Therefore, you need to select Number of Categories from the drop-down list under Field that triggers the event.

4. Set the triggered action.

a. Set the triggered action as follows:

  • Select the plugin: select Subform Filler > Add rows automatically.

  • Set the number of added rows: select Field Value > Number of Categories.

b. Set storage mapping rules. Click Add, and set the rule as saving SubForm.Order to the Item Details.Number field. Click Save after the settings.

Note:

If you do not need the Number field, untick View in Field Properties > Field Permissions.

Split Multiple Selection

1. Add a front-end event.

On the Front-End Event page, click Add Front-End Event.

2. Set the event name and description.

After adding a front-end event, you need to enter basic information about the event, such as the event name and description.

3. Set the trigger.

This plugin will enter data into the subform according to the selected options in the Checkbox field. Therefore, you need to select Item Name (Checkbox) from the drop-down list under Field that triggers the event.

4. Set the triggered action.

a. Set the triggered action as follows:

  • Select the plugin: go to Subform Filler > Split Multiple Options.

  • Select a multi-select-type field (Checkbox/Multi Select field supported) under Multiple Selection : select Field Value > Item Name.

b. Set storage mapping rules. Click Add, and set the rule as saving SubForm.Option to the Item Details.Item Name field. Click Save after the settings.


I have finished reading. 🏆

👉I can't wait to Try for myself.

👉I need more HELP in Discord Forum.

Did this answer your question?