Current Date / Time in a Grid Component?

[Leonw43]

Hi, I am trying to display the current date and time in my grid component (In the Detail View) and can't seem to get anything except the default time to show up. The "Initial Value" property for my Time and Date fields explains that I can use either =date() or =now() etc - but they do nothing. (Have got this to work perfectly in Dialog2's before.) Ideally I want the fields to update with the current date and time every time a certain field is changed (onChange event).

Is there any way of doing this? Any help much appreciated - Thanks,

Leon.

[Rich Hartnett]

Re: Current Date / Time in a Grid Component?

Hi Leon

If I understand you correctly, you want to capture the current date and time when a certain field is updated. I'm not sure about an individual field, but in most of my grids I capture the current date, time & User Name upon the initial creation of the record, and in a separate set of fields, I capture the date/time/User Name each time the record is updated.

Then I display that information on the grid.

Would that suffice, or do you have to specifically have to focus on that one field?

[Leonw43]

Re: Current Date / Time in a Grid Component?

Hi Rich, yes that's correct - with an onChange event. Capturing the date and time when the record is updated would be sufficient, as I can make the record save on that same onChange event to give me the same result. How did you go about doing this?

Thanks,
Leon.

[Rich Hartnett]

Re: Current Date / Time in a Grid Component?

Well Leon I do it a bit differently than what you are looking for, but the end result may be the same so here's how I do it:

In all my tables where I want to capture the date/time/User that first creates the record, and the date/time/user that last makes any changes to it, I start by creating 6 fields in the actual table, and those fields must appear in your grid as "updateable" fields, although you can set them to "hidden" so they do not appear to the end user.

They are:

DateEntered (date field)
TimeEntered (character field, 9 spaces)
EnteredUser (character field, long enough to capture the user's unique ID Number)

DateUpdated (date field)
TimeUpdated (character field, 9 spaces)
UpdatedUser (character field, long enough to capture the user's unique ID Number)

Now in the actual grid, I go to two sections in the server-side events:

In the "BeforeValidateNewRecords," I replace the default code with;
(Which captures the data/time/Ulink (which is my UserID) on the initial entry of the record.)
---------------------------------------------------------------------------------------------
function BeforeValidateNewRecords as v (DataSubmitted as P, Args as p, PageVariables as p)
with PageVariables
DataSubmitted.Dateentered=date()
DataSubmitted.Timeentered=time()
DataSubmitted.EnteredUser=session.__protected__ulink
end with
end function
--------------------------------------------------------------------------------------------
Then in the "CanUpdateRecord" section I replace the default code with;

function BeforeValidateNewRecords as v (DataSubmitted as P, Args as p, PageVariables as p)
with PageVariables
DataSubmitted.Dateupdated=date()
DataSubmitted.Timeupdated=time()
DataSubmitted.UpdatedUser=session.__protected__ulink
end with
end function
--------------------------------------------------------------------------------------------

* This captures the date/time/User of anyone making changes to the record, and updates each time a change is made, so it always shows the last person that performed any action on it. (But doesn't tell you which field was actually changed.)

Incidentally, sometimes I substitue the "session.__protected__ulink" with "session.__protected__Lastname" in situations where I want an actual name recorded instead of just the UlinkID, and still in others I record both.

Hopefully this will help you.

[Leonw43]

Re: Current Date / Time in a Grid Component?

Thanks, this helps a lot as I will need to store the log data to my database in a similar way in the future - although for this instance, I need to display the current time and date in the fields of the detail view, triggered by a javascript event. Saving the current time and date into the table isn't enough for what I'm currently doing, as the data also being used from the detail view to send out an email containing the data before it's saved.

Basically I need the current time / date displayed on the detail view before saving - I mistakenly thought that I didn't need to do this before saving but as it turns out, the email send event is looking at current data on the detail view.

I have been trying to get the onClick event on a test button to set the value of my time field to the current time, but to no avail.
I've tried:
{grid.object}.setValue('D','LOG_TIME',time());
{grid.object}.setValue('D','LOG_TIME',Date.getTime());
etc.

But nothing has worked - am I using incorrect syntax or something here?
Thanks in advance,

Leon.

EDIT: Have found the solution after having another look on the forum:
http://msgboard.alphasoftware.com/al...e-current-date

Here is the code I ended up using:
var d = new Date();
var day = d.getDay();
var month = d.getMonth();
var year = d.getFullYear();
var hour = d.getHours();
var min = d.getMinutes();
var sec = d.getSeconds();
var full = day+"/"+month+"/"+year;
var time = hour+":"+min+":"+sec;

{grid.object}.setValue('D','LOG_DATE',full);
{grid.object}.setValue('D','LOG_TIME',time);

[George Corder]

Re: Current Date / Time in a Grid Component?

I was searching for a way to have a field updated on record modification too. I have a MySQL backend and use Navicat for working with MySQL tables. Inside Navicat I noticed the "On Update Current_Timestamp" checkbox. This appears when you have your field type set to timestamp in Navicat. Very simple way to accomplish my needs. I am sure this feature would be available in MyPHPAdmin for MySQL db too, Navicat is just a great tool to use.

2013-11-07_104716.png

[CharlesParker]

Re: Current Date / Time in a Grid Component?

correct me if I am wrong but I thought all session variables are protected now so there is no need for the session.__protected__ulink anymore.
fieldname =session.ulink is secure now as I understand it...

[TheSmitchell]

Re: Current Date / Time in a Grid Component?

I was searching for a way to have a field updated on record modification too. I have a MySQL backend and use Navicat for working with MySQL tables. Inside Navicat I noticed the "On Update Current_Timestamp" checkbox. This appears when you have your field type set to timestamp in Navicat. Very simple way to accomplish my needs. I am sure this feature would be available in MyPHPAdmin for MySQL db too, Navicat is just a great tool to use.

[ATTACH=CONFIG]37105[/ATTACH]

For those who don't use Navicat -

If you have a TIMESTAMP field, you can use CURRENT_TIMESTAMP to set a field's value on create or update. It's insanely handy. And I was just too excited when I learned about it a few months ago.

CREATE TABLE foo (
  ID INT(11) NOT NULL AUTO_INCREMENT,
  BAR VARCHAR(255) NOT NULL,
  CREATED TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
  UPDATED TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (ID)
)

More information here: http://dev.mysql.com/doc/refman/5.1/...alization.html