Forum Discussion

SystemAdmin4's avatar
SystemAdmin4
Qrew Member
5 years ago

Next and Previous Record IDs based on derived sort

Hi. Table A contains circa 1000 constantly changing records. The order of records in this table (for various purposes) is determined by a sort field B (numeric formula based upon a couple of oth...
APIs and custom code
Relationships
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
5 years ago
Is the sort field unique?

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
SystemAdmin4's avatar
SystemAdmin4
Qrew Member
5 years ago
Hi Mark,

Yep it's unique - and I've used it to create a connected table with that sortfield as the unique key (with the record ID of the original record in Table A in there too). Both are numerics.

Feels like I'm heading in the right direction with this but my brain just can't figure out where to go next with this!

D

------------------------------
dmlaycock2000 dmlaycock2000
------------------------------