Forum Discussion

JordanMcAlister's avatar
JordanMcAlister
Qrew Captain
6 years ago

Is there any way to reset record Id for all records?

Our app has about 18,000 records in one of the tables, but the Record Id is at around 40,000 which means we've deleted a lot of records. Is there a way to reset the record Id and have it re-number bas...
Tables and fields
Tips and tricks
JordanMcAlister's avatar
JordanMcAlister
Qrew Captain
6 years ago
I might just make a new field and renumber that way then. Do you have a quick way suggestion for that? I might export everything to a spreadsheet and filter by date created then number them there then import back into QB into the new numbering field, or is there a quick formula way to do that?