Creating Number Sequence without using Record ID#?

Question

Hi Guys,How to create a sequence of numbers without using Record ID#?For ExampleRecord ID#&nbsp; &nbsp; &nbsp; &nbsp; Sequence1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; --&gt; illustration&nbsp;2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;24&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;--&gt; Considering Record ID# = 3&nbsp;is deleted.5&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;4​------------------------------Vivek VishwanathHyderabad, India+91 8185868789------------------------------

donlarson · Answer

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

Forum Discussion

Creating Number Sequence without using Record ID#?

Related Content

AI Smart Builder for Creating Apps and Streamlining Pipelines

Automatic Sequence Number Field

create pipeline to create new records based on current record

Add button to create record in different app

Create a QR to outside Website or App