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.
