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?
User | Count |
---|---|
25 | |
15 | |
4 | |
3 | |
3 |