How to reset sequence number in subtable?

Due to certain reasons (such as record deletion), the sequence numbers in the numeric subtable fields may not be in your preferred order. To reset the order, you may follow the steps below.

1.

Go to the sheet design mode, click Form Tools and choose Update Values".

2.

Choose the subtable field with the default value $SEQ and enter {{$SEQ}} under "with these values". Also remember to tick the "Update all subtable records" option under Advanced setting.

Save the design after you create the button.

3.

The result:

Originally, the order of the sequence numbers was 1, 3, 4, 5.

After the reset, the order became 1, 2, 3, 4.