Fill fields when grid becomes dirty in a grid detail view

[Larsman]

I have an grid for editing records. The editing takes place in a detail view. When a user begins typing in any of the fields in the detail view (grid becomes dirty) I want to place the current user ID in the "Modified By" and the current date in the "Modified" fields and subsequently save the date on grid submit.

Can anyone point me in the right direction for doing this.

Thanks

[glenschild]

Re: Fill fields when grid becomes dirty in a grid detail view

Hi Lars

I have a process where first of all there is a session variable called session.fullname.

In the Server side events I add the following code to the CanUpdateRecord event.

function CanUpdateRecord as v (DataSubmitted as P, Args as p, PageVariables as p, Result as p )
with PageVariables
Result.Cancel = .f.
Result.ErrorHTML = ""
DataSubmitted.LastUpdated = now()
DataSubmitted.UpdatedBy = session.fullname
end with
end function

Bear in mind my [UpdatedBy] field is a datetime field in MS SQL. If you are using a dbf date field replace now() with date()

[Davidk]

Re: Fill fields when grid becomes dirty in a grid detail view

You could use the Grid Client-side Event onDetailViewStateChange. It fires when you start edit a detail view. Do you need specific info about how to use it? How to set Values?

[Larsman]

Re: Fill fields when grid becomes dirty in a grid detail view

Thank you Glen!

David, I would love to have specific information on how to use and set the values in the Grid Client-side Event onDetailViewStateChange. My Javascript skill need work.

Thanks

[Davidk]

Re: Fill fields when grid becomes dirty in a grid detail view

You're going to have to get to your Userid, if you don't already have it. Here's one way. Go to the Grid XBasic functions and add this...

function getCurrUser as c (e as p)

Dim currUser as C
currUser = a5ws_getCurrentUser()
if currUser = "" then
	currUser = "No User Logged In"
end if	
getCurrUser = "window['currUser']='" + currUser + "';"

end function

This gets the current user and assigns it to a window variable.

Now, get into the Client-Side Events, onDetailViewStateChange and add this...

var currUser = window['currUser'];
{grid.Object}.setValue('D','YOURFIELDNAME',currUser);

This gets the window variable and put it into whatever field you want on your detail view.

Next, staying in Client-Side Events, onGridRender, add this...

{grid.Object}.ajaxCallback('G','{Grid.RowNumber}:all','getCurrUser','','');

This is an Ajax Callback that runs that function we created named getCurrUser.

Finally, get into the Detail section Properties, go to the bottom area and, under Editing Properies, you'll see Refresh data on row dirty... uncheck it.

Overall, when the Grid opens getCurrUser is run and sets up a window variable with the current user.

Then, when you start editing the detail section, onDetailViewStateChange fires and fills in your field with the current user.

Just add any other into you want. Dealing with Dates isn't the most fun. Have a look at w3schools.com for lots of javascript stuff and check out how to create and work with dates.

[Larsman]

Re: Fill fields when grid becomes dirty in a grid detail view

Thanks David! I will try this out.

I notice you are using a window variable vs a session variable. Is there any particular reason behind this choice?

[Larsman]

Re: Fill fields when grid becomes dirty in a grid detail view

David,

I placed the your code as you specified and published my component. When I started to edit a field in the detail grid the user id flashed in the appropriate field and then the field went back to information that was previously in that field. (if the field was empty it flashed and went blank and if there was already data it flashed and reverted.)

Any thoughts?

[Larsman]

Re: Fill fields when grid becomes dirty in a grid detail view

Belay my last. I reread your instructions and found the problem.

Now the issue is that when I press the cancel edits button the fields clear but I cannot close the detail view. I get the alert that says that I have to either cancel edits or save edits in order to close the detail view. Also, when I click the save button the field modified with your code does not get saved to the table.

Any thoughts on this?

[Davidk]

Re: Fill fields when grid becomes dirty in a grid detail view

