This solution applies when two forms need to share the same numbering sequence, such as in inventory management.

For example, there may be two stock-in forms: one used by sales representatives and another used for general stock-in records. When data is submitted through either form, both forms must use the same numbering sequence.

The final numbering sequence is as follows:

Use the MAPX function to generate sequence numbers for both forms, together with a Refresh button and an Aggregate Table.

The Refresh button is also required for concurrency control to prevent duplicate numbers when multiple records are submitted at the same time.

Form 1 and Form 2 use similar configurations, with slight differences in their formulas.

Serial Number: Add a formula to the Serial Number field. In the field properties, also enable validation to prevent duplicate values.

Radio: Add a radio and name it Refresh.

Helper Field 1: Add a Single Line field and set its default value to 1.

Helper Field 2: Add a Number field and set its default value to 1.

Serial Number:Add a formula to the Serial Number field. In the field properties, also enable validation to prevent duplicate values.

Radio : Add a radio and name it Refresh.

Helper Field 1: Add a Single Line field and set its default value to 1.

Helper Field 2: Add a Number field and set its default value to 1.

Use an Aggregate Table to ensure that duplicate numbers cannot exist across the two forms.

Add a Number field to each form and set its default value to 1. Then configure the following formula:

Set the aggregate validation condition to:

As shown below, the numbers generated in Form 1 and Form 2 together form one continuous numbering sequence.