How to adjust serial numbers in a grid edit report while inserting the rows in between

Question

Hi ,
The requirement we have here is&nbsp;
Serial number field is Numeric data type. We have to adjust the serial number column in the grid edit while inserting any rows in between the existing rows. I have tried multiple ways but that is not working as we expected.
Example: Suppose If we have 10 rows with serial number 1,2,3 ---10. And user insert the two rows in between 2 and 3 , then the expected result is 1,2,3,---12. But we are getting result is
1,2,3,4,3,4,5,6,7,8,9,10.
Kindly suggest us if we have any solution.

Thanks &amp; Regards,
Madhavi.
&nbsp;
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;

------------------------------Madhavi Kanugondloola------------------------------

markshnier__you · Answer

Are you asking how to sort the report by serial? Or to auto number the rows sorted by serial number? I'm not understanding the question.

------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------

bhargavikatepa1 · Answer

No Mark , If she is inserting rows in-between 2 serial numbers like 2,3 and they have given serial number as 3,4 for the new rows as we are having 3 already it should make changes like new rows will remain as 3,4 only, old 3 should get change to 5. So, 1,2 remains same 3,4, are new rows and initial third row which is 3 becomes 5th row now. Either using pipeline or formula field or something. It is nothing but auto adjustment. We need to update the serial numbers. Hope I am able to make u understand.
------------------------------Bhargavi Katepalli------------------------------

markshnier__you · Answer

The data will have no awareness of where you inserted the extra rows, so if you expect to have some automated process rely on the actual position of the insertion, then that does not sound possible.

it is possible to auto number rows &nbsp;in sequence from 1 to N and also auto sort based on a sort of a serial number field.------------------------------Mark Shnier (Your Quickbase Coach)mark.shnier@gmail.com------------------------------

Forum Discussion

How to adjust serial numbers in a grid edit report while inserting the rows in between