Autofill

[nilocray]

hi all i was wondering if it is possable to get the system to autofill 2 fields when saving a new record (1:current date 2:current user)

Thanks in advance

Colin

[massiws]

nilocray,
you can use SQL in All tab -> Default Value to autofill your field when opening a new record:

Code: Select all

SELECT CURDATE()            -> to get current date
SELECT '#nu_user_name#'     -> to get current user name

Have a look here for a complete list of hash variables.

To fill fields on save, you have to use nuOnSave() function to perform validation.

Max

[nilocray]

hi thanks that worked great, made the fields read only so the user cant change then and thay only get filled on new records and not if you reopen the record. no need for the onsave code.

regards

colin

[massiws]

.