InfoPath Dev

hi, im trying to use the workday calculation of this site

http://alecpojidaev.wordpress.com/2008/12/30/infopath-codeless-programming-walkthrough-2/

but the thing is i have to use this code for a repeating section.

i dont seem to see what i have to change so it can work for a repeating section. that has 2 datepicker and a field to calculate the days

can someone help me with this?

thnx

Hi Jenfi,

Have you tried to ask Alec about this on his site? You probably need to modify your xpath to use current() or preceding-sibling. Try searching for those here. We have several blogs and posts about these two techniques.

We also provide qRules to solve this and many other common problems. qRules is a plug-in that you inject into your form. It gives you the most commonly asked for features that require code - you don't have to write any code. The trial is free and if you decide to use it, the cost is cheap. It's how we defray the cost of maintaining this free forum.

Thanks for your support,

Yes i have ask Alec, he was about to post the code once he was less busy. but i tink he is still busy though

he explain to me about that xpath. but i'm not shure how to do that.

i'm gonna look for the blogs that have those techniques.

thnx for your reply

Done. Check it out.

Hey Alec,

You rock! Thanks for responding with such a super post. Let us know what humble offering we can take to your shrine.

:)

wow, that is pretty fast.

thank you.

but my repeating table has 2 datepicker startdate and enddate in one row. so every time i click on insert in one row there is 2 datepicker.

do i have to also use 1 DateWN  field for both datepicker.

i see that you are using 1 DateWN  field for that 1 datepicker (Date).

Create repeating group, then just right click on each and every nonrepeating fields (5 of them total) choose MoveTo, then move them one by one into your repeating section.

its me again. My repeating group is connected to a sql server database. so i can not move the items to the repeating group.

if i understand what you are saying.

sorry for so much question. i'm very new at this

In that case solution in my blog won't work for you. You need to calculate work days before data will hit InfoPath. Do some google search there is stored procedude that does what you need.

Hi Alec,

 I want to add one more field "AM/PM" to calculate the work days. It looks like https://docs.google.com/document/d/1UeofM7q1QLku1m-a3Ok3D9OpCYXQDDSiFvpWIeUrtE8/edit. For example, I want to treat from "12-20-2011 AM" to "12-22-2011 AM" as 2.5 days.

Can you help to update your rules in your infopath form(Work days calculation (business days))?

 Thanks,