Hi, I have a sharepoint list datasource with a series of questions and an accompanying question ID number ('QID'. NB: This is a different column than the auto-assigned 'ID' column)
E.g
| 'QID' | 'Question' |
1 2 3 4 5 6 | Question text question text question text question text question text question text |
etc
This is displayed to the user in a standard gallery, with some input controls alongside and a button to Patch in new questions to the list if needed.
Users may need to add a question which falls, for example, between 3 and 4 in the order. Currently, I'm attempting to write a function whereby the user would write their new question, and assign it QID: 3. This should then increment the QID for the current Q3 and all subsequent QIDs by +1, slotting the new q3 nicely into the order and moving everything after it up by 1 place. I am so far unable to come up with a working solution!
Any help or suggestions will be greatly appreciated. Thanks