How to reset the autonumber field?

[Barbara]

Hi,

I have an autonumber field in the table, I have run some tests and deleted the test records but now the number starts from 20 and I would like to reset the number to start from 0, how can I do this?

Barbara

[bahar_vm]

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.

[Jona]

Hi Bahar.

Does this workaround solution works to set the autonumber field to any number I want?

e.g

Id=100 where ID is an autonumber.

thank you!

[anonymous3009]

Hello,

Yes, that is correct. So instead of '0', you would set the field to start at ''99" in your csv file.

Best,

-SO

[bahar_vm]

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.