Prevent numbering gaps can be applied on custom table ?

[Siddhesh Tripat]

Can system property (glide.itil.assign.number.on.insert) be used for my purely custom table? I have a custom table which is not inherting any tables like incident, change or task and for number field i have used number maintainance OOB configuration.But when i am not inserting the data my number is also getting increased. How can i prevent this?

[Bert_c1]

Numbers are free, why worry about gaps? And that system property applies to task and it's child tables.  Related documentation:

EnforcingUniqueNumbering.html.

Otherwise, Create a Business Rule, that runs on Insert and When: Before, with script logic to get the last number on existing records, check that against 'current.number' and if ((current - last) > 1) set the current value to (last + 1).  then go to the record in sys_number_counter and adjust the value there.