Using Subform Data to Update or Create Form Data

Introduction

Functions

Using subform data to update or create form data means adding or updating data in subfields of one form, triggering an automation to update or add the form data in another form.

Application Scenarios

In production management, all basic product information is recorded in a Product Management form and the details of each product are recorded in a Production Record form. After a batch of products is produced, data is entered in the Production Record form and directly synchronized in the Product Management form through an automation, to automatically update and add product information.

Preview

1. Two electronic products have been entered in the Product Management form:

2. Enter the information of products produced this time in the Production Record form:

3. Trigger an automation to update or create record in the Product Management form:

Setting Procedure

Creating a Form

1. Create a form named Product Management and add the following fields:

2. Create a form named Production Record and add the following fields:

Setting an Automation

Add an automation named Production Synchronization. When a batch of products is produced, you can query the information in the Product Management form through Automations. If the same product has been already produced before, the manufacturer is updated simultaneously. If the same product has not been produced before, the product is added to the Product Management form.

1. Configure a trigger in the automation:

2. Configure a triggered action in the automation:

Demonstration

See the section "Preview".