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.

    • If the new file import screen is enabled in the update options settings:
      Select Only add new records under Record data when importing data.
      Screenshot: The "Import from file" screen.
    • If the new file import screen is disabled in the update options settings:

    When importing data, deselect the Key to bulk update checkbox for Record number.
    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".