Skip to main content
Nintex Community Menu Bar
Solved

Reset automate number

  • June 9, 2023
  • 5 replies
  • 129 views

Forum|alt.badge.img+3

Hi,

I already delete record in list view but ID(automate number) doesn’t reset. 

Is there any ways to reset automate number/

Best answer by TinTex

Please see below:

https://help.nintex.com/en-US/k2five/userguide/current/Content/How-Tos/RequiredFieldsEditListView/Add-Required-Fields-Editable-List-View.htm

This tutorial will walk you through generating an editable list view, of which you can inspect the rules generated to understand how it is implemented on an editable list view.

5 replies

Forum|alt.badge.img+11
  • Nintex Employee
  • June 9, 2023

Could you provide some additional detail?

Perhaps the delete button was only configured to remove the record in the list view, but that change was not deleted or saved to the backend.  You can try creating a simple SmartObject, generating a editable list view, and looking at the rules to understand how it is usually implemented.


Forum|alt.badge.img+3
  • Author
  • Rookie
  • June 10, 2023

Could you provide some additional detail?

Perhaps the delete button was only configured to remove the record in the list view, but that change was not deleted or saved to the backend.  You can try creating a simple SmartObject, generating an editable list view, and looking at the rules to understand how it is usually implemented.

I had SmartObject, List view, editable list view. But I haven’t set the rules in editable list view. Could you provide rules I should set in the editable list view?


Forum|alt.badge.img+11
  • Nintex Employee
  • Answer
  • June 12, 2023

Please see below:

https://help.nintex.com/en-US/k2five/userguide/current/Content/How-Tos/RequiredFieldsEditListView/Add-Required-Fields-Editable-List-View.htm

This tutorial will walk you through generating an editable list view, of which you can inspect the rules generated to understand how it is implemented on an editable list view.


Forum|alt.badge.img+7
  • Nintex Employee
  • June 16, 2023

If this is SmartBox the number will continue to increment as it is an Identity field in the database https://learn.microsoft.com/en-us/sql/t-sql/statements/create-table-transact-sql-identity-property?view=sql-server-ver16

To reset the auto number you will need to ask a dba to truncate the SmartBox table in the K2 database and then call 

DBCC CHECKIDENT('TableName', RESEED, 0)

MillaZ
Nintex Employee
Forum|alt.badge.img+22
  • Nintex Employee
  • June 26, 2023

Hi @kkpt 
Did any of these replies resolve your question?