I'll have a look...

[agillbb]

Re: Fill fields when grid becomes dirty in a grid detail view

Lars, my preferred way is tweak the SQL update statement before it hits the database:

Do this (serverside function).....

function onBeforeSQLCommandExecute as v (e as p)
	'inject the DateModified=xx part of the SQL update statement
	if e.SQLType = "UPDATE" then
		e.a_sql.SQL	= update_DateModified(e.a_sql.SQL)
	end if
end function

....AND define a update_Modified function as a global Xbasic function for use in any component. Note this function simply replaces the "SET" part of the SQL update statement with "SET DateModified='blah blah' "

FUNCTION update_DateModified AS C (myString AS C )
	dim myDate as C
	if .not. contains(myString, "DateModified") then
		myDate = " SET DateModified='" + time("yyyy-MM-dd 0h:0m:0s") + "', "
		update_DateModified = stritran(myString, " SET ", myDate)
	else
		update_DateModified = myString
	end if
END FUNCTION

[Davidk]

Re: Fill fields when grid becomes dirty in a grid detail view

Mine is saving ok. I have a Grid, with the Detail View displayed. If I make a change in the detail view, I see my username pop into the field. If I click the Save icon I see that change reflected in my Grid just above.

But I see the issue with the cancel. That's because onDetailViewStateChange is firing (as it should) on every change, including the undo. So... we can test for the 'change' state and that seems to take care of it.

if (e.mode == 'change')
{
var currUser = window['currUser'];
{grid.Object}.setValue('D','YOURFIELDNAME',currUser);
}

[Larsman]

Re: Fill fields when grid becomes dirty in a grid detail view

Thanks Andy! I will have to play with your code to see how it could work in my grid.

David, Thanks for that fix. I found the following JavaScript code to get the date information

function modate() {
var mydate=new Date();
var theyear=mydate.getYear();
if (theyear < 1000);
theyear+=1900;
var theday=mydate.getDay();
var themonth=mydate.getMonth()+1;
if (themonth<10);
themonth="0"+themonth;
var theday=mydate.getDate();
if (theday<10);
theday="0"+theday;

//////EDIT below three variable to customize the format of the date/////

var displayfirst=themonth;
var displaysecond=theday;
var displaythird=theyear;

////////////////////////////////////

return 'displayfirst+"/"+displaysecond+"/"+displaythird';
}

I am wondering how I plug it in to your code so I can see the date information instead of the text string after the "return"

Thanks.

[Davidk]

Re: Fill fields when grid becomes dirty in a grid detail view

Take all the code except for the function statement and the return statement and put it into the code that sets the value... something like...

if (e.mode == 'change')
{
var currUser = window['currUser'];
{grid.Object}.setValue('D','YOURFIELDNAME',currUser);

// Now look after the date.

var mydate=new Date();
var theyear=mydate.getYear();
if (theyear < 1000);
theyear+=1900;
var theday=mydate.getDay();
var themonth=mydate.getMonth()+1;
if (themonth<10);
themonth="0"+themonth;
var theday=mydate.getDate();
if (theday<10);
theday="0"+theday;

var currMth=themonth;
var currDay=theday;
var currYear=theyear;

// Change the following to suit your formatting... e.g. dashes instead of slashes... d/m/y format etc.

var currDate = currMth +"/"+ currDay +"/"+ currYear;

{grid.Object}.setValue('D','MODIFIED',currDate);

}

Overall, it would be nice to have a global javascript function that you can call to get you your current date... so you don't have to code it everywhere... but this will help for now.

[agillbb]

Re: Fill fields when grid becomes dirty in a grid detail view

you really should include a js date library for stuff like this. I include datejs and achieve what you are trying to do in 1 or 2 lines!

[Larsman]

Re: Fill fields when grid becomes dirty in a grid detail view

Thanks David!! It works like a champ. Thanks Andy, I am going to check into integrating your recommendations next.