Jump to content
  • 0

How to reset the autonumber field?


Barbara
 Share

Question

4 answers to this question

Recommended Posts

  • 0

Hello,

There is a workaround solution:

1. Create a CSV file with the same columns as you have in your table and add one record in the CSV file with the autonumber field set to 0.

2. Import this file into your Caspio Bridge account replacing the existing table, this way the autonumber reset and start from 1 for the next entry.

3. Delete the test record in the table.

Note: If the Replace option is not available when importing, perhaps this table is set up for authentication and you need to remove authentication before the import process.

Best,

Bahar M.

Link to comment
Share on other sites

  • 0

Good News! Caspio has a new feature now to reset the autonumber value, so no need to use a workaround anymore:)

You can change the starting value or reset all values in an AutoNumber field. To do this, open the desired Table, select Edit from the menu bar, then select Reset Autonumber … The configuration window will pop up to let you set up the appropriate settings.

Best,

Bahar M.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
 Share

×
×
  • Create New...