Discussions

 View Only
  • 1.  How to adjust serial numbers in a grid edit report while inserting the rows in between

    Posted 03-30-2023 03:39

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


  • 2.  RE: How to adjust serial numbers in a grid edit report while inserting the rows in between

    Posted 03-30-2023 04:51

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



  • 3.  RE: How to adjust serial numbers in a grid edit report while inserting the rows in between

    Posted 03-30-2023 06:00
    Edited by Bhargavi Katepalli 03-30-2023 06:01

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



  • 4.  RE: How to adjust serial numbers in a grid edit report while inserting the rows in between

    Posted 03-30-2023 08:12

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