Data Synchronization

Introduction

Functions

Output tables calculated by a data factory can be synced with its calculated data to forms. Supported synced ways：

Application Scenarios

Setting Procedure

Where to Set

Click Data Factory > Output > Sync output table data into forms.

Sync Rule Settings

Click Settings next to Sync output table data into forms to set specific rules.

a. During the syncing process, all the data of the output table will be added to the form without deleting existing data.

b. Maximum of 20,000 rows and 200 columns of data are allowed when you sync data and maximum of 300 workflows can be triggered.

1. Setting sync forms

The options to sync the output table data include Sync up to New Form and Sync up to Existing Form.

a. Sync up to New Form: create a new form the first time you sync the data, and subsequent data will be synced on this new form, instead of creating a new form for each sync.

b. The data sync rule setting will also be changed from Sync up to New Form to Sync up to Existing Form and the existing form will automatically replace the new form.

When you select Sync up to New Form, check the fields you want to sync and click OK.

You need to select the form to be synced first. Only forms from this application can be synced (cross-app forms are not supported).

Note: When you sync up to an existing form, you can only select forms that have not been calculated by the data stream. None of the input source forms in the data stream are supported to be synced by the output tables.

Next step, you need to set up the field mapping between the output tables and the synced form fields.

When the field data of the output table is synced, it needs to correspond to a field of the synced form to ensure the accuracy.

2. Setting sync modes

The following two types of synchronization settings are supported:

a. Auto

You need to set Scheduled Update in the Update Rule. Only a successful update will trigger data syncing between output tables and forms.

b. Scheduled update

You need to set Sync Start and Sync Schedule. The sync schedule supports:

The scheduled rules can be modified later if you need to modify rules.

Then, you can click OK to save settings.

c. Manual

You can also sync data manually by clicking Sync Data for emergency data sync.

When the sync is complete, you can view in the top right corner of the page whether the sync was successful or not. If the sync succeeds, it will show Data sync completed. If the sync fails, please refer to the Sync Failure Instructions to troubleshoot the problem.

Preview

For the synced form of data factory output tables, it will display Data Streams next to the corresponding form when you view in the app, meaning that the form is a synced form for an output table.

Form data synced by output tables with empty created users.

Notes

1. All data in output tables is synced to the corresponding forms every time.

2. Existing data in the form will not be deleted when you sync data.

3. The workflow form will be automatically triggered after the data is synced and the workflow will automatically flow to the next node.

4. If the next workflow node approver cannot be found, the workflow history shows failed submission, and the workflow is automatically ended.

5. Data synced to the form does not trigger form validation (including required validation, submission validation, duplicate value validation), does not trigger formula, data linkage, default value acquisition, and does not trigger automations.

6. Maximum of 20,000 rows and 200 columns of data at a time and maximum of 300 workflows can be synced simultaneously. The output table will fail to sync after exceeding the limit and no data will be synced.

7. Cases in which the data stream cannot be saved.