Title: Create auto-incremental key
Last modified: September 30, 2019

---

# Create auto-incremental key

 *  Resolved [expserv](https://wordpress.org/support/users/expserv/)
 * (@expserv)
 * [6 years, 7 months ago](https://wordpress.org/support/topic/create-auto-incremental-key/)
 * Is it possible to set a key that will automatically incremented with every new
   entry into a table? Also, is it possible to hide the field and value of this 
   key in the input form?

Viewing 2 replies - 1 through 2 (of 2 total)

 *  Plugin Author [Passionate Programmer Peter](https://wordpress.org/support/users/peterschulznl/)
 * (@peterschulznl)
 * [6 years, 7 months ago](https://wordpress.org/support/topic/create-auto-incremental-key/#post-11983405)
 * Hi expserv,
 * You can add an automatically incremented key in the Data Designer. The simplest
   way is to switch to basic design mode which allows you to add a column with a“*
   Numeric ID (auto increment)” data type. When you save your table the first time,
   this column will be converted to a column containing the right settings for an
   automatically incremented key.
 * By default an auto increment column is visible but not editable for users. On
   a Data Projects page you can hide the column.
 * Hope this helps! Just let me know if you need more assistance…
 * Best regards,
    Peter
 *  Thread Starter [expserv](https://wordpress.org/support/users/expserv/)
 * (@expserv)
 * [6 years, 7 months ago](https://wordpress.org/support/topic/create-auto-incremental-key/#post-11983559)
 * Thank you. That was a big help!

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘Create auto-incremental key’ is closed to new replies.

 * ![](https://ps.w.org/wp-data-access/assets/icon-256x256.png?rev=3299063)
 * [WP Data Access – App Builder for Tables, Forms, Charts, Maps & Dashboards](https://wordpress.org/plugins/wp-data-access/)
 * [Support Threads](https://wordpress.org/support/plugin/wp-data-access/)
 * [Active Topics](https://wordpress.org/support/plugin/wp-data-access/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/wp-data-access/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/wp-data-access/reviews/)

 * 2 replies
 * 2 participants
 * Last reply from: [expserv](https://wordpress.org/support/users/expserv/)
 * Last activity: [6 years, 7 months ago](https://wordpress.org/support/topic/create-auto-incremental-key/#post-11983559)
 * Status: resolved