General

Re: Problem with receive connection Infopath - Sharepoint

warrtalon — Wed, 17 Jun 2009 13:26:43 GMT

Yes, workflow is logic based, but if you haven't done any workflow building in SharePoint, then you will probably want to get some help. InfoPath forms are typically expected to be coupled with workflow. They work extremely well together...

Re: Problem with receive connection Infopath - Sharepoint

HttpPointCom — Wed, 17 Jun 2009 12:37:22 GMT

But can the workflow edit dynamically ? i mean i want when i click to submit this form with "approbation statut = approbated", then the initial number of vacation change to the new.

The workflow issue is something i'm new about, i don't how it work.

Thanks

Re: Problem with receive connection Infopath - Sharepoint

warrtalon — Wed, 17 Jun 2009 12:12:40 GMT

With a workflow, and you have to have a unique identifier in the list that can be compared from the form via the workflow itself.

Re: Problem with receive connection Infopath - Sharepoint

HttpPointCom — Wed, 17 Jun 2009 09:45:39 GMT

It was a problem with the filter, it seems like the filter works weird in Infopath. The NombreConge[usera=Utilisateur] was good but the xpath of usera HAVE TO be ../@usera or it will not working.

Ok now i receive all the field of my sharepoint list without problem, but it really hard to submit the new vacation number. The " how to " i found are for adding a new item, but for editing an item in a sharepoint list, how can you add an item where usera=username into the right column ?

Thanks in advance.

Re: Problem with receive connection Infopath - Sharepoint

warrtalon — Wed, 17 Jun 2009 04:07:08 GMT

Well, how did you resolve it? We spent a lot of time on this, so just to come back and say you randomly resolved it without explaining what was wrong is not very helpful. Do you mind sharing what you changed to make it work?

That link you reference is the way to update a separate list item directly. To do it indirectly, use workflow. It can be done with SharePoint Designer or Visual Studio - very easy with SPD.

Re: Problem with receive connection Infopath - Sharepoint

HttpPointCom — Tue, 16 Jun 2009 15:19:11 GMT

Right, i resolve this problem this problem, now the thing is i want to submit to the sharepoint list the new vacation, i found this :

http://blogs.msdn.com/infopath/archive/2007/03/26/submitting-to-a-sharepoint-list.aspx

but it will be complicated to integer this to my form, i would like to know if there are other methods to submit to a sharepoint list

Re: Problem with receive connection Infopath - Sharepoint

warrtalon — Mon, 15 Jun 2009 16:34:21 GMT

Ok, I will try to take your current XSN and make the changes within it and re-attach. The problem is that for me to test, I have to setup my own environment and change all the data connections. That's what I did on my test form. Now, I'll just make the changes to your form so that you can test in your environment.

So, please attach the current version of your XSN or a test version of it based off your current rule settings.

Re: Problem with receive connection Infopath - Sharepoint

HttpPointCom — Mon, 15 Jun 2009 07:01:32 GMT

I really like to see the .xsn you have because i did the change you suggest and it still doesn't working .... i set the default value to champ2 ->

xdXDocument:GetDOM("Testo")/dfs:myFields/dfs:dataFields/dfs:Testo/@NombreConge[xdXDocument:get-DOM()/my:mesChamps/my:Utilisateur = xdXDocument:GetDOM("Testo")/dfs:myFields/dfs:dataFields/dfs:Testo/@Usera]

I also try with NombreConge[usera=utilisateur] and same result ...

Re: Problem with receive connection Infopath - Sharepoint

warrtalon — Sun, 14 Jun 2009 15:48:09 GMT

I made a lot of changes to what I saw based on how I would build the form, so the XSN I have is not necessarily what you'll want. I think the main thing to do is what I mentioned about using a default value on champ2 instead of a rule to populate it.

Set the default value of champ2 to the exact same value that you are using in your champ3 rule set:

NombreConge where Usera = Utilisateur

Re: Problem with receive connection Infopath - Sharepoint

HttpPointCom — Sun, 14 Jun 2009 12:45:13 GMT

This is why the form i posted here is call " test ", it's not my whole work. In my real form i use this vacation number, then i calculate the workday between 2 datepickers, and i do vacation number - workday calculated = new vacation number, then i'll send it. Of course, i've a type of vacation to choose etc.. and an approbation by a manager, so with the submit button i'll add a rule, if approbation statut is " approbated " then send the new vacation number of current user to the sharepoint list.

How did you do for having the number of vacation of the current user ? do you know the rule for doing the submit to the vacation of current user ? Can you post the .xsn with the updated you did please.

thanks for you time, you help me a lot.

Re: Problem with receive connection Infopath - Sharepoint

warrtalon — Sat, 13 Jun 2009 19:45:37 GMT

Ok, I see what you're doing in the form, and I see what is happening. What I don't know is what you want to do with the vacation days. I don't see a calculation. I just see a radio button that sets itself to the value of 1, and then you have a rule that sets another text field to the value of the vacation days (filtered unsuccessfully by username). I can get this part to work so that the number in champ2 is correct, but what is it you want to do after that? All you're doing so far is duplicating your info for username and vacation days. You also never added the conditional formatting to the repeating table that I mentioned...or you added it and removed it. I added it, and it works. I also can get the champ2 value to always reflect the current user's NombreConge by setting its default value instead of using a rule.

Re: Problem with receive connection Infopath - Sharepoint

HttpPointCom — Sat, 13 Jun 2009 16:54:09 GMT

i tried many things without success, I hope you'll do better.

Re: Problem with receive connection Infopath - Sharepoint

warrtalon — Fri, 12 Jun 2009 16:41:25 GMT

Ok, I got it. That should be very easy. Attach your XSN, and I'll show you.

Re: Problem with receive connection Infopath - Sharepoint

HttpPointCom — Fri, 12 Jun 2009 16:07:16 GMT

Sorry, i badly explain my problem, showing the current user vacation = OK, but this is not what i want to do, i want to use the current user vacation for my form, because i will do a calcul to this vacation then i will submit the new vacation number.

Re: Problem with receive connection Infopath - Sharepoint

warrtalon — Fri, 12 Jun 2009 15:44:08 GMT

I don't really understand the problem, but if you attach the XSN, we could probably troubleshoot it. You should be able to set the conditional formatting so that YOU as the administrator see everything but regular users only see their one record. That way you can do what you need to do. If you do the method I said, it will not show the first record always - it will only show the record that is relevant to the current user (other than you).