InfoPath Dev

Thanks for the suggestion, but your code doesn't work. Anyhow I tought you first need to declare your variables before assigning a value. I think it has to see with the fact that this code is assigned to a button, the same thing works if it used in the 'onafterchange' event of a control. Regards

With the following code, I try to set 2 field values  (LastUpdated_by and LastUpdated_time) at the moment a custom submit button is pressed. function CmdSave::OnClick(eventObj) {  var curDate = new Date()  var sLastUpdated_by = ...

Still not working! some background information: I use a datafield AMPM to determin start en stop hour. In the form there are 3 option buttons for AM / PM / All day.  according to the choice, i try to fill in a default start and stop time (that can be overwritten) with a rule. After the rule, I get the 'invalid data' indicator, instead ...

Thanks for the response the form works against an SQL table. the data format of the field is datetime. the format on the form is identical to the whatever is typed in "99:99".

I try to fill up a time field with a rule: @from_Hour = number("08:00") I recieve a 'NaN' error on my form. How can I avoid this error?  

Since there came no answers, I started looking for the answers myself. And eventualy I found the solution. It was a combination of Greg Collins http://www.infopathdev.com/files/folders/examples/entry283.aspx and Matt Faus http://www.infopathdev.com/blogs/matt/archive/2006/02/02/Setup-Namespaces-for-a-Secondary-Data-Source.aspx that did ...

What I bassicly want to do is retrieve an email address (field EmployeeEmail) from a secondary datasource based on an EmployeeID (Field EmployeeID in table LOCALSALES_APPROVERS). The EmployeeID is entered as Approved_by1in the table LOCALSALES (=main data source). Is there an easy understandable solution that a newbie like me can reproduce ...

the code :  var sSearchString =XDocument.GetDOM("Approvers").selectSingleNode("/dfs:myFields/dfs:dataFields/d:LOCALSALES_APPROVERS/@EmployeeEmail[../@EmployeeID = current()/@Approved_by1]") Returns the following error: Reference to undeclared namespace prefix: 'dfs'   What am I doing wrong?  

Thanks for the response. However I still have difficulties to access all data via code. now I Retrieve the information into the expressionbox with the following statement. xdXDocument:GetDOM("Approvers")/dfs:myFields/dfs:dataFields/d:LOCALSALES_APPROVERS/@EmployeeEmail[../@EmployeeID = current()/@Approved_by1] Can someboy help me on ...

Hello,  Is it possible to retrieve the text entered in an expression box in the forms code?   Thanks in advance