Skip to main content
Question

Creating Number Sequence without using Record ID#?

  • February 27, 2020
  • 0 replies
  • 28 views

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
------------------------------
This topic has been closed for replies.

Forum|alt.badge.img+15
  • Quickbase Alumni
  • March 8, 2020
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
------------------------------