Is it possible to renumber records from 1?

Article Number:040213

Records are automatically numbered in the order that they are added.
Also, record numbers are not updated once they are assigned.

If you want to reassign record numbers starting from "1", follow the steps below to recreate your app.

  1. Create a new app by copying (duplicating) an existing app. Animation: Recreating an app from Kintone Portal

  2. Export the record data of the source app to a CSV file. Animation: Exporting the record data of a source app

  3. Import the CSV file to the app created in Step 1.

    • When using the new file import screen:
      Under Record data, select Only add new records.
      Screenshot: The "Import from file" screen.
    • When using the classic file import screen:
      You need to uncheck the Key to bulk update checkbox for Record number when importing the data.
      Screenshot: The "Key to bulk update" checkbox is deselected on the "Import from file" screen

    Records will be bulk copied to the new app and renumbered starting from "1".