InfoPath Dev

Howdy. I need help with exporting data from InfoPath to MS word. Here's what I'm trying to achieve: I have an InfoPath form with various drop-downs that are populated from an SQL database. After the form is completed and submitted, I want the selections made to be exported to a Word template in a document library. ...

 Hey guys......   I am inserting a repeating section in my form that contains 3 drop down list (drop down list A ,B, C) and a text box field below.  Currently  when I click Drop down list  A  certain result appear in drop down list B appears acording to my data filters and then drop down list C  filters down to ...

Thanks for your quick reply Jimmy, I've already got the date working so I just need to add your bit for the time. Looks like I might be making a few forms with dates as a central theme so I'll definitely look into qRules. Thanks again, Nick

I hope I didn't get your hopes up too much because I don't know of a good way to account for business hours and holidays.  I was just making sure that wasn't a requirement. What you can do to get the raw difference is: Use the trick that's been floating around here to get the number of days between the two dates. Use ...

Within business hours would be great but thats well beyond my Infopath knowledge so I hadnt even considered it! If you know how, then that would be awesome but I'm also happy with just raw differences.

And are you looking for just a raw difference between two datetimes?  Do you need to take into account work hours, weekends and holidays?

Hi Jimmy, Thanks for getting back to me. The difference between the two dates/times will vary condiserably, some forms might be returned within a couple of hours but others might take several days. Nick  

Will both of the times always be within the same day?  If so, you can use this formula to get the number of minutes between two times: 60 * (substring(laterTime, 12, 2) - substring(earlierTime, 12, 2)) + (substring(laterTime, 15, 2) - substring(earlierTime, 15, 2)) + (substring(laterTime, 18, 2) - substring(earlierTime, 18, 2)) div ...

Hello everyone, Im creating a web-enabled Infopath 2010 form which will be used to enter details of IT Support tickets. The form has two 'Date and Time Picker' controls: TimeRaised TimeRepaired  I'd like the difference between these two fields to be displayed in a read-only text box ...

I think the best solution is to use a database. If that is not an option which it wasn't for me; I built both forms in one. All of the controls that are not used in one form or the other are in sections that can be hidden or shown depending on which form I want use. Then if you save it the next time you need that same common info just reopen, ...