nuBuilder Forum

I'm trying to have a the user field default to the current user that is logged into the system, the current date, the current time in fields when the add button is clicked. I found this on github:

https://github.com/nuBuilder/nuBuilder- ... ault_value

and tried the solutions without success. None of them load the current user, date, time into a field when the add button is clicked. I searched the forum and could not find anything. Is there another solution that provides this?

Thanks so much for your help.

Is it necessary to have this information on the form already when the record is added or is it enough to save the user and date details into the database when the record is saved?

preference would be to have the information displayed when a new records is being added in the form or grid view. example would be a comments subform with the user name, date, time fields auto filled with those default values. the user would see that they fields have already been filled and the focus would move the cursor to the comments fields so they would just need to type the comment.

any ideas for this one? thanks for the help.

Hello databs1234,

If you want to show the values in a (potential) new record, you would probably need to set default values using JavaScript.
e.g. you could add something like this to the Edit form JS.
This would set the default value of the object 'user_id' to the current user and the value of 'date_time_stamp' to the current date & time of the user's computer when a new record is added. This value would use the time zone of the client(user) rather than the server and, of course, they could differ. You could capture the time stamp when a record is created in the database layer by using some of the MySQL/MariaDB functions. Have a look at https://mariadb.com/kb/en/timestamp/

Depending on your version of MySQL, you could use something like this to keep a track of when a record was created and subsequently updated. Finally, you could use the method described in https://wiki.nubuilder.cloud/index.php?title=Logging_Activity to let nuBuilder (via PHP) log this activity. The values would need to be extracted using the JSON functions of MySQL and transformed to something that makes more sense - the time is stored as an integer which can be decoded with the FROM_UNIXTIME function, e.g.
A few ideas to play around with...

Neil

Attached is the code and where it was placed, it did not put the date into the field, is there another location where it should be placed?

when working with a main form, the above solutions will work, however, when working with a subform, the below solution has been tested and works:

var df = "events_subform" + nuSubformRowNumber(this.id) + "event_date";
if (nuGetValue(df) == '') {
var today = nuCurrentDate('mm/dd/yy');
nuSetValue(df, today);
}

var df = "events_subform" + nuSubformRowNumber(this.id) + "street";
if (nuGetValue(df) == '') {
nuSetValue(df, nuUserId());
}

The above code is placed into an object of the subform, for this example is was the name of the event, "on change" is the event that is used, it will fire every time event_name is changed but will only set the values in the target fields when they are empty (= setting a default). A screen shot is attached.

A bit shorter (untested):

kev1n wrote: ↑Thu Oct 26, 2023 7:18 am Is it necessary to have this information on the form already when the record is added or is it enough to save the user and date details into the database when the record is saved?

I have a similar question. I'd like to save the current zzzsys_user_id in a field of a new record, but I don't need the process to be visible to the user, saving in database is fair enough for my case. How I do accomplish? i know that the hash cookie #USER_ID# is always available, but can't figure out how to use it

Hi,

One possibility is to use the PHP (BS) event:
"your_user_id" must be a text object on your form. (you may set it to invisible)