How to automatically re-order the list of questions in sequential order?

Hi, I have a data table that allows the users to fill in a question form and each question is listed in order of 1,2,3,4,5,6…14
The user is not allowed to put in a repeated question number.

However, if the user edits the question number from 2 to 15 and saves it.

After saving, the question number is no longer in the sequential order and becomes 1,3,4,5…15

How can I make the order become sequential automatically after a user edits the question number?

0 5 374
5 REPLIES 5
Top Labels in this Space