Logo 
Search:

MOSS Forum

Ask Question   UnAnswered
Home » Forum » MOSS       RSS Feeds

SharePoint linked to InfoPath

  Asked By: Jasen    Date: Jul 21    Category: MOSS    Views: 853

Question 1:
I am running SharePoint Moss 2007 with Enterprise.

I have a InfoPath form I linked to a Document Library.

The InfoPath form has a simple Repeating table, ie: ITEM, QTY, Description.

I want the ITEM to incriment by itself each time a item is added to the list.

Any ideas?

Question 2:
Is there any problems using InfoPath forms with SharePoint I should know about
before investing lots of money in using it with SharePoint?

Share: 

 

4 Answers Found

 
Answer #1    Answered By: Maggie Benson     Answered On: Jul 21

=============Tomsrig wrote:
The InfoPath form has a simple Repeating table, ie: ITEM, QTY, Description.
I want the ITEM to incriment by itself each time a item is added to the list.
==============
We've been doing a lot with IP forms lately from GUI and SPD, and it is my
understanding that you cannot update data inside of a form - period.
------
Next, you will need Forms Publishing if you want your forms to work in browser
AND you have/need code behind the form. Why would you want code: 1) to do
cross field validation, 2) to construct a cascading drop-down to populate some
field.

Give a call if necessary.

 
Answer #2    Answered By: Lane Trujillo     Answered On: Jul 21

After much research I got the thing working.

And, yes, you can update data inside a form.

My solution was to create a xpath expression on the ITEM column on the repeating
table I mentioned in my first email.
In the Text Box properties of the ITEM node, in the formula area,
This is what the formula looks like when it is added by infopath
count(preceding-siblings::*/.)+1

I entered it this way:
count(preceding-siblings::*/Item_Count)+1
Where ITEM_COUNT is my name for the ITEM column. infopath  changes that to a DOT
(.) in the formula when its entered.

Now when I call up the form, the ITEM starts with 1, then as you add a line, the
item goes to 2, and so on. One thing you MUST do to get it to work when you
insert a line or delete a line in the list is to Click the box marked "Update
this value when the result of the formula is recalculated.

If you don't then it will not work when you insert or delete a line. The
inserted line will have the wrong number. And the deleted line will not change
the other lines correctly.

As for inserting data into the form from SharePoint, this works great also.

I have a drop down box, that gets its data from the SharePoint list.
For example:
I create a drop down box called: Departments.

In SharePoint I create a list with one line and change Title to Departments.
Then I simply add all the department names to the list.

Next I go to my form Drop Down Department and edit the "Drop Down List
Properties" box to point it to the SharePoint list called Departments under
"List Box Properties". Select the "Look up values from an external data source"
and follow the directions from there.

Once connected, when you open the form, click on the Department drop down arrow,
and the same list you created in SharePoint is pulled in.

 
Answer #3    Answered By: Rafael Willis     Answered On: Jul 21

To be clear to others, when I said one "could not update data inside an
InfoPath form" I meant outside of the form instance. Say, from a workflow
running on another list in the same site collection.

 
Answer #4    Answered By: Richard Davis     Answered On: Jul 21

I'm not sure I follow you on that one.

Could you give me an example?

 
Didn't find what you were looking for? Find more on SharePoint linked to InfoPath Or get search suggestion and latest updates.




Tagged: