Solved

Split row data into separate files using Infopath 2010 rules or custom code

Posted on 2010-09-13
5
319 Views
Last Modified: 2012-05-10
I've been evaluating InfoPath 2010 using sharepoint recently, and I want to see what the level effort would be to accomplish the following

1. Users would input field data in a repeating table
2. Click a button and have it take all records matching 'field1' and put that in a new infopath form file, then the values matching a different value in 'field1' and put that in a 2nd InfoPath form file
3. user could then submit each file individually

Is this difficult?  
Can it be done using rules (doesn't look like it...)  Is the custom code option too time consuming?
Can it be accomplished easily or should I focus on processing the file from the forms library once it's uploaded?

If anyone has done similar, or has some code examples, let me know, thanks!
0
Comment
Question by:rmicone
  • 3
  • 2
5 Comments
 
LVL 28

Expert Comment

by:clayfox
Comment Utility
a lot of this depends on form design and keeping it simple.

To sum up.
You want user to enter data for type field1 and for type field2 and you want a common starting place (form)

I would have one form.
The user selects the type (Field1 or Field2)
They enter one record and submit.
The submit rules look at the type and submit to a different form library based on the value of type.
They enter another records and submit, etc.

So the user enters the same amount of data they just file each record rather than at the end and you have to sort through the whole batch.

An analogy would be a paper form and filing each one as you filled them out rather than stacking them up and then having a seperate process to access the stack and file each one.

This solution would be real simple and straightforward out of the default features without any complex code or hocus pocus.

0
 
LVL 2

Author Comment

by:rmicone
Comment Utility
well let me give a little more data, basically it's a repeating table which represent line items, but my users want to be able to enter 50 lines, with different ship dates.  So the field that will distinguish the grouping is the 'ship date' field.  

So you are saying the submit rules can query by that field which in this case is date, and send those line items and corresponding field data in the line items to a separate form?  

and is this available in ip2007 and ip2010?  
0
 
LVL 28

Expert Comment

by:clayfox
Comment Utility
Yah.

So as they enter a shipment.  They submit after each one and is submits the data to SharePoint. Which can be conditional based on the date.

Why do they want the data seperated by date? You can have all of the data in one list and then allow them to use filtered views to see just one date at a time later.

Have you looked in 2010 of just making a list and customizing the entry form?

0
 
LVL 2

Accepted Solution

by:
rmicone earned 0 total points
Comment Utility
They are orders, which ship on different dates, so as lazy sales people they go to trade shows and want a form that they can list out 3 key fields, which are item, ship date, and the customer name.  When they get back to the office they have to separate all that out (I know right... huge deal ... not) but we have to make their lives ever-easier so i'm just seeing what is possible.  It seems like the solution is not simple, so I may bag it.

I know you can setup views,  but in this case i need to separate items into new forms based on customer and ship date.

i really like sp2010 and the forms services, i have convinced our COO to get it, we just have to budget it for q1 2011... to solve this problem alone would pay for itself
0
 
LVL 2

Author Closing Comment

by:rmicone
Comment Utility
scope
0

Featured Post

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

The Scenario: Let’s say you have a quote worksheet in Excel that you use to work up sales figures and such for your clients. You utilize SharePoint to manage and keep track of these documents. You would like values from your worksheet to populate Sh…
I thought I'd write this up for anyone who has a request to create an anonymous whistle-blower-type submission form created using SharePoint 2010 (this would probably work the same for 2013). It's not 100% fool-proof but it's as close as you can get…
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …
This tutorial demonstrates a quick way of adding group price to multiple Magento products.

763 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now