add user id to grid

[Mike Reed]

I have a grid that will be used for an employee to enter their work time. It displays 15 rows that includes date and time in, date and time out and an authorization code. They may enter as many rows as needed and then hit the submit button.

Their userid is captured at the login process and saved in a variable called session.vUserid.
How can I make that a calculated field, so that the userid will be saved in a field in each record?

Thanks,
mike

[ColinJD]

Re: add user id to grid

Mike unsure why you wish to make this a calc field?
My answer would be to retrieve the User's Guid and use this instead of the id,
- Then make a hidden field/column for the Guid or Id
- next on Initialize assign the session.variable in question, to the Field via the standard CurrentForm.Controls.whatever methedology.

[Mike Reed]

Re: add user id to grid

I can certainly use the guid, but when someone looks at the record to see who (by that I mean the name of the logged in user) added the record we need a name of the logged in person. That aside, though, I still don't understand how to add the guid, name or whatever to each record. I know how to do it in a dialog or single entry, but I don't know how to do it a multi-row grid (see the attached image.) The user can add many rows of data and click the submit button. I don't know where or how to add code to add the name of the logged on user to each record. Granted I could add a field to the display and have the user enter it, but that's not what we need.

Thanks,
mike

[Steve Wood]

Re: add user id to grid

If you already have the userid at the time they enter their record in the grid, then you need only to use the Grid Events to apply that value at the time they enter the record.

In the BeforeValidateNewRecords, add something like this inside the WITH clause:

DataSubmitted.userid = session.vUserid

userid needs to be in the Grid as an editable field, but you can select field type Hidden + Hide Row to hide the value.

[Pat Bremkamp]

Re: add user id to grid

A few other thoughts on your questions.

You probably have an employee table with an id, say em_id, and the employee name, em_name (or first and last), so if you make the ulink value in security equal to em_id, and save that value in session.__protected__userid, then a couple good things happen.

First, the protected session variable can only be changed with Xbasic, so another employee cannot change the variable and enter records for another employee.

Second, if you make the employee id field hidden as Steve and Colin suggested, then you can create a calculated field that is a simple lookupc() to the employee table to get the name and display that in your grid as a label. The name doesn't need to be saved. That way, the name cannot be changed, either.

Then, you can use the employee id in a search if you need to edit or review the records.

Pat

[Mike Reed]

Re: add user id to grid

Pat, Colin and Steve,
Thanks!
Your thoughts gave me what I needed. I appreciate your help
Mike