Knowledge Base
How can we help?

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.

Top of Page
Learn more about Ragic:
Why we created Ragic
Webinars
User Guide
Ragic Pricing
Applications
Keep in touch:
Blog
Facebook
YouTube
Ragic, Inc.
1-888-666-8037
Terms
Privacy
info@ragic.com