Re: Complicated time calculation

Jimothias — Thu, 29 Jan 2009 09:04:13 GMT

Hilary

Thanks for that, thats a great help :0) However any fields I add seem unable to repeat themselves properly in my repeating table. Anything I put in the top row automatically replicates itself to the additional rows I put in. I tried setting them to repeat and even the GROUP I put them in to repeat. Any help would be brilliant :0)

Thanks

James

Re: Complicated time calculation

Hilary Stoupa — Wed, 28 Jan 2009 17:29:34 GMT

Hi -- you should be able to add fields to the data source for a form that was created from a database -- but only to the root node. If you select the top folder in your form's main data source, you should have the option to add a field.

Re: Complicated time calculation

Alec Pojidaev — Wed, 28 Jan 2009 16:58:59 GMT

Try this

Complicated time calculation

Jimothias — Wed, 28 Jan 2009 10:37:18 GMT

Greetings all :0)

I'm relatively new to the world of InfoPath so I'm learning all the time and would appreciate some help :0) Not the first time, probably not the last, but I'm glad this place is full of helpful people.

I've been making a form that submits to a MS SQL box and I'm using the "Database" form template. I found that I can only use either the Query fields or the Data fields. I wonder if anyone knows if there is a way I can insert some of my own controls (not to be submitted). At the moment I'm using some of the query fields that I'm not using which in turn populate the data fields that remain the same throughout.

The problem I have is that I am trying to work out the differences between 2 time fields. I've followed the guide here: http://www.bizsupportonline.net/infopath2003/time-calculations-infopath-using-rules.htm which when I create a new form and follow it works perfectly. I do change certain coding to match my own form eg -
(((number(substring(../my:endTime, 1, 2)) * 3600) + (number(substring(../my:endTime, 4, 2)) * 60)) - ((number(substring(., 1, 2)) * 3600) + (number(substring(., 4, 2)) * 60))) div 3600
became
(((number(substring(../@finish_time, 1, 2)) * 3600) + (number(substring(../@finish_time, 4, 2)) * 60)) - ((number(substring(., 1, 2)) * 3600) + (number(substring(., 4, 2)) * 60))) div 3600

When I click Verify Formula it all reports as ok and such. The only thing I wonder is that I cant turn the data fields I'm using into the right type and format like I can in the normal form rather than the "Database" template form.

If anyone can see where I am going wrong I would really appreciate a pointer :0)

Thanks in advanced

James

General

Re: Complicated time calculation

Re: Complicated time calculation

Re: Complicated time calculation

Complicated time calculation