Forum Discussion

MadhaviKanugon1's avatar
MadhaviKanugon1
Qrew Member
2 years ago

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

Hi ,

The requirement we have here is 

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 & Regards,

Madhavi.

 

                



------------------------------
Madhavi Kanugondloola
------------------------------
  • 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's avatar
      BhargaviKatepa1
      Qrew Member

      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's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew Legend

        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  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
        ------------------------------