InfoPath Dev

 Thanks, the formula does work, I was putting it in the default value box instead of "The type of information in this column is:" section

Well, sadly, InfoPath is not going to let you submit to both a list and library out of the box. There are some really good threads on here about leveraging CAML to submit to a list (which is the only no-code way to submit a non-list form to a list) - so if you aren't using Office 365 you may want to check that out. Otherwise, you could ...

I'd drag that data connection onto the form & preview to see what the error returned is. Or run Fiddler when you create the data connection.

Seems like it should work - the original field is a date datatype?

I usually paste the query URL in the browser and inspect the returned XML to get a sense of the correct XPath - maybe try that? I don't see anything in your XPaths that indicates you are including a filter with a value from your main data source.

In the form I sent you, the helper field does have a whole number in it (or should) - the translate function is being used to remove the "-" from the date field. You may want to put the helper field on your form, displayed as text, so you can verify the default value there is working correctly.

Hello, I am looking for solution to read the user attached file (usually JPEG, PNG ) from the form and compress it (to reduce file size) and then placing these compressed files instead actual files that user attached. Mine is a browser enabled form. Please advice if we can achieve it. I have code behind option enabled for my form. So i can use ...

Hello Hilary i did tried this and its working on preview mode but when i publish this to my form library it gives error "Nan" it seems max function is only for whole number not for date. could you please help me with this.

 I have a browser form using InfoPath 2010 which has a repeating section . Within the repeating section I have a people/group picker field and that is set to allow multiple selections of people only what I want is that after the user enters data in the first row of the repeating section and then inserts a ...

Hi Hilary, I am using these xPaths rules to get the values from my two columns named LOCATION and FULLNAME in a spreadsheet... set Field1 = xdXDocument:GetDOM("REST data")/ns5:entry/ns5:content/ns3:range/ns3:row/ns3:c[1] and set Field 2 xdXDocument:GetDOM("REST data")/ns5:entry/ns5:content/ns3:range/ns3:row/ns3:c[2]. I am ...