Time Function problem

[KYBiggs]

I am trying to display a time field in a grid as h:m am

I set up a calculated field:time = time("h:0m AM",In)
based on an example for Xbasic for everyone

time = time("h:0m AM",datetime)

This is the grid from Xbasic:

This is the problem [ATTACH]25102[/ATTA[ATTACH]
The error is Grid1_Gridobj is undefined

Any ideas?

[KYBiggs]

Re: Time Function problem- cannot be parsed

Error Message to clarify:

[KYBiggs]

Re: Time Function problem - A5 CS is this correct?

I was trying to add/create a calculated for time display
time("0h:0m am", In)

The field is already a time format.

I changed the display on the field properties; ( I did not see drop down list of pre-selected formats) and selected time("0h:0m am",<value>)


A5 Customer Service is this correct?

[frankbicknell]

Re: Time Function problem

Is your field's name time? If so I think you will have to change it because time is a reserved word. I am not sure of how to use calculated fields in the context in which yo are using it.

[KYBiggs]

Re: Time Function problem

Thanks for the reply.
I am using IN as a time field and Out1 as time field
I am trying to do a calculation in a web grid and I am getting
error message
"Expression cannot be parsed:"
I tried
(Out1-In)
then I tried
toseconds(Out1 )-toseconds(In )

[KYBiggs]

Re: Time Function problem

To be more clear:
I am using IN as a time field and Out1 as time field
I am trying to do a calculation in a web grid and I am getting
error message
"Expression cannot be parsed:"



I have a field Hours � Numeric 19 decimal 2

On the Grid component Field Client Side properties I set up a Calculated Field


I tried
(Out1-In)
then I tried
toseconds(Out1 )-toseconds(In )


What I am doing wrong?

[Frances Peake]

Re: Time Function problem

If you want to use a client-side calculated expression, so that users will see the result of the time calculation immediately (before submitting the record), then you need to use separate fields for hours, minutes and AM/PM. Don't use a time-type field. To my knowledge there is not a JavaScript-compatible function to extract the time from an Alpha Five time field.

In this example:
Out_h is a numeric field for the hours part of the time out.
Out_m is a numeric field for the minutes part of the time out.
Out_ampm is a character field containing AM or PM (JavaScript is case-sensitive so you should give your users a dropdown)
Same as above for In_h, In_m, In_ampm

Here is the client-side calculated expression:

Out_h+(out_m/60)+if(Out_ampm="PM",12,0)-In_h-(in_m/60)-if(In_ampm="PM",12,0)

[KYBiggs]

Re: Time Function problem

Subject: Client side Calculated field - Javascript function declarations

Selwyn pointed out that: function toseconds ():

This will NOT work and cannot be EXPECTED to work.

toseconds() is an Xbasic function. It is not a Javascript function.

Xbasic does not operate on the client-side. the client side is Javascript. you can only use javascript functions on the client side.

when you build a client side expression, a5 lets you choose from a limited number of function that it knows how to convert to javascript.

that list of functions is shown when you click the Insert Function button in the client side expression builder. you will see that toSeconds() is NOT listed.

however, because we don't list this function, does not mean that you are out of luck.

you just need to write your own javascript implementation of toseconds(), or better still, your own Javascript function to calculate the time difference between two time values.

for example, you would go to the Javascript function declarations sections and define this function


function timeDifference(time1, time2) {
return ( (Date.parse(time2) -Date.parse(time1))/1000 )
}


then your client side calculate field would be

timeDifference(timevalue1, timevalue2)

This is a link for a video that defines the how to of the client side expression using the Javascript function declarations sections

http://www.ajaxvideotutorials.com/V1...lculations.swf

You do not get this kind of support from MS. Thanks again
I will take another whack at it.

[KYBiggs]

Re: Time Function problem

Thanks to Jay Talbott
I also found a solution using a Ajax Callback

adding an Onblur event on field Out1 see screen shot below

then setting up in Properties
Xbasic function declarations

function setTime as c (e as p)

'This function will handle the Ajax callback.

'It must return a string of Javscript commands that will be executed in the Browser.


e._set.Hours.value = (ctodt(e._currentRowDataNew.Out1) - ctodt(e._currentRowDataNew.a5fn_In))/3600


end function




Is their a better way to skin this cat with one data entry field
Do you see problems with this?

This process worked well and solved the problem. Client side Xbasic has such much power and in the hands of the wrong people could be dangerous. Thanks Jay for the experience. Great insight.

[KYBiggs]

Re: Time Function problem

Subject: Client side Calculated field - Javascript function declarations

Selwyn pointed out that: function toseconds ():

This will NOT work and cannot be EXPECTED to work.

toseconds() is an Xbasic function. It is not a Javascript function.

Xbasic does not operate on the client-side. the client side is Javascript. you can only use javascript functions on the client side.

when you build a client side expression, a5 lets you choose from a limited number of function that it knows how to convert to javascript.

that list of functions is shown when you click the Insert Function button in the client side expression builder. you will see that toSeconds() is NOT listed.

however, because we don't list this function, does not mean that you are out of luck.

you just need to write your own javascript implementation of toseconds(), or better still, your own Javascript function to calculate the time difference between two time values.

for example, you would go to the Javascript function declarations sections and define this function


function timeDifference(time1, time2) {
return ( (Date.parse(time2) -Date.parse(time1))/1000 )
}


then your client side calculate field would be

timeDifference(timevalue1, timevalue2)

This is a link for a video that defines the how to of the client side expression using the Javascript function declarations sections

http://www.ajaxvideotutorials.com/V1...lculations.swf

You do not get this kind of support from MS. Thanks again
I will take another whack at it.

ERROR MESSAGE
Error:Script:a5res://a5wobject/__hidden__VarTemp2249176_GridSettings line:35 Not found a5wui not found.
What DOES THIS MEAN?