Skip to main content
Adding Records from Subform to Form

Learn how to add records from subform to form

Updated over a week ago

After adding or updating data in the subform fields of a form, you can use Automations Pro to add the data to other form fields. If you have to add or update multiple records in the subform, then these records will be added to another form.


When to Use this Feature?

Scenario Name

Problem Statement

Problem Solving

Car management

Difficult to synchronize car usage details in the Car Application Form to the other form Car Usage Records

After entering a record to the subform of Car Application Form, trigger Automation Pro and add the record to the main form of Car Usage Records

Task notification management

Difficult to synchronize notification details of the form Basic Data to the form Task Notification

After entering a record to the subform of Basic Data, trigger Automation Pro and add the record to the main form of Task Notification


What does it Look Like?

After entering the information of a task in a Basic Info form, Automations Pro automatically adds the information to a Task Reminder form and starts a workflow.


How to Set up?

Step 1 Building a Form

1. Create a Basic Info form. The field settings are as follows:

Field Name

Field Type

Field Setting

Member Name

Member

/

Department

Department

Task Info

Subform

Task Name

Subfield - Single Line

Start Date

Subfield - Date&Time

End Date

Subfield - Date&Time

Description

Subfield - Multi Line

2. Then create a workflow form Task Reminder, and add subfields from the Basic Info form to the Task Reminder form as fields. The settings are as follows:

Field Name

Field Type

Field Setting

Member Name

Member

/

Department

Department

Task Name

Single Line

Start Date

Date&Time

End Date

Date&Time

Status

Radio

Options: Not Started, In Progress, Completed

3. On the Workflow page, set the workflow for the workflow form. The settings include choosing approvers at each node and setting the field-viewing permission. For details, see Configuring a Workflow.

  • Set Field Permissions (including the permissions for viewing/editing certain fields) for the start node.

  • Tick all fields under View and Edit at the task node, and choose an approver at the node. Then the approver has permission to view and edit all fields in the form and can receive tasks.

Step 2 Creating an Automation

To create an automation,

1. Go to Extension > Automations, and click New Automation.

2. Rename the automation.

3. Choose the trigger type Form Trigger, and choose Basic Info from the drop-down as the triggering form.

Step 3 Setting the Trigger Node

Select the trigger node and choose Add record as the trigger event. When you add a new record to the Basic Info form, Automations Pro to be triggered to perform certain actions.

Step 4 Adding an Action Node (Add record)

Add an Add Record node under the trigger node.

Step 5 Setting the Action Node (Add record)

Set the Add Record node as follows:

  • Select a target form: choose Task Reminder as the target form. Then once Automations Pro is triggered, it will add records to this form.

  • Set the field value:

  • Task Name equals Trigger Data--Task Info. Task Name

  • End Date equals Trigger Data--Task Info. End Date

Step 6 Saving & Enabling

After completing all the settings, click Save & Enable to put the Automations Pro into actual use.


More to Know

1. If you want to learn more about how to assign values using subform fields when choosing the trigger event Add record, refer to Subform Assignment Rules.

2. When you add records from the subform of a triggering form to a target form, the number of added records remains the same. If the subform is empty, then no record will be added.


I have finished reading. 🏆

👉I can't wait to Try for myself.

👉I need more HELP in Discord Forum.

Did this answer your question?