Servoy provides several ways in which a column may be automatically populated when a record is created. Some of the auto-enter options are also applicable when an existing record is updated.
System Values
Database-Managed
Indicates that the value is deferred to the database at the time of insert. The value is populated and controlled by the database and it will not be overwritten from Servoy.
Creation User UID
The UID parameter that was supplied at the time of login, entered at the time of record creation.
Modification User UID
The UID parameter that was supplied at the time of login, reentered each time the record is modified.
Creation Datetime
The current date and time on the client, entered at the time of record creation.
Creation Server Datetime
The current date and time on the application server, entered at the time of record creation.
Modification Datetime
The current date and time on the client, reentered each time the record is modified.
Modification Server Datetime
The current date and time on the application server, reentered each time the record is modified.
Custom Value
A custom value is simply a literal value (i.e. 'Blue', 1.5) which may be used as a default. This option is only available for Integer, Number and Text data types.
Database Default
This indicates that the value is deferred to the database at the time of insert. However, unlike Database-Managed system values, this value can be modified from Servoy after the record is inserted.
Lookup Value
Lookup Values provide the option to auto-enter a value that is contextual to the record being inserted. Options include any of the record's data providers, any data providers from foundsets related to the record, as well as an global relations or variables.
Sequence
Sequences may be used to auto-increment a column's value. This is ideal for populating primary key columns, which must be unique.
Servoy Sequence
This is a sequence which is defined in the application tier and managed by Servoy. The sequence will generate integer values using a given next value and step value.
i.e a step value of 1 will yield sequential values of 1,2,3,4...
A step value of 2 will yield 1,3,5,7...
In deployment, Servoy Sequences are stored in the repository database and there are options to recalculate the sequence's next value from existing data.
Database Sequence
Servoy will call a named sequence in the database to populate the value. The column will be populated and available prior to inserting the record
Database Identity
The sequential values are managed and populated by the database. The column is not populated until after the record is inserted
UUID Generation
Servoy will automatically populate a text column with a textual representation of a UUID. Be sure that the column's UUID Flag is also enabled.