Discussions

Expand all | Collapse all

Creating Number Sequence without using Record ID#?

  • 1.  Creating Number Sequence without using Record ID#?

    Posted 02-27-2020 11:29
    Hi Guys,
    How to create a sequence of numbers without using Record ID#?


    For Example

    Record ID#        Sequence
    1                           1            --> illustration 
    2                           2
    4                           3           --> Considering Record ID# = 3 is deleted.
    5                           4









    ------------------------------
    Vivek Vishwanath
    Hyderabad, India
    +91 8185868789
    ------------------------------


  • 2.  RE: Creating Number Sequence without using Record ID#?

    Posted 03-07-2020 22:34
    Vivek,

    • Export the table and use PHP or script to sequence the data based upon the Create Date.
    • Import the sequence back into Quick Base

    You will need to run a batch job at least daily to catch the records that are deleted.

    ------------------------------
    Don Larson
    Paasporter
    Westlake OH
    ------------------------------