Create auto-incremental key

  • Resolved expserv

    (@expserv)


    5 years, 5 months ago

    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

    (@peterschulznl)

    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

    (@expserv)

    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.