Hi Amol,

Firstly, I would like to sincerely apologize for the delayed response as we have been experiencing an unusually high number of tickets. I am sorry that it has taken longer than usual to respond to your concern and your patience is highly appreciated.

-

If you need just a simple "auto-increment" integer Numeric Column, which is going to start from ID as 1,  then 2, 3, and so on, to keep counting them like that;

Our Manual Tables, for example, already have a unique auto-increment ID row, which is hidden by default, but you will find it under the Column List, named as "wdt_ID".

You can check more details here how to make a Manual Table;

Or you can prepare a Spreadsheet and import this data to a new Manual Table;

You will also be able to update existing Manual Tables from file;

And of course, they are fully editable as well.

-

If you wanted something different, like a custom "serial number" Column, you will also have the ability to create a custom SQL Table, outside of our Plugin, if you have knowledge how to work with PHPMyAdmin or similar DB Management Tools, but for that , our Support is limited to only advice, we are not covering building Source Data/Tables or writing Custom SQL Queries.

Then you can call this Table with our SQL Query based Tables, to pull the data you need.

If you create a Column with any "automated function" to auto-populate in your Database -then our SQL Query Table should pull the data correctly as it is coming from the Database.

Or , for example, if you set that column to be "auto increment" via your DB Management Tool, on the source SQL Table - then any new row you create with our Table, is going to automatically populate with +1 logic like that.

You can find various Tutorials, for example this one : How to add auto-increment to column in MySQL database using PhpMyAdmin.

Let  me know if that helps, or if you need to achieve something different?

And i just wanted to point out that you can try wpDataTables before purchasing

 on our sandbox Demo sites ( you can find links for the main plugin Demo,  

as well as add-on Demos, in my signature),

and there is a 15-day money-back guarantee period, 

so if you purchase the plugin, you can safely fully test it out, and if it doesn't fit your needs you can request and receive a refund in that period. ( same goes for all plugins and add-ons)

Let me know if you have any additional questions.